Question: Create a new uptime report in Excel. Use the image below as your model, using the identical cells as shown in the image and show

Create a new uptime report in Excel. Use the image below as your model, using the identical cells as shown in the image
and show identical results with formulas, where needed. Font and color do not matter. Correct location, correct spelling,
correct numeric format and correct answers do matter.
For row value names shown in column A, the formulas and functions for columns B,C and D are as follows.
a. Date is first day of month in M/D/Y format (e.g.,1/1/2022). Remember to format the date to match the
image. Calculate C1 and D1 from B1 using Excel functions. In the image, the date is in the MMM-YY format, and
the day of the month should be 1.
b. Total Minutes is a formula that shows the total minutes in the month. Consider using DAY and EOMONTH. Hint:
Formatting as general/number will be important.
c. Maintenance Minutes is 5 hours each Saturday. Calculate number of Saturdays in a month using this formula >>>
(4+(DAY(B1+34) WEEKDAY(B1-7))). Hint: Formatting as general/number will be important.
d. Code Release Minutes is a fixed value. Enter in the cell what is shown in the uptime image.
e. Total Planned Availability in MInutes is a formula that represents the total minutes minus any maintenance and
code release minutes.
f. Unplanned Downtime in Minutes is a fixed value. Enter in the cell what is shown in the image.
what are the formulas that should be inputted in my excel sheet for question c,e, and f?
Create a new uptime report in Excel. Use the

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Programming Questions!