Excel - Formulas L1
star
star
star
star
star
Last updated about 5 years ago
6 questions
Note from the author:
Here is a short quiz to test your formulas knowledge
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
1. If the ‘Actual Cost’ of costumes in cell C3 was changed to £290,what three other cells would change automatically?
1. 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?