RSC merchandise

Computing

Spreadsheets

To apply a specific colour depending on the average.

Here is a spreadsheet to hold exam marks. 

Conditional formatting could have been used here on Column G, how would it be used?

It is calculating an average of the marks achieved in the four exams.

It is calculating the total of the marks achieved in the four exams.

It is counting the marks achieved in the four exams.

What do you think the formula in column G is doing?

What do you think the formula looks like?

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?

This lesson will be removed by end of Summer Term 2025.

RSC merchandise

Lesson outcome

This lesson will be removed by end of Summer Term 2025.