Which of the following formulas can you use to find the serial number of the date January 1, 2017?
A) '=DATEVALUE(1-Jan-2017)
B) =DATEVALUE(01/1/2017)
C) =DATEVALUE(1st Jan, 2017)
D) =DATEVALUE(''01/1/2017'')
Correct Answer:
Verified
Q11: What is the correct formula to insert
Q21: Stuart inserts the formula '=YEAR ('23-Aug-2012)' into
Q27: To extract the seconds from the time
Q30: A student types the formula '= YEAR(
Q34: Sheila wants to extract the hour from
Q441: Cell A5 contains the number 24.7835.In another
Q443: Ian needs to extract the day of
Q448: Laura is changing data in a worksheet,
Q449: The results of formula =TIMEVALUE("10:30 AM") is
Q450: Rohan can display the current date in
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents