Higher Applications of Mathematics

Checking formula errors

Finding mistakes and checking outputs sensibly.

Spreadsheet reference Spreadsheet mixed quiz

Spreadsheet reference

Check syntax, references, chart checks and common error messages.

Mixed revision quiz

Review Spreadsheet Skills with adaptive feedback.

Before you start

Know how to select a cell and read a row/column reference.
Be confident entering numbers, percentages and short text labels.
Check whether money should be shown to two decimal places.

Method chooser

Which spreadsheet method do I use?

Do you need the spreadsheet to calculate something?

Enter a formula beginning with =.

Are you copying a formula down rows or across columns?

Use relative references and the fill handle.

Should one cell stay fixed when the formula copies?

Lock the cell with $ signs.

Are you comparing an old value with a new value?

Use percentage change.

Are you tracking a loan month by month?

Build a repayment table.

Do you need to display data visually?

Create a suitable chart and check labels.

Are you looking for a relationship between two variables?

Use a scatter graph and trendline.

Is the formula showing an error?

Check syntax, references, brackets and data types.

Spreadsheet lesson

Key idea

This topic focuses on finding and correcting formula errors and unexpected outputs. A good spreadsheet should be easy to read, easy to check and easy to update when values change.
For Higher Applications, the spreadsheet is not just a calculator. You need to show a method, use suitable formulae, and interpret the output in the context of the problem.

Key spreadsheet skills

Check =, brackets, cell references, percentages and data types.
Use clear headings and units.
Use cell references rather than retyping values.
Check copied formulae before trusting outputs.

Worked examples

Walkthrough 1

Set up the calculation

A worksheet is being used for finding and correcting formula errors and unexpected outputs in a Scottish household finance context.

Put labels in row 1 so each column has a clear purpose.
Enter raw data in the first columns and keep assumptions, such as rates, in separate cells.
Use the key method: Check =, brackets, cell references, percentages and data types.

The sheet is easier to audit because inputs, formulae and outputs are separated.

Walkthrough 2

Copy the method safely

The same calculation is needed for several rows of data.

Write the formula once in the first data row.
Copy it down with the fill handle.
Check the first copied row and the final copied row to make sure references moved correctly.

The copied formula should follow the same pattern without changing any locked assumption cells.

Walkthrough 3

Interpret the output

A teacher asks for a written conclusion from the spreadsheet output.

Identify the key value produced by the spreadsheet.
State the units, such as pounds, months or percentage.
Write one sentence explaining what the value means for the decision.

A clear interpretation links the spreadsheet result back to the real problem.

Watch out

Forgetting the equals sign at the start of a formula.
Typing values into formulae instead of using cell references.
Copying a formula without checking whether a reference should be locked with $.
Entering 5% as 5 when the formula expects 0.05 or 5%.
Trusting an output without checking the units and context.

Next step

Move into practice

Use the learning notes to read formulas and references, then try varied spreadsheet errors, fill-down patterns and chart choices.

Spreadsheet mixed quiz