Excel Features and Functions

This video tutorial introduces the Microsoft Excel 2021 interface, covering key elements such as the autosave feature, Quick Access Toolbar, Title Bar, and Search function. It explains the functions of various tabs like Home, Insert, Page Layout, Formula, Data, Review, and View, and details the options available in the File menu. The tutorial also covers Excel components like the Name Box, Active Cell, Formula Bar, and navigation tools such as scrollbars and zoom. The video concludes with a brief overview of how to use Excel worksheets for various tasks.

What is the primary function of the autosave feature in Microsoft Excel 2021?

• To automatically save files to the local drive

• To save files to OneDrive automatically

• To save files to a network drive

• To save files to a USB drive

Which toolbar allows quick access to frequently used commands in Excel?

• Title Bar

• Formula Bar

• Status Bar

• Quick Access Toolbar

What is the difference between 'Save' and 'Save As' in the File tab?

• 'Save' saves to a USB, 'Save As' saves to OneDrive

• 'Save' saves changes to an existing document, 'Save As' saves a copy with a new name

• 'Save' saves to the cloud, 'Save As' saves locally

• 'Save' is for saving a new document, 'Save As' is for saving changes

Which tab would you use to format text with bold, italic, or underline?

• Page Layout

• Home

• Data

• Insert

What is the primary function of the Insert tab in Excel?

• To insert page numbers

• To insert charts and tables

• To insert new worksheets

• To insert comments

Which tab would you use to adjust the page margins and orientation?

• Review

• Page Layout

• Insert

• Home

What is the function of the Formula Bar in Excel?

• To display the name of the workbook

• To navigate between worksheets

• To enter and edit formulas

• To show the status of the worksheet

What does the Name Box in Excel display?

• The formula in the active cell

• The name of the workbook

• The name of the worksheet

• The address of the active cell

How can you move horizontally across a worksheet?

• Using the horizontal scrollbar

• Using the Name Box

• Using the Zoom feature

• Using the vertical scrollbar

What is the purpose of the Zoom feature in Excel?

• To adjust the view size of the worksheet

• To switch between worksheets

• To edit cell content

• To change the font size