A report needs to show the number of weekdays within a project to estimate capacity. Which function would provide the desired result?Select an answer:WEEKDAYNETWORKDAYSWORKDAYDAYS

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

_________ is the number of workdays or work hours required to complete a task.

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()

It takes six analysts forty-two days to write a report.If the report had to be ready in 7 days, how many analysts would be needed?

In cell F13 of the Schedule worksheet, enter a formula that will calculate the total number of employees scheduled to work Sunday for all schedules A-G. Begin by multiplying the number of employees for schedule A, in cell D5, by the value representing whether or not employees are working that day in cell F5. Be sure to make the reference to cell D5 an absolute cell reference so that, when finished, the formula can be copied across the row. So far the result of the formula is 0 because schedule A has people scheduled off on Sunday. Next, add to the product, the number of employees scheduled to work Sunday for schedule B. Continue with the formula by adding a similar calculation for schedules C-G, making an absolute cell reference for each cell in column D.