Microsoft Excel E-book

Microsoft Excel Kya Hai? (Hindi + English)

Microsoft Excel एक स्प्रेडशीट सॉफ्टवेयर है, जिसे Microsoft द्वारा बनाया गया है। इसका उपयोग डेटा को टेबल (rows और columns) में व्यवस्थित करने, गणना करने, चार्ट बनाने और डेटा का विश्लेषण करने के लिए किया जाता है।

Excel में हम फार्मूला और फंक्शन की मदद से आसानी से बड़े डेटा पर काम कर सकते हैं। इसका उपयोग स्कूल, ऑफिस, बैंक, बिजनेस आदि में किया जाता है।

👉 उदाहरण:

  • मार्कशीट बनाना
  • खर्च का हिसाब रखना
  • ग्राफ और चार्ट बनाना

Microsoft Excel is a spreadsheet software developed by Microsoft. It is used to organize data in rows and columns, perform calculations, create charts, and analyze information.

Excel allows users to use formulas and functions to handle large amounts of data easily. It is widely used in schools, offices, banks, and businesses.

👉 Examples:

  • Creating marksheets
  • Managing accounts
  • Making charts and graphs
Excel Full Notes_mergedDownload

50 MCQ Questions with Answers (Microsoft Excel)

Basic Level MCQs

  1. Excel is a type of?
    👉 a) Word Processor
    👉 b) Spreadsheet ✅
    👉 c) Browser
    👉 d) OS
  2. Excel file is called?
    👉 a) Sheet
    👉 b) Workbook ✅
    👉 c) Page
    👉 d) File
  3. Intersection of row and column is?
    👉 a) Range
    👉 b) Cell ✅
    👉 c) Box
    👉 d) Table
  4. Default file extension of Excel is?
    👉 a) .doc
    👉 b) .xls / .xlsx ✅
    👉 c) .ppt
    👉 d) .txt
  5. Excel is used for?
    👉 a) Drawing
    👉 b) Calculation ✅
    👉 c) Gaming
    👉 d) Music

Intermediate MCQs

  1. Formula starts with?
    👉 a) #
    👉 b) @
    👉 c) = ✅
    👉 d) &
  2. SUM function is used for?
    👉 a) Multiply
    👉 b) Add numbers ✅
    👉 c) Divide
    👉 d) Subtract
  3. Shortcut to save file?
    👉 a) Ctrl + S ✅
    👉 b) Ctrl + C
    👉 c) Ctrl + X
    👉 d) Ctrl + V
  4. Maximum rows in Excel (modern)?
    👉 a) 1000
    👉 b) 1048576 ✅
    👉 c) 5000
    👉 d) 10000
  5. Chart is used for?
    👉 a) Typing
    👉 b) Visual representation ✅
    👉 c) Printing
    👉 d) Editing

Advanced MCQs

  1. VLOOKUP is used for?
    👉 a) Searching data vertically ✅
    👉 b) Drawing
    👉 c) Printing
    👉 d) Formatting
  2. Pivot Table is used for?
    👉 a) Data summary ✅
    👉 b) Typing
    👉 c) Drawing
    👉 d) Saving
  3. Cell address example?
    👉 a) 1A
    👉 b) A1 ✅
    👉 c) AA
    👉 d) 11
  4. Shortcut for copy?
    👉 a) Ctrl + X
    👉 b) Ctrl + V
    👉 c) Ctrl + C ✅
    👉 d) Ctrl + Z
  5. Excel belongs to?
    👉 a) MS Office ✅
    👉 b) Windows
    👉 c) Linux
    👉 d) Android

Remaining MCQs (16–50)

  1. Row runs? → Horizontal ✅
  2. Column runs? → Vertical ✅
  3. AutoSum shortcut? → Alt + = ✅
  4. Wrap Text used for? → Text adjust in cell ✅
  5. Merge Cells means? → Combine cells ✅
  6. Function used to count numbers? → COUNT ✅
  7. Average function? → AVERAGE ✅
  8. Highest value? → MAX ✅
  9. Lowest value? → MIN ✅
  10. IF function used for? → Logical test ✅
  11. Workbook contains? → Sheets ✅
  12. Active cell shows? → Bold border ✅
  13. Delete shortcut? → Delete key ✅
  14. Undo shortcut? → Ctrl + Z ✅
  15. Redo shortcut? → Ctrl + Y ✅
  16. Filter used for? → Sorting data ✅
  17. Freeze panes? → Lock rows/columns ✅
  18. Insert row shortcut? → Ctrl + + ✅
  19. Format cells shortcut? → Ctrl + 1 ✅
  20. New workbook? → Ctrl + N ✅
  21. Open file? → Ctrl + O ✅
  22. Print shortcut? → Ctrl + P ✅
  23. Find shortcut? → Ctrl + F ✅
  24. Replace shortcut? → Ctrl + H ✅
  25. Bold shortcut? → Ctrl + B ✅
  26. Italic shortcut? → Ctrl + I ✅
  27. Underline shortcut? → Ctrl + U ✅
  28. Excel formula example? → =A1+B1 ✅
  29. Range example? → A1:A10 ✅
  30. Sheet rename? → Double click ✅
  31. Insert chart? → Insert tab ✅
  32. Conditional formatting? → Highlight data ✅
  33. Hyperlink used for? → Link to page ✅
  34. Data validation? → Restrict input ✅
  35. Macro used for? → Automation ✅

Leave a Reply

Your email address will not be published. Required fields are marked *