Advanced Data Analysis Tools Flashcards
6 cards from real Microsoft Excel practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 Advanced Data Analysis Tools flashcards as text
How does Excel's Forecast Sheet feature generate predictions?
Answer: Using exponential smoothing algorithms (ETS)
Excel's Forecast Sheet uses the AAA version of the ETS algorithm to detect seasonality and generate predictions with confidence intervals.
What is the purpose of Excel's 'Group' feature in the Data tab?
Answer: Creating collapsible outline levels for rows or columns
The Group feature creates outline levels allowing you to collapse and expand rows or columns for easier navigation.
Which Excel feature combines data from multiple ranges into a single summary?
Answer: Consolidate tool
The Consolidate tool on the Data tab combines data from multiple ranges using functions like SUM or AVERAGE.
What distinguishes a 'calculated field' in a PivotTable?
Answer: It creates a new field using a custom formula based on other PivotTable fields
A calculated field uses a formula based on other PivotTable fields to add metrics that don't exist in the source data.
What is the advantage of using structured references in Excel Tables?
Answer: They automatically adjust when columns are renamed or rows are added
Structured references use table and column names instead of cell addresses, automatically adjusting when the table structure changes.
In Power Query, what does 'Append Queries' do?
Answer: Stacks tables vertically by adding rows from one below another
Append Queries stacks tables vertically, combining all rows into a single result set, similar to SQL UNION.