Question 1

What Microsoft tool would most likely be used to create a pivot table?

Accepted Answer

A) Word. 
B) Excel. 
C) Power BI. 
D) Powerpoint. 
A) Word. 
B) Excel. 
C) Power BI. 
D) Powerpoint.

Question 2

Which statement best describes data visualization?

Accepted Answer

A) Data visualization was created to help accessibility issues. 
B) Data visualization is one way we share the story. 
C) Data visualization helps users understand a UML diagram. 
D) Data visualization is they way we input data into tables. 
A) Data visualization was created to help accessibility issues. 
B) Data visualization is one way we share the story. 
C) Data visualization helps users understand a UML diagram. 
D) Data visualization is they way we input data into tables.

Question 3

What type of tables does Excel use to create data visualization?

Accepted Answer

A) Relational tables. 
B) Formatted tables. 
C) Pivot tables. 
D) Sorted tables. 
A) Relational tables. 
B) Formatted tables. 
C) Pivot tables. 
D) Sorted tables.

Question 4

An analyst may use which two features to explain the results of a complex analysis in the most robust manner possible using Tableau?

Accepted Answer

A) Story or Show Me. 
B) Power BI or Pages. 
C) Dashboard or Story. 
D) Dashboard or Class diagram. 
A) Story or Show Me. 
B) Power BI or Pages. 
C) Dashboard or Story. 
D) Dashboard or Class diagram.

Question 5

Which of the following is not a common step in preparing data and developing visualizations?

Accepted Answer

A) Assess the data cost versus its value. 
B) Select visualization. 
C) Set relationships among tables. 
D) Select attributes. 
A) Assess the data cost versus its value. 
B) Select visualization. 
C) Set relationships among tables. 
D) Select attributes.

Question 6

Tableau can source data from all of the following except?

Accepted Answer

A) Microsoft Excel. 
B) Miscrosoft Access. 
C) .CSV files. 
D) Microsoft Power Point. 
A) Microsoft Excel. 
B) Miscrosoft Access. 
C) .CSV files. 
D) Microsoft Power Point.

Question 7

What Microsoft tool would most likely be used to create a complex visualization using a large amount of data?

Accepted Answer

A) Power BI. 
B) Excel. 
C) Access. 
D) Powerpoint. 
A) Power BI. 
B) Excel. 
C) Access. 
D) Powerpoint.

Question 8

Which type of chart would best show outbreaks of the flu by region?

Accepted Answer

A) Pie chart. 
B) Map. 
C) Histogram. 
D) Scatterplot. 
A) Pie chart. 
B) Map. 
C) Histogram. 
D) Scatterplot.

Question 9

Which type of chart would best show each division's relative profit within a corporation?

Accepted Answer

A) Pie chart. 
B) Map. 
C) Histogram. 
D) Scatterplot. 
A) Pie chart. 
B) Map. 
C) Histogram. 
D) Scatterplot.

Question 10

Which of the following in Tableau allows modification of the visualization by changing color?

Accepted Answer

A) Autofill. 
B) Pencil. 
C) Marks. 
D) Pages. 
A) Autofill. 
B) Pencil. 
C) Marks. 
D) Pages.

Question 11

Which type of chart is best for time trend data?

Accepted Answer

A) Vertical bar. 
B) Maps. 
C) Histogram. 
D) Line chart. 
A) Vertical bar. 
B) Maps. 
C) Histogram. 
D) Line chart.

Question 12

Which of the following is an activity performed as part of data visualization?

Accepted Answer

A) Selecting the data visualization tool. 
B) Creating a value chain. 
C) Addressing privacy concerns. 
D) Asking the appropriate questions. 
A) Selecting the data visualization tool. 
B) Creating a value chain. 
C) Addressing privacy concerns. 
D) Asking the appropriate questions.

Question 13

Power Point is the most relevant data visualization tool.

Accepted Answer

A) True 
 B)False

Question 14

When creating a data visualization the analyst should never create new fields.

Accepted Answer

A) True 
 B)False

Question 15

Which type of chart is best to show a persons' weight over time?

Accepted Answer

A) Line chart. 
B) Vertical Bar. 
C) Scatterplot. 
D) Pie chart. 
A) Line chart. 
B) Vertical Bar. 
C) Scatterplot. 
D) Pie chart.

Question 16

A common step in preparing data for visualization is developing an activity model.

Accepted Answer

A) True 
 B)False

Question 17

Data visualization presents data in tables.

Accepted Answer

A) True 
 B)False

Question 18

What must first be added to the page when creating a visualization in Power BI?

Accepted Answer

A) Row. 
B) Table. 
C) Column. 
D) Dashboard. 
A) Row. 
B) Table. 
C) Column. 
D) Dashboard.

What Microsoft tool would most likely be used to create a pivot table?

Which statement best describes data visualization?

What type of tables does Excel use to create data visualization?

An analyst may use which two features to explain the results of a complex analysis in the most robust manner possible using Tableau?

Which of the following is not a common step in preparing data and developing visualizations?

Tableau can source data from all of the following except?

What Microsoft tool would most likely be used to create a complex visualization using a large amount of data?

Which type of chart would best show outbreaks of the flu by region?

Which type of chart would best show each division's relative profit within a corporation?

Which of the following in Tableau allows modification of the visualization by changing color?

Which type of chart is best for time trend data?

Which of the following is an activity performed as part of data visualization?

Power Point is the most relevant data visualization tool.

When creating a data visualization the analyst should never create new fields.

Which type of chart is best to show a persons' weight over time?

A common step in preparing data for visualization is developing an activity model.

Data visualization presents data in tables.

What must first be added to the page when creating a visualization in Power BI?

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Data Modeling

Relational Databases and Enterprise Systems

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language Xbrl

Data Analytics in Accounting: Concepts and the Amps Model

Emerging Technologies: Blockchain and Ai Automation

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing Ais

The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology

Evaluating Ais Investments

Filters

Exam 11: Data Analytics in Accounting: Tools and Practice

What Microsoft tool would most likely be used to create a pivot table?

Which statement best describes data visualization?

What type of tables does Excel use to create data visualization?

An analyst may use which two features to explain the results of a complex analysis in the most robust manner possible using Tableau?

Which of the following is not a common step in preparing data and developing visualizations?

Tableau can source data from all of the following except?

What Microsoft tool would most likely be used to create a complex visualization using a large amount of data?

Which type of chart would best show outbreaks of the flu by region?

Which type of chart would best show each division's relative profit within a corporation?

Which of the following in Tableau allows modification of the visualization by changing color?

Which type of chart is best for time trend data?

Which of the following is an activity performed as part of data visualization?

Power Point is the most relevant data visualization tool.

When creating a data visualization the analyst should never create new fields.

Which type of chart is best to show a persons' weight over time?

A common step in preparing data for visualization is developing an activity model.

Data visualization presents data in tables.

What must first be added to the page when creating a visualization in Power BI?

Accounting Information Systems and Firm Value

Accountants As Business Analysts

Data Modeling

Relational Databases and Enterprise Systems

Sales and Collections Business Process

Purchases and Payments Business Process

Conversion Business Process

Reporting Processes and Extensible Business Reporting Language Xbrl

Data Analytics in Accounting: Concepts and the Amps Model

Emerging Technologies: Blockchain and Ai Automation

Accounting Information Systems and Internal Controls

Information Security and Computer Fraud

Monitoring and Auditing Ais

The Balanced Scorecard, Business Model Canvas, and Business Value of Information Technology

Evaluating Ais Investments

Filters