Excel 2016 Project 5 Q 14 15 16 17 18 19
14. In cell B4, calculate the starting date of the service calls by entering a formula that finds the minimum value of the dates in the Date column. 15. In cell B5, calculate the ending date of the service calls by entering a formula that finds the maximum value of the dates in the Date column. 16. In cell B6, enter a formula that counts the total number of service calls using the values in the Date column. 17. In cell B7, enter a formula that calculates the sum of hours from the Hours column. 18. In cell B8, enter a formula that references the value of cell N40. 19. Add borders around each cell in the range A4:B8.
14. In cell B4, calculate the starting date of the service calls by entering a formula that finds the minimum value of the dates in the Date column. 15. In cell B5, calculate the ending date of the service calls by entering a formula that finds the maximum value of the dates in the Date column. 16. In cell B6, enter a formula that counts the total number of service calls using the values in the Date column. 17. In cell B7, enter a formula that calculates the sum of hours from the Hours column. 18. In cell B8, enter a formula that references the value of cell N40. 19. Add borders around each cell in the range A4:B8.