• 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

  1. Read the cell values into a small table.
  2. Evaluate the formula with the order of operations.
  3. For copied formulas, shift only the relative parts.
  4. 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.

— Exam method

Key takeaways: evaluate with care, remember the reference rules and match chart to purpose.

Check your understanding

  1. 1. A1 = 9, A2 = 6 and A3 = 3. What does =SUM(A1:A3)/COUNT(A1:A3) return?

    1. 18
    2. 3
    3. 9
    4. 6
    Show answer

    Answer: D. SUM = 9 + 6 + 3 = 18 and COUNT = 3, so 18 / 3 = 6.

  2. 2. B1 holds 60 and C1 holds =B1*10%. What does C1 show?

    1. 600
    2. 0.6
    3. 60
    4. 6
    Show answer

    Answer: D. 10% is 0.10, so 60 x 0.10 = 6.

  3. 3. C1 holds =B1*10% and is copied down to C2. B2 holds 120. What does C2 show?

    1. 12
    2. 6
    3. 1200
    4. 120
    Show answer

    Answer: A. The copy becomes =B2*10%, and 120 x 0.10 = 12.

  4. 4. What does =MAX(7,3,11,5) return?

    1. 3
    2. 26
    3. 11
    4. 7
    Show answer

    Answer: C. MAX returns the largest value, which is 11.

  5. 5. A1 holds =$B$2+C3 and is copied three rows down to A4. What does A4 hold?

    1. =$B$5+C6
    2. =$B$2+C6
    3. =$B$2+C3
    4. =$B$2+F3
    Show answer

    Answer: B. $B$2 is absolute and stays. C3 is relative and moves 3 rows down to C6.

Privacy · Terms · Refunds · Delivery