data visualization and dashboards with excel and cognos coursera answers week 1

Creating Charts

Practice Quiz: Visualizing Data using Spreadsheets

1. What is the difference between Bar and Column charts?

  • The length of the bars
  • The width of the bars
  • One uses vertical bars, and one uses horizontal bars
  • The number of bars

2. Which chart uses nested rectangles?

  • Sparklines
  • Treemaps
  • Scatter charts
  • Bubble charts

3. Which two charts typically have categories arranged on the horizontal axis and values on the vertical axis?

  • Pie and bar charts
  • Column and pie charts
  • Column and line charts
  • Pie and line charts

4. When you add a filter to a pivot chart, how do you update the data in the original source pivot table?

  • You need to click Refresh All in the Data group of the Analyze tab for the pivot table
  • You do not need to do anything, as changes are immediately reflected in the pivot table data too
  • You need to refresh the pivot table worksheet to refresh the data
  • You need to manually add the filter to the pivot table in the PivotTable Fields pane

Graded Quiz : Visualizing Data using Spreadsheets

5. What is a capability of line charts?

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

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

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

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

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

8. 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?

  • Google and Bing
  • Google Docs and Word
  • Db2 and SQL
  • PowerPoint and Excel

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

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

10. 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

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

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

Leave a Reply