Excel 2016 Data and List Management

Excel 2016

Lesson 3 – Working with Outlines

E XERCISE

W ORKING WITH O UTLINES



T ASK Apply and use outlines and subtotals.

1. Open REGION19.XLSX . 2. Go to the Expenses worksheet, if necessary. 3. Select columns B through D and apply an outline to the columns. 4. Select rows 5 through 8 and apply an outline to the rows. 5. Collapse and expand the outline. 6. Display the Regional Sales worksheet.

7. Use Auto Outline to create an outline for the whole worksheet. 8. Collapse the outline to level 1 for both rows and columns. 9. Expand the detail rows for the Central and Southwest regions to view the weekly totals. 10. Clear the outline. 11. Display the Sales Summary worksheet. 12. Use the Sort dialog box to sort the list by Area , then by Product , then by Year , then by Period . 13. Create subtotals to sum the Sales at each change in Area . 14. Collapse the outline to level 2 to view the district totals, then expand to level 3 . 15. Create additional subtotals to sum the Sales at each change in Product , without removing the existing subtotals. 16. Collapse the outline to level 3 to view the product totals, then expand to level 4 . 17. Create additional subtotals to sum the Sales at each change in Year , without removing the existing subtotals. 18. Collapse the outline to level 4 to view the year totals. 19. Display the detail rows for any 2006 Total . 20. Remove all the subtotals. 21. Close the workbook without saving it.

OFFICEPRO, Inc.

Page 83