Pearson MyLab IT GO16_XL_CH01_GRADER_1F_AS - Dispenser Sales 1.2 - Microsoft Excel Full answer 2025

Step Instructions Points Possible
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
10 Change the Retail Price of the Artisan Rack to 29.95 and the Quantity Sold of the Cheese Shaker to 425. 4.000
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 100.000

#MicrosoftExcel
#Pearson
#PearsonMyLabIT