Data Visualization

What is the difference between Bar and Column charts?

• The number of bars

• One uses vertical bars, and one uses horizontal bars
  

• The width of the bars

• The length of the bars

Which chart of the following is best to compare with subcategories?

• Bar Charts

• Clustered Bar Chart

• Stacked Bar Chart

• 100% stacked bar chart

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

• Pie and bar charts

• Column and line charts

• Column and pie charts

• Pie and line charts

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

• You need to manually add the filter to the pivot table in the PivotTable Fields pane

• 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 click Refresh All in the Data group of the Analyze tab for the pivot table

"Data ! Data ! Data ! I can't make bricks without clay" - Related to

• Tiger Woods

• Agatha Christie

• Sherlock Holmes

• Pierce Brosnan

Which of the following is NOT a major consideration for data visualization?

• Clarity

• Accuracy

• Efficiency

• Robustness