Excel Functions and Features Quiz

Which formula correctly calculates the total of values in cells B2 to B10?

• =COUNT(B2:B10)

• =SUM(B2:B10)

• =AVERAGE(B2:B10)

• =MAX(B2:B10)

• =MIN(B2:B10)

Where can you find the 'Insert Chart' function in Excel?

• Home tab

• Insert tab

• Formulas tab

• Data tab

• Review tab

What is the keyboard shortcut to paste copied data in Excel?

• Ctrl+X

• Ctrl+C

• Ctrl+V

• Ctrl+Z

• Ctrl+Y

How do you apply percentage formatting to a cell?

• Home → Number → Percentage

• Insert → Percentage

• Data → Format as Percentage

• Formulas → Math & Trig → %

• Right-click → Percentage Style

Which function checks if a condition is met and returns different values for TRUE/FALSE?

• SUMIF

• COUNTIF

• VLOOKUP

• IF

• HLOOKUP

What does the 'Freeze Panes' feature do?

• Locks selected rows/columns while scrolling

• Merges multiple cells

• Hides sensitive data

• Creates a new worksheet

• Protects the workbook with password

Which formula finds the highest value in range C5:C15?

• =TOTAL(C5:C15)

• =MEAN(C5:C15)

• =MAX(C5:C15)

• =MIN(C5:C15)

• =MEDIAN(C5:C15)

What is the purpose of the 'Fill Handle' (small square at cell's bottom-right)?

• Delete cell contents

• Copy formulas/patterns to adjacent cells

• Insert comments

• Change font color

• Create hyperlinks

Which symbol makes a cell reference absolute (e.g.,A....A1)?

• @

• #

• $

• %

• &

What does 'VLOOKUP' do?

• Adds values vertically

• Searches for a value in the first column of a table

• Counts blank cells

• Combines text strings

• Rounds decimal numbers