2.1 Data Types (Text, Numbers, Dates) & Entry Methods

Excel data types ki pehchaan (Text left-align, Numbers right-align), cell mein multi-line text (Alt+Enter), aur direct typing vs formula bar.

---

Excel 2024 Complete Notes — Chapter 2

Data Entry, Cell Selection & Data Management

Language: Hinglish | Level: Basic to Advanced

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

1. Chapter Overview

Is chapter mein aap seekhenge:

1. Excel mein data enter aur edit karna
2. Text, number, date, time aur formula enter karna
3. Cells, rows, columns aur ranges select karna
4. Keyboard se worksheet navigate karna
5. Cut, Copy, Paste aur Paste Special
6. AutoFill, Fill Series aur Flash Fill
7. Rows, columns aur cells insert/delete karna
8. Find, Replace, Go To aur Go To Special
9. Data-entry mistakes ko samajhna
10. Practical assignments aur exercises ━━━━━━━━━━━━━━━━━━━━━━━━━━━━

2. Excel Mein Data Entry Kya Hai?

Data Entry ka matlab worksheet ki cells mein information enter karna hai.

Excel mein aam taur par ye data types use hote hain:

A. Text

Names, city names, product names aur descriptions.

Examples:

Rahul

Jaipur

Excel Training

Product A

B. Numbers

Marks, quantity, salary, price aur percentage ke liye.

Examples:

450

85

1250.50

-25

C. Date

Examples:

22/10/2026

22-Oct-2026

Oct 22, 2026

Date ka actual display aapke regional settings aur cell format par depend kar sakta hai.

D. Time

Examples:

10:30 AM

18:45

2:15 PM

E. Formula

Formula aam taur par equal sign (=) se start hota hai.

Examples:

=A1+B1

=SUM(A1:A5)

=A2*B2

F. Logical Values

TRUE aur FALSE logical values hain. Inka use conditions aur logical formulas mein hota hai.

G. Blank Cell

Aisi cell jisme koi value nahi hoti. Blank cell aur zero (0) ek jaise nahi hote.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

3. Cell Mein Data Enter Karne Ke Tarike

Method 1: Direct Entry

1. Excel workbook open karein.
2. Kisi cell par click karein, jaise A1.
3. Apna data type karein: Student Name
4. Enter press karein. Aam taur par Enter dabane par selection neeche wali cell par chala jata hai.

Method 2: Formula Bar Se Entry

1. Cell select karein.
2. Formula Bar par click karein.
3. Value type karein.
4. Enter press karein. Formula Bar cell ke content ko dekhne aur edit karne mein useful hai.

Method 3: F2 Key

1. Data wali cell select karein.
2. F2 press karein.
3. Cell ke andar content edit karein.
4. Enter press karein.

[!NOTE] Note: Laptop par Fn+F2 ki zaroorat ho sakti hai.

Method 4: Double-Click

Cell par double-click karke uske content ko edit kar sakte hain.

Entry Cancel Karna

Agar aap typing ke dauran current entry cancel karna chahte hain, to Esc press karein. Ye current edit ko cancel karta hai; pehle se saved data ko automatically delete nahi karta.

━━━━━━━━━━━━━━━━━━━━━━━━━━━━

4. Practical: Student Data Enter Karein

Excel mein ye sample table banayein:

| Cell | Value |

|---|---|

| A1 | Student ID |

| B1 | Student Name |

| C1 | Class |

| D1 | Marks |

| A2 | 101 |

| B2 | Aman |

| C2 | 10 |

| D2 | 85 |

| A3 | 102 |

| B3 | Priya |

| C3 | 10 |

| D3 | 92 |

| A4 | 103 |

| B4 | Ravi |

| C4 | 9 |

| D4 | 76 |

---

Hands-on Practice Exercise

[!TIP] Open Microsoft Excel 365 / 2024 on your computer right now and practice each step described above. Memorize the keyboard shortcuts and try them in a fresh worksheet.

• Complete the practical walkthrough in Excel.
• Verify formatting and formula results.
• Attempt the chapter knowledge quiz when ready.