Question 1

What Excel function is used to check if a condition is met in a specific cell and returns one value if true and another value if false?

Accepted Answer

IF

Answer

AVERAGE

Answer

VLOOKUP

Answer

SUM

Question 2

Which Excel function is used to find the largest value in a range of cells?

Accepted Answer

MAX

Answer

COUNT

Answer

AVERAGE

Answer

MIN

Question 3

What Excel function is used to count the number of cells in a range that meet a specific condition?

Accepted Answer

COUNTIF

Answer

IFERROR

Answer

MATCH

Answer

INDEX

Question 4

Which Excel function is used to look up a value in a vertical lookup table and return a corresponding value from the same row?

Accepted Answer

VLOOKUP

Answer

MATCH

Answer

INDEX

Answer

HLOOKUP

Question 5

Which Excel function is used to round a number to the nearest integer or to a specified number of decimal places?

Accepted Answer

ROUND

Answer

VLOOKUP

Answer

IFERROR

Answer

SUMIF

Question 6

What Excel function is used to sum a range of cells based on a given criteria?

Accepted Answer

SUMIF

Answer

COUNTIF

Answer

AVERAGEIF

Answer

MAXIF

Question 7

Which Excel function is used to look up a value in a horizontal lookup table and return a corresponding value from the same column?

Accepted Answer

HLOOKUP

Answer

MATCH

Answer

VLOOKUP

Answer

INDEX

Question 8

What Excel function is used to find the smallest value in a range of cells?

Accepted Answer

MIN

Answer

COUNT

Answer

AVERAGE

Answer

MAX

Question 9

Which Excel function is used to find the average of a range of cells?

Accepted Answer

AVERAGE

Answer

MAX

Answer

SUM

Answer

MIN

Question 10

In Excel, which symbol is used to separate arguments in a function?

Accepted Answer

,

Answer

:

Answer

.

Answer

/

Answer

;

Question 11

What is the syntax to round a number in Excel to the nearest integer?

Accepted Answer

ROUND(number, 0)

Answer

ROUNDUP(number, 0)

Answer

ROUNDDOWN(number, 0)

Answer

ROUND(number, 1)

Question 12

How should you reference a cell B2 in a formula in Excel?

Accepted Answer

B2

Answer

B$2

Answer

2B

Answer

cellB2

Question 13

What is the function to find the maximum value in a range of cells in Excel?

Accepted Answer

MAX(range)

Answer

LARGE(range)

Answer

MAXIMUM(range)

Answer

HIGH(range)

Question 14

How do you sum a range of cells in Excel using a function?

Accepted Answer

SUM(range)

Answer

SUMMARY(range)

Answer

TOTAL(range)

Answer

ADD(range)

Question 15

What is the correct function syntax to count the number of cells that contain numbers in a range in Excel?

Accepted Answer

COUNT(range)

Answer

TOTALNUM(range)

Answer

NUMCOUNT(range)

Answer

COUNTIF(range, 'number')

Question 16

What does the function CONCATENATE in Excel do?

Accepted Answer

Combines multiple strings or values into one text string

Answer

Splits a text string into multiple values

Answer

Calculates the average of a range of numbers

Answer

Finds the maximum value in a range of cells

Question 17

What is the purpose of the IF function in Excel?

Accepted Answer

To perform a logical test and return one value if the test is TRUE and another if it's FALSE

Answer

To round a number to the nearest integer

Answer

To find the average of a range of values

Answer

To count the number of cells that meet a specific criteria

Question 18

What does the LEN function in Excel do?

Accepted Answer

Returns the number of characters in a text string

Answer

Returns the date format of a cell

Answer

Returns the square root of a number

Answer

Returns the largest value in a set of numbers

Related quizzes

Related quizzes