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...