Question

What does the “MIN” and “MAX” functions allow you to do when inserted in a spreadsheet?

Answer 1

Please see explanation

Step-by-step explanation:

A spreadsheet is used to make calculations and payrolls etc. Different functions are used in spreadsheet. Two of them are MIN and MAX.

The MIN function gives the minimum value out of all the cells in the range.

It is written as:

= MIN(number1, number2..)

OR

= MIN(Starting_cell_address:Last_cell_address)

Similarly, MAX function gives the maximum value from the selected range of cells.

= MAX(number1, number2..)

OR

= MAX(Starting_cell_address:Last_cell_address)