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:

Nearest Cent

The nearest cent is a rounding approach where prices or amounts are rounded up or down to the nearest one-hundredth of a dollar.

Evaluate

To carefully assess or appraise the value, quality, or performance of someone or something.

Nearest Cent

Rounding an amount to the closest cent (1/100th of a currency unit) in financial calculations.

Evaluate

To assess or examine something in order to gain an understanding of it, often leading to a judgment or conclusion.