Min, Max, and Average

Finding the Maximum Value

Step 1: Select the cell.

Step 2: Select the Auto-Sum tool in the Editing Group.

Step 3: Select the MAX function.

Step 4: Choose AVERAGE from an INSERT function dialog box.

Step 5: Tap OK.

Step 6: Select the range of cells in the Functions Argument Box.

Finding the Average Value

Step 1: Select the cell.

Step 2: Select the Auto-Sum tool in the Editing Group.

Step 3: Select the AVERAGE function.

Step 4: Choose AVERAGE from an INSERT function dialog box.

Step 5: Tap OK.

Step 6: Select the range of cells in the Functions Argument Box.

FAQs

1. Name some essential functions in Excel.

    Some essential functions in excel are MIN, MAX, COUNT, and AVERAGE.

2. What is the use of the MIN function?

     MIN function is used to find the minimum value in a given range of cells.

3. What is the use of the MAX function?

     MAX function is used to find the maximum value in a given range of cells.

4. What is the use of the AVERAGE function?

     AVG function is used to find the mean of two or more values in a given range of cells.

5. What is the use of the COUNT function?

      The COUNT function is used to find the number of entries in a given range.

Key Takeaways

Congratulations on finishing the blog!! After reading this blog, you will grasp the concept of the essential functions used in Excel.
Check out this problem - Subarray Sum Divisible By K

If you are preparing yourself for the top tech companies, don't worry. Coding Ninjas has your back. Visit this link for a well-defined and structured material, which will help you provide access to knowledge in every domain.