Which of the following functions returns the day of the week from a given date in Excel? Answer( Please choose a correct answer )   CLEARDAY()WEEKDAY()MONTH()YEAR()

Which of the following functions returns only the month from a given date in Excel?Answer( Please choose a correct answer )   CLEARDAY()YEAR()MONTH()DATE()

If January 1st of a certain year is a Sunday, what day of the week will January 1st of the next year be?Answer( Please choose a correct answer )   CLEARSundayMondayTuesdaySaturday

Which MS Excel function (or combination of functions) can be used to determine the number of weekdays between two specific dates?

Suppose you have a sales data that has an order date column. What dax function that you will use to track the sales made on weekdays and weekends?SELECT THE CORRECT ANSWERWeekday()Date()Weekends()dayofweek()

If January 1st of a certain year is a Tuesday, what day of the week will December 31st be in the same year?Answer( Please choose a correct answer )   CLEARMondayTuesdayWednesdaySunday