Back to the full dot-point answer
SingaporeComputer ApplicationsQuick questions
Spreadsheets and Charts
Quick questions on Creating charts: N-Level Computer Applications spreadsheets
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 choosing the chart type?Show answer
Match the chart to the question: comparing items suggests columns, change over time suggests a line, and shares of a total suggest a pie.
What is selecting the data?Show answer
A chart is built from selected cells. You usually select the labels and the values together, for example the option names and their vote counts. The labels become the categories and the values become the bars, line or slices. Including the headings helps the chart name things correctly.
What is labelling the chart?Show answer
A chart must be labelled or the reader cannot tell what it shows:
What is charts update with the data?Show answer
When a chart is made from a range of cells, it stays linked to them. Change a value and the chart redraws automatically, so you do not rebuild it each time the data changes.
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.