Microsoft Excel Advanced Data Analysis Tools 2

Question 1

Which Excel tool allows you to test multiple input values and see their effect on formula results simultaneously?

Accepted Answer

Data Table

Answer

Goal Seek

Answer

Scenario Manager

Answer

Solver

Question 2

What does the Analysis ToolPak add-in provide in Excel?

Accepted Answer

Statistical and engineering analysis functions

Answer

Additional chart types

Answer

Database connectivity tools

Answer

Macro recording capabilities

Question 3

In Excel's Solver tool, what is a 'constraint'?

Accepted Answer

A limitation or requirement that the solution must satisfy

Answer

The formula you want to maximize

Answer

The cell containing the objective function

Answer

A type of circular reference

Question 4

What is the primary purpose of Excel's Power Pivot feature?

Accepted Answer

Working with large datasets from multiple sources using a data model

Answer

Creating pivot charts with animations

Answer

Automatically formatting pivot tables

Answer

Exporting pivot tables to PDF

Question 5

Which function in Excel performs a two-dimensional lookup by matching both a row and column value?

Accepted Answer

INDEX/MATCH combination

Answer

VLOOKUP

Answer

HLOOKUP

Answer

LOOKUP

Question 6

What does the 'What-If Analysis' group in Excel's Data tab include?

Accepted Answer

Scenario Manager, Goal Seek, and Data Table

Answer

Only Goal Seek

Answer

Solver and Data Table only

Answer

Forecast Sheet and Scenario Manager only