a circular error results when a formula refers to:

a) a cell in another workbook that is closed

b) the same cell that contains the formula

c)another cell that refers back to the cell that contains the formula

d)a and b

e) b and c

10. You have decided to invest $4,000 at a rate of 10% per year during the first 30 years. After that, you will be more conservative and expect to earn 5% per year. Which of the formulas in B7 will allow you to dctermine how much moncy will you have 45 vears from now? 1 Initial Investment 2 Years 3 Initial Term 4 Final Term 5 Initial Interest Rate 6 Final Interest Rate 7 Future Value 4,000.00 45 30 15 10% 596 |