Excel Workbook Quiz

Full Name

Email ID

What is a workbook in Excel?

• a) A single cell in a worksheet
• b) A collection of worksheets
• c) A toolbar in Excel
• d) A template for creating charts
• b) A collection of worksheets

What is the cell address for the intersection of the second column and fourth row?

• a) B2
• b) B4
• c) A4
• d) C2
• b) B4

Which of the following represents a valid cell address in Excel?

• a) A10
• b) 10A
• c) AB-1
• d) Cell_12
• a) A10

What does the cell address C3 refer to in Excel?

• a) Third column and third row
• b) Third row and third column
• c) Second column and third row
• d) Third cell in column C
• a) Third column and third row

If you use Auto filter to filter a column, what happens to the rows that do not meet the filter criteria?

• a) They are deleted
• b) They are permanently hidden
• c) They are temporarily hidden
• d) They are moved to the end of the sheet
• c) They are temporarily hidden

How can you clear all filters applied using Autofilter?

• a) Press Ctrl + Z
• b) Go to Data tab and click 'Clear' in the Filter group
• c) Double-click the column header
• d) Right-click and select 'Reset'
• b) Go to Data tab and click 'Clear' in the Filter group

What does the drop-down menu in Autofilter display?

• a) A list of all unique values in the column
• b) All rows in the worksheet
• c) Only numeric values in the column
• d) A list of formulas used in the worksheet
• a) A list of all unique values in the column

Which shortcut opens the 'Go To' dialog box to navigate to a specific cell or range?

• a) Ctrl + G
• b) Ctrl + F
• c) Shift + G
• d) Alt + D
• a) Ctrl + G