Back to the full dot-point answer
SingaporeComputer ScienceQuick questions
Spreadsheets and Data Processing
Quick questions on Charts, sorting and filtering explained: O-Level Computing
6short 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 choosing a chart type?Show answer
Different charts suit different jobs:
What is sorting?Show answer
Sorting rearranges the rows of a table into order based on one column. You can sort:
What is filtering?Show answer
Filtering temporarily hides the rows that do not meet a condition, leaving only the matching records visible. The data is not deleted or reordered; clearing the filter brings every row back.
What is q1?Show answer
State the most suitable chart to show how a class's study time is divided between subjects. [2 marks]
What is q2?Show answer
Explain what happens to a table when it is sorted by a column in ascending order. [2 marks]
What is q3?Show answer
State the difference between sorting and filtering a table. [2 marks]
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.