Ch 1 Grader Project 1F: Balance Sales & Ch 1 Grader Project 1F: Dispenser Sales

User Generated

awfzvgu93

Writing

Description

I need help with 2 MyITLab Grader Project assignments. I just need the completed assignments in excel so I can upload them. All the material should be provided; instructions are on Word documents, and the templates for the work, are provided in Excel. It's chapter 1 material, so it's pretty basic stuff, shouldn't take you very long. Thanks for the help!

Unformatted Attachment Preview

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
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

The completed Excel sheets are attached.Please, give me feedback.

Millstone Restaurant Supply
Tabletop Dispenser Sales
Month Ending March 31
Quantity Sold
Condiment Rack
Creamer
Napkin Dispenser
Cheese Shaker
Oil & Vinegar...


Anonymous
Awesome! Perfect study aid.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags