Exam 77-888: Microsoft Excel Expert 2010

3. Presenting Data Visually

3.2. Apply data analysis: Subtotal Outlines

Data -> Outline-> Subtotal

Viewing the Subtotals

The information is outlined on the left hand side of the spreadsheet.

 

You can use the outline to show or hide the details. The + sign means there is more to see. The – sign indicates that all of the Rows are shown.

 

4. Try It: Use the Outline

Click on the 3. All Rows are visible.

Click on the 2: That's the Subtotals.

Click on the 1. That hides all of the Rows except the Grand Count.

 

Made You Look: In this image, you are looking at Column E, so that it will fit on the page, OK?