Question: For row value names shown in column A , the formulas and functions for columns B , C and D are as follows. a .

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.
wh
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 >>>
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.
g. Total Availability. is a formula that subtracts the total planned availability from the downtime minutes.
h.% Uptime is a formula that compares the total availability to the total planned availabilty. Represent as a
percentage with 3 digits to the right of the decimal.
what is the formula(s) that i input for question h (%uptime)
For row value names shown in column A , 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!