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

Creating Advanced Charts

Practice Quiz: Creating Advanced Charts

1. How does a treemap display the proportion of data represented?

  • As rectangular shapes
  • As data points on a line
  • As columns
  • As numerical values

2. What are scatter charts commonly used for?

  • To display distribution of data grouped into bins
  • To compare statistical, scientific, and engineering data values
  • To compare sales, and inventory data values
  • To compare values across hierarchy levels

3. When you are creating a sparklines visualization, which two methods can you use to specify where the sparklines should appear on a worksheet? (Select two answers)

  • Highlight the column, then right-click the intended cell location, and select Insert.
  • Right-click the intended cell location, and select Paste.
  • Enter the cell reference in the Location Range box.

  • On the worksheet select a cell and Excel will add the cell reference to the Location Range box for you.

4. What's one data type intended for waterfall charts?

  • Financial data
  • Stock performance data
  • Progressively decreasing proportions
  • Non-comparable categories

Graded Quiz: Updating Advanced Charts

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

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

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

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

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

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

8. What are sparklines typically used for?

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

Creating Dashboards Using Spreadsheets

Practice Quiz: Creating Dashboards using Spreadsheets

9. Which of the following are benefits of dashboards in Excel? (Select all that apply)

  • Dashboards can alert you to trends and patterns.

  • Dashboards can be updated dynamically as source data changes.

  • Dashboards provide a way to monitor the performance of your data applications.
  • Dashboards can offer useful insights into your data.

10. Which of the following applications would be considered an advanced data analysis and visualization application? (Select all that apply)

  • Cognos Analytics

  • Google Sheets 
  • Bokeh (in Python)

  • Tableau

  • Excel (Full Desktop version)

11. You should try and add as much information and as many visualizations as possible into your dashboard so that it conveys the most amount of information possible.

  • True
  • False

12. According to the ‘Creating a Simple Dashboard using Excel’ video, which of the following should you have already done prior to creating a dashboard? (Select all that apply)

  • Created a data analysis findings report.
  • Formatted the data as a table.

  • Created pivot tables to help analyze data.

  • Verified data is clean and error free.

Graded Quiz: Creating Dashboards using Spreadsheets

13. Which one of the following statements best describes the main purpose of a digital dashboard?

  • To display all your charts in one location.
  • To provide a static data-findings report of your business data.
  • To display the most important or relevant information in a single place.
  • To analyse different types of data.

14. According to the ‘Creating a Simple Dashboard using Excel’ video, what did subject matter experts advise when building dashboards?

  • Use numbers as much as possible to help focus users on your key points.
  • Bright colors highlight key points.
  • Having as many visualizations as possible can help you clearly define your key points.
  • Displaying too much information means your key points can get lost.

15. Which feature in Excel enables you to precisely control what information is displayed in a visualization such as a chart?

  • Sorting
  • Filters
  • Pivot Tables
  • Sparklines

16. Which of the following tasks should you perform before creating a dashboard? (Select all that apply)

  • Format the data as a table first

  • Remove blank data rows

  • Format the data as a CSV file first
  • Create visualizations

Leave a Reply