Use the drop-down menus to complete the steps for adding conditional formatting to a form. 1. Open the form in view. 2. Click the desired field for the conditional formatting. 3. Click the Format tab, then . 4. In the Rules Manager dialog box, click . 5. Select “check values in the current record or use an expression.” 6. Complete the drop-down menus to determine the condition. 7. Make sure to change the formatting using a color or font so you will clearly see the changes made. Click OK. 8. When you are satisfied with your rule, click and then OK.

Suppose that jim plans to borrow money for an education at texas a& m university. jim will need to borrow $25,000 at the end of each year for the next five years (total=$125,000). jim wishes his parents could pay for his education but they can’t. at least, he qualifies for government loans with a reduced interest rate while he is in school. he has a special arrangement with aggiebank to lend him the money at a subsidized rate of 1% over five years without having to make a payment until the end of the fifth year. however, at the end of the fifth year, jim agrees to pay off the loan by borrowing from longhorn bank. longhorn bank will lend him the money he needs at an annual interest rate of 6%. jim agrees to pay back the longhorn bank with 20 annual payments and the payments will be uniform (equal annual payments including principal and interest). (i) calculate how much money jim has to borrow at the end of 5 years to pay off the loan with aggiebank. a. $121,336 b. $127,525 c. $125,000 d. $102,020 e. none of the above