Let’s say you are building an Excel worksheet like the one shown here, and you enter the following formula =A2/B2 into cell C2.
Because cell B2 has the value 0, the formula =A2/B2 causes an error (division by zero is mathematically undefined).
Notice that there is a small green triangle in the upper left of the cell. If you click on this triangle, you will see the Error option button. This button has a drop down menu that offers options to help resolve the error.
This is a good example of how Smart Tags and Option Buttons can provide context sensitive help. If you made another type of error other than division by zero, the choices on the option button’s menu would reflect this other error.
|