LoveLifeIndia
Ad Image

MS Excel MCQs – 50 Important Questions for Exam | Part 1

Q1. Which key combination is used to quickly save a workbook in Excel?
A) Ctrl + S
B) Ctrl + P
C) Ctrl + N
D) Ctrl + O
Answer: A) Ctrl + S
Q2. Which function returns the sum of a range of cells?
A) AVERAGE()
B) SUM()
C) COUNT()
D) TOTAL()
Answer: B) SUM()
Q3. How do you write an absolute reference to cell A1 in a formula?
A) A1
B) $A$1
C) A$1
D) $A1
Answer: B) $A$1
Q4. Which function returns the largest value in a range?
A) MIN()
B) MAX()
C) LARGE()
D) TOP()
Answer: B) MAX()
Q5. Which feature is used to create a summary report from raw data with drag-and-drop fields?
A) Subtotal
B) PivotTable
C) Solver
D) Data Validation
Answer: B) PivotTable
Q6. Which function looks up a value in the left-most column and returns a value in the same row (approximate or exact match)?
A) VLOOKUP()
B) HLOOKUP()
C) INDEX()
D) MATCH()
Answer: A) VLOOKUP()
Q7. Which Excel tab contains the 'Conditional Formatting' option?
A) Home
B) Insert
C) Data
D) Formulas
Answer: A) Home
Q8. What does the function COUNTIF(range, criteria) do?
A) Counts non-empty cells
B) Counts cells that meet a condition
C) Sums cells that meet a condition
D) Counts characters in a cell
Answer: B) Counts cells that meet a condition
Q9. Which shortcut selects the entire column of the active cell?
A) Ctrl + A
B) Ctrl + Space
C) Shift + Space
D) Alt + Space
Answer: B) Ctrl + Space
Q10. Which function returns the current date?
A) NOW()
B) TODAY()
C) CURRENTDATE()
D) GETDATE()
Answer: B) TODAY()
Q11. Which feature allows splitting the window to view two parts of the sheet at once?
A) Freeze Panes
B) Split
C) New Window
D) Arrange All
Answer: B) Split
Q12. Which function joins (concatenates) text from multiple cells? (modern Excel)
A) CONCATENATE()
B) TEXTJOIN()
C) CONCAT()
D) All of the above
Answer: D) All of the above
Q13. Which tool removes duplicate rows from a dataset?
A) Remove Duplicates (Data tab)
B) Text to Columns
C) Flash Fill
D) Data Validation
Answer: A) Remove Duplicates (Data tab)
Q14. Which function returns the position of an item in a range?
A) INDEX()
B) MATCH()
C) FIND()
D) SEARCH()
Answer: B) MATCH()
Q15. How do you quickly copy a formula down a column?
A) Drag the fill handle
B) Double-click the fill handle
C) Ctrl + D
D) Any of the above (depending on situation)
Answer: D) Any of the above (depending on situation)
Q16. Which function returns text in upper case?
A) UPPER()
B) PROPER()
C) LOWER()
D) CAPS()
Answer: A) UPPER()
Q17. Which feature is used to limit the type of data users can enter in a cell?
A) Protect Sheet
B) Data Validation
C) Conditional Formatting
D) Filter
Answer: B) Data Validation
Q18. Which chart type is best for showing parts of a whole?
A) Line Chart
B) Pie Chart
C) Scatter Plot
D) Histogram
Answer: B) Pie Chart
Q19. Which function returns the number of non-empty cells in a range?
A) COUNT()
B) COUNTA()
C) COUNTBLANK()
D) COUNTIF()
Answer: B) COUNTA()
Q20. Which feature lets you convert text in one column into multiple columns based on a delimiter?
A) Text to Columns
B) Flash Fill
C) Split Cells
D) Convert Text
Answer: A) Text to Columns
Q21. Which function returns the remainder after division?
A) MOD()
B) INT()
C) ROUND()
D) TRUNC()
Answer: A) MOD()
Q22. Which feature quickly fills values based on patterns (like splitting names or extracting parts)?
A) AutoFill
B) Flash Fill
C) Fill Series
D) Quick Fill
Answer: B) Flash Fill
Q23. Which function would you use to test a condition and return one value if TRUE and another if FALSE?
A) IF()
B) IFS()
C) SWITCH()
D) CHOOSE()
Answer: A) IF()
Q24. Which feature can you use to test different input values to see results (simple what-if analysis)?
A) Goal Seek
B) Solver
C) Scenario Manager
D) Data Table
Answer: C) Scenario Manager
Q25. Which function returns the average of a range, ignoring text?
A) AVERAGE()
B) AVERAGEA()
C) AVERAGEIF()
D) MEAN()
Answer: A) AVERAGE()
Q26. Which command pastes only values (not formulas or formats)?
A) Paste
B) Paste Special → Values
C) Paste Special → Formulas
D) Paste Link
Answer: B) Paste Special → Values
Q27. Which function would you use to return a value from a table based on row & column numbers?
A) INDEX()
B) MATCH()
C) VLOOKUP()
D) HLOOKUP()
Answer: A) INDEX()
Q28. Which feature protects a worksheet from editing while allowing users to select cells?
A) Protect Workbook
B) Protect Sheet
C) Protect Cells
D) Lock View
Answer: B) Protect Sheet
Q29. Which function returns TRUE if all supplied conditions are TRUE?
A) OR()
B) AND()
C) ALL()
D) EVERY()
Answer: B) AND()
Q30. Which feature creates a chart quickly from selected data?
A) Insert → Chart
B) Recommended Charts
C) Quick Chart (Alt + F1)
D) All of the above
Answer: D) All of the above
Q31. What does the TRIM() function do?
A) Removes all spaces from text
B) Removes leading and trailing spaces
C) Removes extra decimal places
D) Converts text to uppercase
Answer: B) Removes leading and trailing spaces
Q32. Which feature lets you show only rows that meet criteria?
A) Sort
B) Filter
C) Group
D) Subtotal
Answer: B) Filter
Q33. Which function converts a number to text with a specified format?
A) TEXT()
B) VALUE()
C) FORMAT()
D) TO_TEXT()
Answer: A) TEXT()
Q34. Which command is used to group rows or columns for expand/collapse?
A) Data → Group
B) View → Group
C) Insert → Group
D) Format → Group
Answer: A) Data → Group
Q35. Which function finds text within text and returns starting position?
A) FIND()
B) SEARCH()
C) Both A and B
D) LOCATE()
Answer: C) Both A and B
Q36. Which feature allows you to trace formulas to see precedent cells?
A) Evaluate Formula
B) Trace Precedents
C) Watch Window
D) Formula Auditing toolbar
Answer: B) Trace Precedents
Q37. Which file extension is used by default for Excel workbooks (modern versions)?
A) .xls
B) .xlsx
C) .xlsm
D) .csv
Answer: B) .xlsx
Q38. Which Excel feature can automatically detect relationships and suggest visual summaries (in newer versions / Office 365)?
A) Ideas (formerly Insights)
B) Flash Fill
C) Power Query
D) Power Pivot
Answer: A) Ideas (formerly Insights)
Q39. Which function returns the number of characters in a text string?
A) LEN()
B) COUNT()
C) CHARS()
D) LENGTH()
Answer: A) LEN()
Q40. Which tool helps import and transform external data (ETL) in Excel?
A) Power Query
B) Power Pivot
C) Solver
D) Macro Recorder
Answer: A) Power Query
Q41. Which function returns the smallest value in a range?
A) MIN()
B) SMALL()
C) LEAST()
D) LOW()
Answer: A) MIN()
Q42. Which feature converts columns of data into a single column or vice versa?
A) Transpose (Paste Special)
B) PivotTable
C) Merge Cells
D) Consolidate
Answer: A) Transpose (Paste Special)
Q43. Which function returns a value based on row and column match using MATCH with INDEX (combination)?
A) INDEX(MATCH())
B) VLOOKUP
C) HLOOKUP
D) LOOKUP
Answer: A) INDEX(MATCH())
Q44. Which function returns a random number between 0 and 1?
A) RAND()
B) RANDBETWEEN()
C) RANDOM()
D) RANDINT()
Answer: A) RAND()
Q45. Which feature allows creating named ranges for easy reference?
A) Define Name (Formulas → Define Name)
B) Data Validation
C) Named Table
D) Format as Table
Answer: A) Define Name (Formulas → Define Name)
Q46. Which feature quickly formats a range as a structured table with filters and style?
A) Format Painter
B) Insert → Table
C) Home → Format as Table
D) Both B and C
Answer: D) Both B and C
Q47. Which function returns a value if a match is found, otherwise returns #N/A?
A) VLOOKUP()
B) MATCH()
C) LOOKUP()
D) All of the above can return #N/A
Answer: D) All of the above can return #N/A
Q48. Which command lets you record user actions as VBA code?
A) Developer → Record Macro
B) View → Record Macro
C) Insert → Macro Recorder
D) Data → Record Macro
Answer: A) Developer → Record Macro
Q49. Which feature helps analyze variability and frequency of numeric data (bins)?
A) PivotTable
B) Histogram (Analysis ToolPak)
C) Scatter Plot
D) Sparklines
Answer: B) Histogram (Analysis ToolPak)
Q50. Which function would you use to return a substring from the left of a text string?
A) RIGHT()
B) MID()
C) LEFT()
D) SUBSTRING()
Answer: C) LEFT()
Picture of LoveLifeIndia

LoveLifeIndia

Leave a Comment

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

Recent Posts

Scroll to Top