Top Posters
Since Sunday
e
4
h
4
h
4
m
3
d
3
B
3
o
3
w
3
H
3
a
3
c
3
k
3
Home Q & A Board Science-Related Homework Help Computer Studies
New Topic  
JohnAmera JohnAmera
wrote...
Go to Answer
Posts: 432
Rep: 0 0
6 years ago
What is the purpose of the Row_num argument in the following INDEX function?

=INDEX(A2:B5,MATCH(MAX(B2:B5),B2:B5,0),1)
A) To return the highest value in the range B2:B5
B) To return the position of the highest value in the range B2:B5
C) To return the column to the left of the highest values in the range B2:B5
D) To return the row of the highest value in the range B2:B5
Textbook 
Exploring Microsoft Office Excel 2016 Comprehensive

Exploring Microsoft Office Excel 2016 Comprehensive


Edition: 1st
Authors:
Read 73 times
1 Reply
Exploring Microsoft Office Excel
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

JohnAmera Author
wrote...

6 years ago
Thanks for your help!!
amandamraz
wrote...

Yesterday
Correct Slight Smile TY
Cdfields
wrote...

2 hours ago
Helped a lot
New Topic      
Quick Reply
Explore
Post your homework questions and get free online help from our incredible volunteers
  1389 People Browsing
Start New Topic Take the Tour CoursesNew Study Tools Topics Trending Browse by Textbook
Live Chat
Related Images
  
 377
  
 278
  
 197
Your Opinion
Which industry do you think artificial intelligence (AI) will impact the most?
Votes: 484
Previous poll results: Who will win the 2024 president election?