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

Using simple linear regression only

Answer

Using moving averages

Answer

Using polynomial curve fitting

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

Grouping worksheets together

Answer

Merging cells in a range

Answer

Linking workbooks together

Question 3

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

Accepted Answer

Consolidate tool

Answer

CONCATENATE function

Answer

Merge & Center

Answer

Group feature

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

It uses only built-in PivotTable functions

Answer

It can only perform SUM calculations

Answer

It references cells outside the PivotTable

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

They execute faster than cell references

Answer

They work only with VLOOKUP

Answer

They prevent formula errors entirely

Question 6

In Power Query, what does 'Append Queries' do?

Accepted Answer

Stacks tables vertically by adding rows from one below another

Answer

Joins tables side by side based on matching columns

Answer

Creates a new calculated column

Answer

Filters rows based on a condition