MS Excel Quiz

What is the primary area where data is entered and manipulated in Excel?

• Formula Bar

• Status Bar

• Worksheet Grid

• Ribbon

Which component of the Excel interface displays the name of the workbook?

• Sheet Tabs

• Name Box

• Formula Bar

• Title Bar

What keyboard shortcut is used to go to the first cell (A1) in Excel?

• Alt + Tab

• Ctrl + Home

• Ctrl + Arrow Keys

• Ctrl + End

Which of the following is NOT a method to manage worksheets in Excel?

• Adding Worksheets

• Exporting Worksheets

• Renaming Worksheets

• Deleting Worksheets

What does the Name Box in Excel do?

• Displays the workbook name

• Shows the address of the selected cell

• Contains commands for formatting

• Displays the current formula

Which function would you use to calculate the average of a set of numbers in Excel?

• COUNT()

• SUM()

• AVERAGE()

• MAX()

What is the purpose of Conditional Formatting in Excel?

• To highlight cells based on conditions

• To protect cells from editing

• To format text styles

• To create charts and graphs

Which of the following is a logical function in Excel?

• SUM()

• IF()

• VLOOKUP()

• AVERAGE()

What does the F2 key do in Excel?

• Edits the active cell

• Opens a new workbook

• Saves the workbook

• Closes the application

Which of the following is a method to protect a worksheet in Excel?

• Conditional Formatting

• Data Validation

• Cell Formatting

• Password Protection