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'')
Correct Answer:
Verified
Correct Answer:
Verified
Related Questions
Q20: To preserve an exact cell address in
Q21: Kathy wants to add the numbers entered
Q22: To insert the current date in cell
Q23: Sheila wants to extract the hour from
Q24: Where can you see a brief description
Q26: Which formula can you use to extract
Q27: Your worksheet contains a price in cell
Q28: To insert an equation,click on the Object
Q29: To have Excel enter the lowest price
Q30: What is the correct formula to insert