Millstone Restaurant Supply
Tabletop Dispenser Sales
Product Number
Quantity Sold
Retail Price Total Sales Percent of Total Sales
Condiment CR-3
Rack
382
15,25
Creamer CE-8
421
5,95
Npkin Dispenser
NA-2
122
12,5
Cheese Shaker
CH-4
365
5,5
Oil & Vinegar
OV-5
Dispenser
284
12,95
Artisan RackAR-6
195
32,25
Sugar Packet
SP-8
Dispenser
205
10,95
Total Sales for All Products
Pro Fit Marietta
Balance and Stabilization Sales
Product Number
Quantity Sold
Retail Price Total Sales Percent of Total Sales
Balance Pillow
BP-3
275
22.95
Silde BoardSB-8
382
99.95
Foam RollerFR-2
251
39.5
Rebounder RB-4
162
139.95
Stability BallSB-5
380
51.5
Balance Board
BB-6
206
84.95
Balance PadBP-8
220
75.99
Total Sales for All Products
Grader - Instructions
Excel 2016 Project
GO16_XL_CH01_GRADER_1F_HW - Balance Sales 1.3
Project Description:
In the following project, you will create a worksheet summarizing the sales of balance and stabilization equipment that Pro Fit
Marietta is marketing.
Steps to Perform:
Step
Points
Possible
Instructions
1
Start Excel. Download and open the file named go16_xl_ch01_grader_1f_hw.xlsx.
0
2
Merge and center the title and then the subtitle across columns A:F and apply the Title and
Heading 1 cell styles respectively.
8
3
Check spelling in your worksheet, and correct Silde to Slide. Widen column A to 180 pixels
and columns B:F to 95 pixels.
4
4
In cell E4, construct a formula to calculate the Total Sales of the Balance Pillow by multiplying
the Quantity Sold by the Retail Price. Copy the formula down for the remaining products.
10
5
Select the range E4:E10, and then use the Quick Analysis tool to sum the Total Sales for All
Products, which will be formatted in bold. To the total in cell E11, apply the Total cell style.
10
Note, Mac users, instead of the Quick Analysis tool, use the Sum button. Complete the step as
specified.
6
Using absolute cell references as necessary so that you can copy the formula, in cell F4,
construct a formula to calculate the Percent of Total Sales for the first product. Copy the
formula down for the remaining products.
10
7
To the computed percentages, apply Percentage Style with two decimal places, and then
center the percentages.
8
8
Apply the Comma Style with no decimal places to the Quantity Sold figures. To cells D4, E4,
and E11, apply the Accounting Number Format.
10
9
To the range D5:E10, apply the Comma Style.
4
10
Change the Retail Price of the Slide Board to 75.50 and the Quantity Sold of the Balance Pad
to 150.
4
11
Delete column B.
6
12
Insert a new row 3. In cell A3, type Month Ending March 31 and then merge and center the
text across the range A3:E3. Apply the Heading 2 cell style.
10
13
To cell A12, apply the 20% - Accent1 cell style.
4
14
Select the four column titles. Apply Wrap Text, Middle Align, and Center formatting, and then
apply the Heading 3 cell style.
8
15
Center the worksheet horizontally on the page, and then insert the file name in the footer in
the left section. Return the worksheet to Normal view, if necessary.
4
16
Save and close the workbook. Exit Excel. Submit the file as directed.
0
Created On: 01/29/2019
1
GO16_XL_CH01_GRADER_1F_HW - Balance Sales 1.3
Grader - Instructions
Excel 2016 Project
Total Points
Created On: 01/29/2019
2
100
GO16_XL_CH01_GRADER_1F_HW - Balance Sales 1.3
Office 2016 – myitlab:grader – Instructions
Excel Project
GO16_XL_CH01_GRADER_1F_AS - Dispenser Sales 1.2
Project Description:
In the following project, you will create a worksheet summarizing the sales of Tabletop Dispenser equipment that
Millstone Restaurant Supply is marketing.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step
Points
Possible
Instructions
1
Start Excel. Download and open the file named go16_xl_ch01_grader_1f_as.xlsx.
0.000
2
Merge and center the title and then the subtitle across columns A:F and apply the Title and
Heading 1 cell styles respectively.
8.000
3
Check spelling in your worksheet, and correct Npkin to Napkin. Widen column A to 25 and
columns B:F to 12.85.
8.000
4
In cell E4, construct a formula to calculate the Total Sales of the Condiment Rack by
multiplying the Quantity Sold by the Retail Price. Copy the formula down for the remaining
products.
12.000
5
Select the range E4:E10, and then use the Quick Analysis tool to sum the Total Sales for All
Products, which will be formatted in bold.
Note, Mac users, sum the Total Sales for All Products in cell E11. To the total in cell E11, apply
the Total cell style.
10.000
6
Using absolute cell references as necessary so that you can copy the formula, in cell F4,
construct a formula to calculate the Percent of Total Sales for the first product. Copy the
formula down for the remaining products.
10.000
7
To the computed percentages, apply Percent Style with two decimal places, and then center
the percentages.
8.000
8
Apply the Comma Style with no decimal places to the Quantity Sold figures. To cells D4, E4,
and E11 apply the Accounting Number Format with two decimal places.
4.000
9
To the range D5:E10, apply the Comma Style.
4.000
Change the Retail Price of the Artisan Rack to 29.95 and the Quantity Sold of the Cheese
Shaker to 425.
4.000
10
Updated: 08/29/2017
1
Current_Instruction.docx
Office 2016 – myitlab:grader – Instructions
Step
Excel Project
Points
Possible
Instructions
11
Delete column B.
6.000
12
Insert a new row 3. In cell A3, type Month Ending March 31 and then merge and center
the text across the range A3:E3. Apply the Heading 2 cell style.
10.000
13
To cell A12, apply the 20% - Accent1 cell style.
4.000
14
Select the four column titles. Apply Wrap Text, Middle Align, and Center formatting, and then
apply the Heading 3 cell style.
8.000
15
Center the worksheet Horizontally on the page, and then insert the file name in the footer in
the left section. Return the worksheet to Normal view, if necessary.
4.000
16
Save and close the workbook. Exit Excel. Submit the file as directed.
0.000
Total Points
Updated: 08/29/2017
2
100.000
Current_Instruction.docx
Purchase answer to see full
attachment