Home » Excel Experts Quiz

Excel Experts Quiz

Question 1 of 13

In Excel 2010, which function calls will return the 1st day of the current month

=TEXT(WEEKDAY(TODAY()-DAY(TODAY()-1)),"dddd")

=DAYS360(DATE(YEAR(NOW()),1,1),DATE(YEAR(NOW()),MONTH(NOW()),1))

=TEXT(TODAY()-DAY(TODAY())+1,"ddd, mmm dd, yyyy")

=DATE(YEAR(TODAY()),MONTH(TODAY()),1)

=DATE(YEAR(NOW()),MONTH(NOW()),1)

=TODAY()-DAY(TODAY())+1

=DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()))

=EOMONTH(TODAY(),-1)+1