Final answer:
To find the lowest value in the 'Actual Occupancy' column on the 'Occupancy' worksheet, use the MIN function by entering =MIN(Occupancy!A:A) into cell B4.
Step-by-step explanation:
To find the lowest value in the 'Actual Occupancy' column from the 'Occupancy' worksheet and enter the function into cell B4, you would use the MIN function in Excel. This function is specifically designed to locate the smallest number within a range of cells.Here is an example of how you would write this function:=MIN(Occupancy!A:A)
Assuming that the 'Actual Occupancy' data is in column A of the 'Occupancy' worksheet, this formula would return the lowest value from that column. You would enter this formula in cell B4 on the worksheet where you need the result to appear.
To find the lowest value in the actual occupancy column from the occupancy worksheet, you can use the MIN function in Excel. In cell B4, you can enter the formula =MIN(occupancy!A:A), assuming the actual occupancy column is in the A column of the occupancy worksheet. This formula will return the smallest value in that column.