Table of Contents
Data Visualization and Dashboards with Excel and Cognos Week 01 Quiz Answers
Quiz : Graded 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
- Google and Bing
- Google Docs and Word
- 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
Quiz : Graded 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
Quiz : Graded 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?
- Your name
- Your country /region
- Your closest data center
- Your address
Q2. In Cognos Analytics what is the first step to build a dashboard?
- Upload a spreadsheet or workbook
- 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?
- Modify navigation paths.
- 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