The RSC Live event

Computing (non-GCSE)

Spreadsheets

This spreadsheet is keeping track of donations made to a charity.

a.	Using 1 word, what do you think the formula in cell F3 is doing?

b.	What do you think the formula in cell F3 looks like? Circle your answer

Data held in just one place, making it easier to change if necessary.

For each employee, their point on the payscale is entered (column C) and a lookup formula in column D returns their actual salary. What two advantages are there to using a lookup here?

Starter Quiz