Question

The function =HLOOKUP(F16, Discounts,2, TRUE) retrieves the value in _____.

A. The value in column 2 of the "Discounts" table.
B. The value in row 2 of the "Discounts" table.
C. The value in column F16 of the "Discounts" table.
D. The value in the second row of the "Discounts" table.

Answer 1

The function =HLOOKUP(F16, Discounts, 2, TRUE) retrieves the value in row 2 of the "Discounts" table.

Step-by-step explanation:

The function =HLOOKUP(F16, Discounts, 2, TRUE) is used to search for a value in the top row of a table or range and then return a value in the same column from a specified row.

In the given function, F16 would be the lookup value; Discounts is the table or range where the lookup is performed, 2 refers to the row number from which to retrieve the value, and TRUE indicates that an approximate match is sufficient. Therefore, the function retrieves the value in row 2 of the "Discounts" table, which corresponds to choice B.