DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Column or Bar Charts
|
|
|
Bar or Pie Charts
|
|
|
Line or Column Charts
|
|
|
Pie or Line Charts
|
Detailed explanation-1: -The column chart is probably the most used chart type. This chart is best used to compare different values when specific values are important, and it is expected that users will look up and compare individual values between each column.
Detailed explanation-2: -Bar and column chart Bar, stacked bar, column, and stacked column charts are commonly used to visualize relationships between categorical data sets.
Detailed explanation-3: -A scatter plot or scattergram chart will show the relationship between two different variables or reveals distribution trends. Use this chart when there are many different data points, and you want to highlight similarities in the data set.
Detailed explanation-4: -Bar charts make sense for categorical or nominal data, since they are measured on a scale with specific possible values.
Detailed explanation-5: -Frequency tables, pie charts, and bar charts are the most appropriate graphical displays for categorical variables.