This topic contains a solution. Click here to go to the answer
« previous next »

Author Question: Alex is using Excel to calculate the compound interest he will receive on an investment. His ... (Read 88 times)

joblessjake

  • Hero Member
  • *****
  • Posts: 555
on: Jun 24, 2018
Alex is using Excel to calculate the compound interest he will receive on an investment. His investment accrues interest on a quarterly basis. If the yearly interest rate is 8 and stored in Cell B3, what formula should Alex use to calculate the 1st quarter interest rate?
 A) =B3/3
  B) =B3/4
  C) =B33
  D) =B34

Question 2

The date of a promissory note is entered in Cell A2 as a date; 4/10/2010, and the number of days before discount is entered in Cell A3 as a number, 35. What must be done in Excel to calculate the discount date?
 A) Both Cell A2 and Cell A3 must first be converted to dates and then added together.
  B) Both Cell A2 and Cell A3 must first be converted to numbers and then added together.
  C) Subtract Cell A3 from A2.
  D) Add cell A3 to A2.


Related Topics

Need homework help now?

Ask unlimited questions for free

Ask a Question
Marked as best answer by a Subject Expert

macagnavarro

  • Sr. Member
  • ****
  • Posts: 334
Reply #1 on: Jun 24, 2018
Answer to Question 1

D

Answer to Question 2

D


joblessjake

  • Member
  • Posts: 555
Reply 2 on: Jun 24, 2018
Excellent

nothere

  • Member
  • Posts: 324
Reply 3 on: Yesterday
Thanks for the timely response, appreciate it

« previous next »
 

Did you know?

Asthma occurs in one in 11 children and in one in 12 adults. African Americans and Latinos have a higher risk for developing asthma than other groups.

Did you know?

About 3% of all pregnant women will give birth to twins, which is an increase in rate of nearly 60% since the early 1980s.

Did you know?

There can actually be a 25-hour time difference between certain locations in the world. The International Date Line passes between the islands of Samoa and American Samoa. It is not a straight line, but "zig-zags" around various island chains. Therefore, Samoa and nearby islands have one date, while American Samoa and nearby islands are one day behind. Daylight saving time is used in some islands, but not in others—further shifting the hours out of sync with natural time.

Did you know?

Excessive alcohol use costs the country approximately $235 billion every year.

Did you know?

A good example of polar molecules can be understood when trying to make a cake. If water and oil are required, they will not mix together. If you put them into a measuring cup, the oil will rise to the top while the water remains on the bottom.

Steel-toed shoes are a worthwhile investment to help prevent foot injury due to falling objects. ... Steel-toed shoes are a worthwhile investment to help prevent foot injury due to falling objects. ...
Effect of Increasing the Investment Rate on the Steady State Effect of Increasing the Investment Rate on the Steady State
Use a compound angle addition formula to determine an equivalent trig expression for cos(x + ... Use a compound angle addition formula to determine an equivalent trig expression for cos(x + ...
Calculate the magnitude and direction of the resultant for Calculate the magnitude and direction of the resultant for
Calculate the given limits eliminating zero denominator algebraicilly Calculate the given limits eliminating zero denominator algebraicilly
A typical lightning bolt may last for 0.167 s and transfer 1.07 x 10 electrons. Calculate the ... A typical lightning bolt may last for 0.167 s and transfer 1.07 x 10 electrons. Calculate the ...
Video: Bone Healing Animation

For a complete list of videos, visit our video library