When solving an HLOOKUP formula, Excel looks up a value by testing for a criterion across a ____.
A) row
B) column
C) table
D) worksheet

Name: When solving an HLOOKUP formula, Excel looks up a value by testing for a criterion across a ____. A) row B) column C) table D) worksheet
Brand: Quizplus
Rating: 4.8 (37 reviews)

Question

Quizplus · Accepted Answer

In an HLOOKUP formula, Excel searches for a criterion across a row, not a column, table, or worksheet. The formula returns a value from a specified cell in the same column as the search criterion.

When Solving an HLOOKUP Formula, Excel Looks Up a Value