DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Chart type choices vary depending on the selection
|
|
|
Only a few of the most popular chart types are available
|
|
|
Generated charts cannot be customized
|
|
|
The list of chart types can be customized in the Options window
|
|
|
None
|
Detailed explanation-1: -Bar graphs can help you compare data between different groups or to track changes over time. Bar graphs are most useful when there are big changes or to show how one group compares against other groups.
Detailed explanation-2: -A pie chart typically represents numbers in percentages, used to visualize a part to whole relationship or a composition.
Detailed explanation-3: -Bar and column charts are used to compare different items. Bars on a column chart are vertical while bars on a bar chart are horizontal. Bar charts are generally used to help avoid clutter when one data label is long or if you have more than 10 items to compare.
Detailed explanation-4: -The answer is now clear, line charts. Most data analysts prefer using a line chart as compared to other types. If you want to plot changes and trends over time, a line chart is your best option. Line charts compare data, reveal differences across categories, show trends while also revealing highs and lows.