Year 3: Term 3: Task 3

What do we use Microsoft Excel the most for?

• Calculations

• Typing an essay

• Showing a presentation.

The formula SUM, is used for _________.

• Addition

• Subtraction

• Division

• Multiplication

If we what to calculate the middle number, which formula do we use?

• SUM

• MAX

• MIN

• Average

If we want to calculate the number that's the most, which formula do we use?

• SUM

• MAX

• MIN

• Average

If we want to calculate the number that's the least, which formula doe we use?

• MAX

• MIN

• SUM

• Average

If I have the following numbers, what answer would I get if I use the formula SUM?

2,4,8,10,1

• 25

• 14

• 8

• 1

If I have the following numbers, what answer would I get if I use the formula MAX?

2,4,8,10,1

• 25

• 8

• 10

• 1

If I have the following numbers, what answer would I get if I use the formula MIN?

2,4,8,10,1

• 25

• 8

• 10

• 1

If I have the following numbers, what answer would I get if I use the formula Average?

2,4,8,10,1

• 5

• 25

• 8

• 1