Year 10 CT: Analysing Data

What does the formula =SUM(A1:A5) do?

• Adds numbers in cells A1 to A5

• It finds the maximum value in the range A1 to A5.
• It counts the number of cells in the range A1 to A5.
• It calculates the average of the values in A1 to A5.

What does the formula =AVERAGE(B2:B6) do?

• It sums the values in cells B2 to B6.
• It finds the maximum value in cells B2 to B6.
• It counts the number of non-empty cells in B2 to B6.
• It calculates the average of the values in cells B2 to B6.

What symbol is used to start a formula in Excel?

• =
• @

• $

• *

What does =MAX(C1:C10) return?

• Largest number

• Minimum value

• The average value of the range C1:C10.
• The sum of the values in the range C1:C10.

Which of these formulas uses absolute referencing?

• A1+B1
• =$A1+B1
• =$A$1+B$1
• =$A$1+B1

What does $ in a formula mean?

• The $ symbol denotes a function call.
• The $ symbol is used for comments in code.
• Makes a cell reference stay the same when copied

• The $ symbol represents a mathematical constant.

What is the purpose of the formula =MIN(D2:D7)?

• To calculate the average value in the range D2 to D7.
• To count the number of entries in the range D2 to D7.
• To find the maximum value in the range D2 to D7.
• Finds the smallest number

Which formula will count how many numbers are in a list?

• =AVERAGE(range)
• =SUM(range)
• =COUNT(range)
• =MAX(range)

What will =IF(B2>50, "Pass", "Fail") return if B2 is 45?

• Pass
• Error
• Incomplete
• Fail

What will =IF(B2<50, "Good", "Try Harder") return if B2 is 54?

• B2

• Try Harder
• Good

• 50