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:

Bagels

A type of bread product originating from the Jewish communities of Poland, known for its dense, chewy texture and a distinctive hole in the center.

Pizzas

A popular Italian dish consisting of a round, flattened base of leavened wheat-based dough topped with tomatoes, cheese, and various other ingredients.

Cookies

Small pieces of data stored by a web server on a user's computer, designed to remember information about the user's visit.

Property Tax

A levy on property that the owner is required to pay, typically based on the value of the property, and used by municipalities to fund public services and infrastructures.