How does an administrator use a spreadsheet's formulae, functions and charts to process and present numerical information?
The spreadsheet features used to process and present numerical information (formulae and functions such as SUM, AVERAGE, MAX, MIN and IF, formatting, sorting and filtering, charts and graphs), and choosing the right feature for a given task.
A focused answer to the SQA National 5 Administration and IT content on spreadsheets, covering formulae and functions (SUM, AVERAGE, MAX, MIN, IF), formatting, sorting and filtering, and charts, and how to choose the right feature to process and present numerical information.
Reviewed by: AI editorial process; not yet individually human-reviewed
Have a quick question? Jump to the Q&A page
Jump to a section
What this dot point is asking
The SQA wants you to name and describe the spreadsheet features an administrator uses to process numbers (formulae and functions) and to present them (formatting and charts), and to choose the right feature for a task. Questions give a scenario such as sales figures or a budget and ask which features would help.
What a spreadsheet does
A spreadsheet is used for any task involving numbers: budgets, sales figures, stock levels, wages and invoices. Data sits in cells referenced by column and row (for example B3), and formulae use those references so results update automatically when the data changes.
Because the references update as data changes, a spreadsheet is far more than a calculator: it is a model that recalculates the moment any input is altered. This is why administrators use spreadsheets for budgets and forecasts, where they often need to ask "what if" a figure were higher or lower and see the effect at once.
Key functions and features
Choosing the right feature
The exam rewards matching the feature to the task.
Try this
Q1. State which function would add up a column of figures. [1 mark]
- Cue. SUM.
Q2. Describe two spreadsheet features used to present numerical information clearly. [2 marks]
- Cue. Formatting (currency, decimal places) and a chart or graph to show the figures visually.
Q3. Explain one benefit of using a spreadsheet rather than a calculator for a budget. [2 marks]
- Cue. It recalculates automatically when a figure changes, saving time and reducing errors.
Exam-style practice questions
Practice questions written in the style of SQA exam questions on this dot point, with worked answer explainers. The year tag is the paper they imitate, not the source.
SQA-style Describe4 marksDescribe spreadsheet features an administrator could use to process sales figures.Show worked answer →
Award 1 mark for each feature described, up to 4. Use the SUM function to add up the total sales quickly (1). Use AVERAGE to find the mean sales per month or per product (1). Use MAX and MIN to find the highest and lowest sales figures (1). Use sorting to put the figures in order, for example highest to lowest (1). Use a chart or graph to present the figures visually so trends are easy to see (1). Use formatting such as currency to make the figures clear (1). Markers reward a described feature linked to its purpose, not a one-word list.
SQA-style Explain4 marksExplain the benefits to an administrator of using formulae and functions rather than working figures out by hand.Show worked answer →
Award marks for explained benefits, up to 4. Formulae calculate automatically and quickly, saving the administrator time (1). They are more accurate than manual arithmetic, reducing errors (1). If a figure is changed, the spreadsheet recalculates the result automatically, so there is no need to redo the sums (1). Functions such as SUM and AVERAGE handle large amounts of data that would be slow to total by hand (1). Markers reward a clear benefit with its reason, not just naming the function.
Related dot points
- The word-processing and desktop-publishing features used to create and edit business documents (house style, templates, mail merge, tables, headers and footers, page numbering, find and replace, spellcheck), and choosing the right feature for a given task.
A focused answer to the SQA National 5 Administration and IT content on word processing and desktop publishing, covering features such as house style, templates, mail merge, tables, headers and footers, and how to choose the right feature to produce accurate, professional business documents.
- The database features used to store and manage information (fields and records, data types, sorting on one or more fields, searches and queries using criteria, and reports), and choosing the right feature for a given task.
A focused answer to the SQA National 5 Administration and IT content on databases, covering fields and records, data types, sorting on one or more fields, searches and queries using criteria, and reports, and how to choose the right feature to manage information.
- Good electronic file-management practice (clear folder structures, sensible file naming, version control, regular backups) and the use of an electronic diary (e-diary) to schedule appointments, set reminders and manage time.
A focused answer to the SQA National 5 Administration and IT content on electronic file management and electronic diaries, covering folder structures, file naming, version control and backups, and how an e-diary is used to schedule appointments and manage time.
- The methods of gathering information (the internet, books and journals, surveys and questionnaires, observation, internal records), the difference between primary and secondary sources, and how to judge the reliability of a source so that decisions are based on trustworthy information.
A focused answer to the SQA National 5 Administration and IT content on gathering and sharing information, covering methods of gathering information, the difference between primary and secondary sources, and how to judge whether a source is reliable so decisions rest on trustworthy information.
Sources & how we know this
- National 5 Administration and IT Course Specification — SQA (2024)
- National 5 Administration and IT - Course overview — SQA (2024)