🧮 Day 48: Data Entry (MS Excel) – Hinglish

Data Entry (MS Excel) – Hinglish

📌 Data Entry kya hota hai?

Excel me cells ke andar data likhna = Data Entry.

👉 Data ka type:

  • Text (Name, Subject)

  • Number (Marks, Price)

  • Date (12/01/2026)

  • Formula (=A1+B1)

✏️ 1) Cell me data kaise enter kare?

✅ Steps:

  1. Cell par click karo

  2. Data type karo

  3. Enter key press karo

👉 Example:

  • A1 = Name

  • B1 = Marks

🔄 2) Data edit kaise kare?

✅ Method 1:

  • Cell par double click karo

  • Data change karo

✅ Method 2:

  • Cell select karo

  • Formula Bar se edit karo

❌ 3) Data delete kaise kare?

✅ Steps:

  • Cell select karo

  • Delete key press karo

📋 4) Copy, Cut & Paste

CommandShortcut
CopyCtrl + C
CutCtrl + X
PasteCtrl + V

🔢 5) AutoFill (Series)

👉 Use:

  • Numbers series (1,2,3…)

  • Dates

  • Days (Mon, Tue, Wed…)

✅ Steps:

  1. A1 me 1 likho

  2. A2 me 2 likho

  3. Dono cells select karo

  4. Fill handle drag karo

📏 6) Enter key directions

👉 Enter key press karne par cursor move hota hai:

  • Default = Down

  • Settings se change possible

🧪 Practice Task (Important)

👉 Excel me ye data enter karo:

Roll NoNameMarks
1Rahul85
2Priya90
3Amit78

Tasks:

  • Marks column me data edit karo

  • Ek row copy karo

  • Roll No series AutoFill se banao

📝 Short Notes (Exam ke liye)

👉 Data Entry = Excel me data input karna
👉 Data types = Text, Number, Date, Formula

⬅ Previous Day


                            Next Day ➡