# Data Visualization and Dashboards with Excel and Cognos Quiz Answers

### Data Visualization and Dashboards with Excel and Cognos Week 01 Quiz Answers

Q1. What is a capability of line charts?

• Compare the frequency of data sets
• Compare different, unrelated data sets
• Compare similar, unrelated data sets
• Compare different, but related data sets

Q2. Each portion of a pie chart represents static values or categories. What is the sum of the categories equal to?

• 50%
• 100%
• 75%
• 99%

Q3. According to the ‘Introduction to Charts’ video, which chart is one of the most commonly used?

• Scatter chart
• Bar chart
• Funnel chart
• Bubble chart

Q4. In the ‘Expert Viewpoints: Using Visualizations to Tell a Data Story’ video, one expert mentioned two software programs that help highlight the important information. Which were the two software programs?

• PowerPoint and Excel
• Db2 and SQL

Q5. In the ‘Creating Basic Charts in Excel’ video, which type of chart shows the relative contribution of unit sales from Ford car models?

• Pie chart
• Bar chart
• Funnel chart
• Line chart

Q6. How does a pivot chart differ from a standard chart in Excel?

• A pivot chart contains data series, categories, and chart axes
• A pivot chart cannot be a line, pie or bar chart
• A pivot chart uses data from a pivot table
• A pivot chart always has its data arranged in columns and rows

Q7. What is the main difference between Area and Column charts?

• A column chart uses vertical bars, and an area chart uses data points
• A column chart uses data points, and an area chart uses vertical bars
• An area chart uses horizontal bars, and a column chart uses rows
• An area chart makes sense of complicated data and a column chart shows chart axis like basic charts

### Data Visualization and Dashboards with Excel and Cognos Week 02 Quiz Answers

Q1. What do treemaps use to represent hierarchical data categories?

• Treemaps use data points on a line.
• Treemaps use interconnected circles.
• Treemaps use color, size, and closeness of shapes.
• Treemaps use different shapes.

Q2. Histograms can look like a bar chart, what’s the key difference?

• Bar charts compare data and histograms display the distribution of data.
• Histograms use bins.
• Histograms use Axis Options to display different bin sizes.
• Bar charts use horizontal bars.

Q3. What kind of data works best with filled map charts?

• Complicated data
• Data containing geographical regions
• Scientific data
• Raw data

Q4. What are sparklines typically used for?

• To show regional information.
• To highlight a data range.
• To contrast numerical values.
• To show data trends.

### Data Visualization and Dashboards with Excel and Cognos Week 03 Quiz Answers

Q1. When signing up for a trial of Cognos Analytics, which item in the account form is the key one to take note of?

Q2. In Cognos Analytics what is the first step to build a dashboard?

• Provide questions and answers to the assistant
• Select visualizations
• Choose a template

Q3. Which of the following methods can be used in Cognos Analytics to create visualizations? (Select all that apply)

• By using widgets.
• By using the Assistant to suggest questions and suggested visualizations.
• By automatic recommended visualizations.
• By manually populating by dragging and dropping.

Q4. How can you create infographics in Cognos Analytics?

• Use Exclude to filter out some data.
• Ask the Assistant different questions.
• Drag and drop a widget shape icon onto a visualization.
##### Get all Course Quiz Answers of IBM Data Analyst Professional Certificate

Introduction to Data Analytics Coursera Quiz Answers

Excel Basics for Data Analysis Coursera Quiz Answers

Data Visualization and Dashboards with Excel and Cognos Quiz Answers

Python for Data Science, AI & Development Coursera Quiz Answers

Python Project for Data Science Coursera Quiz Answers

Databases and SQL for Data Science with Python Coursera Quiz Answers

##### Team Networking Funda

We are Team Networking Funda, a group of passionate authors and networking enthusiasts committed to sharing our expertise and experiences in networking and team building. With backgrounds in Data Science, Information Technology, Health, and Business Marketing, we bring diverse perspectives and insights to help you navigate the challenges and opportunities of professional networking and teamwork.