Gyansetu Team 
Practice these MCQs to strengthen your skills and prepare for job interviews or certification exams.
The goal of preparing an Advanced Excel Course In Gurgaon or cracking Excel-based interviews?
You are in the right place. We have curated 70+ MCQs on Advanced Excel, which covers everything from formulas and data analysis to pivot tables and Power Query – with all answers, no hatches.
Section 1: Excel Basics and Formulas
Q1. What is the shortcut key to insert a new worksheet?
a) Ctrl + W
b) Shift + F11
c) Ctrl + N
d) Alt + F11
Answer: b) Shift + F11
Q2. Which function gives the number of characters in a string?
a) COUNT
b) LEN
c) TEXT
d) CHAR
Answer: b) LEN
Q3. What does the VLOOKUP function do?
a) Total calculations
B) vertically searches
C) discovers horizontally
d) formats data
Answer: b) vertically searches
Q4. Which function is used to find the largest value?
a) MAX
b) BIG
c) LARGE
d) HIGH
Answer: a) MAX
Q5. = What is the result of =ROUND(15.789, 1)?
a) 15.7
B) 15.8
C) 16
d) 15.79
Answer: B) 15.8
Section 2: Logical and Lookup Function
Q6. Which function is used for conditional logic?
a) IF
b) MATCH
c) SUM
d) INDEX
Answer: a) IF
Q7. Which formula finds a price position?
a) FIND
b) LOCATE
c) POSITION
d) MATCH
Answer: d) MATCH
Q8. = IF (5> 3, “yes”, “no”) returns?
A) Yes
B) No
C) error
d) 5
Answer: A) Yes
Q9. Which function connects INDEX and MATCH?
a) VLOOKUP
b) XLOOKUP
c) Nested formula
d) INDEXMATCH
Answer: c) Nested formula
Q10. Which function in Excel 365 replaces VLOOKUP and HLOOKUP?
a) FIND
b) MATCH
c) XLOOKUP
d) SEARCH
Answer: c) XLOOKUP
Section 3: Lesson Work
Q11. Which function extracts gives left characters?
a) RIGHT
b) MID
c) LEFT
d) LEN
Answer: c) LEFT
Q12. What = trim (“hello”) return?
a) Hello
b) Hello
c) ” Hello “
d) Hello with spaces
Answer: a) Hello
Q13. Which function converts lowercase into uppercase?
a) PROPER
b) LOWER
c) UPPER
d) CAPITAL
Answer: c) UPPER
Q14. What = CONCAT (“Excel”, “2025”) return?
a) Excel 2025
B) Excel2025
C) error
D) “Excel”, “2025”
Answer: b) Excel2025
Q15. Which function returns a part of the text from the middle?
a) LEFT
b) MID
c) RIGHT
d) PART
Answer: b) MID
Section 4: Date & Time Functions
Q16.What does =TODAY() return?
a) Current time
b) Current date
c) Day of the week
d) Month
Answer: b) Current date
Q17. Which function gives the number of days between two dates?
a) COUNT
b) DAYS
c) DATEDIF
d) DATEGAP
Answer: b) DAYS
Q18. What does =NOW() return?
a) Date
b) Time
c) Date and time
d) None
Answer: c) Date and time
Q19. Which function removes the month from a date?
a) MONTH
b) DATE
c) DAY
d) YEAR
Answer: a) MONTH
Get Expert Supervision
Q20. What = YEAR (“1/1/2020”) return?
a) 2020
B) 20
C) 1
D) error
Answer: A) 2020
Section 5: Charts and Visualization
Q21. Which chart type shows a ratio?
a) Line
b) Column
c) Pie
d) Bar
Answer: c) Pie
Q22. What is a sparkline in Excel?
a) Mini chart
b) Formula
c) Button
d) Theme
Answer: a) Mini chart
Q23. Where do you find chart options in Excel?
a) Insert
b) Review
c) File
d) Data
Answer: a) Insert
Q24. Can you make a combo chart in Excel?
A) No
B) only in Excel 2010
C) Yes
d) only on Mac
Answer: C) Yes
Q25. What does the data label show in the chart?
a) Chart title
b) Value or name
c) Axis
d) Legend
Answer: b) Value or name
Section 6: Data Equipment and Tools
Q26. Which feature removes duplicate values?
a) Filter
b) Data Validation
c) Remove Duplicates
d) Find & Replace
Answer: c) Remove Duplicates
Q27. Shortcut to applying a filter?
a) Ctrl + F
b) Ctrl + Shift + L
c) Alt + F4
d) Shift + L
Answer: b) Ctrl + Shift + L
Q28. Data Validation helps to:
a) Remove the errors
B) Format cells
C) Restrict data entry
d) Auto-Fill data
Answer: C) Restrict data entry
Q29. What is the Excel feature used in Analysis?
a) Pivot Table
b) Scenario Manager
c) Conditional Formatting
d) Slicers
Answer: b) Scenario Manager
Q30. What does Flash Fill do?
a) Sort data
b) Fill patterns quickly
c) Format cells
d) Print documents
Answer: b) Fill patterns quickly
Section 7: Pivot Table
Q31. What is the purpose of a pivot table?
a) Enter data
b) Data analysis
c) Formatting cells
d) Drawing shapes
Answer: b) Data analysis
Q32. What can’t you do with the pivot tables?
a) Sort
b) Filter
c) Write macros
d) Analyze
Answer: c) Write macros
Q33. In Pivot Table, “rows” represent:
a) Categories
b) Filters
c) Values
d) None
Answer: a) Categories
Q34. Is Slicer usable with Pivot Tables?
A) Yes
B) No
C) Only Excel 2010
d) Only charts
Answer: A) Yes
Q35. Default Calculation in PivotTable?
a) Average
b) Count
c) Sum
d) Min
Answer: c) Sum
Section 8: Power Query and Power Pivot
Q36. Used for Power Query:
a) Formatting
b) Data transformation
c) Drawing charts
d) File saving
Answer: b) Data transformation
Q37. Power Query uses which language?
a) Excel
b) VBA
c) M
d) C++
Answer: c) M
Q38. Power Pivot enables:
a) Macros
b) Big data models
c) Slicers
d) Password protection
Answer: b) Big data models
Q39. DAX stands for:
a) Data Array Excel
b) Data Analysis Expressions
c) Data Aggregation Excel
d) None
Answer: b) Data Analysis Expressions
Q40. Is Power Pivot for Excel available in 2010?
a) Yes, as add-in
B) No
C) only in 365
d) Mac only
Answer: A) Yes, as add-in
Section 9: Shortcut and Advanced Tools
Q41. Shortcut to insert the current date?
a) Ctrl + D
B) Ctrl + ;
C) Alt + D
D) Shift +;
Answer: b) Ctrl + ;
Q42. Which shortcut Format opens Cells?
a) Ctrl + 1
b) Ctrl + F
c) Alt + Enter
d) Ctrl + Shift + F
Answer: a) Ctrl + 1
Q43. Shortcut for auto-sum?
a) Ctrl + Alt + S
b) Alt + =
c) Ctrl + Shift + =
d) Alt + Shift + S
Answer: b) Alt + =
Q44. Shortcut to insert hyperlinks?
a) Ctrl + K
B) CTRL + H
c) Alt + K
d) Ctrl + l
Answer: a) Ctrl + K
Q45. Shortcut to go to A1?
a) Ctrl + G
b) Ctrl + Home
c) Alt + A
d) Ctrl + A
Answer: b) Ctrl + Home
Section 10: Miscellaneous
Q46. Excel file extension (latest)?
a) .xls
b) .XLSX
c) .docx
d) .csv
Answer: b) .XLSX
Q47. Max columns in Excel 365?
a) 16,384
b) 1,048,576
c) 10,000
d) 25,600
Answer: a) 16,384
Q48. Max rows in Excel 365?
a) 100,000
B) 500,000
C) 1,048,576
d) unlimited
Answer: C) 1,048,576
Q49. Table creation shortcut?
a) Ctrl + T
b) Ctrl + Q
c) Ctrl + L
d) Ctrl + E
Answer: a) Ctrl + T
Q50. Convert the column into a row?
a) PIVOT
b) TRANSPOSE
c) SWITCH
d) ROTATE
Answer: b) TRANSPOSE
Q51. Which device makes the dropdown menus?
a) Filter
b) Data Validation
c) Conditional Formatting
d) Scenario
Answer: b) Data Validation
Q52. Remove all formatting?
a) Clear Contents
b) Clear All
c) Clear Formats
d) Delete
Answer: c) Clear Formats
Q53. Shortcut to repeat the final action?
a) Ctrl + R
b) Ctrl + Y
c) Ctrl + Z
d) Alt + Y
Answer: b) Ctrl + Y
Q54. Highlight duplicate values?
a) Filter
b) Find
c) Conditional Formatting
d) Data Validation
Answer: c) Conditional Formatting
Data Science Courses By Gyansetu
Q55. Apply limits for selection?
a) Ctrl + Shift + 7
b) Ctrl + B
c) Ctrl + Alt + B
d) Shift + B
Answer: a) Ctrl + Shift + 7
Q56. Text to Columns is used for?
a) Merging cells
b) Splitting data
c) Wrapping text
d) Finding values
Answer: b) Splitting data
Q57. Cell reference with $ symbol is?
a) Absolute
b) Relative
c) Mixed
d) Dynamic
Answer: a) Absolute
Q58. Merge and Center is found under?
a) Insert
b) View
c) Home
d) Data
Answer: c) Home
Q59. Shortcut for Find?
a) Ctrl + G
b) Ctrl + F
c) Ctrl + Shift + F
d) Ctrl + H
Answer: b) Ctrl + F
Q60. Conditional formatting is used:
a) Delete rows
b) Format charts
c) Highlight rules
d) Merge cells
Answer: c) Highlight rules
Q61. What is the goal looking for?
a) Chart analysis
b) Solve equations
c) Formatting
d) Validation
Answer: b) Solve equations
Q62. Excel shortcut to Save As?
a) F11
B) F12
c) F10
d) F5
Answer: b) F12
Q63. Hyperlink function syntax?
a) =LINK()
b) =HYPER()
c) =HYPERLINK()
d) =URL()
Answer: c) =HYPERLINK()
Q64. Excel cell reference for row 2, column 3?
a) C2
b) B3
c) A2
d) C3
Answer: a) C2
Q65. Which tab allows Freeze Panes ?
a) Data
b) Home
c) View
d) Review
Answer: c) View
Q66. Format Painter copies?
a) Values
b) Layout
c) Formatting
d) Borders
Answer: c) Formatting
Q67. Shortcut to hide rows?
a) Ctrl + 9
b) Ctrl + Shift + H
c) Ctrl + Alt + 9
d) Ctrl + 0
Answer: a) Ctrl + 9
Q68. Shortcut for unhide columns?
a) Ctrl + Shift + 0
b) Ctrl + Shift + 9
c) Ctrl + 1
d) Ctrl + U
Answer: a) Ctrl + Shift + 0
Q69. Shortcut to close Excel?
a) Ctrl + Q
b) Ctrl + F4
c) Ctrl + W
d) Alt + F4
Answer: d) Alt + F4
Q70. Default Excel number format?
a) General
b) Number
c) Currency
d) Text
Answer: a) General
Conclusion
Mastering these Advanced Excel MCQs is a great step toward improving your data handling efficiency. If you’re looking to build your career with real-time projects and instructor-led training, join our Advanced Excel course in Gurgaon at Gyansetu and become proficient with ease.
