Excel 2016 Managing Worksheets

Excel 2016

Lesson 3 – Using Large Worksheets

E XERCISE

U SING L ARGE W ORKSHEETS



T ASK Use features for working with a large worksheet.

1. Open REGION11.XLSX . 2. Zoom the worksheet to 75% so that you can view more of it on the screen. 3. Zoom the range A1:E11 to fit the window. 4. Return the view to 100% . Deselect the range. 5. Display the document in Full Screen view. 6. Close Full Screen view. 7. Split the screen into two vertical panes, so that you can view both the Total Sales and the Percent of Total columns. 8. Remove the panes. 9. Freeze the row headings in column A and the column headings in rows 1 through 4. 10. Scroll to display the Avg. Sales and Percent of Total columns. 11. Unfreeze the panes. 12. Close the workbook without saving it.

OFFICEPRO, Inc.

Page 45