TEST BANK FOR DATA ANALYTICS FOR
ACCOUNTING, 3RD EDITION BY VERNON
RICHARDSON, VERIFIED CHAPTERS 1 - 9,
COMPLETE NEWEST VERSION
1|Page
, TABLE OF CONTENTS
1. Data Analytics for Accounting and Identifying the Questions
2. Mastering the Data
3. Performing the Test Plan and Analyzing the Results
4. Communicating Results and Visualizations
5. The Modern Accounting Environment
6. Audit Data Analytics
7. Managerial Analytics
8. Financial Statement Analytics
9. Tax Analytics
10. Project Chapter (Basic)
11. Project Chapter (Advanced): Analyzing Dillard’s Data to
Predict Sales Returns
Appendices:
A. Basic Statistics Tutorial
B. Excel (Formatting, Sorting, Filtering, and PivotTables)
C. Accessing the Excel Data Analysis Toolpak
D. SQL Part 1
E. SQL Part 2
F. Power Query in Excel and Power BI
G. Power BI Desktop
H. Tableau Prep Builder
I. Tableau Desktop
J. AlteryxK: Data Dictionaries
2|Page
, TRUE/FALSE - Write 'T' If The Statement Is True And 'F' If The Statement Is False.
1) Data Analytics Is The Process Of Evaluating Data With The Purpose Of Drawing Conclusions To
Address Business Questions.
⊚ True
⊚ False
2) The Process Of Data Analytics Aims To Transform Raw Information Into Data To Create Value.
⊚ True
⊚ False
3) Data Analytics Has The Potential To Transform The Manner In Which Companies Run Their
Businesses, However It Is Not Practical In The Near Future.
⊚ True
⊚ False
4) Auditors Can Use Social Media To Hear What Customers Are Saying About A Company And Compare This
To Inventory Obsolescence And Other Estimates.
⊚ True
⊚ False
5) Data Analytics Allows Auditors To Glean Insights That Are Beneficial To The Client, Without
Breeching Independence.
⊚ True
⊚ False
3|Page
, 6) The Predictive Analytics Is An Important Aspect Of Data Analytics For Auditors, But Is Not Applicable For
Tax Accountants.
⊚ True
⊚ False
7) The I In IMPACT Cycle Represents Identify The Question.
⊚ True
⊚ False
8) The M In IMPACT Cycle Represents Master The Data.
⊚ True
⊚ False
9) The P In IMPACT Cycle Represents Predict The Results.
⊚ True
⊚ False
10) The A In IMPACT Cycle Represents Analyze The Data.
⊚ True
⊚ False
11) The C In IMPACT Cycle Represents Continuously Track.
⊚ True
⊚ False
12) The T In IMPACT Cycle Represents Track Outcomes.
4|Page
ACCOUNTING, 3RD EDITION BY VERNON
RICHARDSON, VERIFIED CHAPTERS 1 - 9,
COMPLETE NEWEST VERSION
1|Page
, TABLE OF CONTENTS
1. Data Analytics for Accounting and Identifying the Questions
2. Mastering the Data
3. Performing the Test Plan and Analyzing the Results
4. Communicating Results and Visualizations
5. The Modern Accounting Environment
6. Audit Data Analytics
7. Managerial Analytics
8. Financial Statement Analytics
9. Tax Analytics
10. Project Chapter (Basic)
11. Project Chapter (Advanced): Analyzing Dillard’s Data to
Predict Sales Returns
Appendices:
A. Basic Statistics Tutorial
B. Excel (Formatting, Sorting, Filtering, and PivotTables)
C. Accessing the Excel Data Analysis Toolpak
D. SQL Part 1
E. SQL Part 2
F. Power Query in Excel and Power BI
G. Power BI Desktop
H. Tableau Prep Builder
I. Tableau Desktop
J. AlteryxK: Data Dictionaries
2|Page
, TRUE/FALSE - Write 'T' If The Statement Is True And 'F' If The Statement Is False.
1) Data Analytics Is The Process Of Evaluating Data With The Purpose Of Drawing Conclusions To
Address Business Questions.
⊚ True
⊚ False
2) The Process Of Data Analytics Aims To Transform Raw Information Into Data To Create Value.
⊚ True
⊚ False
3) Data Analytics Has The Potential To Transform The Manner In Which Companies Run Their
Businesses, However It Is Not Practical In The Near Future.
⊚ True
⊚ False
4) Auditors Can Use Social Media To Hear What Customers Are Saying About A Company And Compare This
To Inventory Obsolescence And Other Estimates.
⊚ True
⊚ False
5) Data Analytics Allows Auditors To Glean Insights That Are Beneficial To The Client, Without
Breeching Independence.
⊚ True
⊚ False
3|Page
, 6) The Predictive Analytics Is An Important Aspect Of Data Analytics For Auditors, But Is Not Applicable For
Tax Accountants.
⊚ True
⊚ False
7) The I In IMPACT Cycle Represents Identify The Question.
⊚ True
⊚ False
8) The M In IMPACT Cycle Represents Master The Data.
⊚ True
⊚ False
9) The P In IMPACT Cycle Represents Predict The Results.
⊚ True
⊚ False
10) The A In IMPACT Cycle Represents Analyze The Data.
⊚ True
⊚ False
11) The C In IMPACT Cycle Represents Continuously Track.
⊚ True
⊚ False
12) The T In IMPACT Cycle Represents Track Outcomes.
4|Page