Where is total cell style in excel

It is a 24 question assignment that must be done on on an excel spreadsheet. You must be proficient to advanced on microsoft excel.

1 Start Excel. Open the downloaded Excel file named GO_eV1_Grader_CAP.xlsx.
0
2 On the Net Sales worksheet, in the range F4:F8, calculate the annual total sales for each state.
2
3 In the range B9:F9, calculate totals.
2
4 Using absolute cell references as necessary, in cell G4, construct a formula to calculate the percent that the Colorado Total is of Total Sales, and then fill the formula down through the range G5:G8.
2
5 Apply the Total cell style to the range B9:F9.
2
6 In cell H4, insert a Line sparkline using the data range B4:E4. Format the sparkline by applying the Sparkline Style Accent 2 (no dark or light). Copy the sparklines down to cell H8.
2
7 Insert a 3-D Pie chart using the nonadjacent ranges A4:A8 and G4:G8. Change the chart style to Style 7. Reposition the chart so that the top left corner of the chart is centered in cell A10. Change the width of the chart to 6.5 inches.
2
8 Change the chart title to Annual Net Sales by State and add data labels to the chart that display only the Category Name and Percentage positioned in the Center. Change the data labels Font color to Black, Text 1 and apply Bold Italic. Remove the Legend from the chart.
2.5
9 Change the angle of the first slice of the pie to 200, and then explode the red New Mexico slice of the pie by 10%. Change the solid fill color of the orange Colorado slice to Tan, Accent 6.
2.5
10 On the Seattle Inventory worksheet, in cell G14, enter an IF function to determine the items to be ordered. If the Quantity in Stock is less than 50, then the cell should displayOrder. If not, then the cell should display OK. Copy the function down through cell G19.
2
11 Format the range A13:G19 as a table with headers and then apply Table Style Medium 5.
2
12 Add Gradient Fill Orange Data Bars to the range A14:A19. Add conditional formatting to the range G14:G19 so that the cells with text that contain the word Order are formatted as Yellow Fill with Dark Yellow Text. Sort the table by Item # from Smallest to Largest.
2.5
13 Filter the table on the Sport column to display only the Skiing types. Display a Total Row in the table, and then sum the Quantity in Stock for Skiing items. Type the result in cell B11. Remove the total row from the table and then clear the Sport filter.
2
14 In cell B5, enter a function that will display the average retail price. In cell B6, enter a function that will display the median retail price. In cell B7, enter a function that will calculate the lowest retail price. In cell B8, enter a function that will calculate the highest retail price. Format the range B5:B8 with Accounting Number Format.
4
15 Display the Inventory Summary sheet. In cell B4, enter a formula that references cell B4 in the Seattle Inventory sheet so that the Seattle Total Items in Stock displays in cell B4. In cell B5, enter a formula that references cell B5 in the Seattle Inventory sheet so that the Seattle Average Price displays in cell B5. In cells B6, B7, and B8, enter similar formulas to reference the Median Price, Lowest Price, and Highest price in the Seattle Inventory sheet. 2.