If You Need to Find the Day of the Month

question 27

Multiple Choice

If you need to find the day of the month on which events occurred from a list of dates in the named range of Start_Date, which formula would provide the correct result?

• A)=DAYS(End_Date,Start_Date)
• B)=DAYMONTH(Start_Date)
• C)=IF(DAYMONTH(Start_Date)<31,Start_Date,1)
• D)=DAY(Start_Date)

---

Definitions:

Future Cash Flows

The projected amounts of money expected to be received or paid out by an entity over future periods as a result of investment, operational, and financing activities.

Payback Period

The length of time required to recover the cost of an investment.

Direct Materials

Materials that can be directly linked to the production of a product and represent a substantial portion of the cost.

Accounting Rate of Return

A financial metric used to assess the profitability of an investment, calculated as the average annual profit divided by the initial investment cost.