- Practice
- About 14 min
- 5 practice questions
Spreadsheets mixed practice
Practise mixed questions combining ranges, formulas, references and charts.
If something looks wrong, please tell us.
Mixed questions test whether you can evaluate a formula by hand, copy it correctly and pick a tool. Work step by step and write intermediate values.
Method
- Read the cell values into a small table.
- Evaluate the formula with the order of operations.
- For copied formulas, shift only the relative parts.
- For tool questions, name the goal first.
Worked examples
Example 1. A1=6, A2=4, A3=2. What is =SUM(A1:A3)/COUNT(A1:A3)? SUM = 12, COUNT = 3, so 12 / 3 = 4.
Example 2. B1=50 and C1 holds =B1*10%. It is copied down to C2 where B2=80. What are C1 and C2? C1 = 50 x 0.10 = 5. C2 holds =B2*10% = 8.
Write the values, apply the order of operations, shift only relative references.
Key takeaways: evaluate with care, remember the reference rules and match chart to purpose.
Check your understanding
-
1. A1 = 9, A2 = 6 and A3 = 3. What does =SUM(A1:A3)/COUNT(A1:A3) return?
- 18
- 3
- 9
- 6
Show answer
Answer: D. SUM = 9 + 6 + 3 = 18 and COUNT = 3, so 18 / 3 = 6.
-
2. B1 holds 60 and C1 holds =B1*10%. What does C1 show?
- 600
- 0.6
- 60
- 6
Show answer
Answer: D. 10% is 0.10, so 60 x 0.10 = 6.
-
3. C1 holds =B1*10% and is copied down to C2. B2 holds 120. What does C2 show?
- 12
- 6
- 1200
- 120
Show answer
Answer: A. The copy becomes =B2*10%, and 120 x 0.10 = 12.
-
4. What does =MAX(7,3,11,5) return?
- 3
- 26
- 11
- 7
Show answer
Answer: C. MAX returns the largest value, which is 11.
-
5. A1 holds =$B$2+C3 and is copied three rows down to A4. What does A4 hold?
- =$B$5+C6
- =$B$2+C6
- =$B$2+C3
- =$B$2+F3
Show answer
Answer: B. $B$2 is absolute and stays. C3 is relative and moves 3 rows down to C6.
Sign in to keep track of the lessons you finish.