Microsoft Advance Excel Certification exam answers 2026: This page lists all 100 questions of the official Microsoft Advance Excel Certification exam by Itronix Solutions, each with its four answer options and the correct answer highlighted in green. Use it to revise every topic before you attempt the test and earn your verifiable certificate.
About this certification: Advanced Excel skills include the ability to produce graphs and tables, use spreadsheets efficiently, and perform calculations and automation.
| Certification | Microsoft Advance Excel Certification |
| Provider | Itronix Solutions |
| Category | Office & Computer Basics |
| Total questions | 100 multiple-choice questions |
| Marks | 1 mark per question (100 marks) |
| Passing score | 80% (80 out of 100) |
| Retake | Available if you do not pass |
| Certificate | Verifiable online certificate |
Take the exam: Microsoft Advance Excel Certification on Itronix Solutions. See every other Itronix exam in our complete list of Itronix certification answers.
Microsoft Advance Excel Exam Questions and Answers
Questions 1 to 25
1. What is the shortcut key to display the “Format Cells” dialog box in Excel?
Correct answer: A. Ctrl+1
2. Which of the following format you can decide to apply or not in AutoFormat dialog box?
Correct answer: D. All of above
3. In MS-Excel which functions will calculate the number of workdays between 6/9/2013 and 8/12/2013
Correct answer: B. Weekday
4. In MS-Excel data marker on a chart are linked to data points in a worksheet, therefore
Correct answer: D. Both (b) & (c)
5. MS Excel is a ________.
Correct answer: C. Spreadsheet software
6. What function displays row data in a column or column data in a row?
Correct answer: D. Transpose
7. Hounding errors can occur
Correct answer: A. When you use multiplication, division or exponentiation in a formula
8. In Excel got functions? No? You need the insert function dialog box. How do you get it?
Correct answer: B. Click the insert menu and then click function
9. When you insert an Excel file into a Word document, the data are ______.
Correct answer: A. Placed in a word table
10. Except for the …… function, a formula with a logical function shows the word “TRUE” or “FALSE” as a result.
Correct answer: B. IF
11. Macros are “run” or executed from the ….. Menu.
Correct answer: C. Tools
12. In Excel two common wildcard characters that Excel recognizes are
Correct answer: A. * and ?
13. Which of the following is not What IF analysis tool in Excel?
Correct answer: C. Macros
14. Each excel file is called a workbook because
Correct answer: B. It can contain many sheets including worksheets and chart sheets
15. Which key do you press to check spelling?
Correct answer: C. F7
16. How are data organized in a spreadsheet?
Correct answer: C. Rows and columns
17. You can print only an embedded chart by
Correct answer: D. a and c
18. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?
Correct answer: B. On the file menu, click print, and then click selection under print what
19. How can you delete a record?
Correct answer: B. Select Data > Form from the menu to open the Data Form dialog box, find the record and Click the Delete button
20. The cell labeled 23. 54 the cell labeled F5 refers to
Correct answer: B. column F row 5
21. Which function adds a range of cells?
Correct answer: B. SUM
22. Which function returns the average of a range?
Correct answer: C. AVERAGE
23. COUNT counts cells that contain:
Correct answer: B. Numbers
24. COUNTA counts cells that are:
Correct answer: A. Not empty
25. COUNTBLANK counts:
Correct answer: D. Empty cells
Questions 26 to 50
26. COUNTIF counts cells that:
Correct answer: D. Meet a single condition
27. SUMIFS adds values that:
Correct answer: B. Meet multiple conditions
28. AVERAGEIF returns the average of cells that:
Correct answer: A. Meet a condition
29. VLOOKUP searches for a value in:
Correct answer: B. The first column of a table and returns a value from the same row
30. In VLOOKUP, FALSE as the last argument means:
Correct answer: C. Exact match
31. A key limitation of VLOOKUP is that it:
Correct answer: A. Cannot look to the left of the lookup column
32. XLOOKUP improves on VLOOKUP because it can:
Correct answer: B. Look in any direction and defaults to exact match
33. INDEX and MATCH together are used to:
Correct answer: C. Perform flexible lookups
34. MATCH returns:
Correct answer: C. The position of a value in a range
35. HLOOKUP searches:
Correct answer: C. Horizontally across the first row
36. The IF function returns:
Correct answer: D. One value if a condition is true and another if false
37. IFERROR is used to:
Correct answer: B. Return a custom value when a formula results in an error
38. IFS lets you:
Correct answer: B. Test multiple conditions without nesting many IFs
39. AND returns TRUE when:
Correct answer: A. All conditions are true
40. OR returns TRUE when:
Correct answer: B. At least one condition is true
41. CONCAT (or the & operator) is used to:
Correct answer: A. Join text from multiple cells
42. TEXTJOIN differs from CONCAT because it:
Correct answer: A. Can add a delimiter and ignore empty cells
43. LEFT returns:
Correct answer: D. Characters from the start of a text string
44. RIGHT returns:
Correct answer: B. Characters from the end of a text string
45. MID returns:
Correct answer: C. Characters from the middle of a text string at a given position
46. LEN returns:
Correct answer: A. The number of characters in a text string
47. TRIM removes:
Correct answer: D. Extra spaces from text
48. UPPER converts text to:
Correct answer: A. Capital letters
49. PROPER converts text so that:
Correct answer: A. Each word starts with a capital letter
50. TODAY returns:
Correct answer: D. The current date
Questions 51 to 75
51. NOW returns:
Correct answer: B. The current date and time
52. DATEDIF can calculate:
Correct answer: D. The difference between two dates in days, months or years
53. NETWORKDAYS returns:
Correct answer: D. The number of working days between two dates
54. ROUND(3.456, 2) returns:
Correct answer: B. 3.46
55. Absolute references are written with:
Correct answer: D. Dollar signs, like $A$1
56. A mixed reference like $A1 locks:
Correct answer: C. The column only
57. Pressing F4 while editing a reference:
Correct answer: B. Cycles through absolute and relative reference types
58. A PivotTable is used to:
Correct answer: A. Summarise and analyse large datasets quickly
59. In a PivotTable, the Values area usually contains:
Correct answer: D. Numbers to sum, count or average
60. A slicer in Excel is used to:
Correct answer: B. Filter PivotTables or tables visually
61. A PivotChart is:
Correct answer: A. A chart linked to a PivotTable
62. Converting a range to an Excel Table (Ctrl+T) gives:
Correct answer: C. Structured references, filters and automatic formatting
63. Conditional formatting is used to:
Correct answer: A. Format cells automatically based on rules
64. Data validation is used to:
Correct answer: D. Restrict what users can enter in cells
65. A drop-down list in a cell is created with:
Correct answer: D. Data validation
66. Freeze Panes is used to:
Correct answer: D. Keep rows or columns visible while scrolling
67. Remove Duplicates is found under:
Correct answer: C. The Data tab
68. Text to Columns is used to:
Correct answer: C. Split text in one column into multiple columns
69. Flash Fill (Ctrl+E) is used to:
Correct answer: C. Automatically fill values based on a detected pattern
70. Goal Seek is used to:
Correct answer: B. Find the input needed to reach a target result
71. Scenario Manager is used to:
Correct answer: D. Compare different sets of input values
72. Solver is an add-in used for:
Correct answer: A. Optimisation problems with constraints
73. Power Query is used to:
Correct answer: C. Import, clean and transform data
74. Power Pivot is used to:
Correct answer: B. Build data models and handle large related datasets
75. A macro in Excel is:
Correct answer: C. A recorded or written set of actions that can be replayed
Questions 76 to 100
76. Macros are written in:
Correct answer: D. VBA (Visual Basic for Applications)
77. A macro-enabled workbook uses the extension:
Correct answer: B. .xlsm
78. The #N/A error usually means:
Correct answer: A. A lookup value was not found
79. The #DIV/0! error means:
Correct answer: C. A formula is dividing by zero
80. The #REF! error means:
Correct answer: A. A formula refers to an invalid or deleted cell
81. The #VALUE! error usually means:
Correct answer: C. A wrong type of argument was used
82. The #NAME? error usually means:
Correct answer: C. Excel does not recognise a function or name
83. Ctrl+Shift+L in Excel:
Correct answer: B. Turns filters on or off
84. Ctrl+Arrow key moves to:
Correct answer: D. The edge of the current data region
85. Alt+= inserts:
Correct answer: C. An AutoSum formula
86. Ctrl+; enters:
Correct answer: C. The current date
87. Named ranges are useful because they:
Correct answer: B. Make formulas easier to read and maintain
88. FILTER is a dynamic array function that:
Correct answer: B. Returns rows that meet given criteria
89. SORT is a dynamic array function that:
Correct answer: D. Returns a sorted version of a range
90. UNIQUE returns:
Correct answer: A. A list of distinct values from a range
91. A spill error (#SPILL!) happens when:
Correct answer: B. A dynamic array result is blocked by non-empty cells
92. Sparklines are:
Correct answer: B. Tiny charts inside a single cell
93. A combo chart combines:
Correct answer: B. Two or more chart types, such as column and line
94. Protecting a worksheet can prevent users from:
Correct answer: C. Editing locked cells
95. Track Changes or comments in Excel help with:
Correct answer: B. Collaboration and review
96. What-If Analysis tools include:
Correct answer: D. Goal Seek, Scenario Manager and Data Tables
97. A circular reference occurs when:
Correct answer: A. A formula refers back to its own cell directly or indirectly
98. To show formulas instead of results you can press:
Correct answer: C. Ctrl+` (grave accent)
99. Excel is best described as:
Correct answer: A. A spreadsheet application for calculation, analysis and visualisation
100. The PMT function calculates:
Correct answer: A. The periodic payment for a loan
How to Pass the Microsoft Advance Excel Exam
- Read every question carefully; most options look similar, so look for the most precise answer.
- Revise the questions above topic by topic rather than memorising letters, because option order can change in the live test.
- You need 80 correct answers out of 100 to pass, so aim to understand at least 85 to stay safe.
- If you do not clear it on the first attempt, review the questions you missed and use the retake option.
Frequently Asked Questions
How many questions are in the Microsoft Advance Excel Certification exam?
The exam has 100 multiple-choice questions, each worth 1 mark.
What is the passing score for the Microsoft Advance Excel Certification?
You need at least 80% (80 out of 100) to pass and receive the certificate.
Can I retake the Microsoft Advance Excel Certification exam?
Yes. If you score below 80%, you can retry the test after reviewing the topics.
Is the Itronix certificate verifiable?
Yes. Every certificate issued by Itronix Solutions has a unique ID that can be checked on the Itronix verify-certificate page.
More Office & Computer Basics Certification Answers
- Basics of Computer Certification Exam Answers
- Communication Skills Professional Certification Exam Answers
- Data entry Operator Certification Exam Answers
- Google Workspace Professional Certification Exam Answers
- Health and Nutrition Certification Exam Answers
- Interview Preparation Professional Certification Exam Answers
- Microsoft Excel VBA Certification Exam Answers
- Microsoft Office Specialist (MOS) Certification Exam Answers
Disclaimer: These answers are provided for learning and revision. Questions and answers are checked regularly; if you find a mistake, let us know in the comments.
Priya Dogra – Free Certifications, Exam Answers & Career Guides Free certification exam answers, courses, scholarships and career guides for learners worldwide
One comment
Pingback: Data entry Operator Certification Exam Answers 2026 (All 100 Questions) - Priya Dogra