WGU D552 | 150 Original Practice Questions | Excel Scenarios 2026/2027
WGU D552
Data Analytics for Accountants I
150 Original Practice Questions
Answers & Detailed Rationales | Excel Scenarios 2026/2027
Document Type: Practice Questions & Study Guide
Course: WGU D552 - Data Analytics for Accountants I
Academic Year:
Question Count: 150 Multiple-Choice Questions
Structure: 4 Sections (30 + 40 + 40 + 40)
Cognitive Mix: 30% Recall | 50% Application | 20% Analysis
Question Style: 75% Scenario-Based | 25% Direct
Includes: Complete Answer Key + Detailed Rationales + Grading Rubric
Aligned with 2026|2027 academic and professional standards.
Integrates Microsoft 365 features, Excel scenarios, and modern audit analytics.
Page 1 | WGU D552 Practice Questions
,WGU D552 | 150 Original Practice Questions | Excel Scenarios 2026/2027
Examination Overview
This 150 Original Practice Questions & Study Guide for WGU D552 Data Analytics for
Accountants I assesses mastery across four integrated competency domains: (1) Foundations
of Data Analytics in Accounting & Excel Basics; (2) Advanced Excel Functions, PivotTables,
& Data Manipulation; (3) Power Query, Data Modeling, & Visualization; and (4) Statistical
Analysis, Audit Analytics, & 2026 Updates. The guide mirrors the cognitive demand profile
of the official assessment: 30 percent recall, 50 percent application, and 20 percent
analysis, with 75 percent scenario-based items and 25 percent direct items.
Each question includes the correct answer and a detailed step-by-step rationale explaining
the exact Excel function syntax, Power Query transformation logic, or statistical
principle, and explicitly identifying why each distractor represents a flawed formula,
inefficient workflow, or incorrect analytical conclusion. Distractors are engineered to
reflect the most consequential errors observed in accounting analytics practice.
Document Structure
Part Content Questions
Part 1 Examination Questions (150 Items) Q1 - Q150
Sec 1 Foundations of Data Analytics & Excel Basics Q1 - Q30
Sec 2 Advanced Excel Functions, PivotTables & Manipulation Q31 - Q70
Sec 3 Power Query, Data Modeling & Visualization Q71 - Q110
Sec 4 Statistical Analysis, Audit Analytics & 2026 Updates Q111 - Q150
Part 2 Complete Solution Key (Answer Summary) All 150
Part 3 Grading Rubric & Mastery Thresholds Scoring Guide
Page 2 | WGU D552 Practice Questions
,WGU D552 | 150 Original Practice Questions | Excel Scenarios 2026/2027
PART 1: EXAMINATION QUESTIONS (150 Items)
Instructions: Select the single best answer for each question. Questions are sequenced Q1
through Q150 across four sections. Correct answers and detailed rationales are provided
inline beneath each question and summarized in Part 2.
Section 1: Foundations of Data Analytics in Accounting & Excel Basics
(Q1-Q30)
Q1: A senior accountant is initiating a project to analyze three years of production cost
data. According to the data analytics lifecycle, which sequence of phases represents the
correct order of activities?
A. Business question definition, data acquisition, data preparation, analysis, interpretation,
deployment [CORRECT]
B. Data extraction, data transformation, data loading, then analysis
C. Data visualization, model building, data cleaning, then reporting
D. Hypothesis testing, data mining, dashboard creation, then ETL processing
Correct Answer: A
Rationale: The lifecycle begins with defining the business question, then acquisition, preparation,
analysis, interpretation, and deployment. Option A describes only the ETL subset; Option C reverses
analysis and cleaning; Option D places visualization before data preparation.
Q2: A controller receives a CSV general ledger export and a folder of scanned vendor
invoices in PDF format. Which statement accurately characterizes these data types?
A. Both are structured data because both contain financial information about vendor
transactions.
B. The CSV is structured data in rows and columns; the PDFs are unstructured data requiring OCR
or NLP extraction before analysis. [CORRECT]
C. The CSV is unstructured because it lacks a database schema; the PDFs are structured because
they follow an invoice template.
D. Both are unstructured data requiring a data warehouse before any analytical processing can
occur.
Correct Answer: B
Rationale: Structured data (CSV) has a predefined row-column schema that is machine-readable, whereas
unstructured data (scanned PDFs) requires OCR or NLP. Option A mislabels PDFs; Option C reverses
definitions; Option D overstates requirements since CSVs are analyzable immediately.
Q3: Which statement best describes the 'Transform' stage within an ETL pipeline used for
vendor payment analytics?
A. Transform is the process of writing data into the destination data warehouse.
B. Transform is the retrieval of raw records from the ERP source system.
C. Transform encompasses data-shaping operations such as cleansing, standardization, type
conversion, and enrichment performed between extraction and loading. [CORRECT]
D. Transform is a separate audit validation performed after the load completes.
Correct Answer: C
Rationale: The Transform stage encompasses cleansing, standardization, type conversion, calculated
fields, and enrichment performed between extraction and loading. Option A describes Load; Option B
describes Extract; Option D invents a nonexistent audit stage.
Page 3 | WGU D552 Practice Questions
, WGU D552 | 150 Original Practice Questions | Excel Scenarios 2026/2027
Q4: An accounts payable analyst builds a pipeline that nightly pulls vendor payment
records, standardizes vendor name spellings, converts currency to USD, and loads the result
into Power BI. Which ETL stage contains the currency conversion?
A. Extract, because the exchange rate data must first be pulled.
B. Load, because conversions are applied when writing to the destination.
C. Validate, a fourth stage dedicated to business rules after loading.
D. Transform, because currency conversion and name standardization are data-shaping operations
between extraction and loading. [CORRECT]
Correct Answer: D
Rationale: Currency conversion and name standardization are data-shaping operations performed in the
Transform stage between extraction and loading. Option A confuses retrieval with transformation;
Option B applies already-transformed data; Option D invents a fourth stage.
Q5: Which statement correctly distinguishes structured, semi-structured, and unstructured
data in an accounting context?
A. Structured data is organized in a defined row-column schema (e.g., GL CSV); semi-structured
data has tags or markers but no rigid schema (e.g., JSON or XML invoices); unstructured data has
no predefined model (e.g., scanned PDFs, emails). [CORRECT]
B. Structured data has no defined schema; unstructured data is stored in relational tables;
semi-structured data is always numeric.
C. All three data types are identical and interchangeable in accounting analytics.
D. Semi-structured data cannot be analyzed by any tool; only structured data is analyzable.
Correct Answer: A
Rationale: Structured data has a rigid row-column schema, semi-structured data has tags or markers
without a rigid schema (JSON/XML), and unstructured data has no predefined model (PDFs, emails).
Option A reverses definitions; Option C is false; Option D is wrong since semi-structured data is
analyzable with appropriate tools.
Q6: An accounting firm debates between descriptive, diagnostic, predictive, and
prescriptive analytics for a new engagement. Which statement best defines predictive
analytics?
A. Predictive analytics summarizes what happened in the past using historical reports.
B. Predictive analytics uses statistical and machine learning models to forecast likely future
outcomes based on historical data patterns. [CORRECT]
C. Predictive analytics recommends specific actions the company should take.
D. Predictive analytics diagnoses why a variance occurred by drilling into root causes.
Correct Answer: B
Rationale: Predictive analytics uses statistical and ML models to forecast likely future outcomes
from historical patterns. Option A describes descriptive analytics; Option C describes prescriptive
analytics; Option D describes diagnostic analytics.
Q7: In a dimensional data warehouse for accounting analytics, which statement correctly
describes the roles of fact and dimension tables?
A. Fact tables contain descriptive attributes like customer names; dimension tables store
numeric measures.
B. Fact and dimension tables are interchangeable and contain the same column types.
C. Fact tables store quantitative measures at a defined grain (e.g., revenue), while dimension
tables store descriptive context (e.g., customer, product, time) that gives measures meaning.
[CORRECT]
D. Dimension tables store transactional measures like revenue; fact tables store descriptive
context.
Correct Answer: C
Rationale: Fact tables store quantitative measures at a defined grain, surrounded by dimension tables
providing descriptive context for filtering and grouping. Option A reverses roles; Option B is
incorrect; Option C also reverses the roles.
Page 4 | WGU D552 Practice Questions
WGU D552
Data Analytics for Accountants I
150 Original Practice Questions
Answers & Detailed Rationales | Excel Scenarios 2026/2027
Document Type: Practice Questions & Study Guide
Course: WGU D552 - Data Analytics for Accountants I
Academic Year:
Question Count: 150 Multiple-Choice Questions
Structure: 4 Sections (30 + 40 + 40 + 40)
Cognitive Mix: 30% Recall | 50% Application | 20% Analysis
Question Style: 75% Scenario-Based | 25% Direct
Includes: Complete Answer Key + Detailed Rationales + Grading Rubric
Aligned with 2026|2027 academic and professional standards.
Integrates Microsoft 365 features, Excel scenarios, and modern audit analytics.
Page 1 | WGU D552 Practice Questions
,WGU D552 | 150 Original Practice Questions | Excel Scenarios 2026/2027
Examination Overview
This 150 Original Practice Questions & Study Guide for WGU D552 Data Analytics for
Accountants I assesses mastery across four integrated competency domains: (1) Foundations
of Data Analytics in Accounting & Excel Basics; (2) Advanced Excel Functions, PivotTables,
& Data Manipulation; (3) Power Query, Data Modeling, & Visualization; and (4) Statistical
Analysis, Audit Analytics, & 2026 Updates. The guide mirrors the cognitive demand profile
of the official assessment: 30 percent recall, 50 percent application, and 20 percent
analysis, with 75 percent scenario-based items and 25 percent direct items.
Each question includes the correct answer and a detailed step-by-step rationale explaining
the exact Excel function syntax, Power Query transformation logic, or statistical
principle, and explicitly identifying why each distractor represents a flawed formula,
inefficient workflow, or incorrect analytical conclusion. Distractors are engineered to
reflect the most consequential errors observed in accounting analytics practice.
Document Structure
Part Content Questions
Part 1 Examination Questions (150 Items) Q1 - Q150
Sec 1 Foundations of Data Analytics & Excel Basics Q1 - Q30
Sec 2 Advanced Excel Functions, PivotTables & Manipulation Q31 - Q70
Sec 3 Power Query, Data Modeling & Visualization Q71 - Q110
Sec 4 Statistical Analysis, Audit Analytics & 2026 Updates Q111 - Q150
Part 2 Complete Solution Key (Answer Summary) All 150
Part 3 Grading Rubric & Mastery Thresholds Scoring Guide
Page 2 | WGU D552 Practice Questions
,WGU D552 | 150 Original Practice Questions | Excel Scenarios 2026/2027
PART 1: EXAMINATION QUESTIONS (150 Items)
Instructions: Select the single best answer for each question. Questions are sequenced Q1
through Q150 across four sections. Correct answers and detailed rationales are provided
inline beneath each question and summarized in Part 2.
Section 1: Foundations of Data Analytics in Accounting & Excel Basics
(Q1-Q30)
Q1: A senior accountant is initiating a project to analyze three years of production cost
data. According to the data analytics lifecycle, which sequence of phases represents the
correct order of activities?
A. Business question definition, data acquisition, data preparation, analysis, interpretation,
deployment [CORRECT]
B. Data extraction, data transformation, data loading, then analysis
C. Data visualization, model building, data cleaning, then reporting
D. Hypothesis testing, data mining, dashboard creation, then ETL processing
Correct Answer: A
Rationale: The lifecycle begins with defining the business question, then acquisition, preparation,
analysis, interpretation, and deployment. Option A describes only the ETL subset; Option C reverses
analysis and cleaning; Option D places visualization before data preparation.
Q2: A controller receives a CSV general ledger export and a folder of scanned vendor
invoices in PDF format. Which statement accurately characterizes these data types?
A. Both are structured data because both contain financial information about vendor
transactions.
B. The CSV is structured data in rows and columns; the PDFs are unstructured data requiring OCR
or NLP extraction before analysis. [CORRECT]
C. The CSV is unstructured because it lacks a database schema; the PDFs are structured because
they follow an invoice template.
D. Both are unstructured data requiring a data warehouse before any analytical processing can
occur.
Correct Answer: B
Rationale: Structured data (CSV) has a predefined row-column schema that is machine-readable, whereas
unstructured data (scanned PDFs) requires OCR or NLP. Option A mislabels PDFs; Option C reverses
definitions; Option D overstates requirements since CSVs are analyzable immediately.
Q3: Which statement best describes the 'Transform' stage within an ETL pipeline used for
vendor payment analytics?
A. Transform is the process of writing data into the destination data warehouse.
B. Transform is the retrieval of raw records from the ERP source system.
C. Transform encompasses data-shaping operations such as cleansing, standardization, type
conversion, and enrichment performed between extraction and loading. [CORRECT]
D. Transform is a separate audit validation performed after the load completes.
Correct Answer: C
Rationale: The Transform stage encompasses cleansing, standardization, type conversion, calculated
fields, and enrichment performed between extraction and loading. Option A describes Load; Option B
describes Extract; Option D invents a nonexistent audit stage.
Page 3 | WGU D552 Practice Questions
, WGU D552 | 150 Original Practice Questions | Excel Scenarios 2026/2027
Q4: An accounts payable analyst builds a pipeline that nightly pulls vendor payment
records, standardizes vendor name spellings, converts currency to USD, and loads the result
into Power BI. Which ETL stage contains the currency conversion?
A. Extract, because the exchange rate data must first be pulled.
B. Load, because conversions are applied when writing to the destination.
C. Validate, a fourth stage dedicated to business rules after loading.
D. Transform, because currency conversion and name standardization are data-shaping operations
between extraction and loading. [CORRECT]
Correct Answer: D
Rationale: Currency conversion and name standardization are data-shaping operations performed in the
Transform stage between extraction and loading. Option A confuses retrieval with transformation;
Option B applies already-transformed data; Option D invents a fourth stage.
Q5: Which statement correctly distinguishes structured, semi-structured, and unstructured
data in an accounting context?
A. Structured data is organized in a defined row-column schema (e.g., GL CSV); semi-structured
data has tags or markers but no rigid schema (e.g., JSON or XML invoices); unstructured data has
no predefined model (e.g., scanned PDFs, emails). [CORRECT]
B. Structured data has no defined schema; unstructured data is stored in relational tables;
semi-structured data is always numeric.
C. All three data types are identical and interchangeable in accounting analytics.
D. Semi-structured data cannot be analyzed by any tool; only structured data is analyzable.
Correct Answer: A
Rationale: Structured data has a rigid row-column schema, semi-structured data has tags or markers
without a rigid schema (JSON/XML), and unstructured data has no predefined model (PDFs, emails).
Option A reverses definitions; Option C is false; Option D is wrong since semi-structured data is
analyzable with appropriate tools.
Q6: An accounting firm debates between descriptive, diagnostic, predictive, and
prescriptive analytics for a new engagement. Which statement best defines predictive
analytics?
A. Predictive analytics summarizes what happened in the past using historical reports.
B. Predictive analytics uses statistical and machine learning models to forecast likely future
outcomes based on historical data patterns. [CORRECT]
C. Predictive analytics recommends specific actions the company should take.
D. Predictive analytics diagnoses why a variance occurred by drilling into root causes.
Correct Answer: B
Rationale: Predictive analytics uses statistical and ML models to forecast likely future outcomes
from historical patterns. Option A describes descriptive analytics; Option C describes prescriptive
analytics; Option D describes diagnostic analytics.
Q7: In a dimensional data warehouse for accounting analytics, which statement correctly
describes the roles of fact and dimension tables?
A. Fact tables contain descriptive attributes like customer names; dimension tables store
numeric measures.
B. Fact and dimension tables are interchangeable and contain the same column types.
C. Fact tables store quantitative measures at a defined grain (e.g., revenue), while dimension
tables store descriptive context (e.g., customer, product, time) that gives measures meaning.
[CORRECT]
D. Dimension tables store transactional measures like revenue; fact tables store descriptive
context.
Correct Answer: C
Rationale: Fact tables store quantitative measures at a defined grain, surrounded by dimension tables
providing descriptive context for filtering and grouping. Option A reverses roles; Option B is
incorrect; Option C also reverses the roles.
Page 4 | WGU D552 Practice Questions
