Chapter 3 Charts in MS Excel exercise
Answers
Answer:
1. What is a chart?Ans: A chart is a graphical representation of data.2. List out any four elements of a chart?Ans: The four elements of a chart are Value Axis, Category Axis, Legend and Chart Area.3. Write the names of the ribbon that appear when you select a chart?Ans: When we select a chart , the insert ribbon with the Recommended Charts option , charts, maps and Pivot charts options will appear.4. What is the difference between legends and gridlines?Ans: The difference between the Legends and Gridlines areLegends- The Legend displays the plotted data series with a predefined symbol and the name of the series.It also assigns a unique colour to each series.Gridlines- These are the parallel lines along the X-axis and Y-axis in the plot area which makes it easier to identify the value of each data point on the chart.5. Define Pie Chart?Ans: A Pie-chart is also known as circular chart.It displays data points of individual items as a percentage of the whole.Q2. LONG ANSWER QUESTIONS:1. Why is a Chart useful?Ans: A chart is useful because i) It helps in understanding the large quantities of data better.ii) It makes data analysis simpler.iii) It captures the interest of audience.iv) It provides an easier way to read and understand the data.2. What is the Combo Chart?Ans: The Combo chart is a chart that combines two or more data series to make the data easy to understand.This type of chart is used when numbers in the specified data vary widely from data series to data series.For eg.- Price and Volume3. Distinguish between Bar Chart and Column Chart?Ans: Bar Chart – A bar chart represents data using bars at different heights.It uses horizontal bars instead of vertical bars.Column Chart – A Column chart is used to represent the data in vertical bars.It gives a clear view of the highest , the lowest and the intermediate values.4. How can you insert and remove chart elements?Ans: Steps to insert and remove chart elements are as follows:i) Select the chart to edit.Three buttons will appear at the upper- right corner of the chart.ii) Select the first button, Chart elements + button. A list of chart elements will appear with +checkboxes.iii) Check the elements that has to appear and Uncheck the elements that you don’t want to appear in a chart.5. Name the type of Chart:1. To compare multiple values using horizontal bars Bar Chart2. To show changes in Stocks Line chart3. To show percentage of whole Pie Chart4. To plot X and Y variables XY Scatter Chart5. Give one word for the following statements:1. This button holds Styles and colour for the selected chart.Ans: Chart Styles button2. This is a tab that you click to access the charts.Ans: Insert tab3. This is a group that holds all types of charts available in Excel.Ans: Charts group4. This is an element of a chart that shows data series in a unique colour.Ans: Legend5. This button holds filter for the selected chartAns: Chart Filters button