Spreadsheet Formulas Quiz

Which of the following formulas correctly adds the values in cells A1 and B1?

• `=SUM(A1, B1)`

• `=A1 + B1`

• `=ADD(A1, B1)`

• `=A1 & B1`

What function would you use to find the average of the numbers in cells C1 through C10?

• `=SUM(C1:C10)`

• `=AVERAGE(C1:C10)`

• `=MEAN(C1:C10)`

• `=MEDIAN(C1:C10)`

Which of the following is an absolute cell reference?

• `A1`

• `A$1`

• `$A1`

How would you apply conditional formatting to highlight cells in column D that are greater than 100?

• Use the formula `=D1>100` in the conditional formatting rule.

• Use the formula `=D1<100` in the conditional formatting rule.

• Use the formula `=D1=100` in the conditional formatting rule.

• Use the formula `=D1<>100` in the conditional formatting rule.

What does the `#DIV/0!` error indicate in a spreadsheet?

• A cell reference is invalid.

• A formula is trying to divide by zero.

• A function is not recognised.

• A cell contains text instead of a number.

Which function would you use to count the number of cells that contain numbers in a range?

• `=COUNTIF(range, criteria)`

• `=COUNTA(range)`

• `=COUNT(range)`

• `=COUNTBLANK(range)`

How would you reference cell B2 from a different sheet named "Data"?

• `=Data!B2`

• `=Data.B2`

• `=Data:B2`

• `=Data-B2`

Which function returns the current date and time?

• `=TODAY()`

• `=NOW()`

• `=DATE()`

• `=TIME()`

What is the result of the formula `=IF(A1>10, "High", "Low")` if A1 contains the value 8?

• `High`

• `Low`

• `TRUE`

• `FALSE`

Which function would you use to find the largest number in a range?

• `=LARGE(range)`

• `=MAX(range)`

• `=BIG(range)`

• `=GREATEST(range)`