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:

Sale of Goods Act

Legislation governing the sale of goods that outlines the rights and obligations of the buyer and seller.

Writing Requirements

Legal stipulations that certain types of contracts or agreements must be in writing to be enforceable.

Purchase Order

A commercial document issued by a buyer to a seller, indicating types, quantities, and agreed prices for products or services.

Title

The legal right to own, use, or dispose of property, as well as the formal document that serves as evidence of such ownership.