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 80 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
Gracias!

daiying98

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

« previous next »
 

Did you know?

Egg cells are about the size of a grain of sand. They are formed inside of a female's ovaries before she is even born.

Did you know?

In Eastern Europe and Russia, interferon is administered intranasally in varied doses for the common cold and influenza. It is claimed that this treatment can lower the risk of infection by as much as 60–70%.

Did you know?

According to the National Institute of Environmental Health Sciences, lung disease is the third leading killer in the United States, responsible for one in seven deaths. It is the leading cause of death among infants under the age of one year.

Did you know?

Always store hazardous household chemicals in their original containers out of reach of children. These include bleach, paint, strippers and products containing turpentine, garden chemicals, oven cleaners, fondue fuels, nail polish, and nail polish remover.

Did you know?

The heart is located in the center of the chest, with part of it tipped slightly so that it taps against the left side of the chest.

How to calculate present value (Question 4) How to calculate present value (Question 4)
Investment in Computers as a Percentage of GDP, 1982–2009 Investment in Computers as a Percentage of GDP, 1982–2009
A $50 000 bond bearing interest at 5.5% payable semi-annually is redeemable at par on August ... A $50 000 bond bearing interest at 5.5% payable semi-annually is redeemable at par on August ...
compound compound
Henrik, a Canadian hockey player, agreed to a contract where he was to receive S30,OOO 00 in 3 ... Henrik, a Canadian hockey player, agreed to a contract where he was to receive S30,OOO 00 in 3 ...
Video: Griffith's experiments

For a complete list of videos, visit our video library