Spreadsheet Functions: SUM and AVERAGE

What is the result of adding 5 and 3 using the SUM function?

• 6

• 8

• 10

• 7

Calculate the total of 10, 15, and 20 using the SUM function.

• 25

• 35

• 30

• 45

Using the SUM function, find the total of the numbers in cells A1, A2, and A3.

• =SUM(A1, A2, A3)

• =SUM(A1, A3)

• =SUM(A1:A2)

• =SUM(A1:A3)

If the values in cells B1, B2, B3, and B4 are 8, 12, 15, and 20 respectively, what is the total using the SUM function?

• 45

• 55

• 30

• 60

What is the average of the numbers 10, 15, 20, 25, and 30?

• The average is 18.

• The average is 25.

• The average is 12.

• The average is 20.

Find the average of the range A1 to A5 using the AVERAGE function.

• =AVERAGE(A1,A2,A3,A4,A5)

• =SUM(A1:A5)/5

• =A1+A2+A3+A4+A5/5

• =AVERAGE(A1:A5)

If the values in cells B1, B2, B3, B4, and B5 are 12, 18, 20, 25, and 30 respectively, what is the average using the AVERAGE function?

• 28

• 21

• 15

• 23

Calculate the average of the numbers 5, 10, 15, and 20 using the AVERAGE function.

• The average of 5, 10, 15, and 20 is 18.5.

• The average of 5, 10, 15, and 20 is 12.5.

• The average of 5, 10, 15, and 20 is 10.

• The average of 5, 10, 15, and 20 is 25.

What is the result of adding 7 and 4 using the SUM function?

• 9

• 12

• 15

• 11

Calculate the total of 25, 30, and 35 using the SUM function.

• 100

• 50

• 75

• 90