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 48 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

raili21

  • Member
  • Posts: 324
Reply 3 on: Yesterday
Gracias!

« previous next »
 

Did you know?

As many as 28% of hospitalized patients requiring mechanical ventilators to help them breathe (for more than 48 hours) will develop ventilator-associated pneumonia. Current therapy involves intravenous antibiotics, but new antibiotics that can be inhaled (and more directly treat the infection) are being developed.

Did you know?

Symptoms of kidney problems include a loss of appetite, back pain (which may be sudden and intense), chills, abdominal pain, fluid retention, nausea, the urge to urinate, vomiting, and fever.

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?

Immunoglobulin injections may give short-term protection against, or reduce severity of certain diseases. They help people who have an inherited problem making their own antibodies, or those who are having certain types of cancer treatments.

Did you know?

Throughout history, plants containing cardiac steroids have been used as heart drugs and as poisons (e.g., in arrows used in combat), emetics, and diuretics.

How to calculate annuity when compounded semi-annually (Part 1) How to calculate annuity when compounded semi-annually (Part 1)
How to calculate regular payments or deposits using the annuity formula (Question 2) How to calculate regular payments or deposits using the annuity formula (Question 2)
Calculate the physical variables Calculate the physical variables
Calculate the net field at the location of q 3 Calculate the net field at the location of q 3
Calculate ΔS° Calculate ΔS°
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: Oxygen transport - methods and oxyhemoglobin

For a complete list of videos, visit our video library