S5 · A-level Subsidiary ICT · Term 3
Electronic Spreadsheet S5 Subsidiary ICT questions and answers
10 practice questions on Electronic Spreadsheet in the Elaarn app, marked line by line like the exam.
Installed it? Come back and tap Open in Elaarn.
Electronic Spreadsheet: 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
Define the following spreadsheet terms: cell, range and workbook.
Show answer
Answer: Cell = row/column intersection; range = group of cells; workbook = file of worksheets.
Question 2
Distinguish between a relative and an absolute cell reference, giving an example of each.
Show answer
Answer: Relative changes on copying (B2); absolute stays fixed (E1).
Question 3
In a marks sheet, a student's mark is in C2. Write one formula for D2 that shows "Distinction" for 80 and above, "Pass" for 50 to 79, and "Fail" below 50. Explain how the formula works.
Show answer
Answer: =IF(C2>=80,"Distinction",IF(C2>=50,"Pass","Fail")); tests in order; copy down.
What you practise in Electronic Spreadsheet
- Spreadsheet concepts and terms
- Formulas and cell references
- Built-in functions
- Charts
- Managing data: sort, filter, conditional formatting
More S5 Subsidiary ICT topics
A-level · S5 · Subsidiary ICT · ICT. Elaarn covers every class from P1 to S6. About Elaarn