question archive Select the Northeast sales for the four quarters , and then display the Quick Analysis gallery for 8 Totals
Select the Northeast sales for the four quarters , and then display the Quick Analysis gallery for 8 Totals
Subject:MathPrice: Bought3
Select the Northeast sales for the four quarters , and then display the Quick Analysis gallery for 8 Totals. Click the second Sum option-the sixth item in the gallery-which displays the column selection in yellow . Copy the formula down through cell F7 ; recall that the Quick Analysis tool formats sums in bold . Mac users : Instead of the Quick Analysis tool , use the AutoSum button , and then apply Bold formatting to the total 7 Apply the Accounting Number Format to the first row of sales figures and to the total row . 8 Apply the Comma Style to the remaining sales figures . Format the totals in row 7 with the Total cell style .
