Excel mock tests
Test yourself on the whole course, against the clock: questions from every module, then coding problems you solve and run right here. Your score comes at the end, with every answer explained.
Each mock test has 12 questions drawn from the lessons, and 45 minutes on the clock, which keeps running if you reload. Questions are worth a point each. Score 60% or more to pass; your best score is kept.
- 01Mock test 112 questions · 45 minutes · 12 points
- 02Mock test 212 questions · 45 minutes · 12 points
- 03Mock test 312 questions · 45 minutes · 12 points
Part A · 12 questions
- Which reference stays fixed in both directions when copied?
- In =VLOOKUP("P04", A2:C5, 2, FALSE), which column is returned?
- What does =COUNTIFS(B2:B8, "North", D2:D8, ">500") count?
- A range contains 4, 0, blank and 8. What does AVERAGE return?
- A column holds 10 names and 2 empty cells. What does COUNT give?
- Which match_mode finds the band for a score, using each band's lower limit?
- What does =SUMIF(B2:B8, "North", D2:D8) add up?
- What does the custom format 00000 do to the number 731?
- A2 contains " priya NAIR ". Which formula gives "Priya Nair"?
- When does a combo chart with a secondary axis help?
- Why write $A$2:$C$5 instead of A2:C5 in a VLOOKUP you'll fill down?
- What does =MATCH("Maya", B2:B6, 0) return?
Part A · 12 questions
- What does the range A1:B3 contain?
- What is the difference between FIND and SEARCH?
- Why does INDEX/MATCH keep working when a column is inserted into the table?
- How many MATCH functions does a two-way lookup by row and column need?
- Which area of a PivotTable holds the numbers being summed or counted?
- A2 contains 10 and B2 contains 4. What does =A2-B2*2 show?
- Why can you subtract one date from another in Excel?
- How do you add amounts for dates in June 2024 only?
- How do you count amounts greater than the value in cell F1?
- What does the error #DIV/0! mean?
- What is the address of the cell in column D, row 7?
- What layout should the source data have?
Part A · 12 questions
- What does =EOMONTH(DATE(2024,2,10), 0) return?
- What does =IFERROR(A1/B1, "-") show when B1 is 0?
- What kind of match does XLOOKUP do if you give only three arguments?
- Why should a column chart's value axis start at zero?
- Which formula adds the values in C2 to C10?
- D2 contains =B2*C2. You fill it down to D5. What formula is in D5?
- Which formula returns "Pass" only when B2 is at least 50 AND C2 is "Submitted"?
- A cell displays 18% after formatting. What value does a formula see?
- You apply Percentage format to a cell containing 25. What does it show?
- Which chart best shows how monthly visitors changed over a year?
- =A1*B1 in C1 is copied down to C2. What does it become?
- How do you show "Not found" instead of #N/A?