- Foundation
- 15 practice questions
Final self-assessment: spreadsheet basics
Test yourself on the whole course: 15 questions with answers explained.
If something looks wrong, please tell us.
Attempt all 15 questions first, working each one out on paper, then check your answers and read the explanations.
Final self-assessment
-
1. How many cells are in the range C2:E9?
- 21
- 18
- 24
- 27
Show answer
Answer: C. Columns C, D and E make 3; rows 2 to 9 make 8; 3 x 8 = 24 cells.
-
2. What is the address of the cell in the 5th column and the 12th row?
- 12E
- L5
- E12
- F12
Show answer
Answer: C. The 5th column is E, and the address is column letter then row number: E12. L5 would be the 12th column and 5th row.
-
3. A cell displays the date 04-10-2026. How does the spreadsheet store it internally?
- As a text label
- As a formula
- As a picture
- As a number
Show answer
Answer: D. Dates are stored as numbers internally, which is why they can be used in calculations.
-
4. What does =10-4/2*3 return?
- 9
- 18
- 1
- 4
Show answer
Answer: D. Division and multiplication from left to right: 4 / 2 = 2, then 2 x 3 = 6. Then 10 - 6 = 4.
-
5. What does =2*3^2 return?
- 36
- 12
- 81
- 18
Show answer
Answer: D. The power comes first: 3^2 = 9, then 2 x 9 = 18.
-
6. A1 holds 60, A2 holds 20 and A3 holds 4. What does =(A1-A2)/A3+A3 return?
- 5
- 14
- 10
- 59
Show answer
Answer: B. Brackets first: 60 - 20 = 40. Then division: 40 / 4 = 10. Then addition: 10 + 4 = 14.
-
7. A1 to A5 hold 10, 20, the word absent, 30 and 40. What does =COUNT(A1:A5) return?
- 5
- 100
- 4
- 3
Show answer
Answer: C. COUNT counts only the cells holding numbers: 10, 20, 30 and 40, so 4. The word is ignored.
-
8. A1 to A5 hold 10, 20, the word absent, 30 and 40. What does =AVERAGE(A1:A5) return?
- 20
- 25
- 30
- 100
Show answer
Answer: B. AVERAGE uses only the numbers: (10 + 20 + 30 + 40) / 4 = 100 / 4 = 25. Dividing by 5 to get 20 is the trap.
-
9. B2 to B5 hold 72, 58, 91 and 64. What does =MAX(B2:B5)-MIN(B2:B5) return?
- 33
- 27
- 58
- 149
Show answer
Answer: A. MAX = 91 and MIN = 58, so 91 - 58 = 33.
-
10. D2 holds =B2*$F$1. It is copied to E5 (one column right, three rows down). What does E5 hold?
- =C5*$F$1
- =B5*$F$1
- =C5*$G$4
- =C2*$F$1
Show answer
Answer: A. The relative B2 moves one column right and three rows down to C5; the absolute $F$1 stays fixed.
-
11. B2 holds 40, B3 holds 25 and E1 holds 5. C2 holds =B2*$E$1 and is copied to C3. What does C3 show?
- 125
- 200
- 0
- 25
Show answer
Answer: A. C3 holds =B3*$E$1 = 25 x 5 = 125. The rate stays fixed in E1 because of the dollar signs.
-
12. B2 holds =A$1. It is copied to C4. What does C4 hold?
- =A$1
- =B$1
- =B$3
- =A$3
Show answer
Answer: B. The copy moves one column right and two rows down. The column A is relative and becomes B; the row 1 is locked by the dollar sign, so the result is =B$1.
-
13. Marks 72, 55, 90, 63 and 48 are filtered to show marks above 60. How many rows stay visible?
- 2
- 4
- 3
- 5
Show answer
Answer: C. Only 72, 90 and 63 are above 60, so 3 rows stay visible; 55 and 48 are hidden, not deleted.
-
14. The names Rohit, Anil, Meena and Zoya are sorted in ascending order. What is the result?
- Zoya, Rohit, Meena, Anil
- Anil, Meena, Rohit, Zoya
- Rohit, Anil, Meena, Zoya
- Anil, Rohit, Meena, Zoya
Show answer
Answer: B. Ascending for text means A to Z: Anil, Meena, Rohit, Zoya.
-
15. Which chart is matched with a purpose it suits?
- Pie chart: change in sales over 12 months
- Scatter chart: each item's share of a budget
- Line chart: each item's share of a budget
- Line chart: rainfall in each of 12 months, to show the change over time
Show answer
Answer: D. A line chart shows change over time. A pie chart is for parts of a whole and a scatter chart for how two measures relate, so the other pairings are wrong.
Questions 1-3: lesson 1 (Workbooks, worksheets, rows, columns and cells). Questions 4-6: lesson 2 (Formulas and operators). Questions 7-9: lesson 3 (Common functions: SUM, AVERAGE, MAX, MIN and COUNT). Questions 10-12: lesson 4 (Cell references: relative, absolute and mixed). Questions 13-15: lesson 5 (Sorting, filtering and charts). Revisit a lesson for the questions you missed.
Sign in to keep track of the lessons you finish.