Data Visualization and Dashboards with Excel and Cognos Quiz Answers

All Week Data Visualization and Dashboards with Excel and Cognos Quiz Answers

This course covers some of the first steps in the development of data visualizations using spreadsheets and dashboards. Begin the process of telling a story with your data by creating the many types of charts that are available in spreadsheets like Excel.

Explore the different tools of a spreadsheet, such as the important pivot function and the ability to create dashboards and learn how each one has its own unique property to transform your data. Continue to gain valuable experience by becoming familiar with the popular analytics tool – IBM Cognos Analytics – to create interactive dashboards.

Enroll on Coursera

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.
Data Visualization and Dashboards with Excel and Cognos Course Review:

In our experience, we suggest you enroll in the Data Visualization and Dashboards with Excel and Cognos Course and gain some new skills from Professionals completely free and we assure you will be worth it.

Data Visualization and Dashboards with Excel and Cognos course is available on Coursera for free, if you are stuck anywhere between quiz or graded assessment quiz, just visit Networking Funda to get Data Visualization and Dashboards with Excel and Cognos Quiz Answers.

This Course is a part of the IBM Data Analyst Professional Certificate.

Conclusion:

I hope this Data Visualization and Dashboards with Excel and Cognos Quiz Answers would be useful for you to learn something new from this Course. If it helped you then don’t forget to bookmark our site for more Coursera Quiz Answers.

This course is intended for audiences of all experiences who are interested in learning about Data Analytics in a business context; there are no prerequisite courses.

Keep Learning!

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

Data Analysis with Python Coursera Quiz Answers

Data Visualization with Python Coursera Quiz Answers

IBM Data Analyst Capstone Project Coursera Quiz Answers

Leave a Reply

Your email address will not be published. Required fields are marked *

error: Content is protected !!