2023-24 - Y8 - Data Modelling - Quiz 4

Which cell reference contains the number of calories burnt during swimming?

• B9
• D2
• D9
• D8

Which formula would add together the two weights?

• =F3+F9
• =F3 ADD F9
• =ADD(F9, F3)
• =+F3F9

Which function should be used to add together all of the calories burnt?

• MAX
• MIN
• SUM
• AVERAGE

What would be the result of the following formula: =MAX(D2:D11)

• 400
• 500
• 250
• 600

What would be the result of the following formula: =MIN(C2:C11)

• 15
• 30
• 45
• 60

Which of the following is the correct function to find the average of the distances?

• AVG
• AV
• AVERAGE
• AVE

Which of the following is the correct function to count the number of feelings recorded?

• COUNTA
• COUNT
• COUNTER
• COUNTBLANK

What would be the result of the following formula: =COUNTBLANK(E2:E11)

• 1
• 2
• 3
• 4

What would be the result of the following formula: =COUNT(F2:F11)

• 2
• 4
• 6
• 8

Which calculation would work out the calories burnt per minute?

• Calories Burned * Duration (min)
• Calories Burned + Duration (min)
• Calories Burned / Duration (min)
• Calories Burned - Duration (min)