Get Started: MO-211 Exam [2026] Dumps Microsoft PDF Questions
MO-211 Premium Exam Engine pdf Download
NEW QUESTION # 37
To add a calculated field to a PivotTable, navigate to ____ > Calculated Field.
- A. PivotTable Tools > Analyze
- B. View > Formulas
- C. Home > Styles
- D. Data > Subtotal
Answer: A
NEW QUESTION # 38
Conditional formatting that changes cell color based on a percentage is set using the _____ option.
- A. Cell Rules
- B. Data Bars
- C. Color Scales
- D. Icon Sets
Answer: C
NEW QUESTION # 39
If you want to highlight cells that are not equal to 20 using conditional formatting, which formula would you use?
- A. =A1<>20
- B. !=20
- C. <>"20"
- D. A1!=20
Answer: A
NEW QUESTION # 40
What does protecting worksheet and cell ranges NOT prevent?
- A. Formatting cells
- B. Adding new sheets
- C. Viewing hidden cells
- D. Editing cell contents
Answer: B
NEW QUESTION # 41
You need to restrict users from adding or deleting worksheets but allow them to edit cell contents. What should you do?
- A. Protect Workbook
- B. Protect Sheet
- C. Use Conditional Formatting
- D. Allow Edit Ranges
Answer: A
NEW QUESTION # 42
Which functions would you use to perform a what-if analysis?
(Choose Two)
- A. Goal Seek
- B. Solver
- C. Scenario Manager
- D. Data Table
Answer: B,C
NEW QUESTION # 43
What tool allows you to check why your Excel formula isn't working as expected by showing arrows that point to cells referenced in the formula?
- A. Error Checking
- B. Watch Window
- C. Trace Precedents
- D. Formula Auditing
Answer: C
NEW QUESTION # 44
What is the main advantage of using a Box & Whisker chart in data analysis?
- A. It identifies changes over time
- B. It shows frequency distributions
- C. It summarizes variation in large datasets
- D. It displays hierarchical data
Answer: C
NEW QUESTION # 45
How can you make a cell turn green if the value is greater than 100 using conditional formatting?
- A. Use a custom formula
- B. Set a simple rule for greater than 100
- C. Apply a green fill to all cells then set exceptions for those not greater than 100
- D. Conditional formatting cannot achieve this
Answer: B
NEW QUESTION # 46
How can you modify a PivotChart to better present data trends?
- A. Change the chart style
- B. Apply a complex formula
- C. Insert a slicer
- D. Use a secondary axis
Answer: A
NEW QUESTION # 47
Arrange the steps to configure a rule that restricts data entry to a specific range of dates.
1. Select the cell range
2. Select Date from the Allow list
3. Go to Data > Data Validation
4. Set the start and end date
- A. 1, 2, 3, 4
- B. 4, 1, 2, 3
- C. 2, 3, 4, 1
- D. 1, 3, 2, 4
Answer: D
NEW QUESTION # 48
To create a PivotChart based on a PivotTable, go to ____ > PivotChart.
- A. PivotTable Tools > Analyze
- B. View > Charts
- C. Data > Consolidate
- D. Home > Charts
Answer: A
NEW QUESTION # 49
What is the purpose of the 'Track Changes' feature in Excel?
- A. To revert the workbook to a previous version
- B. To automatically save periodic copies of the workbook
- C. To compare two different workbooks
- D. To monitor and list changes made by different users
Answer: D
NEW QUESTION # 50
Which tool in Excel is used to quickly remove all duplicate records from a dataset?
- A. Conditional Formatting
- B. Remove Duplicates
- C. Data Validation
- D. Flash Fill
Answer: B
NEW QUESTION # 51
When sharing a workbook for collaboration, what should be done to prevent others from viewing sensitive data?
- A. All of the above
- B. Encrypt the workbook
- C. Protect the workbook with a password
- D. Hide sensitive sheets
Answer: A
NEW QUESTION # 52
......
Pass Your Microsoft Exam with MO-211 Exam Dumps: https://www.practicetorrent.com/MO-211-practice-exam-torrent.html
Verified MO-211 Bundle Real Exam Dumps PDF: https://drive.google.com/open?id=1VyZn7HB6DtBSLcwgrXmogkJMP120vctW