Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

? asked in Science & MathematicsMathematics · 9 years ago

What formula will be found in cell D4 if the formula =SUM(A1:C1) is entered into cell D1 and then filled dow..?

1.) Using the compound interest formula A = P(1 + i)n, determine the future amount, to two decimal places, if an amount of $500 is invested at 8% per annum, compounded semi-annually, for 10 years. Fill in the blanks for the the following values. (do not put a $ sign).

P =

i =

n =

A =

2.) Determine the future value of an investment if $1800 is invested at 5.8% per annum, compounded quarterly, for 5 years.

~5558.86

~2400.57

~27 001.15

~3188.45

3.) To determine how much money you need to invest at 6% per annum, compounded semi- annually, for the investment to accumulate to $5500 in 4 years, which of the following would be the correct entries in you graphing calculator?

~N=8

I%=6

PV=?

PMT=0

FV=5500

P/Y=2

C/Y=1

PMT:END

 

~N=4

I%=6

PV=?

PMT=0

FV=5500

P/Y=2

C/Y=2

PMT:END

 

~N=8

I%=6

PV=5500

PMT=0

FV=

P/Y=2

C/Y=2

PMT:END

 

~N=8

I%=6

PV=?

PMT=0

FV=5500

P/Y=2

C/Y=2

PMT:END

 

4.) What formula will be found in cell D4 if the formula =SUM(A1:C1) is entered into cell D1 and then filled down to cell D4?

~ =SUM(A4:C4)

~ =SUM(A1:D4)

~ =SUM(C4:D4)

~ =SUM(A4:D4)

1 Answer

Relevance
  • fcas80
    Lv 7
    9 years ago
    Favorite Answer

    4) =SUM(A4:C4)

Still have questions? Get your answers by asking now.