Typing day formula would reference cell day

		6: USING FoRMULAS AND FUNCTIoNS
Delete a named range	1

4 Click Delete. 5 Click OK to clear the confirmation dialog box that appears. 6 Click Close.

	1		7	6
1 Click the Formulas tab.

6 Click OK.

7 Close the Name Manager dialog box.

letters from the rest of the name. The name DAY1 isn’t valid, but the	3		5	6
	3		5	6

6: USING FoRMULAS AND FUNCTIoNS

Using names in formulas

2 Type = followed by the formula that you want. When you want to

use a range that has a name, start typing the name instead of the

TIP If you change the name of a range of cells, Excel automati-

cally makes the name change in every one of your formulas.