Online Access Free MO-211 Practice Test

Which chart would you use to display quantitative data through their quartiles and outliers?

• A.Area chart
• B.Scatter chart
• C.Box & Whisker chart
• D.Combo chart

To configure data validation rules, navigate to ____ > Data Tools > Data Validation.

• A.Data
• B.View
• C.Insert
• D.Home

What is the best use of the LET() function in Excel formulas?

• A.To handle errors in calculations
• B.To define variables for use within the formula
• C.To automate tasks through macros
• D.To execute conditional logic

What should you use to create dynamic, interactive filters for reports or dashboards?

• A.Sparklines
• B.Hyperlinks
• C.Data bars
• D.Slicers

What function fills cells based on patterns from adjacent cells?

• A.Flash Fill
• B.RANDARRAY
• C.AutoFill
• D.Data Validation