DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Line Chart
|
|
|
Pie Chart
|
|
|
Column Chart
|
|
|
Bar Chart
|
Detailed explanation-1: -Use a line chart or an area chart to show changes that are continuous over time. Line charts are the most effective chart for displaying time-series data. They can handle a ton of data points and multiple data series, and everyone knows how to read them.
Detailed explanation-2: -If you want to compare values, use a pie chart-for relative comparison-or bar charts-for precise comparison. If you want to compare volumes, use an area chart or a bubble chart. If you want to show trends and patterns in your data, use a line chart, bar chart, or scatter plot.
Detailed explanation-3: -Pie charts They use segments of a circle to show the relationship of parts to the whole. To highlight actual values, use another chart type, such as a stacked chart. Pie charts plot a single data series.
Detailed explanation-4: -A line chart reveals trends or change over time.