Microsoft Excel Formulas and Functions 2

Question 1

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

Accepted Answer

Exact match (FALSE) or approximate match (TRUE)

Answer

FALSE requires exact match; TRUE allows approximate match from sorted data.

Question 2

How does the IF function handle nested conditions?

Accepted Answer

Value_if_false can contain another IF for multiple conditions

Answer

You can nest IF functions by placing another IF as the value_if_false argument.

Question 3

What is the difference between SUMIF and SUMIFS?

Accepted Answer

SUMIF applies one criterion, SUMIFS applies multiple with AND logic

Answer

SUMIF handles one condition; SUMIFS evaluates multiple criteria, summing where ALL are met.

Question 4

What replaced CONCATENATE and why?

Accepted Answer

CONCAT and TEXTJOIN; they accept ranges and add delimiters

Answer

CONCAT accepts ranges; TEXTJOIN adds delimiters and can skip empty cells.

Question 5

How does INDEX work with a single range?

Accepted Answer

Returns the value at a specified row position

Answer

INDEX returns the value at a given row and optional column position within a range.

Excel Practice Test