NAMING CELLS AND RANGES
Cells and ranges can be given a name so that when you need to refer to that cell or range of cells, you can refer to its name rather than an address.
- First select the cell or range of cells before creating the name.
- Click on Formula Tab and click on define name, the new name dialog box will display as illustrated below.
- In the above example suppose you want to define a “tamount” for the cell range D4:D6.
- Type the name “tamount” in name box in the new name dialog box.
- Select the scope of the name for total work book or within the sheet like sheet1.
- Click on OK to create name. You can write name within formula to calculate.
- For example you calculate G Total by using name tamount so you can write formula as below:
=sum(tamount)
EDITING CELL RANGE NAME
You can edit or delete Cell range name by click on
Name Manager in defined Names group of
Formula ribbon.
- When you click on Name Manager option then a Name Manager dialog box will appear as illustrated above.
- For a new name click on New button.
- For Editing select a name from the list and click on Edit button.
- For Deleting a name first select a name from the list and click on Delete.
GOAL SEEK
- Goal seek is a “what‐if” analysis tool
- Essentially, goal seek changes the value of one cell used in a formula by changing the value of another cell in the formula.
- Goal seek can be found under “What‐If Analysis” in the Data tab.
- With this example I am trying to determine how many apples $5 will buy me.