Use this spreadsheet on Students’ Test Scores to answer the questions below.
1. State the data type that is best suited for the data in each of the following fields. 

Write to choose from the options in these boxes: number, text, date

a. Name of Student

b. Date Test Taken

c. Math Mark

d. Science Mark

Look at picture. Then match the following to choose from the options in these boxes.

• NUmber

• Science Mark

• Number

• Math Mark

• Text

• Name of Student

• Date

• Date Test Taken

The teacher enters the data ‘Alex’ in the Math Mark column, but she gets an error message. Explain why she got an error message. 

Choose the correct formula to calculate the total of the Science and Math marks for Judy Andrews in the spreadsheet.

• =C2+D2

• C2+D2=

• C2+D2

• C2+E2

What is the name of the function that can be used to calculate the Total Score?

• AVERAGE

• SUM

• +

Look at the picture. To get the Total Mark for Abidah Ali, the teacher used the formula =C5+D5 instead of =10.0+25.0. Explain why.

Look at the picture. Use the spreadsheet to answer the following questions.

Choose the correct formula to calculate the number of scones remaining.

• =B2-C2

• =B5-C5

• =B5+C5

• =B5*C5

Choose the correct function to calculate the average amount of desserts sold.

• =(C2+C3+C4+C5)/5

• =SUM(C2:C5)

• =AVERAGE(C2:C5)

• =AVERAGE(B2:B5)

Choose the correct function to calculate the Total amount of desserts remaining.

• =D2+D3+D4+D5

• =SUM(D2:D5)

• =AVERAGE(D2:D5)

• =D2-D5

The Amount Sold for chocolate cake was changed from 4 to 6. What cell values will be affected by the change?

• Total Amount Remaining

• Average Amount Sold

• Amount Remaining