SKILL BENCHMARK

Data Visualization with Excel Literacy

  • 13m
  • 13 questions
The Data Visualization with Excel Literacy benchmark will measure your ability to recall and relate data visualization concepts in Excel. You will be evaluated on your ability to recognize the foundational concepts of data visualization, its uses, and best practices, including the basics of visualization in Excel. A learner who scores high on this benchmark demonstrates that they have the basic data visualization skills to understand and grasp visualization techniques and their uses.

Topics covered

  • add up/down bars and high/low lines to a line chart, copy and paste a line chart to a new sheet, and format the line chart
  • create a basic line chart, experiment with the data label options in a line chart, and change the fill color of the line in a line chart
  • create a histogram to bin a continuous data series, visualize the counts of rows in each bin, and create histograms for normally and non-normally distributed data series
  • create various kinds of clustered column charts and stacked column charts, hide a selection of rows, and hide a chart using that feature
  • customize various aspects of the line on a line chart, such as the thickness of the line and whether a line is represented using dashes, dots, or both.
  • describe the difference between a column chart and a bar chart, create a clustered bar chart, and perform various operations, such as sorting on that chart
  • identify use cases that require tables and bar charts
  • list use cases and best practices for line charts and pie charts
  • open up Microsoft Excel and read in data from an Excel workbook and a CSV file
  • outline different presentation types and considerations before choosing a chart type for your data
  • recognize the importance of data visualization in the age of big data
  • recognize use cases that require histograms and box plots
  • visualize data using built-in Excel charts, explore various column chart types, and create basic and clustered column charts