Deck 11: Data Analytics in Accounting: Tools and Practice

Question 1

Excel supports data presentation.

Answer 1

True

Question 2

Which type of chart is best for categorical data?

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

Answer 2

A

Question 3

Data visualization is the way we share the story.

Answer 3

True

Question 4

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

Question 5

Which type of chart is best to describe the economic conditions of each country?

A)Map.
B)Doughnut chart.
C)Treemap.
D)Pie chart.

Question 6

Data visualization must create or reinforce knowledge.

Question 7

Which type of chart would best show enrollment between 2005-2020?

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

Question 8

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

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

Question 9

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

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

Question 10

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

Question 11

Data visualization presents data in tables.

Question 12

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

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

Question 13

Which statement best describes data visualization?

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 14

Which type of chart would best compare hours studied and test scores?

A)Scatter plot.
B)Map.
C)Histogram.
D)Vertical bar.

Question 15

Power Point is the most relevant data visualization tool.

Question 16

Which type of chart is best for time trend data?

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

Question 17

A common step in preparing data for visualization is setting relationships among tables.

Question 18

Which of the following is not considered a data visualization tool?

A)Excel.
B)Chart Maker.
C)Power BI.
D)Python.

Question 19

Which type of chart is best to describe exam results for a class?

A)Treemap.
B)Maps.
C)Histogram.
D)Pie chart.

Question 20

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

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

Question 21

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

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

Question 22

Which visualization tool creates dashboards and stories?

A)Power Point.
B)Access.
C)Excel.
D)Tableau.

Question 23

What can users do with Tableau?

A)Create calculated fields.
B)Build relationships between data sources.
C)Create data visualizations.
D)All of the other answers are correct.

Question 24

Which of the following is not an example of a measure in Tableau?

A)Quantity.
B)Price.
C)Volume.
D)All of these are examples of measures.

Question 25

Power BI can source data from all of the following except?

A)All of the following are sources.
B)Miscrosoft Excel.
C)Text files.
D)Power BI datasets.

Question 26

What is the first step to get data when using Tableau?

A)Select File>New.
B)Select Dashboard>New Dashboard.
C)Select File>Open.
D)Select Connect>To a file.

Question 27

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

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

Question 28

What is the first step to prepare Excel data?

A)Select Data>Advanced Filter.
B)Select Data>Summarize with Pivot Table.
C)Select Insert>Recommended Charts.
D)Select Insert>Table.

Question 29

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

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

Question 30

Which of the following best describes a difference between Excel and Power BI?

A)Power BI can only ingest data from Microsoft Access.
B)There are no key differences described in this text.
C)Excel can only ingest data from other Excel files.
D)Power BI only exists in the cloud.

Question 31

Tableau can source data from all of the following except?

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

Question 32

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

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

Question 33

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

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

Question 34

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

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

Question 35

Which of the following is not an example of a dimension in Tableau?

A)Property location.
B)Sale date.
C)Quantity sold.
D)Sales manager.

Question 36

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

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

Question 37

Which of the following best describes the Get Data step in preparing data and developing a visualization?

A)Modify data to .csv format.
B)Build connections among tables.
C)Understand and clean the data for use.
D)Select the appropriate chart.

Question 38

Which of the following is not a common element of performing and sharing data analysis amongst visualization tools?

A)Get data.
B)Set relationships.
C)Create data.
D)Select and modify the visualization.