Excel goal seek and naming cells

Excel s Goal Seek Tool and Naming of Cells 

We saw in Section 6-8 that GOAL SEEK finds solutions to numerical equations. In setting up Equation 9-22, we made the (superb) approximation [H+] [OH ] and neglected [OH ]. With goal SEEK, it is easy to use Equations 9-20 and 9-21 without approximations  

The spreadsheet illustrates GOAL SEEK and the naming of cells to make formulas more meaningful. In column A, enter labels for Ka, Kw, FHA, FA, Hf], and [OH ]. Write numerical values for Ka, Kw. FHA. and FA in B1 B4. In cell B5, enter a guess for H 

Now we want to name cells B1 through B6. Select cell Bl, go to the INSERT menu, select NAME and then DEFINE. The window will ask if you want to use the name Ka that appears in cell Al. If you like this name, click OK. By this procedure, name the other cells in column B Kw . FHA . FA , H , and OH . Now when you write a formula referring to cell B2, you can write Kw instead of B2. Kw is an absolute reference to cell B 2. 

In cell B6 enter the formula =Kw/H and Excel returns the value IE-11 for [OH ]. The beauty of naming cells is that =Kw/H is easier to understand than = B 2/ B 5 . 

---