Microsoft Excel 2021365 - Beginner to Advanced - Exercise 13

The video tutorial guides viewers through creating and arranging workbooks, adding dummy data, and practicing zooming techniques. It also covers freezing and unfreezing panes in a worksheet. The instructor demonstrates these tasks, providing step-by-step instructions and encouraging viewers to practice different layout options and zoom methods.

What is the first task the instructor asks you to perform with the workbooks?

• Save them

• Arrange them on the desktop

• Enter data

• Create a chart

Which of the following is NOT a method mentioned for zooming in and out in Excel?

• Using the zoom button in the ribbon

• Using the control key and mouse scroll wheel

• Using the keyboard shortcuts Alt + Z

• Using the zoom slider

What feature allows you to zoom into a specific selection in Excel?

• Zoom to range

• Zoom to fit

• Zoom to selection

• Zoom to area

What is the purpose of freezing panes in Excel?

• To lock the workbook

• To keep certain rows and columns visible while scrolling

• To highlight important data

• To prevent data entry

Which cell should you click to freeze both the top row and the first column?

• The first cell of the worksheet

• Any cell in the first column

• The cell where the top row and first column intersect

• Any cell in the top row