Question 1

Which Excel function is used to calculate the average of a set of numbers?

Accepted Answer

AVERAGE

Answer

SUM

Answer

COUNT

Answer

MAX

Question 2

What does the SUM function do in Excel?

Accepted Answer

Adds all the numbers in a range of cells

Answer

Counts the number of cells in a range

Answer

Calculates the average of numbers in a range

Answer

Finds the largest number in a range

Question 3

Which Excel function would you use to find the maximum value in a set of numbers?

Accepted Answer

MAX

Answer

AVERAGE

Answer

MIN

Answer

COUNT

Question 4

Which Excel function would you use to count the number of cells that are not empty in a range?

Accepted Answer

COUNTA

Answer

COUNT

Answer

COUNTIF

Answer

SUM

Question 5

Which Excel function is used to find the smallest number in a range of cells?

Accepted Answer

MIN

Answer

SUM

Answer

AVERAGE

Answer

MAX

Question 6

Which Excel function can be used to combine the text from multiple cells into one cell?

Accepted Answer

CONCATENATE

Answer

MERGE

Answer

JOIN

Answer

APPEND

Question 7

Which Excel function calculates the number of cells that meet a specific condition?

Accepted Answer

COUNTIF

Answer

COUNTA

Answer

AVERAGEIF

Answer

SUMIF

Question 8

What is the purpose of the VLOOKUP function in Excel?

Accepted Answer

To search for a value in the first column of a table and return a value in the same row from another column

Answer

To calculate the average of a set of values

Answer

To sort a list of numbers

Answer

To count how many cells are empty

Related quizzes