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
New Topic  
JohnAmera JohnAmera
wrote...
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 74 times
1 Reply
Exploring Microsoft Office Excel
Replies
Answer verified by a subject expert
zatan_zazatan_za
wrote...
Posts: 265
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
Good timing, thanks!
wrote...

Yesterday
Smart ... Thanks!
wrote...

2 hours ago
Helped a lot
New Topic      
Explore
Post your homework questions and get free online help from our incredible volunteers
  1265 People Browsing
Related Images
  
 1654
  
 297
  
 242
Your Opinion

Previous poll results: How often do you eat-out per week?