Top Posters
Since Sunday
6
n
3
j
3
o
2
x
2
c
2
2
p
2
n
2
3
2
C
2
z
2
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
David_DiSanto David_DiSanto
wrote...
Go to Answer
Posts: 421
Rep: 0 0
6 years ago
What type of match would the following function return when the lookup array is sorted in descending order?

 =MATCH(A3,B7:B53,-1)
A) The match would be the greatest value in the list that is less than or equal to the value of A3.
B) The match would be an exact match to A3.
C) The match would be A3-1.
D) The match would be the smallest value in the list without going over the value of A3.
Textbook 
Exploring Microsoft Office Excel 2016 Comprehensive

Exploring Microsoft Office Excel 2016 Comprehensive


Edition: 1st
Authors:
Read 262 times
2 Replies
Replies
Answer verified by a subject expert
zatan_zazatan_za
wrote...
#1
Posts: 265
Rep: 13 0
6 years ago
Sign in or Sign up in seconds to unlock everything for free
More solutions for this book are available here
1

Related Topics

wrote...
#2
3 years ago
THANKS
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  963 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 375
  
 198
  
 340
Your Opinion
Where do you get your textbooks?
Votes: 372
Previous poll results: Should Ph.D.'s be addressed as doctors?