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.
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- store.certiport.com — Fees, retake fee · verified Nov 2026
- certiport.pearsonvue.com — Renewal, score validity, score release, exam format · verified Nov 2026
- learn.microsoft.com — Test delivery, time limit, eligibility · verified Nov 2026