1. Linear Series kya hai?

Linear Series Microsoft Excel ke Fill Series feature ka ek type hai. Iska use numbers ko ek fixed difference (Step Value) ke according automatically continue karne ke liye kiya jata hai.

Simple words mein, agar har next number mein same value add ya subtract ho rahi hai, to use Linear Series kaha jata hai.

2. Example

Agar starting value 10 hai aur Step Value 5 hai:

10 → 15 → 20 → 25 → 30 → 35

Har next number mein 5 add ho raha hai.

Another example:

100 → 90 → 80 → 70 → 60

Yahan har next number mein 10 subtract ho raha hai.

3. Linear Series ke Main Elements

Example

Starting Value = 20
Step Value = 10
Stop Value = 100

Result:

20, 30, 40, 50, 60, 70, 80, 90, 100

4. Linear Series kaise create karein?

1. Excel mein starting value enter karein.
2. Jitne cells mein series chahiye unhe select karein.
3. Home → Fill → Series par click karein.
4. Series in mein Row ya Column select karein.
5. Type → Linear select karein.
6. Step Value enter karein.
7. Stop Value enter karein.
8. OK par click karein.

5. Positive Step Value

Positive Step Value se series increase hoti hai.

Example:

Starting = 5
Step = 5

5 → 10 → 15 → 20 → 25

6. Negative Step Value

Negative Step Value se series decrease hoti hai.

Example:

Starting = 100
Step = -10

100 → 90 → 80 → 70 → 60

7. Linear Series in Rows

Linear Series horizontally bhi create ki ja sakti hai.

Yahan Step Value = 10 hai.

8. Linear Series in Columns

Vertical direction mein:

Yahan bhi Step Value = 10 hai.

9. Linear Series ka Practical Use

Linear Series ka use:

• Student Roll Numbers
• Serial Numbers
• Invoice Numbers
• Employee IDs
• Product Numbers
• Monthly Targets
• Sales Targets
• Stock Quantities
• Financial Calculations
• Data Tables

mein kiya ja sakta hai.