• Practice
  • About 25 min
  • 15 practice questions

Final self-assessment: Spreadsheet practice

Test yourself on the whole course: 15 questions with answers explained.

If something looks wrong, please tell us.

Attempt all 15 questions in about 25 minutes without a computer, writing the working for each formula. They mix every lesson of this course and are harder than the lesson checks. Mark your answers only at the end and study each explanation.

Final self-assessment

  1. 1. What does =100-20/4*2 show?

    1. 40
    2. 97.5
    3. 80
    4. 90
    Show answer

    Answer: D. Division and multiplication first, left to right: 20 ÷ 4 = 5, 5 × 2 = 10. Then 100 − 10 = 90.

  2. 2. What does =2+3*2^2 show?

    1. 20
    2. 38
    3. 14
    4. 100
    Show answer

    Answer: C. Power first: 2^2 = 4. Then 3 × 4 = 12. Then 2 + 12 = 14.

  3. 3. A price of 2400 must be increased by 15% GST. Which formula gives 2760?

    1. =2400*(1+15%)
    2. =2400+15%
    3. =2400*15%
    4. =(2400+15)%
    Show answer

    Answer: A. Adding 15% means multiplying by 1.15: 2400 × 1.15 = 2760. =2400+15% adds only 0.15, and =2400*15% gives the tax alone, 360.

  4. 4. B2 holds =A$1*$B2. It is copied to D5. What formula is in D5?

    1. =A$1*$B5
    2. =C$1*$B5
    3. =C$4*$D5
    4. =C$1*$D2
    Show answer

    Answer: B. The move is 2 columns right and 3 rows down. In A$1 the row is fixed and the column moves from A to C: C$1. In $B2 the column is fixed and the row moves from 2 to 5: $B5.

  5. 5. B8 holds =SUM(B2:B5)/$B$7. It is copied to E8. What formula is in E8?

    1. =SUM(B2:B5)/$E$7
    2. =SUM(E2:E5)/$E$7
    3. =SUM(B2:B5)/$B$7
    4. =SUM(E2:E5)/$B$7
    Show answer

    Answer: D. Copying 3 columns right moves the relative range B2:B5 to E2:E5. $B$7 is absolute in both parts, so it stays $B$7.

  6. 6. Which action leaves a formula's references exactly as they were?

    1. Cutting it and pasting it in another cell
    2. Copying it and pasting it in another cell
    3. Dragging its fill handle down
    4. Filling it right across a row
    Show answer

    Answer: A. Moving a formula (cut and paste) keeps it pointing at the same cells. Copying in any form, including the fill handle, shifts its relative references.

  7. 7. A1:A3 hold 12, 0 and 7. What does =ROUND(AVERAGE(A1:A3),1) show?

    1. 9.5
    2. 6.3
    3. 6.4
    4. 19
    Show answer

    Answer: B. Zero is a number and is counted: (12 + 0 + 7) ÷ 3 = 19 ÷ 3 = 6.333..., which rounds to 6.3. Leaving out the zero would wrongly give 19 ÷ 2 = 9.5.

  8. 8. F2 holds 59.99. What does =IF(F2>=60,"B",IF(F2>=40,"C","D")) show?

    1. B
    2. D
    3. C
    4. #VALUE!
    Show answer

    Answer: C. 59.99 is less than 60, so the first test is false; it is at least 40, so the second test is true and the result is C.

  9. 9. Marks are in B2:B6 and results (Pass/Fail) in C2:C6. Which formula adds the marks of only the students who passed?

    1. =COUNTIF(C2:C6,"Pass")
    2. =SUM(B2:B6,"Pass")
    3. =SUMIF(C2:C6,"Pass",B2:B6)
    4. =IF(C2:C6="Pass",SUM(B2:B6))
    Show answer

    Answer: C. SUMIF checks the condition in C2:C6 and adds the matching cells of B2:B6. COUNTIF would only count how many passed.

  10. 10. What does =UPPER(LEFT("Sikhora",3))&LEN("Sikhora") show?

    1. SIK7
    2. Sik7
    3. SIK 7
    4. SIKHORA3
    Show answer

    Answer: A. LEFT gives Sik, UPPER makes it SIK, and LEN("Sikhora") is 7. Joining with & and no space gives SIK7.

  11. 11. A1 holds 01-01-2024 and B1 holds 31-12-2024. What does =B1-A1 return?

    1. 366
    2. 364
    3. 12
    4. 365
    Show answer

    Answer: D. 2024 is a leap year with 366 days, but subtracting the first day from the last counts the gaps between them: 366 − 1 = 365.

  12. 12. You want rows 1 to 3 to stay visible, but no columns. Which cell do you select before freezing?

    1. A3
    2. A4
    3. B4
    4. D1
    Show answer

    Answer: B. The rows above the selected cell are frozen, and the columns to its left. A4 has rows 1-3 above it and no columns to its left.

  13. 13. C5 holds =SUM(C1:C5). What is the problem?

    1. #DIV/0!, because C5 starts empty
    2. #NAME?, because SUM needs two ranges
    3. A circular reference: the formula includes its own cell
    4. Nothing; it totals C1 to C5 correctly
    Show answer

    Answer: C. The range includes C5, so the formula depends on its own result. Excel warns about a circular reference and Calc shows Err:522. Use =SUM(C1:C4) instead.

  14. 14. A chart must show a company's monthly profit for three years so that rises and falls are easy to see. Which chart fits best?

    1. Line chart
    2. Pie chart
    3. Bar chart sorted by profit
    4. Pie chart for each month
    Show answer

    Answer: A. A trend over time is a line chart's job; months run along the horizontal axis. Pie charts show shares of one total, and sorting by profit would destroy the time order.

  15. 15. A sheet prints with its last two columns on a separate page. Which setting fixes this most directly?

    1. Freeze the first row
    2. Scale the sheet to fit all columns on one page (and use landscape)
    3. Apply a filter
    4. Turn on AutoFill
    Show answer

    Answer: B. Scaling to one page wide, usually together with landscape orientation, brings all columns onto the same page. Freezing and filtering affect the screen and the rows shown, not the page width.

Use your results to choose what to revise. Questions 1-3: lesson 1 (order of operations and percentages). Questions 4-6: lesson 2 (relative, absolute and mixed references). Questions 7-10: lesson 3 (functions, nested IF, SUMIF and text). Questions 11-12: lesson 4 (dates and freeze panes). Questions 13-15: lesson 5 (errors, charts and printing). Rebuild any task you missed on a real sheet in Calc or Excel.

Sign in to keep track of the lessons you finish.

Privacy · Terms · Refunds · Delivery