With the INDEX function, if you specify ____ contiguous range(s), you can omit the area_num argument.
A) only one
B) one or two
C) two or more
D) three or more

Name: With the INDEX function, if you specify ____ contiguous range(s), you can omit the area_num argument. A) only one B) one or two C) two or more D) three or more
Brand: Quizplus
Rating: 4.9 (34 reviews)

Question

Quizplus · Accepted Answer

The INDEX function can only work with one contiguous range when omitting the area_num argument. Therefore, the correct choice is A which specifies only one contiguous range.

With the INDEX Function, If You Specify ____ Contiguous Range(s)