Excel 2013

Challenge!

1. Open an existing Excel workbook. If you want, you can use our Lesson 20 Practice Workbook.
2. Try grouping a range of rows or columns together. If you are using the example, group columns D and E.
3. Use the Show and Hide Detail buttons to hide and unhide the group.
4. Try ungrouping the group. If you are using the example, ungroup columns D and E.
5. Outline your worksheet using the Subtotal command. If you are using the example, outline by T-shirt size.
6. Remove subtotaling from your worksheet.