1. Open excel and enter some data.

2. Enter the function =MAX(B2:B 10) in the column of maximum value, that is, calculate the maximum value from cell B2 to cell B 10.

3. Press Enter to confirm that the maximum value is displayed.

4. Enter the function =MIN(B2:B 10) in the minimum value column, which means calculating the minimum value from B2 cell to B 10 cell.

5. Press Enter to confirm that the minimum value has been calculated.