Phil Has Put Together the Worksheet Above with a 5-Year

question 79

Multiple Choice

Phil has put together the worksheet above with a 5-year cash flow estimate for his shoe company. He needs to explain the chart to his investors. Please answer the questions below using this figure as a reference.
-Phil enters the tax rate of 35% in the workbook as a range named Taxrate without first entering the value itself in the workbook. In Excel, you can give a value a range name without actually entering the value in a specific cell. To do so, you use the ____ dialog box.

• A) New Name
• B) Range Name
• C) Data Name
• D) Cell Name

---

Definitions:

Few Competitors

A market condition where only a small number of firms operate, often leading to higher prices and reduced competition.

Oligopoly

Market structure in which relatively few sellers compete and high start-up costs form barriers to keep out new competitors.

Planned Economy

Economic system in which government controls determine business ownership, profits, and resource allocation to accomplish government goals rather than those set by individual firms.

Mixed Market Economy

features both private and public enterprise, blending elements of capitalist and socialist economic systems.