Sign up for FREE

Excel - Formulas L1

Last updated about 5 years ago

6 questions

Note from the author:

Here is a short quiz to test your formulas knowledge

Spreadsheets Formulas

TEST YOUR KNOWLEDGE

1

1

1

1

1

1

Question 1

1.

Type the formula to calculate the AVERAGE Maths score.

Question 2

2.

Type the formula the user applied to calculate the Actual Cost TOTAL in cell C9

Question 3

3.

How did the user calculate the difference for costumes in cell D9?

Question 4

4.

1. If the ‘Actual Cost’ of costumes in cell C3 was changed to £290,
what three other cells would change automatically?

B3, B4 and B5

B8, B9 and D9

C9, D3 and D9

C8, C9 and D8

Question 5

5.

What simple calculation has the user entered to calculate the difference between highest and lowest

Question 6

6.

What symbol separate the first cell and last cell in a cell range?