8.000 8 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 cell style. 8.000 7 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. 8.000 6 Select the Northeast sales for the four quarters, and then display the Quick Analysis Totals gallery. By using the Quick Analysis tool, Sum the Quarter 1 sales, and then copy the formula across for the remaining Quarters.
0 kommentar(er)
