Excel 2016 Managing Worksheets

Lesson 1 – Working with Multiple Worksheets

Excel 2016

E XERCISE

W ORKING WITH M ULTIPLE W ORKSHEETS



T ASK Work with multiple worksheets in a workbook.

1. Open REGION12.XLSX . 2. Display the Totals worksheet. 3. Select the Totals and By Week worksheets. 4. Color both worksheet tabs yellow. 5. Keeping both sheets selected, insert two new worksheets. 6. Rename the first inserted worksheet Northwest . 7. Rename the second inserted worksheet Southwest . 8. Delete the By Week worksheet. 9. Print the Northeast and Southeast worksheets. 10. Close the workbook without saving it.

Page 14

OFFICEPRO, Inc.