Page 100 - CalcBus_Flipbook

11-6 Credit with MS Excel CH 11]

10. Click on cell D10 to select it and then click inside the formula bar to enter
this formula: =(1+D9)^H5 and press the Enter key of the keyboard. This will
calculate the interest rate for one month. The + character tells the computer to add
and is found above the = key on your keyboard; you press down and hold the shift
key and then tap the = key to get the +. The ^ key (caret key) is the exponent
character or “raise to the power” the numbers. The ^ character is found above the 6
key and is the mathematical exponent in the calculation. To get the exponent
character ^ you press down and hold the shift key and then tap the 6 key.

=(1 + D9)^H5

11. Click on cell D11 to select it and then click inside the formula bar to enter
this formula: =(D9*D10)/(D10-1)and press the Enter key of the keyboard. The *
character tells the computer to multiply and is found above the 8 key on your
keyboard; you press down and hold the shift key and then tap the 8 key to get the *.
The / key (forward slash key) is the divisor character and is found under the ? key.
1 is subtracted from D15 and thus written as D10 −1.

=(D9*D10)/(D10-1)

Copyrighted Material