Online Access Free MO-211 Exam Questions

Which actions can be performed on a PivotTable to enhance analysis?
(Choose two)

• A.Insert slicers
• B.Apply Conditional Formatting
• C.Use Data Validation
• D.Group data

Which function generates an array of random numbers?

• A.SUMIF()
• B.IF()
• C.RANDARRAY()
• D.CONCATENATE()

What symbol is used in custom number formats to represent currency?

• A.&
• B.0
• C.$
• D.#

How can you ensure that a range of cells highlights in red if any cell is below 50?

• A.Use a data bar formatting style
• B.Use a simple color rule for less than
• C.Apply an advanced custom formula
• D.Implement a threshold formula

What functionality does grouping in PivotTables offer?

• A.It simplifies data entry.
• B.It increases data processing speed.
• C.It enhances data security by limiting access.
• D.It allows for detailed data analysis and subtotals.