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


Data -> Outline-> Subtotal


Data: Subtotal

The list has been Sorted by City. Now, here are the steps to Subtotal by City.


2. Try it: Subtotal the Data

Select Column E (City).

Go to Data ->Outline->Subtotal.


You will be prompted to answer the following questions for this Subtotal:


At each change: City.

You just sorted by City, select City for the Subtotal so it matches.


Use function: Count.


Add the subtotal to: City.

The Subtotal is counting the number of customers in each city. It makes sense to add the Subtotal to the City.


Click OK. Keep going...