Spreadsheet Functions

SUM, AVERAGE and COUNT are all known as spreadsheet:

• formula

• data

• functions

• graphs

A spreadsheet is used for

• creating drawings

• typing letters and resumes

• calculating data

• creating tables but not for calculations

Which of the following is an example of a range?

• D3

• D3 and D5

• D3:D18

• Sum

Use the spreadsheet you created, see sample in image. Which function calculates the total for score 1?

• =Total(B2:B4)

• =Sum(B2:B4)

• =Sum(C2:C4)

• =Total(C2:C4)

Use the spreadsheet you created, see sample in image. Type the CORRECT function that calculates the average for score 1?

Use the spreadsheet you created, see sample in image. Type YOUR CORRECT answer as a digit. What is the answer in cell C7?

Use the spreadsheet you created, see sample in image. Type YOUR CORRECT answer as a digit. What is the average for score 2? Rounded to 2 decimal places.

Use the spreadsheet you created, see sample in image. Type YOUR CORRECT answer as a digit. What is the average for score 1? Rounded to 2 decimal places.

Use the spreadsheet you created, see sample in image. Type YOUR CORRECT answer as a digit. What is the total for score 1?

Use the spreadsheet you created, see sample in image. Who got the highest number for score 2?

• Pam

• Shawna

• Bobby

• Floyd