GMetrix Exam GMetrix Excel: Formulas and Functions 5

Question 1

What is the purpose of the XLOOKUP function compared to VLOOKUP?

Accepted Answer

XLOOKUP can search in any direction and returns a range instead of a column index

Answer

XLOOKUP searches in any direction, returns an array, and doesn't require a col_index_num like VLOOKUP.

Question 2

Which function converts a text string to all uppercase letters?

Accepted Answer

UPPER

Answer

UPPER converts every letter in a text string to uppercase.

Question 3

What does =CHOOSE(2, "Apple", "Banana", "Cherry") return?

Accepted Answer

Banana

Answer

CHOOSE returns the value from the list that corresponds to the index number; index 2 returns the second value.

Question 4

Which statistical function returns the most frequently occurring value in a range?

Accepted Answer

MODE

Answer

MODE returns the value that appears most often in a data set.

Question 5

What does the formula =A1&" "&B1 do?

Accepted Answer

Joins the text values of A1, a space, and B1

Answer

The ampersand & operator concatenates text values, combining A1, a space, and B1 into one string.

GMetrix Exam Practice Test