Excel Questions with Answers Set 01 – 100 Most Asked Exam Paper Questions
Microsoft Excel 2026 me bhi sabse jyada use hone wale Office applications me se ek hai. School exams, competitive exams, computer courses, नौकरी interviews, CCC, O Level, ADCA, DCA, Data Entry Operator, Office Assistant aur Banking related exams me Excel se related questions frequently puche jaate hain.
Is post me aapko 100 Most Asked Excel Questions with Answers 2026 milenge jo basic se advance level tak cover karte hain. Ye questions specially exam preparation aur interview purpose ke liye SEO friendly aur updated format me diye gaye hain.
MS Excel Basic Questions with Answers
1. Microsoft Excel kya hai?
Answer: Microsoft Excel ek spreadsheet software hai jo data entry, calculation, chart, report, aur data analysis ke liye use kiya jata hai.
2. Excel kis company ne develop kiya hai?
Answer: Excel ko Microsoft ne develop kiya hai.
3. Excel file ka default extension kya hota hai?
Answer: Excel 2007 aur uske baad ka default extension .xlsx hota hai.
4. Workbook kya hota hai?
Answer: Excel me save ki gayi puri file ko Workbook kaha jata hai.
5. Worksheet kya hota hai?
Answer: Workbook ke andar ka working page Worksheet kehlata hai.
6. Excel me row aur column ka intersection kya kehlata hai?
Answer: Row aur Column ke intersection ko Cell kaha jata hai.
7. Active Cell kya hota hai?
Answer: Jo cell currently selected hota hai use Active Cell kehte hain.
8. Excel me total kitni rows hoti hain?
Answer: Excel me total 10,48,576 rows hoti hain.
9. Excel me total kitne columns hote hain?
Answer: Excel me total 16,384 columns hote hain.
10. Column ka last name kya hota hai?
Answer: Excel ka last column name XFD hota hai.
Excel Interface Related Questions
11. Formula Bar ka kya use hai?
Answer: Formula Bar me formulas aur cell data ko dekhne aur edit karne ke liye use kiya jata hai.
12. Name Box kya hota hai?
Answer: Name Box active cell ka address show karta hai.
13. Ribbon kya hota hai?
Answer: Ribbon me tabs aur commands available hoti hain jinke through Excel features use kiye jate hain.
14. Quick Access Toolbar ka use kya hai?
Answer: Frequently used commands ko jaldi access karne ke liye Quick Access Toolbar use hota hai.
15. Status Bar kya show karta hai?
Answer: Status Bar worksheet ki current information show karta hai jaise Sum, Average, aur Count.
Excel Shortcut Keys Questions
16. New Workbook banane ki shortcut key kya hai?
Answer: Ctrl + N
17. Workbook save karne ki shortcut key kya hai?
Answer: Ctrl + S
18. Copy karne ki shortcut key kya hai?
Answer: Ctrl + C
19. Paste karne ki shortcut key kya hai?
Answer: Ctrl + V
20. Undo karne ki shortcut key kya hai?
Answer: Ctrl + Z
21. Redo karne ki shortcut key kya hai?
Answer: Ctrl + Y
22. Find command ki shortcut key kya hai?
Answer: Ctrl + F
23. Replace command ki shortcut key kya hai?
Answer: Ctrl + H
24. Bold formatting ki shortcut key kya hai?
Answer: Ctrl + B
25. Italic formatting ki shortcut key kya hai?
Answer: Ctrl + I
Excel Formula and Function Questions
26. Formula kya hota hai?
Answer: Excel me calculation karne ke liye use hone wale expression ko Formula kehte hain.
27. Formula Kis sign se start hota hai?
Answer: Formula Equal (=) sign se start hota hai.
28. SUM function ka use kya hai?
Answer: SUM function numbers ko add karne ke liye use hota hai.
29. AVERAGE function kya karta hai?
Answer: AVERAGE function selected values ka average nikalta hai.
30. MAX function ka use kya hai?
Answer: MAX function sabse badi value find karta hai.
31. MIN function kya karta hai?
Answer: MIN function sabse chhoti value find karta hai.
32. COUNT function ka use kya hai?
Answer: COUNT function numeric cells ki counting karta hai.
33. IF function kya hota hai?
Answer: IF function condition check karne ke liye use hota hai.
34. TODAY function kya return karta hai?
Answer: TODAY function current date return karta hai.
35. NOW function kya show karta hai?
Answer: NOW function current date aur time show karta hai.
36. LEN function kya karta hai?
Answer: LEN function text ki total length count karta hai.
37. CONCATENATE function ka use kya hai?
Answer: Multiple text values ko combine karne ke liye use hota hai.
38. VLOOKUP function kya hai?
Answer: VLOOKUP kisi table me vertically data search karne ke liye use hota hai.
39. HLOOKUP function kya karta hai?
Answer: HLOOKUP horizontally data search karta hai.
40. ROUND function ka use kya hai?
Answer: Decimal numbers ko round karne ke liye ROUND function use hota hai.
Formatting Related Questions
41. Cell Formatting kya hota hai?
Answer: Cell ki appearance change karne ki process ko Formatting kehte hain.
42. Merge and Center ka use kya hai?
Answer: Multiple cells ko merge karke text ko center me lane ke liye use hota hai.
43. Wrap Text kya karta hai?
Answer: Cell ke text ko multiple lines me display karta hai.
44. Conditional Formatting kya hai?
Answer: Specific conditions ke according cells ko automatically format karna Conditional Formatting kehlata hai.
45. Border ka use kya hai?
Answer: Cells ke around lines add karne ke liye Border use hota hai.
Data Management Questions
46. Sorting kya hota hai?
Answer: Data ko ascending ya descending order me arrange karna Sorting kehlata hai.
47. Filtering kya hai?
Answer: Sirf required data ko display karna Filtering kehlata hai.
48. Data Validation kya hota hai?
Answer: Data entry rules apply karne ki process ko Data Validation kehte hain.
49. Freeze Panes ka use kya hai?
Answer: Rows ya columns ko fixed rakhne ke liye Freeze Panes use hota hai.
50. Remove Duplicates feature kya karta hai?
Answer: Duplicate data ko remove karta hai.
Chart and Graph Questions
51. Chart kya hota hai?
Answer: Data ka graphical representation Chart kehlata hai.
52. Excel me commonly used chart kaun sa hai?
Answer: Column Chart sabse commonly used chart hai.
53. Pie Chart kis purpose ke liye use hota hai?
Answer: Percentage aur proportion show karne ke liye Pie Chart use hota hai.
54. Line Chart ka use kya hai?
Answer: Trends aur progress show karne ke liye Line Chart use hota hai.
55. Bar Chart aur Column Chart me kya difference hai?
Answer: Bar Chart horizontal hota hai, jabki Column Chart vertical hota hai.
Excel Printing Questions
56. Print Preview kya hota hai?
Answer: Print se pehle page ka preview dekhna Print Preview kehlata hai.
57. Page Orientation kitne types ki hoti hai?
Answer: Portrait aur Landscape.
58. Header aur Footer kya hote hain?
Answer: Page ke top aur bottom me information add karne ko Header aur Footer kehte hain.
59. Print Area kya hota hai?
Answer: Worksheet ka selected area jo print hoga use Print Area kehte hain.
60. Page Break ka use kya hai?
Answer: Printing pages ko divide karne ke liye Page Break use hota hai.
Advanced Excel Questions
61. Pivot Table kya hai?
Answer: Large data ko summarise aur analyse karne ke liye Pivot Table use hoti hai.
62. Macro kya hota hai?
Answer: Repetitive tasks ko automate karne ke liye Macro use hota hai.
63. VBA ka full form kya hai?
Answer: Visual Basic for Applications.
64. Goal Seek kya karta hai?
Answer: Desired result ke according input value find karta hai.
65. What-If Analysis kya hota hai?
Answer: Different values ke effect ko analyse karna What-If Analysis kehlata hai.
66. Scenario Manager kya hai?
Answer: Multiple scenarios create aur compare karne ke liye use hota hai.
67. Power Query kya hai?
Answer: Data import aur transformation tool ko Power Query kehte hain.
68. Power Pivot ka use kya hai?
Answer: Large data models aur advanced analysis ke liye use hota hai.
69. Flash Fill kya karta hai?
Answer: Pattern identify karke automatically data fill karta hai.
70. Sparklines kya hoti hain?
Answer: Cell ke andar mini charts ko Sparklines kehte hain.
Excel File and Security Questions
71. Workbook ko password se secure kaise karte hain?
Answer: File menu me जाकर Protect Workbook option use kiya jata hai.
72. Read-only mode kya hota hai?
Answer: Is mode me file ko sirf dekha ja sakta hai edit nahi.
73. AutoSave feature kya karta hai?
Answer: File ko automatically save karta hai.
74. Excel template kya hota hai?
Answer: Pre-designed workbook ko Template kehte hain.
75. CSV file kya hoti hai?
Answer: Comma Separated Values format wali file ko CSV file kehte hain.
Tally Prime Online Test: 100 Most Important Accounting Questions & Answers
Practical Excel Questions
76. Percentage calculate karne ka formula kya hai?
Answer:
77. Total marks calculate karne ke liye kaunsa function use hota hai?
Answer: SUM function.
78. Result Pass/Fail ka formula kya hota hai?
Answer: IF function use hota hai.
79. Salary sheet banane me kaunsa software use hota hai?
Answer: Microsoft Excel.
80. Attendance sheet banane ke liye Excel useful hai?
Answer: Haan, Excel attendance management ke liye bahut useful hai.
CCC Questions with Answers – 100 Most Asked Exam Paper Questions in Hindi
Excel Interview Questions 2026
81. Relative Cell Reference kya hota hai?
Answer: Copy karne par automatically change hone wala reference Relative Reference kehlata hai.
82. Absolute Reference kya hota hai?
Answer: Fixed reference ko Absolute Reference kehte hain.
83. Absolute Reference ka symbol kya hota hai?
Answer: Dollar sign ($)
84. Mixed Reference kya hota hai?
Answer: Jisme row ya column me se koi ek fixed ho use Mixed Reference kehte hain.
85. Nested IF kya hai?
Answer: IF function ke andar multiple IF conditions use karna Nested IF kehlata hai.
86. Excel me error #DIV/0! Kab aata hai?
Answer: Jab kisi number ko zero se divide kiya jata hai.
87. #NAME? error ka kya matlab hai?
Answer: Formula me invalid name ya spelling mistake hone par ye error aata hai.
88. #VALUE! error kab aata hai?
Answer: Wrong data type use karne par #VALUE! error aata hai.
89. Formula copy karne ke liye Fill Handle kya hota hai?
Answer: Cell ke corner par small square ko Fill Handle kehte hain.
90. AutoFill feature kya karta hai?
Answer: Series aur formulas automatically fill karta hai.
CCC Questions with Answers in English – 101 Most Asked CCC Exam Paper Questions
Excel Exam MCQ Type Questions
91. Excel me cell address ka example kya hai?
Answer: A1
92. Excel me text ko default alignment kis side hota hai?
Answer: Left side.
93. Numbers ka default alignment kis side hota hai?
Answer: Right side.
94. Excel me chart insert karne ke liye kaunsi tab use hoti hai?
Answer: Insert Tab.
95. Formula edit karne ke liye kaunsi key use hoti hai?
Answer: F2
96. Excel me spelling check ki shortcut key kya hai?
Answer: F7
97. Nayi line same cell me lane ke liye kaunsi shortcut key use hoti hai?
Answer: Alt + Enter
98. Excel me zoom feature ka kya use hai?
Answer: Worksheet ko bada ya chhota dekhne ke liye use hota hai.
99. Excel Online kya hai?
Answer: Browser me chalne wala cloud-based Excel version Excel Online kehlata hai.
100. Excel ka latest modern use kis field me sabse jyada hota hai?
Answer: Data Analysis, Accounting, Office Work, Reporting aur Business Management.
Conclusion at Excel Questions with Answers Set 01
Ye Excel Questions with Answers Set 01 – 100 Most Asked Exam Paper Questions in 2026 jo computer exams, interviews aur practical knowledge ke liye bahut important hain. Agar aap CCC, O Level, ADCA, DCA, Data Entry, Banking, Office Assistant, ya Computer Operator exams ki preparation kar rahe hain to ye questions aapke liye kaafi helpful rahenge.
Important links:
- VedantSri official website: https://vedantsri.com
- Course store website: https://vedantsri.in
- Job assist website: https://www.jobdo.in
- MS Word class: https://mswordclass.com
- Corel free class: https://corelclass.com
- Free Excel class: https://msexcelclass.com
