Spreadsheet test 1

Which arithmetic operation would you use to work out the total KM for this D of E Hike?

• • MINUS -

• PLUS +

• DIVIDE /

• MULTIPLY *

• =SUM( )

Which arithmetic operation would you use to work out the discount with a Morrison's more card?

• PLUS +

• MINUS -

• MULTIPLY *

• DIVIDE /

Which arithmetic operation would you use to work out the total cost for all of the quantities of all Apples?

• DIVIDE /

• ADD +

• MINUS -

• MULTIPLY *

What formular would we use to work out all the totals?

• =MAX

• =AVERAGE

• =COUNT

• =SUM

What formular would we use to work out the number of pupils that are in this class?

• =SUM

• =AVERAGE

• =COUNT

• =MAX

What formular would we use to work out the numbers of students doing Football, Basketball and Tennis?

• =COUNT()

• =SUM()

• =MAX()

• =COUNTIF()

What should the numbers in green be formatted too?

• Percentage

• Decimal

• Currency

• Date

What formular would we use to work out the Average cost?

• =SUM()

• =AVERAGE()

• =MAX()

• =MIN()

What formular would we use to work out the Highest cost?

• =SUM()

• =AVERAGE()

• =MAX()

• =MIN()

What formular would we use to work out the Lowest cost?

• =SUM()

• =AVERAGE()

• =MAX()

• =MIN()