Question 1

What does the IF function in a spreadsheet do?

Accepted Answer

It performs a logical test and returns one value if TRUE and another value if FALSE

Answer

It counts the number of cells with numerical values

Answer

It finds the average of a set of numbers

Answer

It calculates the sum of a range of cells

Question 2

Which of the following formulas correctly calculates the average of cells A1 to A10?

Accepted Answer

=AVERAGE(A1:A10)

Answer

=AVERAGE(A1, A10)

Answer

=AVG(A1:A10)

Answer

=MEAN(A1:A10)

Question 3

What is the result of the formula =IF(A1>10, 'High', 'Low') when A1 contains the value 15?

Accepted Answer

'High'

Answer

'15'

Answer

'10'

Answer

'Low'

Question 4

Which function would you use to find the total sum of numerical values in cells B1 through B10?

Accepted Answer

=SUM(B1:B10)

Answer

=ADD(B1:B10)

Answer

=SUMMATION(B1:B10)

Answer

=TOTAL(B1:B10)

Question 5

In a spreadsheet, what does the formula =COUNT(A1:A5) do?

Accepted Answer

Counts the number of cells in the range A1 to A5 that contain numerical values

Answer

Counts all the cells regardless of their content

Answer

Adds up all the values in A1 to A5

Answer

Calculates the average of the values in A1 to A5

Question 6

Which of the following functions will return the highest value in the range C1 to C10?

Accepted Answer

=MAX(C1:C10)

Answer

=HIGH(C1:C10)

Answer

=HIGHEST(C1:C10)

Answer

=LARGEST(C1:C10)

Question 7

What will the formula =IF(A1<5, 'Under', IF(A1=5, 'Equal', 'Over')) return when A1 is 3?

Accepted Answer

'Under'

Answer

'Over'

Answer

'None'

Answer

'Equal'

Question 8

What function would you use in a spreadsheet to check if a value in cell A1 is greater than 10 and return 'Yes' if true or 'No' if false?

Accepted Answer

IF(A1>10, 'Yes', 'No')

Answer

SUM(A1, 10)

Answer

VALUE(A1, 10)

Answer

CHECK(A1>10, 'Yes', 'No')

Question 9

Which of the following formulas will correctly calculate the average of the values in cells B1 through B10?

Accepted Answer

AVERAGE(B1:B10)

Answer

CALC(B1:B10)

Answer

SUM(B1:B10)/10

Answer

MEAN(B1:B10)

Related quizzes