Which formula can you use to extract the month from the date in cell F5: 2016 July 8th?
A) =MONTH(F5)
B) =MONTH("F5")
C) =MONTH(DATE(2016,7,0) )
D) =MONTH(DAY(2016,7,0) )
Correct Answer:
Verified
Q27: To extract the seconds from the time
Q28: Rohan wants to create a column containing
Q29: Which of the following formulas can you
Q30: A student types the formula '= YEAR(
Q31: The formula =ROUNDUP(G5,0)can be used to round
Q33: A jewelry designer creates an excel sheet
Q34: Sheila wants to extract the hour from
Q35: A student inserts the formula =TIMEVALUE("10:30 AM")in
Q36: The formula =ROUNDDOWN(G5,0)can be used to round
Q37: To round time 10:30 pm inserted 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