Free Microsoft MO-211 Exam Dumps Questions & Answers

What option enables you to reference data in another workbook?

• A.  IMPORT
• B.  External Reference Syntax
• C.  CONCATENATE
• D.  INDIRECT

Which functions would you use to perform a what-if analysis?
(Choose Two)

• A.  Scenario Manager
• B.  Data Table
• C.  Solver
• D.  Goal Seek

What is the main advantage of using a Box & Whisker chart in data analysis?

• A.  It displays hierarchical data
• B.  It identifies changes over time
• C.  It summarizes variation in large datasets
• D.  It shows frequency distributions

What can you create in Excel to quickly filter PivotTables, PivotCharts, and CUBE functions?

• A.  Data validation rules
• B.  Slicers
• C.  Conditional formatting
• D.  Calculated fields

The formula =RANDARRAY(5) generates ______ of random numbers.

• A.  a single row
• B.  a single column
• C.  five columns
• D.  an array