Microsoft Excel हर student, professional और job aspirant के लिए important skill है। Excel exams, competitive tests और interviews में अक्सर ये basic और frequently asked MCQs पूछे जाते हैं।
नीचे top 30 Excel MCQs दिए गए हैं जो आपके लिए exam preparation और practice के लिए बहुत useful होंगे।
🔹 1–10: Excel Basics
- Which of the following is used to create a spreadsheet in Microsoft Excel?
a) Word
b) Excel ✅
c) PowerPoint
d) Access - Default extension of Excel file is:
a) .docx
b) .xlsx ✅
c) .pptx
d) .txt - What is the shortcut key to save a workbook in Excel?
a) Ctrl + P
b) Ctrl + S ✅
c) Ctrl + C
d) Ctrl + V - Which key is used to move to the next cell in Excel?
a) Enter ✅
b) Tab
c) Shift
d) Esc - Which of the following is not a data type in Excel?
a) Text
b) Number
c) Formula
d) Paragraph ✅ - How can you insert a new worksheet in Excel?
a) Right-click tab → Insert ✅
b) Ctrl + N
c) Home → Format
d) File → New - Which of the following is used to calculate totals in Excel?
a) SUM ✅
b) COUNT
c) AVERAGE
d) MAX - Which feature in Excel is used to arrange data in ascending or descending order?
a) Filter
b) Sort ✅
c) Freeze Panes
d) Conditional Formatting - In Excel, a cell address is defined by:
a) Column letter + Row number ✅
b) Row number + Column letter
c) Worksheet name
d) None of the above - Shortcut to undo an action in Excel is:
a) Ctrl + C
b) Ctrl + Z ✅
c) Ctrl + Y
d) Ctrl + X
🔹 11–20: Formulas & Functions
- Which formula is used to calculate average in Excel?
a) =SUM(A1:A10)
b) =AVERAGE(A1:A10) ✅
c) =COUNT(A1:A10)
d) =MAX(A1:A10) - What does VLOOKUP function do in Excel?
a) Creates charts
b) Looks for a value in a table ✅
c) Counts cells
d) Adds numbers - Which formula is used to count cells based on criteria?
a) SUMIF
b) COUNTIF ✅
c) AVERAGEIF
d) IF - Which of the following is used to combine text from multiple cells?
a) CONCATENATE ✅
b) SUM
c) AVERAGE
d) LEFT - Formula to round off a number in Excel is:
a) =ROUND(A1,2) ✅
b) =SUM(A1,2)
c) =AVERAGE(A1,2)
d) =TRUNC(A1,2) - Which function returns the current date?
a) NOW
b) TODAY ✅
c) DATE
d) TIME - Which of the following is used to find maximum value in a range?
a) MAX ✅
b) MIN
c) SUM
d) COUNT - Which function extracts characters from the left of a string?
a) RIGHT
b) LEFT ✅
c) MID
d) LEN - IF formula is used for:
a) Mathematical calculation
b) Conditional check ✅
c) Sorting
d) Filtering - Which symbol is used to start a formula in Excel?
a) &
b) = ✅
c) +
d) $
🔹 21–30: Shortcuts & Advanced Tips
- Shortcut to select entire column:
a) Ctrl + C
b) Ctrl + Space ✅
c) Shift + Space
d) Alt + C - Shortcut to select entire row:
a) Ctrl + Space
b) Shift + Space ✅
c) Ctrl + Shift
d) Alt + R - What does Freeze Panes feature do?
a) Lock header rows or columns ✅
b) Delete rows
c) Hide sheets
d) Merge cells - Which chart is used for comparing parts of a whole?
a) Line
b) Column
c) Pie ✅
d) Scatter - Shortcut to insert a new worksheet:
a) Shift + F11 ✅
b) Ctrl + N
c) Alt + N
d) Ctrl + T - What is the use of Conditional Formatting in Excel?
a) Apply formatting based on conditions ✅
b) Freeze rows
c) Sort data
d) Count cells - Which function is used to remove extra spaces in a cell?
a) CLEAN
b) TRIM ✅
c) LEFT
d) MID - Shortcut to open Format Cells window:
a) Ctrl + 1 ✅
b) Ctrl + 2
c) Ctrl + F
d) Ctrl + Alt + F - Which function is used for horizontal lookup?
a) VLOOKUP
b) HLOOKUP ✅
c) LOOKUP
d) INDEX - Which of the following is used to calculate loan EMI in Excel?
a) PMT ✅
b) EMI
c) LOAN
d) RATE
✅ Conclusion
ये Top 30 Excel MCQs आपके exam preparation, interviews और competitive exams के लिए बहुत useful हैं।
💡 Pro Tip: सिर्फ याद करने के बजाय इन MCQs को Excel में practice करें।