The correct answer is the formula bar.
Key Points
- By using the Defined names, the user can make the formulas much easier to understand and maintain.
- The user can define a name for a cell range, function, constant, or table. With the practice of using names in the workbook, the user can easily update, audit, and manage these names.
- The user Defined names will appear in the formula bar.
Additional Information
- Steps to define names from a selected range
- Select the range you want to name, including the row or column labels.
- Select Formulas > Create from Selection.
- In the Create Names from Selection dialog box, designate the location that contains the labels by selecting the Top row, Left column, Bottom row, or Right column check box.
- Select OK.
- Steps to use names in formulas
- Select a cell and enter a formula.
- Place the cursor where you want to use the name in that formula.
- Type the first letter of the name, and select the name from the list that appears.
- Or, select Formulas > Use in Formula and select the name you want to use.
- Press Enter.
- How to manage names in your workbook with Name Manager
- On the Ribbon, go to Formulas > Defined Names > Name Manager. You can then create, edit, delete and find all the names used in the workbook.