ACCT 310 - Ch. 11

Power BI can source data from all of the following except? A) All of the following are sources. B) Microsoft Excel C) Text files D) Power BI datasets

A) All of the following are sources.

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.

A) Assess the data cost versus its value.

Which type of chart is best to show a persons' weight over time? A) Line chart B) Vertical bar C) Scatterplot D) Pie chart

A) Line chart

Which type of chart is best to describe the economic conditions of each country? A) Map B) Doughnut chart C) Tree map D) Pie chart

A) Map

Which type of chart would BEST show each division's relative profit within a corporation? A) Pie chart B) Map C) Histogram D) Scatterplot

A) Pie chart

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

A) Power BI

Which type of chart would BEST compare hours studied and test scores? A) Scatterplot B) Map C) Histogram D) Vertical bar

A) Scatterplot

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.

A) Selecting the data visualization tool.

Which type of chart is best for categorical data? A) Vertical bar B) Maps C) Histogram D) Pie chart

A) Vertical bar

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.

B) There are no key differences described in this text.

Which type of chart is best for time trend data? A) Vertical bar B) Maps C) Histogram D) Line chart

D) Line chart

Which of the following is not considered a data visualization tool? A) Excel B) Chart Maker C) Power BI D) Python

B) Chart Maker

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 the way we input data into tables.

B) Data visualization is one way we share the story.

What Microsoft tool would most likely be used to create a pivot table? A) Word B) Excel C) Power BI D) PowerPoint

B) Excel

Which type of chart would BEST show outbreaks of the flu by region? A) Pie chart B) Map C) Histogram D) Scatterplot

B) Map

What must first be added to the page when creating a visualization in Power BI? A) Row B) Table C) Column D) Dashboard

B) Table

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

D) All of these are examples of measures

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

C) Create data

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) PowerBI or Pages C) Dashboard or Story D) Dashboard or Class Diagram

C) Dashboard or Story

Which type of chart is best to describe exam results for a class? A) Tree map B) Maps C) Histogram D) Pie chart

C) Histogram

Which type of chart would best show enrollment between 2005-2020? A) Pie chart B) Map C) Line chart D) Scatterplot

C) Line chart

Which of the following in Tableau allows modification of the visualization by changing color? A) Autofill B) Pencil C) Marks D) Pages

C) Marks

What type of tables does Excel use to create data visualization? A) Relational tables B) Formatted tables C) Pivot tables D) Sorted tables

C) Pivot tables

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

C) Quantity sold

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.

C) Understand and clean the data for use.

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

D) All of the other answers are correct

Tableau can source data from all of the following except? A) Microsoft Excel B) Microsoft Access C) .CSV files D) Microsoft PowerPoint

D) Microsoft PowerPoint

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

D) Select Connect >> To a file

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

D) Select Insert >> Table

Which visualization tool creates dashboards and stories? A) PowerPoint B) Access C) Excel D) Tableau

D) Tableau