Free Printable Mastering Spreadsheet Functions Quiz

1.

What is the result of the formula $=5+3*2$ in a spreadsheet?

a)

11

b)

16

c)

13

d)

10

2.

Which function would you use to find the average of a range of cells in a spreadsheet?

a)

SUM

b)

AVERAGE

c)

MEDIAN

d)

MODE

3.

How would you apply conditional formatting to highlight cells greater than 100 in a spreadsheet?

a)

Use the formula $=IF(A1>100,$

b)

Use the conditional formatting rule "Cell Value > 100"

c)

Use the function $=HIGHLIGHT(A1, 100)$

d)

Use the formula $=A1>100$

4.

What is the purpose of the SUM function in spreadsheets?

a)

To find the average of numbers

b)

To add up a range of numbers

c)

To count the number of cells

d)

To find the maximum value

5.

Which of the following is a basic formula to subtract 10 from 25 in a spreadsheet?

a)

$=25-10$

b)

$=SUBTRACT(25, 10)$

c)

$=10-25$

d)

$=DIFFERENCE(25, 10)$

6.

What does the function $=MAX(A1:A10)$ do in a spreadsheet?

a)

Finds the minimum value in the range A1 to A10

b)

Finds the maximum value in the range A1 to A10

c)

Adds all the values in the range A1 to A10

d)

Counts the number of cells in the range A1 to A10

7.

How can you format a cell to display numbers as currency in a spreadsheet?

a)

Use the formula $=CURRENCY(A1)$

b)

Apply the currency format from the formatting menu

c)

Use the function $=FORMAT(A1,$

d)

Type the currency symbol manually

8.

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

a)

COUNT

b)

COUNTA

c)

COUNTIF

d)

COUNTBLANK

9.

What is the result of the formula $=10/2+3$ in a spreadsheet?

a)

8

b)

5

c)

6

d)

7

10.

Which function would you use to find the smallest number in a range of cells?

a)

MAX

b)

MIN

c)

SMALL

d)

LEAST

11.

How would you apply conditional formatting to change the text colour to red for cells containing the word "Fail"?

a)

Use the formula $=IF(A1=$

b)

Use the conditional formatting rule "Text contains 'Fail'"

c)

Use the function $=TEXTCOLOR(A1,$

d)

Use the formula $=A1=$

12.

What is the purpose of the AVERAGE function in spreadsheets?

a)

To add up a range of numbers

b)

To find the middle value in a range

c)

To find the average value of a range

d)

To find the most frequent value in a range

13.

Which of the following is a basic formula to multiply 7 by 3 in a spreadsheet?

a)

$=7*3$

b)

$=MULTIPLY(7, 3)$

c)

$=7+3$

d)

$=PRODUCT(7, 3)$

14.

How can you format a cell to display numbers as percentages in a spreadsheet?

a)

Use the formula $=PERCENTAGE(A1)$

b)

Apply the percentage format from the formatting menu

c)

Use the function $=FORMAT(A1,$

d)

Type the percentage symbol manually

15.

Which function would you use to count the number of non-empty cells in a range?

a)

COUNT

b)

COUNTA

c)

COUNTIF

d)

COUNTBLANK

16.

What is the result of the formula $=8-3+2$ in a spreadsheet?

a)

3

b)

7

c)

5

d)

6

17.

How would you apply conditional formatting to fill cells with a green background if they contain a value less than 50?

a)

Use the formula $=IF(A1<50,$

b)

Use the conditional formatting rule "Cell Value < 50"

c)

Use the function $=FILL(A1,$

d)

Use the formula $=A1<50$

Mastering Spreadsheet Functions Quiz

Total questions: 17

Worksheet time: 9mins

Similar Resources on Wayground