Question

Which date formats are allowed in Excel for February 14, 2018? Check all that apply.

Answer 1

Date Format in Excel

14-Feb-18 , 14-Feb and February 14,2018 are allowed while 2/014/2018, 02/14/18 and 2/14/2018 are not allowed

Explanation:

In Excel, there are date formats which support the formats

dd-mmm-yy ( 14-Feb-18)

dd-mmm (14-Feb)

Month Dd, yyyy ( February 14, 2018)

Where as the dates

2/014/2018 ,  02/14/18 , 2/14/2018​ are not supported as the '/' cannot be used in date format. However, if you wish to  write date in these formats, you have to write them as text like '2/014/2018 ,  '02/14/18 , '2/14/2018, but then in that case you will not be able to perform any date functions. This can be used only to display the text

Answer 2

Answer:

1,2,5 and 6

Explanation:

Hope this helps!!!!!!!

Forever friend and helper,

Cammie:)