Test your knowledge with this challenging Advanced Excel MCQ. Put your thinking cap on and see how much you know about Microsoft Excel.
Advanced Excel MCQ
1. What function would you use to find the standard deviation of a set of numbers in Excel?
A) =AVERAGE()
B) =STDEV()
C) =SUM()
D) =MAX()
Answer: B) =STDEV()
2. In Excel, what does the VLOOKUP function do?
A) Looks up values vertically in a table
B) Calculates the variance of a range of cells
C) Finds the maximum value in a range of cells
D) Adds up values in a range of cells
Answer: A) Looks up values vertically in a table
3. Which Excel feature allows you to automate a series of actions by recording them as a macro?
A) AutoFill
B) PivotTables
C) Conditional Formatting
D) Macro Recorder
Answer: D) Macro Recorder
4. Which of the following is NOT a valid error type in Excel?
A) #DIV/0!
B) #VALUE!
C) #SORT!
D) #N/A
Answer: C) #SORT!
Microsoft Office MCQ
These quizzes provide a structured approach to learning, allowing you to assess your understanding of various features, shortcuts, and functionalities. Whether you’re a beginner aiming to familiarize yourself with the basics or an advanced user seeking to refine your skills, practicing MCQs offers a dynamic and interactive way to engage with the intricacies of Microsoft Office.
5. What does the function =IFERROR(A1/B1, “Error”) do in Excel?
A) Divides cell A1 by cell B1 and displays “Error” if there’s a divide by zero error
B) Returns “Error” if there’s any error in the formula, otherwise performs the division
C) Checks if cell A1 and cell B1 are both errors, and if true, displays “Error”
D) None of the above
Answer: B) Returns “Error” if there’s any error in the formula, otherwise performs the division
6. Which Excel feature allows you to visually represent data trends over time?
A) Sparklines
B) Data Bars
C) Slicers
D) Goal Seek
Answer: A) Sparklines
7. What does the formula =INDEX($A$1:$A$10, MATCH(B1, $B$1:$B$10, 0)) do?
A) Returns the value in column A corresponding to the value in cell B1
B) Returns the value in column B corresponding to the value in cell A1
C) Returns the first value in column A that matches the value in cell B1
D) None of the above
Answer: A) Returns the value in column A corresponding to the value in cell B1
8. What does the function =TRANSPOSE(A1:C3) do in Excel?
A) Transposes the range A1:C3 into a single column
B) Transposes the range A1:C3 into a single row
C) Transposes the range A1:C3 into a square matrix
D) None of the above
Answer: B) Transposes the range A1:C3 into a single row
9. In Excel, what is the keyboard shortcut to open the Format Cells dialog box?
A) Ctrl + F
B) Alt + F4
C) Ctrl + Shift + F
D) Ctrl + 1
Answer: D) Ctrl + 1
10. Which function in Excel would you use to calculate the internal rate of return (IRR) of a series of cash flows?
A) =IRR()
B) =NPV()
C) =PV()
D) =RATE()
Answer: A) =IRR()