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 84 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
Wow, this really help

robbielu01

  • Member
  • Posts: 336
Reply 3 on: Yesterday
Excellent

« previous next »
 

Did you know?

Amphetamine poisoning can cause intravascular coagulation, circulatory collapse, rhabdomyolysis, ischemic colitis, acute psychosis, hyperthermia, respiratory distress syndrome, and pericarditis.

Did you know?

Cytomegalovirus affects nearly the same amount of newborns every year as Down syndrome.

Did you know?

Inotropic therapy does not have a role in the treatment of most heart failure patients. These drugs can make patients feel and function better but usually do not lengthen the predicted length of their lives.

Did you know?

A seasonal flu vaccine is the best way to reduce the chances you will get seasonal influenza and spread it to others.

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.

In 2009, historian Woody Holton described how Abigail Adams shrewdly invested in the Continental Con In 2009, historian Woody Holton described how Abigail Adams shrewdly invested in the Continental Con
Investment in Computers as a Percentage of GDP, 1982–2009 Investment in Computers as a Percentage of GDP, 1982–2009
Effect of Increasing the Investment Rate on the Steady State Effect of Increasing the Investment Rate on the Steady State
Calculate the number of grams of solute in 500.0 mL of 0.169 M KOH. Calculate the number of grams of solute in 500.0 mL of 0.169 M KOH.
After 159 days,she paid a maturity value of $11,626, which included interest of $814. After 159 days,she paid a maturity value of $11,626, which included interest of $814.
Calculate ΔG° Calculate ΔG°
Video: What is Cholesterols? Introduction to Lipoproteins

For a complete list of videos, visit our video library