Refer to the screenshot below. suppose we would like to create a drop-down box in cell e4 so that the user could enter a name by selecting the name from a list. one way of accomplishing this would be via the (two-word answer) feature from the ribbon.

Amanda rice has just arranged to purchase a $640,000 vacation home in the bahamas with a 20 percent down payment. the mortgage has a 7 percent apr compounded monthly and calls for equal monthly payments over the next 30 years. her first payment will be due one month from now. however, the mortgage has an eight-year balloon payment, meaning that the balance of the loan must be paid off at the end of year 8. there were no other transaction costs or finance charges. how much will amanda’s balloon payment be in eight years