DATABASE FUNDAMENTALS
HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Bar
|
|
|
Line
|
|
|
Column
|
|
|
Pie
|
Detailed explanation-1: -Column Charts are useful to visually compare values across a few categories or for showing data changes over a period of time. A Column Chart typically displays the categories along the horizontal (category) axis and the values along the vertical (value) axis. Follow the steps given to insert a column chart.
Detailed explanation-2: -With column charts, you could compare values for different categories or compare value changes over a period of time for a single category.
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. They are easy to understand and to create.
Detailed explanation-4: -So, instead of showing the table summary alone, we can offer those numbers in charts called a “comparison chart.” For example, you want to know the sales value of your product in two different regions of a country.