Which tool would you use to edit a named range named 'CurrentSalaries' so it refers to B2:B6 on the Salaries worksheet?

Which tool would you use to edit a named range named 'CurrentSalaries' so it refers to B2:B6 on the Salaries worksheet?

• A. Home > Name Manager
• B. Data Validation
• C. Formulas, Name Manager, Current Salaries
• D. Review > Protect Workbook

Answer: (C)

To adjust what a named range points to, you use the Name Manager so you can see and edit the Refers to value for that name. In Excel, Name Manager is found under the Formulas tab. Open it, select the named range CurrentSalaries, and change its Refers to to the range on the Salaries sheet, for example =Salaries!B2:B6 (or Salaries!$B$2:$B$6). This directly updates the named range so any formulas or data validations that rely on CurrentSalaries now reference those cells. The other options aren’t about editing what a named range references: Data Validation controls input rules, Protect Workbook deals with security and permissions, and the path Home > Name Manager isn’t the correct location for managing named ranges.

To adjust what a named range points to, you use the Name Manager so you can see and edit the Refers to value for that name. In Excel, Name Manager is found under the Formulas tab. Open it, select the named range CurrentSalaries, and change its Refers to to the range on the Salaries sheet, for example =Salaries!B2:B6 (or Salaries!$B$2:$B$6). This directly updates the named range so any formulas or data validations that rely on CurrentSalaries now reference those cells.

The other options aren’t about editing what a named range references: Data Validation controls input rules, Protect Workbook deals with security and permissions, and the path Home > Name Manager isn’t the correct location for managing named ranges.