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.
Question 1
In a spreadsheet, what is the name of the cell in column C, row 5?
Show answer
Answer: C5
Question 2
Write the formula to add the numbers in cells B2 to B10 using a function.
Show answer
Answer: =SUM(B2:B10)
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
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