Enter a function in cell K17 that will count the number of months in the range B5:B17. Since the data in the worksheet should be for one year, verify that the output of the function makes sense. Also note that one blank cell, B17, is included in this range.

Enter a formula in cell D5 to calculate the January capacity for the hotel. The capacity is calculated by multiplying the occupants per room (cell C3) by the number of rooms in the hotel (cell C2). This result is then multiplied by the number of days in the month (cell C5). Construct this formula so that relative referencing does not change cells C3 and C2 when the formula is pasted into other cell locations.

Copy the formula in cell D5 and paste it into the range D6:D16. Use a paste method that does not change the borderline style in column D.

what functions do I use for these? Thank you in advance!

Chapter 4 DA Exercise 2 Tell me L \begin{tabular}{|l|l|l|l} M & N & o & p \end{tabular} Months of Diala Cost Analytics Edit if nccessibility: Investigate