Question

Edit the Bonuses named range so it refers to cells B9:B12 on the Bonus worksheet. Close the Name Manager when you are finished.

Answer 1

To edit a named range in Excel, access the Name Manager via the Formulas tab, select the range to edit, and adjust the 'Refers to' field to the new desired range, ensuring accuracy in the worksheet name and cell references.

Step-by-step explanation:

The question pertains to modifying a named range in Microsoft Excel. Here's how you would edit the Bonuses named range to refer to cells B9:B12 on the Bonus worksheet:

1. Open the Excel workbook that contains the named range you wish to edit.
2. Go to the Formulas tab on the Excel ribbon.
3. Click on Name Manager.
4. In the Name Manager dialog box, locate the Bonuses named range and select it.
5. Click the Edit button.
6. In the Edit Name dialog box, modify the Refers to field to reflect the new range 'Bonus'!$B$9:$B$12.
7. Click OK to save your changes.
8. Close the Name Manager by clicking the Close button. Your changes will be saved.

Make sure the worksheet name and range are accurate and do not have any typos to ensure that Excel can correctly identify the new range for the Bonuses named range.