Ian Needs to Extract the Day from the Date 5/31/2017

question 10

Multiple Choice

Ian needs to extract the day from the date 5/31/2017 entered in cell A1.Which formula can he use to do this?

• A) =DAY(A1)
• B) =DAY("A1'')
• C) =DATE(DAY(A1))
• D) =DATE("DAY"(A1))

---

Definitions:

Down Payment

An initial payment made when something is bought on credit.

Compounded Quarterly

A method of calculating interest where it is added to the principal amount every three months.

Amortized

The process of paying off a debt through regular payments over a period of time, where each payment covers both interest and a portion of the principal amount.

Compounded Semi-annually

The process of calculating interest on both the initial principal and the accumulated interest of a deposit or loan every six months.