← Computer Applications syllabus

SingaporeComputer Applications

Spreadsheets and Charts

5 dot points across 5 inquiry questions. Click any dot point for a focused answer with worked past exam questions where available.

How do I use built-in functions such as SUM, AVERAGE, MAX, MIN, COUNT and IF to calculate quickly in a spreadsheet?

Use common built-in functions, including SUM, AVERAGE, MAX, MIN, COUNT and IF, with cell ranges to summarise and test data
A step-by-step answer to the N-Level Computer Applications outcome on spreadsheet functions: SUM, AVERAGE, MAX, MIN, COUNT and IF, using cell ranges to total, average and test data quickly.
9 min answer →

How do I turn spreadsheet data into a clear chart, and how do I choose the right chart type for the data?

Create charts from spreadsheet data, choose a suitable chart type, and label the chart with a title, axis labels and a legend
A step-by-step answer to the N-Level Computer Applications outcome on charts: selecting data, choosing a suitable chart type (column, line or pie), and adding a title, axis labels and a legend.
8 min answer →

How do I enter data into a spreadsheet and format cells so numbers, dates and money are clear and correct?

Enter data into a spreadsheet and apply cell formatting, including number, currency, percentage and date formats, borders and column width, to present data clearly
A step-by-step answer to the N-Level Computer Applications outcome on entering and formatting spreadsheet data: cells, rows and columns, number, currency, percentage and date formats, borders and column width.
8 min answer →

How do I write formulas in a spreadsheet, and when should I use a relative reference versus an absolute reference?

Write formulas using cell references and arithmetic operators, and choose between relative and absolute references so formulas copy correctly
A step-by-step answer to the N-Level Computer Applications outcome on spreadsheet formulas: arithmetic operators, cell references, and choosing relative versus absolute references so a formula copies correctly.
9 min answer →

How do I sort and filter data in a spreadsheet to put it in order and show only the rows I need?

Sort data by one or more columns and apply filters to display only rows meeting chosen criteria, keeping rows of data together
A step-by-step answer to the N-Level Computer Applications outcome on sorting and filtering spreadsheet data: ordering by one or more columns and filtering to show only rows that meet chosen criteria.
8 min answer →