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.
Question 1
Write a formula to find the highest mark in cells B2 to B40.
Show answer
Answer: =MAX(B2:B40)
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")
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