If You See ____ as the Result of a VLOOKUP

question 36

Multiple Choice

If you see ____ as the result of a VLOOKUP formula you might have entered a letter for the col_index_num instead of a number.

• A)#NULL
• B)#REF?
• C)#NAME?
• D)#DIV\0

---

Definitions:

Average Collection Period

The mean number of days a company waits to get payments from customers for products or services provided on credit.

Balance Sheet

A document showcasing a corporation's assets, obligations, and the equity held by shareholders on a specific date.

Sales On Account

Transactions where goods or services are delivered but payment is delayed, creating an account receivable on the balance sheet.

Average Sale Period

The average sale period is a financial metric indicating the average time taken to convert inventory into sales, also known as the inventory turnover period.