S3 · UCE Information and Communications Technology · Term 2

Spreadsheets II S3 Information and Communications Technology questions and answers

10 practice questions on Spreadsheets II in the Elaarn app, marked line by line like the exam.

Installed it? Come back and tap Open in Elaarn.

Spreadsheets II: sample questions with answers

Work each one out first, then open the answer. The full working and your marks are in the app.

  1. Question 1

    Write a formula to find the highest mark in cells B2 to B40.

    Show answer

    Answer: =MAX(B2:B40)

  2. Question 2

    Write a formula that shows "Pass" if the mark in C2 is 50 or more, otherwise "Fail".

    Show answer

    Answer: =IF(C2>=50,"Pass","Fail")

  3. Question 3

    A shop lists prices in column B and the VAT rate (18%) in cell E1. Write a formula in C2 for VAT that can be copied down the column, and explain why.

    Show answer

    Answer: =B2*E1; B2 is relative so it changes for each row; E1 is absolute so the formula always uses the VAT rate

What you practise in Spreadsheets II

  • Functions: IF, COUNT, MAX, MIN, AVERAGE
  • Relative and absolute cell references
  • Sorting and filtering data
  • Choosing and formatting charts

More S3 Information and Communications Technology topics

← Word Processing IIElectronic Publication →

All S3 Information and Communications Technology questions and answers · UCE revision

Lower secondary · S3 · Information and Communications Technology · Data Management and Sharing. Elaarn covers every class from P1 to S6. About Elaarn