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:

Crete

The largest and most populous of the Greek islands, known for its rich mythology, history, and as the center of the Minoan civilization.

Knossos

The largest Bronze Age archaeological site on Crete, associated with the ancient Minoan civilization and the myth of the Minotaur and the Labyrinth.

Minoan Column

Characterized by its tapered shape and capital painted in vivid colors, this type of column is a distinctive feature of ancient Minoan architecture from Crete.

Lotus Capital

Architectural element typically found in ancient Egyptian and Indian buildings, characterized by a capital that resembles a lotus flower, symbolizing purity and creation.