Question

Zoe creates a spreadsheet to make simple interest calculations. The user input values for the principal, rate, and time in years in row 2. Write each formula. Remember to include the = symbol

Answer 1

Answer:

a. For A2 to compute the interest.

b. For B2 to compute the principal.

c. For C2 to compute the interest rate.

d. For D2 to compute time in years, given the interest, rate, and the principal.

e. For E2 to compute the time in months, given the time in years.

a) A2 = B2 x C2 x D2

b) B2 = A2/ (C2 x D2)

c) C2 = A2/ (B2 x D2)

d) B2 = A2/ (C2 x D2)

e) E2 = 12 x D2

I know they only asked for principle, I just added for imformation lol