Which Formula Can Be Applied for the Given Data in a Cell

question 25

Multiple Choice

Which formula can be applied for the given data in a cell A2: 01/01/2017 to get the serial number of the date as text?

• A) =DATEVALUE(1-Jan-2017)
• B) =DATEVALUE(01/01/2017)
• C) =DATEVALUE(1st Jan,2017)
• D) =DATEVALUE(''01/01/2017'')

---

Definitions:

Opportunity Cost

The price paid by not choosing the second-best option available during decision-making.

College

An institution of higher education offering undergraduate programs, sometimes along with graduate programs.

Tuition

The fee charged for instruction, typically at an educational institution like a university or college.

Opportunity Cost

The worth of the best option given up because of a choice made.