Back to the full dot-point answer
SingaporeComputer ScienceQuick questions
Spreadsheets and Data Processing
Quick questions on Common spreadsheet functions explained: O-Level Computing
4short Q&A pairs drawn directly from our worked dot-point answer. For full context and worked exam questions, read the parent dot-point page.
What is cell ranges with a colon?Show answer
A range is a block of cells written with a colon between the first and last cell. B2:B11 means every cell from B2 down to B11. A range can also span columns, such as A1:C3 for a rectangular block.
What is cOUNT counts numbers, not text?Show answer
A key detail: COUNT counts only cells that hold a number. Empty cells and cells holding text are ignored. This is why COUNT over a column of marks gives the number of students who actually sat the test.
What is q1?Show answer
Write a function to find the smallest value in cells D1 to D20. [2 marks]
What is q2?Show answer
State what the colon means in the range A2:A10. [1 mark]
Have a question we have not covered?
This dot-point answer is short enough that we have not extracted many short questions yet. Read the full dot-point answer or ask Mo, our study assistant, in the chat for follow ups.