Sign up for FREE

Excel - Formulas L2

Last updated about 5 years ago

7 questions

Note from the author:

Here is a quiz to test your knowledge of the formulas for Level 2

1

1

1

1

1

1

1

Spreadsheets Formulas - Level 2

TEST YOUR KNOWLEDGE

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.

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?

Question 7

7.

There is something missing from the following IF AND formula

=IF(AND(A1>10,B1>200,”Pass”, Fail”)
Can you write out the formula correctly?