DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What is the name of the dialog box that enables you to create, edit, delete, and filter range names in a workbook?
|
|
Manage Names
|
|
|
Name Manager
|
|
|
Define Names
|
|
|
Range Manager
|
Explanation:
Detailed explanation-1: -To manage range names, go to the Formulas tab, select Name Manager, choose a name, then select Delete or Edit.
Detailed explanation-2: -On the Formulas tab, in the Defined Names group, click Name Manager. In the Name Manager dialog box, double-click the name you want to edit, or, click the name that you want to change, and then click Edit.
Detailed explanation-3: -The Name Manager is a dialog box in Excel that allows you to create, edit, and delete defined names. These names can be named ranges, named formulas, and named constants. Using named ranges can make formulas easier to read, understand. and maintain Names also provide simple navigation via the Name Box.
There is 1 question to complete.