You Have Been Using a Variety of Nested IF Functions

question 48

Multiple Choice

You have been using a variety of nested IF functions to calculate costs in your spreadsheet when a colleague stops by and comments on what you have been working on, suggesting that there is an easier approach to use.
-You implement the VLOOKUP formula at your colleague's suggestion,but you get the #VALUE! error as the result of the formula.Which of the following is likely true?

• A)You might have entered a table name for the table_array value instead of the cell reference of the lookup table.
• B)You might have indicated that the compare values are a range of values instead of an exact match.
• C)You might have entered a number for the col_index_num instead of a letter.
• D)You might have entered a letter for the col_index_num instead of a number.

---

Definitions:

Credit Card Issuer

The financial institution or company that provides credit cards to consumers, extending credit for their purchases.

Disputed Amount

A specific sum of money that is the subject of a disagreement between parties, often related to billing or contractual obligations.

Section 5

Could refer to a specific part of a law or statute, needing further context to accurately define; generally, it's used to denote a particular subsection of legal documentation.

FTC Act

The Federal Trade Commission Act, a law that established the FTC and aims to prevent unfair competition, and deceptive or unfair business practices.