ag ag ag ag ag ag ag ag ag ag ag
Chapter 01 3e ag ag
Answers Included ag
TRUE/FALSE - Write 'T' if the statement is true and 'F' if the statement is false.
ag ag ag ag ag ag ag ag ag ag ag ag ag ag ag
1) Data analytics is the process of evaluating data with the purpose of drawing conclusions t
ag ag ag ag ag ag ag ag ag ag ag ag ag ag
o address business questions.
ag ag ag
⊚ true
⊚ false
2) The process of data analytics aims to transform raw information into data to create value.
ag ag ag ag ag ag ag ag ag ag ag ag ag ag
⊚ true
⊚ false
3) Data analytics has the potential to transform the manner in which companies run their
ag ag ag ag ag ag ag ag ag ag ag ag ag ag
businesses, however it is not practical in the near future.
ag ag ag ag ag ag ag ag ag
⊚ true
⊚ false
4) Auditors can use social media to hear what customers are saying about a company and
ag ag ag ag ag ag ag ag ag ag ag ag ag ag ag
compare this to inventory obsolescence and other estimates.
ag ag ag ag ag ag ag
⊚ true
⊚ false
5) Data analytics allows auditors to glean insights that are beneficial to the client, without
ag ag ag ag ag ag ag ag ag ag ag ag ag ag
breeching independence.
ag
⊚ true
⊚ false
6) The predictive analytics is an important aspect of data analytics for auditors, but is not
ag ag ag ag ag ag ag ag ag ag ag ag ag ag ag
applicable for tax accountants.
ag ag ag
⊚ true
⊚ false
7) The I in IMPACT Cycle represents Identify the Question.
ag ag ag ag ag ag ag ag
1
, ⊚ true
⊚ false
8) The M in IMPACT Cycle represents Master the Data.
ag ag ag ag ag ag ag ag
⊚ true
⊚ false
9) The P in IMPACT Cycle represents Predict the Results.
ag ag ag ag ag ag ag ag
⊚ true
⊚ false
10) The A in IMPACT Cycle represents Analyze the Data.
ag ag ag ag ag ag ag ag
⊚ true
⊚ false
11) The C in IMPACT Cycle represents Continuously Track.
ag ag ag ag ag ag ag
⊚ true
⊚ false
12) The T in IMPACT Cycle represents Track Outcomes.
ag ag ag ag ag ag ag
⊚ true
⊚ false
13) The IMPACT cycle is iterative, as insights are gained, outcomes are tracked, and new
ag ag ag ag ag ag ag ag ag ag ag ag ag ag
questions are identified.
ag ag
⊚ true
⊚ false
14) Data analysis through data manipulation is performing basic analysis to understand the
ag ag ag ag ag ag ag ag ag ag ag ag
quality of the underlying data and its ability to address the business question.
ag ag ag ag ag ag ag ag ag ag ag ag
⊚ true
⊚ false
2
,15) To be proficient in data analysis, accountants need to become data scientists.
ag ag ag ag ag ag ag ag ag ag ag
⊚ true
⊚ false
16) By developing an analytics mindset, accountants will be able to recognize when and how
ag ag ag ag ag ag ag ag ag ag ag ag ag ag
data analytics can address business questions.
ag ag ag ag ag
⊚ true
⊚ false
17) While it is important for accountants to clearly articulate the business problem, drawing
ag ag ag ag ag ag ag ag ag ag ag ag ag
appropriate conclusions, based on the data, should be left to statisticians.
ag ag ag ag ag ag ag ag ag ag
⊚ true
⊚ false
18) Analytic-
minded accountants should report results of analysis in an accessible way to each varied decis
ag ag ag ag ag ag ag ag ag ag ag ag ag ag
ion maker and their specific needs.
ag ag ag ag ag
⊚ true
⊚ false
MULTIPLE CHOICE - ag ag
Choose the one alternative that best completes the statement or answers the question.
ag ag ag ag ag ag ag ag ag ag ag ag ag
19) With a goal to give organizations the information they need to make sound and timely
ag ag ag ag ag ag ag ag ag ag ag ag ag ag ag
business decisions, data analytics often involves all of the following except:
ag ag ag ag ag ag ag ag ag a g
A) technologies.
B) statistics.
C) strategies.
D) databases.
20) Patterns discovered from ag ag
blank enable businesses to identify opportunities and risks and better plan for
ag ag ag ag ag ag ag ag ag ag ag blank.
3
, A) past archives; the future
ag ag ag
B) current data; the futureag ag ag
C) current data; today ag ag
D) past archives; today
ag ag
21) Which of the following best describes the goal of descriptive data analysis:
ag ag ag ag ag ag ag ag ag ag ag
A) recognize what is meant by data quality, be it completeness, reliability or validity
ag ag ag ag ag ag ag ag ag ag ag ag
B) perform basic analysis to understand the quality of the underlying data and its ability t
ag ag ag ag ag ag ag ag ag ag ag ag ag ag
o address the business question
ag ag ag ag
C) demonstrate ability to sort, rearrange, merge, and reconfigure data in a manner that
ag ag ag ag ag ag ag ag ag ag ag ag ag
allows enhanced analysis
ag ag
D) comprehend the process needed to clean and prepare the data before analysis
ag ag ag ag ag ag ag ag ag ag ag
22) Which of the following Microsoft software tool specializes in data joining?
ag ag ag ag ag ag ag ag ag ag
A) Excel
B) Power Query ag
C) Power BI ag
D) Power Automate ag
23) Which of the following Microsoft software tools specializes in creating dashboards?
ag ag ag ag ag ag ag ag ag ag
A) Excel
B) Power Query ag
C) Power BI ag
D) Power Automate ag
24) Which of the following Tableau software tools specializes in data transformation?
ag ag ag ag ag ag ag ag ag ag
4