What is Data Entry?

Data Entry ka simple meaning hai Excel worksheet ke cells mein information enter karna. Jab hum kisi worksheet mein student ka naam, marks, fees, salary, quantity ya koi other information type karte hain, to is process ko Data Entry kaha jata hai.

Excel mein data ko directly cells mein enter kiya jata hai. Har cell ki apni location hoti hai, jise Cell Reference se identify kiya ja sakta hai.

For example, agar hum student ka record banana chahte hain:

┌────────────┬────────────┬────────────┐
│    Name    │    Marks   │    Fees    │
├────────────┼────────────┼────────────┤
│   Rahul    │     85     │    5000    │
│   Amit     │     72     │    4500    │
│   Neha     │     91     │    5500    │
└────────────┴────────────┴────────────┘

Yahan Name, Marks aur Fees ka data worksheet ke different cells mein enter kiya gaya hai.

How Data Entry Works in Excel?

Excel mein data enter karna ek simple process hai:

       DATA ENTRY
           ↓
      Select a Cell
           ↓
       Enter Data
           ↓
       Press Enter
           ↓
      Data Stored
           ↓
    Use for Calculation

For example, agar hum B2 cell select karke 85 type karte hain:

┌──────────────────────────────┐
│           B2                 │
│                              │
│             85               │
│                              │
└──────────────────────────────┘

To 85 value B2 cell mein store ho jayegi.

Data Entry ka Practical Example

Maan lo hum ek simple student record bana rahe hain:

Ab Excel mein hum entered data ko calculations ke liye bhi use kar sakte hain.

Formula Example

Agar B2 mein marks 85 hain aur C2 mein 5 bonus marks hain:

┌────────────────────────────────┐
│          FORMULA               │
├────────────────────────────────┤
│                                │
│          =B2+C2                │
│                                │
│          Result = 5085         │
│                                │
└────────────────────────────────┘

Yahan Excel cell references ka use karke calculation karta hai.

Data Entry ko Samajhne ka Easy Way

Data Entry ko simply is flow se yaad rakho:

Information
     ↓
Select Cell
     ↓
Type Data
     ↓
Press Enter
     ↓
Data Stored in Cell
     ↓
Formula / Function
     ↓
Result

Important Point

Excel mein data enter karne ka main purpose sirf information store karna nahi hai. Enter kiya hua data baad mein formulas, functions aur other Excel operations ke through calculation aur analysis ke liye use kiya ja sakta hai. Tere notes mein bhi formulas/functions ko worksheet data ke saath use karne ka concept diya gaya hai.

Quick Revision