Question

In cell B22, enter a function to calculate the minimum attendance for the year 2022?

Answer 1

Answer:

The user must use min() to attain the desired results. Let us understand the syntax of min() with an example.

Syntax:

min(range) where min is the name of the function and the range specifies the address of cells from which the minimum number needs to be found.  

Eg. min(A1:A8)

This function will scan the values from A1 to A8 and then find the minimum value from the given range of values.

So according to the problem,

B22 = min(range). Provide range for which minimum attendance needs to be calculated.