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.

  1. 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.

  2. 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).

  3. 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

← Electronic Word Processing

All S5 Subsidiary ICT questions and answers

A-level · S5 · Subsidiary ICT · ICT. Elaarn covers every class from P1 to S6. About Elaarn