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:

Filter Information

The process of selectively paying attention to certain stimuli while ignoring others, based on relevance or importance.

Upward Communication

Upward communication is the flow of information from lower levels of a hierarchy to higher levels, such as from employees to management, facilitating feedback and reporting.

Leaner Channels

Communication methods that involve fewer cues and less information richness, often used in more formal or straightforward exchanges.

Routine Messages

Standardized communications that convey regular, operational information within or between organizations, typically involving procedural or administrative details.