Lesson 5: Inserting Formula and Functions

Section 5.5 - Using the MAX Function

  1. Step 1. Click on the cell you want to perform the formula.
  2. Step 2. Click the Formulas tab, go to the Function Library group and click the AutoSum drop-down button.
  3. Step 3. On the drop-down menu, click the Max command and highlight the data that you would like to find the maximum value.
  4. Step 4. Press the Enter Key to finish the formula.

Section 5.6 - Using the COUNT Function

  1. Step 1. Click on the cell you want to perform the formula.
  2. Step 2. Click the Formulas tab, go to the Function Library group and click the AutoSum drop-down button.
  3. Step 3. On the drop-down menu, click the Count command and highlight the data that you would like to find the maximum value.
  4. Step 4. Press the Enter Key to finish the formula.