excel mcqs

Top Excel Multiple Choice Questions (MCQs) For 2026

November 2nd, 2026
22973
15:00 Minutes

Preparing to become an Expert in Microsoft Excel? This Top Excel MCQs collection is your ultimate resource. It includes frequently asked multiple-choice questions, categorized for comprehensive learning, to evaluate your expertise and identify areas for improvement.

Note: Score 60% or higher to unlock an exclusive offer of up to 50% off on all self-paced Excel courses.

Let's begin!

Excel Fundamentals

1. Which file extension is used by default for Excel workbooks in recent versions?






2. What does a cell reference like A1 refer to?






3. Which key opens the Go To dialog (to jump to a cell) in Excel?






4. Which of the following is a valid way to start a formula in Excel?






5. What does the Fill Handle do?






Want to Learn Everything About Microsoft Excel?

Start Your Learning Journey With our Online Trainings

Core SkillsHands-on LearningCareer Growth

Formulas & Functions — Basics

6. Which function returns the sum of a range?






7. What does the function VLOOKUP do?






8. Which function counts non-empty cells in a range?






9. Which function returns the largest value in a range?






10. Which function checks whether a condition is TRUE or FALSE and returns one value for TRUE and another for FALSE?






Formulas & Functions — Intermediate

11. What does INDEX/MATCH together provide compared to VLOOKUP?






12. Which function returns the current date?






13. Which function would you use to join text from multiple cells with a delimiter?






14. Which function converts text to uppercase?






15. What does the ROUND function do?






Want to Learn Everything About Microsoft Excel?

Start Your Learning Journey With our Online Trainings

Core SkillsHands-on LearningCareer Growth
Enroll in Pivot Table Course →

Data Analysis & Pivot Tables

16. What is a PivotTable used for?






17. Which feature allows you to get unique values from a range (Excel 365 and later)?






18. Which function filters a range based on criteria (dynamic arrays)?






19. In a PivotTable, where would you place a field to use it as categories (rows)?






20. What does the SLICER provide when used with PivotTables?






Charts & Visualization

21. Which chart type is best for showing trends over time?






22. Which chart type is best to show parts of a whole?






23. How do you add data labels to a chart?






24. Which chart is best to show distribution of a single numeric variable?






25. Which feature lets you create a chart that updates automatically when source data changes?






Want to Learn Everything About Microsoft Excel?

Start Your Learning Journey With our Online Trainings

Core SkillsHands-on LearningCareer Growth
Enroll in Excel with AI Course →

Formatting & Data Cleaning

26. What does the TRIM function do?






27. Which feature highlights cells based on rules (e.g., greater than)?






28. What does Text to Columns do?






29. How do you freeze the top row so it stays visible while scrolling?






30. Which command removes duplicate rows from a selected range?






Data Validation & Protection

31. What does Data Validation allow you to do?






32. Which option helps protect a worksheet from edits by others?






33. What is a common use for data validation drop-down lists?






34. What does sheet protection commonly allow you to do while preventing others from editing?






35. What Excel feature can notify you if someone changes a shared workbook?






Shortcuts & Productivity

36. Which shortcut edits the active cell?






37. Which shortcut quickly selects an entire column?






38. What does Ctrl+; (semicolon) insert?






39. Which feature fills values automatically based on patterns (e.g., months)?






40. Which feature guesses and fills values based on examples you provide (like splitting names)?






Want to Learn Everything About Microsoft Excel?

Start Your Learning Journey With our Online Trainings

Core SkillsHands-on LearningCareer Growth
Enroll in Excel Formula Course →

Advanced: Power Query, Macros & Collaboration

41. What is Power Query primarily used for in Excel?






42. Which language is used to write Excel macros?






43. Which feature automates repetitive tasks by recording keystrokes and actions?






44. What is Power Pivot used for?






45. Which file type stores recorded macros when saving an Excel workbook?






46. Which feature lets multiple users work on the same workbook at the same time (cloud-enabled)?






47. Which DAX function returns filtered values in Power Pivot / Power BI?






48. What does the Watch Window help you do?






49. Which feature helps combine data from multiple sheets or sources into one query?






50. What does the Goal Seek feature do?






XLOOKUP & Modern Lookup Functions

51. Which modern Excel function is designed to replace VLOOKUP in many cases?






52. What advantage does XLOOKUP have over VLOOKUP?






53. Which function is commonly paired with INDEX for flexible lookups?






54. Which function can return the relative position of a value in a range?






55. You need to search for an employee ID and return the department name from another column. Which function is most suitable?






56. Which argument in XLOOKUP helps define a custom message if no match is found?






57. Which lookup function can search from bottom to top?






58. Which Excel function is best for returning multiple matching results dynamically?






59. Which function can combine lookup and exact match capabilities in a single formula?






60. Which lookup function works horizontally across rows?






Dynamic Array Functions

61. Which function automatically spills unique values into adjacent cells?






62. Which function sorts a range dynamically in Excel 365?






63. What does the #SPILL! error usually indicate?






64. Which function creates sequential numbers automatically?






65. Which function generates random numbers in a dynamic array?






66. Which function filters rows based on conditions dynamically?






67. Which function sorts data based on another range or column?






68. Which symbol is commonly used to reference an entire spilled array?






69. Which modern Excel feature allows formulas to return multiple values automatically?






70. Which function converts rows into columns or vice versa?






Excel Dashboards & Reporting

71. Which Excel feature is commonly used to create interactive dashboard filters?






72. Which chart type is commonly used in dashboards to display KPIs quickly?






73. What is the purpose of Sparklines in Excel?






74. Which Excel feature helps summarize large business datasets visually?






75. Which feature allows a dashboard chart to update automatically with new data?






76. Which Excel feature is useful for creating drop-down dashboard selectors?






77. What is a KPI in Excel reporting?






78. Which dashboard component helps users filter reports by dates interactively?






79. Which chart is commonly used to compare sales across categories?






80. Which Excel feature allows dashboards to connect multiple PivotTables together?






Advanced Power Query

81. What is the main purpose of Power Query in Excel?






82. Which Power Query operation combines tables vertically?






83. Which Power Query feature combines tables using matching columns?






84. Which Power Query action converts columns into attribute-value pairs?






85. Which button refreshes imported Power Query data?






86. Which language powers Power Query formulas and transformations?






87. Which Power Query feature removes duplicate rows during data cleaning?






88. What does “Close & Load” do in Power Query?






89. Which Power Query feature tracks all transformation steps?






90. Which business process is Power Query often associated with?






Excel AI & Copilot Features

91. What is the primary purpose of Microsoft Copilot in Excel?






92. Which Excel AI feature can automatically suggest charts and trends from your data?






93. Which task can Excel Copilot help automate?






94. Which type of prompt can be used with Excel Copilot?






95. Which Excel AI feature helps identify insights without manually building formulas?






96. You want Excel to summarize monthly sales performance automatically. Which feature is most useful?






97. Which benefit does AI-powered Excel analysis provide?






98. Which Excel feature can suggest PivotTables automatically?






99. Which Microsoft subscription is commonly required for Copilot features in Excel?






100. Which Excel AI capability helps explain trends and anomalies in data?






Financial & Business Functions

101. Which Excel function calculates loan payments?






102. Which financial function calculates the future value of an investment?






103. Which function calculates the present value of future cash flows?






104. Which function helps calculate the profitability of an investment using cash flows?






105. Which function calculates net present value in Excel?






106. Which Excel feature is commonly used for budgeting and forecasting?






107. Which function returns the interest rate per period for a loan or investment?






108. Which Excel tool helps test different financial scenarios quickly?






109. Which Excel function is useful for compound growth calculations?






110. Which Excel feature is commonly used by finance teams to optimize calculations and targets?






Collaboration, Security & Productivity

111. Which Excel feature allows multiple users to edit the same workbook simultaneously?






112. Which cloud platform is commonly used for Excel file collaboration?






113. Which Excel feature lets users view previous versions of a workbook?






114. What is the purpose of “Comments” in Excel?






115. Which Excel feature automatically saves changes to cloud-based files?






116. Which keyboard shortcut is commonly used to save a workbook quickly?






117. Which Excel feature allows users to recover unsaved workbooks?






118. Which permission setting prevents users from editing an Excel workbook?






119. Which Excel feature helps trace formula relationships and errors?






120. You want to protect formulas while still allowing users to enter data in certain cells. Which Excel feature should you use?






Excel Logical & Lookup Functions

121. Which Excel function returns a value based on a logical condition?






122. Which function returns a value if multiple conditions are TRUE?






123. Which function is commonly used to return a custom value instead of an error?






124. Which function returns the position of a lookup value within a range?






125. Which function returns the value at a specified row and column within a range?






126. Which modern Excel function can replace both VLOOKUP and HLOOKUP?






127. Which function returns multiple matching records dynamically?






128. Which function returns only unique values from a range?






129. Which function sorts a dynamic array automatically?






130. Which function combines FILTER() with sorting in a single formula?






Excel What-If Analysis & Forecasting

131. Which Excel feature helps determine the input needed to achieve a desired result?






132. Which Excel tool is used to optimize multiple variables while applying constraints?






133. Which What-If Analysis feature allows you to compare multiple sets of input values?






134. Which Excel feature creates a table showing results for different input values automatically?






135. Which function is commonly used to estimate future values based on historical data?






136. Which chart type is most commonly used to display trends over time?






137. Which Excel feature can automatically add a trendline to a chart?






138. Which Excel feature predicts future values using historical trends?






139. Which Excel feature is best for comparing different budgeting scenarios?






140. Which Excel tool would you use to maximize profit while considering multiple business constraints?






Excel Formula Auditing & Error Handling

141. Which Excel feature helps identify which cells are referenced by the active formula?






142. Which Formula Auditing tool shows all formulas that depend on the selected cell?






143. Which Excel tool lets you evaluate a complex formula one step at a time?






144. Which Excel feature monitors the values of important cells while working in another worksheet?






145. Which error appears when a formula tries to divide a number by zero?






146. Which Excel error indicates an invalid cell reference?






147. Which function checks whether a cell contains an error value?






148. Which error occurs when Excel cannot find a lookup value?






149. Which function is commonly used to return a custom value when a lookup function cannot find a match?






150. Which tab on the Excel ribbon contains most Formula Auditing tools?






151. What is the main difference between a process and a thread?






152. Which system call is commonly used to create a new process in Unix-like operating systems?






153. What is the purpose of the exec() family of system calls?






154. What is a zombie process?






155. What is a context switch?






156. Which scheduling algorithm assigns each ready process a fixed time quantum?






157. Which scheduling algorithm can suffer from the convoy effect?






158. What is starvation in CPU scheduling?






159. Which technique is commonly used to reduce starvation in priority scheduling?






160. What is the main goal of CPU scheduling?






161. What is a system call?






162. Why are system calls required instead of allowing applications to directly access hardware?






163. Which CPU mode normally executes privileged kernel instructions?






164. What happens when a user application performs a system call?






165. What is an interrupt?






166. What is a trap in operating systems?






167. What is copy-on-write commonly used for after fork()?






168. What is a page fault?






169. Which page replacement algorithm replaces the page that has not been used for the longest time?






170. What is thrashing?






171. What is a Translation Lookaside Buffer (TLB)?






172. What is a major benefit of huge pages?






173. What does NUMA stand for?






174. Why is NUMA awareness important for high-performance applications?






175. What is memory fragmentation?






176. What is internal fragmentation?






177. Which IPC mechanism allows multiple processes to access a common memory region?






178. Which IPC mechanism provides a unidirectional communication channel commonly used between related processes?






179. What is a semaphore primarily used for?






180. What is a mutex?






181. Which condition is one of the four necessary conditions for deadlock?






182. Which algorithm is commonly associated with deadlock avoidance?






183. What is priority inversion?






184. Which technique can mitigate priority inversion?






185. What is a race condition?






186. What is a critical section?






187. What is a monitor in operating systems?






188. What is the main purpose of a condition variable?






189. What is the main purpose of a file descriptor in Unix-like systems?






190. Which file descriptor normally represents standard error in Unix-like systems?






191. What is a file system primarily responsible for?






192. Which Linux file system is commonly used for general-purpose Linux installations?






193. What is journaling in a file system?






194. Which Linux command is commonly used to inspect running processes?






195. What does the Linux top command primarily provide?






196. Which Linux command is commonly used to trace system calls made by a process?






197. What does the Linux /proc filesystem primarily expose?






198. What is systemd primarily used for on many modern Linux distributions?






199. What is virtualization?






200. Which type of hypervisor runs directly on physical hardware?






201. What is the key operating system difference between containers and virtual machines?






202. Which Linux kernel feature provides process and resource isolation for containers?






203. What is the primary purpose of Linux namespaces?






204. Which Linux namespace isolates process IDs?






205. What is the main purpose of Linux cgroups?






206. Which resource can cgroups control or account for?






207. Which technology is commonly used to restrict the system calls a Linux process can make?






208. What are Linux capabilities used for?






209. Which Linux security mechanism is commonly used for mandatory access control?






210. What is AppArmor primarily used for?






211. What is eBPF?






212. Which area is eBPF widely used for in modern Linux systems?






213. What is the primary advantage of eBPF compared with modifying and rebuilding the kernel for every new tracing or networking feature?






214. What is io_uring designed to improve?






215. Which model does io_uring commonly use to communicate I/O requests and completions?






216. Why can io_uring improve I/O performance?






217. What is the primary purpose of a kernel scheduler?






218. What is CPU affinity?






219. Why can CPU affinity improve performance in some workloads?






220. What is load balancing in a multicore scheduler?






221. What is a preemptive scheduler?






222. What is a real-time operating system designed to prioritize?






223. Which type of real-time system has strict deadlines where missing one may be considered a system failure?






224. Which scheduling algorithm is commonly used for hard real-time systems when tasks have deadlines?






225. What is a kernel module?






226. Why are device drivers important in an operating system?






227. What is DMA?






228. What is the primary benefit of DMA for I/O devices?






229. What is an IOMMU used for?






230. What is a kernel panic?






231. What is the main purpose of an operating system's security model?






232. What is privilege escalation?






233. What is the principle of least privilege?






234. What is ASLR designed to protect against?






235. What is DEP or NX protection intended to prevent?






236. What is a buffer overflow?






237. Which operating system feature helps isolate applications by separating their address spaces?






238. What is a segmentation fault generally associated with?






239. What is swap space?






240. Why can excessive swapping negatively affect performance?






241. What is the purpose of a page table?






242. What is demand paging?






243. What is the working set of a process?






244. What is memory-mapped I/O?






245. What is a memory barrier used for in concurrent programming?






246. What is a spinlock?






247. When is a spinlock generally more appropriate than a blocking mutex?






248. What is the purpose of atomic operations?






249. What is the main goal of kernel preemption?






250. What is the main purpose of a cache-aware CPU scheduler?






You Can Also Check:

1. Best Excel Interview Questions and Answers
2. Excel Keywords Shortcuts: A Complete Cheat Sheet
3. Excel Cheat Sheet
4. Top Data Structures MCQs With Answers
5. Top Excel Formulas Everyone Need to Know
6. XLOOKUP vs VLOOKUP
7. How to Subtract in Excel?
Want to learn more? Keep reading:
Ready to go from reading to doing?
About the Author
Vinay Agarwal | igmGuru
About the Author

Vinay Agarwal is a certified Microsoft technology professional with experience spanning Azure infrastructure, Microsoft 365, and productivity platforms. He works on cloud administration, identity management, and Microsoft certification pathways. Vinay follows Microsoft product and certification updates closely and helps prepare IT professionals for industry-recognized credentials.

Drop Us a Query
Fields marked * are mandatory
Recent Post
×

Your Shopping Cart


Your shopping cart is empty.