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 61 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
Great answer, keep it coming :)

ghepp

  • Member
  • Posts: 361
Reply 3 on: Yesterday
YES! Correct, THANKS for helping me on my review

« previous next »
 

Did you know?

The Centers for Disease Control and Prevention has released reports detailing the deaths of infants (younger than 1 year of age) who died after being given cold and cough medications. This underscores the importance of educating parents that children younger than 2 years of age should never be given over-the-counter cold and cough medications without consulting their physicians.

Did you know?

Urine turns bright yellow if larger than normal amounts of certain substances are consumed; one of these substances is asparagus.

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?

If you use artificial sweeteners, such as cyclamates, your eyes may be more sensitive to light. Other factors that will make your eyes more sensitive to light include use of antibiotics, oral contraceptives, hypertension medications, diuretics, and antidiabetic medications.

Did you know?

Approximately 25% of all reported medication errors result from some kind of name confusion.

Wasp ocelli (simple eyes) and dorsal part of the compound eyes; also showing fine, unbranched hairs Wasp ocelli (simple eyes) and dorsal part of the compound eyes; also showing fine, unbranched hairs
How to calculate mortgage payments (Question 2 of 2) How to calculate mortgage payments (Question 2 of 2)
How to calculate credit card interest when the interest is compounded How to calculate credit card interest when the interest is compounded
Basic Marketing Research: Using Microsoft Excel Data Analysis Basic Marketing Research: Using Microsoft Excel Data Analysis
Calculate the amount of interest that will be charged on $9000.00 borrowed for four months at ... Calculate the amount of interest that will be charged on $9000.00 borrowed for four months at ...
How to calculate the gain and loss gene numbers with low bootstrap of phylogenetic tree? How to calculate the gain and loss gene numbers with low bootstrap of phylogenetic tree?
Video: Stimulus (introduction)

For a complete list of videos, visit our video library