Exam 77-420 Microsoft Excel 2013
2. Create Cells and Ranges
2.3 Order and Group Cells and Ranges: Insert Subtotals
graphic1

Data -> Outline-> Subtotal

graphic2

Hello Subtotals!

3. What Do You See? This spreadsheet now has Subtotals that count the number of customers in each city. There is also a Grand Total that adds up all of our customers in all of the cities.

 

What Else Do You See? Microsoft Excel created formulas for the Subtotals. Scroll down and select any Subtotal. Please review the formula. This example shows:

=SUBTOTAL(3,F2:F245)

 

Impressive.

 

Keep going...