In an INDEX function, the argument ____ refers to the part of a nonadjacent range referenced in the first argument.
A) reference
B) row_num
C) column_num
D) area_num

Question

Quizplus · Accepted Answer

The argument "area_num" in the INDEX function refers to the part of a nonadjacent range referenced in the first argument, allowing the user to specify which range to use if there are multiple nonadjacent ranges included.

In an INDEX Function, the Argument ____ Refers to the Part