S2 · UCE Information and Communications Technology · Term 1

Spreadsheets I S2 Information and Communications Technology questions and answers

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

Installed it? Come back and tap Open in Elaarn.

Spreadsheets I: 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

    In a spreadsheet, what is the name of the cell in column C, row 5?

    Show answer

    Answer: C5

  2. Question 2

    Write the formula to add the numbers in cells B2 to B10 using a function.

    Show answer

    Answer: =SUM(B2:B10)

  3. Question 3

    The school canteen manager writes daily sales in a book and often makes mistakes when adding totals. Explain how she could use a spreadsheet to record sales, find weekly totals and see which item sells best.

    Show answer

    Answer: Applies spreadsheet features to the canteen's records; Enter items in rows and days in columns; Use =SUM to find totals automatically; Use AVERAGE / sort to compare items; Draw a bar chart to see the best-selling item

What you practise in Spreadsheets I

  • Spreadsheet terms: cells, rows, columns
  • Entering formulas
  • Using functions such as SUM and AVERAGE
  • Creating charts

More S2 Information and Communications Technology topics

Electronic Presentation →

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

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