![]() Copy the formula down for the remaining regions. 7 8.000 8 6.000 9 Using absolute cell references as necessary so that you can copy the formula, in cell G4 construct a formula to calculate the Percent of Total Sales for the first region. ![]() ![]() Insert a new row 6 with the row title Midwest and the following sales figures for each quarter: 110985.74.48.21.17 Copy the formula from F5 to F6. Format the totals in row 7 with the Total cel style. Apply the Accounting Number Format to the first row of sales figures and to the total row, and the Comma Style to the remaining sales figures. Note, Mac users, on the Home tab, use the Sum tool. Click the second Sum option the sixth item in the gallery which displays the column selection in yellow. Select the Northeast sales for the four quarters, and then display the Quick Analysis Totals gallery. Note, Mac users, on the Home tab, use the Sum tbol. 5 8.000 6 8.000 By using the Quick Analysis tool, Sum the Quarter 1 sales, and then copy the formula across for the remaining Quarters.
0 Comments
Leave a Reply. |