Microsoft Excel 2021365 - Beginner to Advanced - The Backstage Area

The video tutorial explains the File tab in Excel, focusing on the Backstage area, which serves as an admin hub for creating, opening, saving, and managing workbooks. It highlights the Info page for protecting and inspecting workbooks, recovering unsaved files, and managing document properties. The tutorial also covers closing workbooks and navigating back to the main Excel interface.

What is the primary function of the Backstage area in Excel?

• To provide a ribbon for formatting

• To access administrative options like saving and printing

• To create charts and graphs

• To edit cell formulas

Which of the following can be done from the Info page in the Backstage area?

• Add a password to protect a workbook

• Insert a pivot table

• Create a new workbook

• Format cells

How can you recover an unsaved workbook in Excel?

• By clicking on the Home tab

• By reopening Excel

• By using the Save As option

• Through the Info page in the Backstage area

What information can be found in the document properties section?

• Cell formatting details

• Workbook formulas

• Author's name and last modified date

• Chart types used

What happens when you click the cross in the top right corner of Excel?

• It closes the current workbook only

• It minimizes the workbook

• It closes all open workbooks and Excel

• It saves the workbook automatically