Back to the full dot-point answer
SingaporeComputer ApplicationsQuick questions
Spreadsheets and Charts
Quick questions on Sorting and filtering: N-Level Computer Applications spreadsheets
3short 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 sorting?Show answer
Sorting puts the rows into an order based on a column. You can sort:
What is sorting by more than one column?Show answer
You can sort by several columns in order of priority. For example, sort first by Class (A to Z), then within each class by Score (highest first). The first sort is the main order; the second sort breaks ties within the first. This groups the data neatly, such as each class together with its top scorer first.
What is filtering?Show answer
A filter hides the rows that do not meet a condition, leaving only the matching rows visible. The hidden rows are not deleted; they come back when you clear the filter. For example, you can filter a class list to show only class 4A, or a stock list to show only items with fewer than ten in stock. Filtering lets you focus on part of a large list without changing or losing the rest.
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.