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.
Correct Answer:
Verified
Q21: What is the interest rate on a
Q25: What is the simple interest on an
Q27: Kelly borrowed $3,000 with an interest rate
Q29: What is the maturity value on a
Q30: Malcolm anticipates his college tuition and books
Q32: Alex is using Excel to calculate the
Q32: The face value of a note is
Q35: The face value on a loan is
Q37: What is the difference between the exact
Q39: What is the principal on a 200-day
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents