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.
In this exercise we have to use our knowledge of excel and minimal function to explain how this function construction is done, like this:
Returns the smallest kth value from the data set. Use this function to return values with a specific relative position in a dataset.
The =MIN() function identifies the smallest number in a range on a worksheet, and can be useful for analyzing the smallest deviation of a table. To use the formula, in a blank cell, type "=MIN(" and select the desired range. Then close the parentheses by typing ")" and press the enter key.
See more about excel at brainly.com/question/12788694
