Year 10 Plenary SUM,MAX, MIN, AVERAGE

I can find the lowest number in a range with the ... function

• MIN
• MAX
• AVERAGE
• COUNT

When you key a formula in a spreadsheet what do you key in first?

• Subtraction sign
• Equal Sign
• Addition sign
• Division sign

What function is used to add more than 2 cells?

• +

• =

• SUM

• ( )

Columns are identified using _______?

• Numbers
• Letters
• Numbers & Letters
• Cells

Rows are identified using ________?

• Numbers
• Letters
• Numbers & Letters
• Cells

SUM, AVERAGE, MAX and VLOOKUP are examples of what?

• Functions
• Tables
• Formulae
• Statistical tools

What formula would you use to find out the highest number within a range of cells?

• =Max

• =Min

• =High

=SUM(A5:A14) Could also be calculated in Excel by which formula?

• =A5+A14

• =SUM A5:A14

• =A5+A6+A7+A8+A9+A10+A11+A12+A13+A14

• =A6+A13

Which feature allows a formula to be copied to another cell yet adjusting the cell reference to match?

• Copy and paste

• Autofill

• Sum

• Fill

Which function calculates the average number in a range?

• Average

• sum and divide by the number

• Autosum

• Sum