Pearson MyLab IT GO16_XL_CH01_GRADER_1F_HW - Balance Sales 1.3 - Microsoft Excel (Full answer 2025)

Step Instructions Points Possible
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.

Note, Mac users, instead of the Quick Analysis tool, use the Sum button. Complete the step as specified. 10
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

#MicrosoftExcel
#Excel
#PearsonMyLabIT
#Techniques
#Excel
#MicrosoftOffice