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

amandalm

  • Member
  • Posts: 306
Reply 3 on: Yesterday
:D TYSM

« previous next »
 

Did you know?

The first war in which wide-scale use of anesthetics occurred was the Civil War, and 80% of all wounds were in the extremities.

Did you know?

By definition, when a medication is administered intravenously, its bioavailability is 100%.

Did you know?

Tobacco depletes the body of vitamins A, C, and E, which can result in any of the following: dry hair, dry skin, dry eyes, poor growth, night blindness, abscesses, insomnia, fatigue, reproductive system problems, sinusitis, pneumonia, frequent respiratory problems, skin disorders, weight loss, rickets, osteomalacia, nervousness, muscle spasms, leg cramps, extremity numbness, bone malformations, decayed teeth, difficulty in walking, irritability, restlessness, profuse sweating, increased uric acid (gout), joint damage, damaged red blood cells, destruction of nerves, infertility, miscarriage, and many types of cancer.

Did you know?

Despite claims by manufacturers, the supplement known as Ginkgo biloba was shown in a study of more than 3,000 participants to be ineffective in reducing development of dementia and Alzheimer’s disease in older people.

Did you know?

Women are two-thirds more likely than men to develop irritable bowel syndrome. This may be attributable to hormonal changes related to their menstrual cycles.

The first five reactions constitute the energy-investment phase of glycolysis The first five reactions constitute the energy-investment phase of glycolysis
How to calculate compound interest (Part 2) How to calculate compound interest (Part 2)
How to calculate mean, median, and mode How to calculate mean, median, and mode
Effect of Increasing the Investment Rate on the Steady State Effect of Increasing the Investment Rate on the Steady State
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?
Find the proceeds of the following promissory note. A five-year, $4500.00 note bearing interest ... Find the proceeds of the following promissory note. A five-year, $4500.00 note bearing interest ...
Video: DNA Replication

For a complete list of videos, visit our video library