Std VIII ICT
4. Using Charts in MS Excel
---------------------------------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------------------------------
Answer the following.
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. 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.
--------------------------------------------------------------------------------------------------------------
5. Name the type of Chart:
1. To compare multiple values using horizontal bars----------- Bar Chart
2. To show changes in Stocks ----------Line chart
3. To show percentage of whole -------------- Pie Chart
4. To plot X and Y variables----------- XY Scatter Chart
---------------------------------------------------------------------------------------------------------------------------
5. Give one word for the following statements:
1. This button holds Styles and colour for the selected chart.
Ans: Chart Styles button
2. This is a tab that you click to access the charts.
Ans: Insert tab
3. This is a group that holds all types of charts available in Excel.
Ans: Charts group
4. This is an element of a chart that shows data series in a unique colour.
Ans: Legend
5. This button holds filter for the selected chart
Ans: Chart Filters button
------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment