What Is the Proper Format for Creating an External Reference

question 27

Multiple Choice

What is the proper format for creating an external reference with no spaces in the file name located in the same folder as the destination file?

• A)[WorkbookName]"WorksheetName"!RangeOfCells
• B)[WorkbookName]'WorksheetName'!RangeOfCells
• C)WorksheetName!RangeOfCells
• D)[WorkbookName]WorksheetName!RangeOfCells

---

Definitions:

DFL

Degree of Financial Leverage, a ratio that measures the sensitivity of a company's earnings per share to fluctuations in its operating income.

EPS

Earnings Per Share; a company's profit divided by the outstanding shares of its common stock, indicating company profitability on a per-share basis.

EBIT

Earnings Before Interest and Taxes, a measure of a firm's profitability that excludes interest and income tax expenses.

EBIT

A profitability metric that calculates a company's profits excluding interest and income tax expenses.