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

COUNTIF(range, criteria) counts cells that match a specified condition, such as counting how many cells contain a value greater than 100 or matching a specific text.

Question 2

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

Accepted Answer

MAX

Answer

MAX returns the largest numeric value in a range. For example, =MAX(A1:A100) returns the highest value from that range.

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 fourth argument controls match type: FALSE (or 0) requires an exact match, while TRUE (or 1) allows an approximate match using a sorted lookup column.

Question 4

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

Accepted Answer

AVERAGEIF

Answer

AVERAGEIF(range, criteria, [average_range]) calculates the arithmetic mean of cells that satisfy the specified condition.

Question 5

What does the CONCATENATE function do in Excel?

Accepted Answer

Joins two or more text strings into one string

Answer

CONCATENATE joins multiple text strings into a single string. It has been largely replaced by CONCAT and TEXTJOIN in newer Excel versions.

Excel Practice Test

Excel Practice Test

Microsoft Excel Functions Questions and Answers 2