Excel formulas quiz
Spreadsheet whiz or formula fumbler? Test your Excel skills.
10 multiple-choice questions, with the answer explained after each one.
Answer each question, see why, and beat your best score.
All 10 questions and answers
Want to check an answer or run the quiz out loud? Every question is here, with the answer hidden until you open it.
- What character must every Excel formula start with?
- =
- +
- #
- @
Show answer
=. For example, =SUM(A1:A10).
- Which function adds up a range of numbers?
- TOTAL
- ADD
- PLUS
- SUM
Show answer
SUM. =SUM(B2:B20).
- Which function finds the mean of a range?
- AVERAGE
- MEDIAN
- MEAN
- MID
Show answer
AVERAGE. MEDIAN finds the middle value.
- What does =IF(A1>50,"Pass","Fail") return when A1 is 70?
- Fail
- TRUE
- 70
- Pass
Show answer
Pass. 70 > 50 is true, so the first value is returned.
- What does the $ do in $A$1?
- It locks the reference when copying
- It formats as currency
- It hides the cell
- It makes it bold
Show answer
It locks the reference when copying. It's called an absolute reference.
- Which error appears when you divide by zero?
- #REF!
- #DIV/0!
- #VALUE!
- #N/A
Show answer
#DIV/0!. Wrap the formula in IFERROR to handle it.
- Which function counts cells that meet a condition?
- IFCOUNT
- SUMIF
- COUNT
- COUNTIF
Show answer
COUNTIF. =COUNTIF(A:A,"Yes").
- Which modern function looks up a value and returns a matching result?
- SEEK
- FINDIT
- XLOOKUP
- LOOKFOR
Show answer
XLOOKUP. It replaces many uses of VLOOKUP.
- Which function returns today's date?
- DATE()
- TODAY()
- NOW_DATE()
- CURRENT()
Show answer
TODAY(). NOW() returns the date and time.
- What does a pivot table do?
- Prints sheets
- Locks cells
- Rotates a chart
- Summarises large data sets by grouping and totalling
Show answer
Summarises large data sets by grouping and totalling. Drag fields to rows, columns and values.
Read the Excel formulas guide →