Microsoft Office Tutorials and References
In Depth Information
Goal Seeking
9. Click the Style list box and choose an alert icon, such as Stop or
10. Click in the Title text box and type a title for your error message.
11. Click in the Error Message text box and type the message to appear if
the user types invalid data into the cell.
12. Click OK.
After you define data validation for a cell, you can always remove it later. To
remove validation for a cell, follow these steps:
1. Click in the cell that contains data validation.
2. Click the Data tab.
3. Click the Data Validation icon in the Data Tools group.
The Data Validation dialog box appears (refer to Figure 9-11).
4. Click Clear All and then click OK.
Excel clears all your data validation rules for your chosen cell.
Goal Seeking
When you create a formula, you can type in data to see how the formula
calculates a new result. However, Excel also offers a feature known as Goal
Seeking. With Goal Seeking, you specify the value you want a formula to
calculate, and then Excel changes the data in the formula’s cell references to tell
you what values you need to achieve that goal.
For example, suppose you have a formula that calculates how much money
you make every month by selling a product such as cars. Change the number
of cars you sell, and Excel calculates your monthly commission. But if you
use Goal Seeking, you can specify you want to earn $5,000 for your monthly
commission, and Excel will work backward to tell you how many cars you
need to sell. As its name implies, Goal Seeking lets you specify a goal and see
what number, in a specific cell, needs to change to help you reach your goal.
To use Goal Seeking, follow these steps:
1. Click in a cell that contains a formula.
2. Click the Data tab.
Search JabSto ::

Custom Search