Question
When Range_lookup argument with the word TRUE is defined in the HLOOKUP function, then the data specified in the table_array argument must be sorted? a)
When Range_lookup argument with the word TRUE is defined in the HLOOKUP function, then the data specified in the table_array argument must be sorted?
a) from left to right in ascending order based on the row values specified in the argument index_number.
b) from left to right in ascending order based on the first-row values.
c) from left to right in descending order based on the first-row values.
d) from left to right in descending order based on the row values specified in the argument index_number.
Step by Step Solution
3.35 Rating (155 Votes )
There are 3 Steps involved in it
Step: 1
The answer is b from left to right in ascending order based on the firstrow val...
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Succeeding in Business with Microsoft Excel 2013 A Problem Solving Approach
Authors: Debra Gross, Frank Akaiwa, Karleen Nordquist
1st edition
978-1285099149, 9781285963969, 1285099141, 1285963962, 978-1285715346
