Lesson: Minimum & Maximum in Microsoft Excel

1. Introduction

Student Report mein students ke marks ka analysis karte waqt humein kabhi-kabhi ye find karna hota hai ki:

• Sabse kam marks kitne hain?
• Sabse zyada marks kitne hain?

Microsoft Excel mein in values ko easily find karne ke liye MIN aur MAX functions ka use kiya ja sakta hai.

The Student Report practical in the provided Excel notes includes finding minimum and maximum values from the student data.

2. MIN Function

The MIN function is used to find the smallest value from a selected range of cells.

Syntax

=MIN(range)

Example

Suppose the marks are:

To find the lowest mark:

=MIN(B2:B5)

Result

55

Therefore, 55 is the minimum mark in the selected range.

3. MAX Function

The MAX function is used to find the largest value from a selected range of cells.

Syntax

=MAX(range)

Example

Using the same marks:

To find the highest mark:

=MAX(B2:B5)

Result

82

Therefore, 82 is the maximum mark in the selected range.

4. MIN and MAX Together

MIN and MAX are often used together when analyzing a Student Report.

Example Data

Minimum Total

=MIN(B2:B5)

Result:

186

Maximum Total

=MAX(B2:B5)

Result:

270

5. MIN & MAX Formula Chart

┌──────────────────────────────────┐
│       MINIMUM & MAXIMUM          │
├──────────────────────────────────┤
│                                  │
│ MIN → Smallest Value             │
│                                  │
│ =MIN(B2:B5)                      │
│                                  │
│ MAX → Largest Value              │
│                                  │
│ =MAX(B2:B5)                      │
│                                  │
└──────────────────────────────────┘

Easy Memory Trick

MIN → Minimum → Smallest
MAX → Maximum → Largest

6. MIN and MAX in a Student Report

Suppose a Student Report contains subject marks:

We can find the minimum and maximum marks for a particular range.

Minimum English Marks

=MIN(B2:B5)

Maximum English Marks

=MAX(B2:B5)

Similarly, the same functions can be applied to other subject columns.

7. MIN vs MAX

8. Why MIN & MAX Are Useful

In a Student Report, these functions help us quickly analyze the data.

For example, we can find:

• Lowest marks in a subject.
• Highest marks in a subject.
• Lowest total marks.
• Highest total marks.

Instead of checking every student’s marks manually, Excel can find the required value automatically.

9. Important Point About the Range

The range inside the formula determines which values Excel will check.

For example:

=MIN(B2:B10)

means:

Find the smallest value from B2 to B10.

And:

=MAX(B2:B10)

means:

Find the largest value from B2 to B10.

So always select the correct range.

10. Complete Practical Flow

Student Marks
      ↓
Select Required Range
      ↓
      ├───────────────┐
      ↓               ↓
     MIN             MAX
      ↓               ↓
Smallest Value    Largest Value

11. Quick Revision

Remember

MIN = Lowest

MAX = Highest

⭐ One-Line Definitions

MIN Function: Finds the smallest value from a selected range.

MAX Function: Finds the largest value from a selected range.

The provided Student Report practical specifically includes finding minimum and maximum values as part of student-data analysis.