George Runs a Mid-Size Accounting Practice and Recently Upgraded to Excel

question 11

Multiple Choice

George runs a mid-size accounting practice and recently upgraded to Excel 2010.He expects sales to grow in the next few months during tax season.After that, he would like to begin upgrading some of the equipment and furniture for the employees in his office.He will start with the Reception area, which has the most visibility.In George's Sales Data worksheet, the result for a formula in cell H14 is ######.What should George do?

• A)increase the width of column H
• B)provide a correct argument or operand
• C)run the calculation again to find the available value
• D)replace the incorrect formula in cell H14 with one that does not divide by zero

---

Definitions:

Expected Rate

Anticipated return on an investment, often based on historical data or the inherent risk of the investment.

Dollar-weighted Return

This type of return measures the performance of an investment, taking into account the timing and magnitude of inflows and outflows of money.

Time Period

The duration or length of time for which an investment, project, data collection, or any specified activity lasts.

VaR

Value at Risk, a statistical measure used to assess the level of financial risk within a firm, portfolio, or position over a specific time frame.