BrounStack
Learning›Excel Tutorial›Introduction & Workbooks
CHAPTER 1 · EXCEL FOUNDATION

Excel Introduction & Workbooks

Excel ek spreadsheet application hai jahan data cells me organize hota hai aur formulas, functions, formatting aur analysis tools ke through useful output banaya jata hai. Is chapter me workbook, worksheet, row, column, cell, range aur basic interface samjhenge.

English + HinglishBeginnerExcel Lab connected

Workbook aur Worksheet

Workbook complete Excel file hoti hai. Ek workbook me ek ya multiple worksheets ho sakti hain.

Simple Hinglish

Workbook ko notebook samjho aur worksheets ko us notebook ke pages. Ek hi file me January, February aur March ke alag sheets ho sakte hain.

Rows, Columns aur Cells

  • Rows horizontal hoti hain aur numbers se identify hoti hain: 1, 2, 3...
  • Columns vertical hoti hain aur letters se identify hoti hain: A, B, C...
  • Cell row aur column ka intersection hai, jaise B3.

Cell Address

Cell address me pehle column letter aur phir row number aata hai. Example: D5 ka matlab column D, row 5.

Important: Formula likhte waqt cell references exact hone chahiye. B2 aur B3 alag cells hain.

Ranges

Continuous cells ke group ko range kehte hain. Example B2:B6 means B2 se B6 tak. A1:C5 rectangular range hai.

Common workbook actions

  • New workbook create karna
  • Worksheet rename karna
  • New sheet add karna
  • Sheet reorder karna
  • Save / Save As use karna
  • Useful file name dena

Good spreadsheet habits

  • Header row clear rakho.
  • Ek column me same type ka data rakho.
  • Blank rows unnecessarily dataset ke beech mat rakho.
  • Raw data aur summary ko logically separate rakho.
  • Important workbook ko meaningful name se save karo.

Practice — First sheet

  1. A1 me Name aur B1 me Marks likho.
  2. A2 me Rahul aur B2 me 85 enter karo.
  3. B2 cell select karke uska address identify karo.
  4. A1:B2 range select karo.

Practice in Excel Lab →

← Course HomeNext: Data Entry & Formatting →