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

Question

Quizplus · Accepted Answer

The Defined Names group on the FORMULAS tab contains the Name Manager option which allows you to modify named ranges. The Edit Names group on the HOME tab also allows you to manage named ranges, but it does not have the same level of functionality as the Name Manager in the Defined Names group on the FORMULAS tab. Therefore, the best choice is C.

To Modify a Named Range,you Select Its Name in the Name