Microsoft Excel 2021365 - Beginner to Advanced - Exploring the Interface

This video tutorial introduces the Excel 2021 interface, starting with creating a new blank workbook. It explores the modernized interface, including the title bar, quick access toolbar, and search bar. The tutorial explains the various ribbons like Home, Insert, and Formulas, detailing their functions and commands. It also covers navigating the workbook, understanding cell references, and using the name and formula bars. The video concludes with customizing the Excel interface by toggling advanced ribbons.

What is the default name given to a new Excel workbook before it is saved?

• Document1

• Sheet1

• Book1

• File1

Which toolbar in Excel allows you to quickly access frequently used commands?

• Quick Access Toolbar

• Status Bar

• Title Bar

• Ribbon

What is the keyboard shortcut to create a new blank workbook in Excel?

• Ctrl + O

• Ctrl + S

• Ctrl + W

• Ctrl + N

Which ribbon would you use to insert charts and pictures into your Excel spreadsheet?

• Insert

• Home

• Data

• Review

Where can you find the formula library in Excel?

• Home Ribbon

• Insert Ribbon

• Formulas Ribbon

• Data Ribbon

Which ribbon is not turned on by default and contains advanced commands like macros?

• View

• Insert

• Developer

• Home

How can you customize which ribbons are visible in Excel?

• File > Options > Customize Ribbon

• View > Show/Hide

• Home > Ribbon Settings

• Insert > Ribbon Options

What is the purpose of the Name box in Excel?

• To display the current cell reference

• To show the workbook name

• To list all open worksheets

• To provide help tips

How are cells identified in an Excel worksheet?

• By their color

• By their size

• By cell reference

• By their content

What is the function of the status bar in Excel?

• To provide a search function

• To show the current view and zoom level

• To list all open workbooks

• To display the workbook title