Preskoči na glavni sadržaj

Sign up for FREE

Excel - Formulas L1

Posljednje ažuriranje over 5 years ago

6

Napomena autora:

Here is a short quiz to test your formulas knowledge

Spreadsheets Formulas

TEST YOUR KNOWLEDGE

1

Pitanje 1

1.

Type the formula to calculate the AVERAGE Maths score.

1

1

1

1

1

Pitanje 2

2.

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

Pitanje 3

3.

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

Pitanje 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

Pitanje 5

5.

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

Pitanje 6

6.

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