When Using an INDEX Function, If You Enter a Row_num

question 68

Multiple Choice

When using an INDEX function, if you enter a row_num, column_num, or area_num outside of the range you referenced in the first argument, Excel displays ____.

• A) an error message
• B) the INDEX wizard
• C) the next nearest column or row
• D) none of the above

---

Definitions:

Relationship Roles

The functions or behaviors expected from individuals in their respective positions within interpersonal relationships.

Task Roles

Specific behaviors or functions performed by group members to ensure the progress and completion of group tasks or objectives.

Cohesive

Pertaining to a state of unity and solidarity among members of a group or structure, fostering a sense of belonging and support.

Autokinetic Effect

A psychological phenomenon where a small, stationary light in a dark room appears to move because of involuntary eye movements.