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

Data Tables allow you to substitute multiple input values into formulas and display all results in a table format.

Question 2

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

Accepted Answer

Statistical and engineering analysis functions

Answer

The Analysis ToolPak provides data analysis tools for statistical and engineering analysis, including regression, histograms, and ANOVA.

Question 3

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

Accepted Answer

A limitation or requirement that the solution must satisfy

Answer

Constraints in Solver are conditions that restrict possible solutions, such as requiring a value to be non-negative or within a range.

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

Power Pivot enables you to import millions of rows from multiple data sources, create relationships, and perform advanced calculations using DAX formulas.

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

INDEX combined with two MATCH functions can perform a two-dimensional lookup at the intersection of a matched row and column.

Excel Practice Test

Excel Practice Test

Microsoft Excel Advanced Data Analysis Tools 2