GRADE 10-SPREADSHEET FUNCTIONS

Which of the following is NOT a spreadsheet function?

• MIN

• MAX

• COUNT

• TOTAL

Which FUNCTION is used to find the largest number in a column?

• MIN

• MAX

• GREATER THAN

• SUM

If you want to know how many items you bought you will need to use this FUNCTION

• AVERAGE

• MAX

• COUNT

• SUM

Refer to your practice spreadsheet. Same one as in this image. What is the correct FUNCTION used to arrive at the answer in B5

• =AVERAGE(B2:B4)

• =SUM(B2:B9)

• =TOTAL(B2:B4)

• =SUM(B2:B4)

Refer to your practice spreadsheet. Same one as in this image. Which of the following would you use to calculate answer in C8?

• =MIN(B2:C4)

• =MIN(D2:C4)

• =MIN(C2:C4)

• =MAX(B2:B4)

Refer to your practice spreadsheet. Same one as in this image. Which of the following would you use to calculate answer in B9?

• =MAX(B2:C4)

• =MIN(B2:C4)

• =AVERAGE(C2:C4)

• =SUM(B2:B4)

Refer to your practice spreadsheet. Same one as in this image. How many items are shown/used for the spreadsheet?

• 5

• 3

• 6

• 1

Refer to your practice spreadsheet. Same one as in this image. What was the most you spent on an item in Cost #1.

• $5

• $3

• $18

• $7

Refer to your practice spreadsheet. Same one as in this image. What was the lowest you spent on an item in Cost #2.

• $5

• $3

• $4

• $15

Which of the statement is NOT TRUE about the spreadsheet?

• The user bought three different items

• The average cost for Cost#1 is in B6

• The total for Cost#1 is less than Cost#2

• $15 is the total for Cost#2