Scribd
Upload
12 views1 page

Section 4

The document contains a series of questions and answers related to the INDEX function in Excel. It covers what the INDEX function returns, its syntax, its capability to return values from a 2D range, the outcome when row_num is 0, and a function commonly combined with INDEX for dynamic lookups. The correct answers to the questions are provided for each inquiry.

Uploaded by

cultusnaanmudhalvanprojects
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
12 views1 page

Section 4

The document contains a series of questions and answers related to the INDEX function in Excel. It covers what the INDEX function returns, its syntax, its capability to return values from a 2D range, the outcome when row_num is 0, and a function commonly combined with INDEX for dynamic lookups. The correct answers to the questions are provided for each inquiry.

Uploaded by

cultusnaanmudhalvanprojects
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

Section 4: INDEX Function (Questions 81-100)

81. What does the INDEX function return?


a) The position of a value
b) The value at a specific position in a range
c) The sum of a range
d) The reference of a cell
Answer: b) The value at a specific position in a range

82. What is the correct syntax for INDEX (array form)?


a) =INDEX(array, row_num, [col_num])
b) =INDEX(row_num, col_num, array)
c) =INDEX([col_num], array, row_num)
d) =INDEX(array, [col_num], row_num)
Answer: a)

83. Can INDEX return a value from a 2D range?


a) Yes
b) No
Answer: a) Yes

84. What happens if row_num in INDEX is 0?


a) Returns the entire column
b) Returns an error
c) Returns the first row
d) Returns the last row
Answer: a) Returns the entire column

85. Which function is often combined with INDEX for dynamic lookups?
a) VLOOKUP
b) MATCH
c) HLOOKUP
d) SUMIF
Answer: b) MATCH

You might also like