Question 1

What function would you use to find the total sum of a range of cells in a spreadsheet?

Accepted Answer

SUM

Answer

AVERAGE

Answer

COUNT

Answer

MAX

Question 2

Which formula would you use to find the highest number in a range of cells?

Accepted Answer

MAX

Answer

MIN

Answer

AVG

Answer

SUM

Question 3

What function would you use to calculate the average of a range of numbers?

Accepted Answer

AVERAGE

Answer

TOTAL

Answer

COUNT

Answer

SUM

Question 4

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

Accepted Answer

COUNT

Answer

MAX

Answer

SUM

Answer

AVERAGE

Question 5

What is the purpose of the CONCATENATE function in spreadsheets?

Accepted Answer

To join text from multiple cells into one cell

Answer

To find the minimum number in a range

Answer

To sort numbers in ascending order

Answer

To calculate the total sum of numbers

Question 6

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

Accepted Answer

MIN

Answer

COUNT

Answer

AVERAGE

Answer

SUM

Question 7

What does the IF function do in a spreadsheet?

Accepted Answer

It checks a condition and returns one value for true and another for false

Answer

It counts the number of cells

Answer

It finds the average of a set of values

Answer

It sums up a range of numbers

Question 8

Which function can be used to round a number to the nearest integer in a spreadsheet?

Accepted Answer

ROUND

Answer

CEILING

Answer

TRUNCATE

Answer

FLOOR

Question 9

What is the function used to convert text to lowercase in a spreadsheet?

Accepted Answer

LOWER

Answer

TRIM

Answer

PROPER

Answer

UPPER

Question 10

Which function would you use to find the current date in a spreadsheet?

Accepted Answer

TODAY

Answer

DATE

Answer

NOW

Answer

TIME

Related quizzes

Related quizzes