Microsoft Excel Expert - Microsoft 365 Apps - MO-211 Exam Practice Test
Arrange the steps to enable workbook version control.
1. Go to File > Info
2. Click on Version History
3. Save the workbook
4. Access previous versions
1. Go to File > Info
2. Click on Version History
3. Save the workbook
4. Access previous versions
Correct Answer: B
Vote an answer
Grouping data in Excel can be undone by choosing ______.
Correct Answer: B
Vote an answer
To copy a macro between two workbooks, you must first open the ____.
Correct Answer: C
Vote an answer
What function would you use to look up data based on a single criterion across multiple sheets?
Correct Answer: C
Vote an answer
Arrange the steps to restrict editing to specific ranges.
1. Select the range you want to protect
2. Go to Review > Allow Users to Edit Ranges
3. Set the password for the range
4. Protect the worksheet
1. Select the range you want to protect
2. Go to Review > Allow Users to Edit Ranges
3. Set the password for the range
4. Protect the worksheet
Correct Answer: B
Vote an answer
Which actions can be performed on a PivotTable to enhance analysis?
(Choose two)
(Choose two)
Correct Answer: B,C
Vote an answer
How would you use the WATCH WINDOW to monitor changes in value and formula?
Correct Answer: C
Vote an answer
Which of these actions can NOT be performed once a worksheet is protected?
Correct Answer: D
Vote an answer
How would you summarize multiple ranges of data using Excel features?
Correct Answer: C
Vote an answer
To remove duplicate records from a dataset, use ____ > Remove Duplicates.
Correct Answer: C
Vote an answer
Which option allows you to enable macros in a workbook?
Correct Answer: C
Vote an answer
When might you need to enable macros in a workbook that you received via email?
Correct Answer: A
Vote an answer
Which setting must be enabled to use macros in an Excel workbook?
Correct Answer: D
Vote an answer
To manage workbook versions efficiently, which feature should be activated?
Correct Answer: A
Vote an answer
To find the sum of values based on multiple conditions, which function is most appropriate?
Correct Answer: C
Vote an answer