Question

To modify a named range, you select its name in the Name Box, then click Name Manager in the:

A) Defined Names group on the HOME tab.
B) Edit Names group on the HOME tab.
C) Defined Names group on the FORMULAS tab.
D) Edit group on the FORMULAS tab.

Answer 1

To modify a named range in Excel, first select its name in the Name Box, then use the Name Manager found in the Defined Names group on the FORMULAS tab.

Step-by-step explanation:

To modify a named range in Microsoft Excel, you select its name in the Name Box, then click Name Manager in the: C) Defined Names group on the FORMULAS tab.

When you're working in Excel and you have a named range that needs to be updated, you can easily do this by using the Name Manager. First, you can access the Name Box usually found to the left of the formula bar to select the name of the range you want to edit.

Then, to open the Name Manager where you can add, edit, or delete named ranges, you navigate to the FORMULAS tab on the ribbon, which is the toolbar at the top of Excel. Under the FORMULAS tab, you will find the Defined Names group. Within this group, there is an option for Name Manager which opens a dialog box listing all of your named ranges.