Microsoft Excel Functions Questions and Answers 2

Question 1

What does the COUNTIF function do in Excel?

Accepted Answer

Counts the number of cells in a range that meet a single condition

Answer

Counts all non-empty cells in a range

Answer

Counts the number of unique values in a range

Answer

Counts cells that contain formulas

Question 2

Which function would you use to find the largest value in a range of cells?

Accepted Answer

MAX

Answer

LARGE

Answer

HIGH

Answer

TOP

Question 3

What does the VLOOKUP function's fourth argument (range_lookup) control?

Accepted Answer

Whether to find an exact match or an approximate match

Answer

The number of columns to search

Answer

Whether the search is case-sensitive

Answer

The direction of the lookup

Question 4

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

Accepted Answer

AVERAGEIF

Answer

AVGIF

Answer

AVERAGE

Answer

SUMIF

Question 5

What does the CONCATENATE function do in Excel?

Accepted Answer

Joins two or more text strings into one string

Answer

Splits a text string into separate cells

Answer

Compares two text strings for equality

Answer

Removes duplicate characters from text

Question 6

Which Excel function removes leading and trailing spaces from a text string?

Accepted Answer

TRIM

Answer

CLEAN

Answer

STRIP

Answer

COMPACT