To apply the rounding formula to the entire worksheet:

1. Select the cell with the formula you want to apply to the entire worksheet.
2. Click on the small square in the bottom right corner of the selected cell. This will activate the "Fill" feature.
3. Drag the mouse down to the last cell in the column that you want to apply the formula to. This will fill the formula down to all the cells in that column.
4. If you want to apply the formula to other columns in the worksheet, select the entire column by clicking on the column letter at the top of the worksheet, then repeat steps 2 and 3.

To apply the formula to a specific range of cells using the "Name Manager":

1. Click on the "Formulas" tab in the Excel ribbon.
2. Click on the "Name Manager" button in the "Defined Names" group.
3. Click on the "New" button to create a new named range.
4. Enter a name for the range (e.g. "RoundedPrices").
5. In the "Refers to" field, enter the formula you want to apply to the range, using absolute cell references (e.g. =MROUND($A$1,10)-1).
6. Click "OK" to save the named range.
7. Select the range of cells you want to apply the formula to.
8. Click on the "Formulas" tab in the Excel ribbon.
9. Click on the "Name Manager" button in the "Defined Names" group.
10. Select the named range you created in step 4.
11. Click on the "Edit" button.
12. In the "Refers to" field, change the cell reference to the top-left cell of the range you selected in step 7 (e.g. =MROUND($A$1,10)-1).
13. Click "OK" to save the changes.
14. The formula should now be applied to the selected range of cells.