Excel - Formulas L2
star
star
star
star
star
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
Type the formula to calculate the AVERAGE Maths score.
Type the formula to calculate the AVERAGE Maths score.
1
Type the formula the user applied to calculate the Actual Cost TOTAL in cell C9
Type the formula the user applied to calculate the Actual Cost TOTAL in cell C9
1
How did the user calculate the difference for costumes in cell D9?
How did the user calculate the difference for costumes in cell D9?
1
If the ‘Actual Cost’ of costumes in cell C3 was changed to £290,what three other cells would change automatically?
If the ‘Actual Cost’ of costumes in cell C3 was changed to £290,
what three other cells would change automatically?
1
What simple calculation has the user entered to calculate the difference between highest and lowest
What simple calculation has the user entered to calculate the difference between highest and lowest
1
What symbol separate the first cell and last cell in a cell range?
What symbol separate the first cell and last cell in a cell range?
1
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?
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?