Microsoft Excel Advanced Data Analysis Tools 3

Question 1

How does Excel's Forecast Sheet feature generate predictions?

Accepted Answer

Using exponential smoothing algorithms (ETS)

Answer

Excel's Forecast Sheet uses the AAA version of the ETS algorithm to detect seasonality and generate predictions with confidence intervals.

Question 2

What is the purpose of Excel's 'Group' feature in the Data tab?

Accepted Answer

Creating collapsible outline levels for rows or columns

Answer

The Group feature creates outline levels allowing you to collapse and expand rows or columns for easier navigation.

Question 3

Which Excel feature combines data from multiple ranges into a single summary?

Accepted Answer

Consolidate tool

Answer

The Consolidate tool on the Data tab combines data from multiple ranges using functions like SUM or AVERAGE.

Question 4

What distinguishes a 'calculated field' in a PivotTable?

Accepted Answer

It creates a new field using a custom formula based on other PivotTable fields

Answer

A calculated field uses a formula based on other PivotTable fields to add metrics that don't exist in the source data.

Question 5

What is the advantage of using structured references in Excel Tables?

Accepted Answer

They automatically adjust when columns are renamed or rows are added

Answer

Structured references use table and column names instead of cell addresses, automatically adjusting when the table structure changes.

Excel Practice Test