Twa kɔ nsɛm atitiriw so

Sign up for FREE

Excel - Formulas L1

Last updated over 5 years ago

6 Nsɛmmisa

Hyɛ no nsow a efi ɔkyerɛwfo no hɔ:

Here is a short quiz to test your formulas knowledge

Spreadsheets Formulas

TEST YOUR KNOWLEDGE

1

Asemmisa {{asɛmmisaAhyɛnsode}}

1.

Type the formula to calculate the AVERAGE Maths score.

1

1

1

1

1

Asemmisa {{asɛmmisaAhyɛnsode}}

2.

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

Asemmisa {{asɛmmisaAhyɛnsode}}

3.

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

Asemmisa {{asɛmmisaAhyɛnsode}}

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

Asemmisa {{asɛmmisaAhyɛnsode}}

5.

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

Asemmisa {{asɛmmisaAhyɛnsode}}

6.

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