Excel Searches for an Exact Match of the First Argument

question 46

Multiple Choice

Excel searches for an exact match of the first argument in the first column of the data when the range in the VLOOKUP function is

• A)TRUE.
• B)NULL.
• C)FALSE.
• D)EXACT.

---

Definitions:

Operating Income (EBIT)

Earnings Before Interest and Taxes, a measure of a company's profitability from its operations.

Dollar Sales

The total revenue generated from the sale of goods or services, measured in dollars.

Financial Leverage

The use of borrowed funds (debt) to amplify returns from an investment, which can increase the potential for profit as well as loss.

Variable Cost Ratio

The proportion of variable costs to total sales, indicating how variable costs change with sales levels.