What does a formula do in a spreadsheet program? A. It uses data entered in certain cells to calculate values for other cells.

B. It directs users where to enter important data and what ranges the values of those pieces of data should fall within.

C. It directs users to external resources that will help them analyze the data.

D. It instructs users how to use the data in the spreadsheet to calculate other important values for analysis.

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

The simple interest in a loan of $200 at 10 percent interest per year is

Aproperty title search firm is contemplating using online software to increase its search productivity. currently an average of 40 minutes is needed to do a title search. the researcher cost is $2 per minute. clients are charged a fee of $400. company a's software would reduce the average search time by 10 minutes, at a cost of $3.50 per search. company b's software would reduce the average search time by 12 minutes at a cost of $3.60 per search. which option would have the higher productivity in terms of revenue per dollar of input?