1
F11 function key is used to insert a chart instantly in a worksheet.
Solution not available in the source paper.
Charts in Excel
ICSE Class 8 Computer Studies · Class - 8: ICSE Kips Logix Computer Book Solutions with BlueJ · 24 solved questions
2
The mini charts that fit into a single worksheet cell to provide the visual representation of the data are known as Sparklines
Solution not available in the source paper.
3
Legend depicts the colours, patterns, and symbols assigned to the data series.
Solution not available in the source paper.
4
Radar chart looks similar to a spider net.
Solution not available in the source paper.
5
Chart Title describes the aim and contents of the chart.
Solution not available in the source paper.
1
A chart is a textual representation of data in a worksheet.
False
Solution not available in the source paper.
2
Area chart displays data in the form of long rectangular rods also called bars.
False
Solution not available in the source paper.
3
Line chart is in the form of lines and is used to illustrate trends in data at equal intervals.
True
Solution not available in the source paper.
4
Scatter chart is the default chart type in Excel.
False
Solution not available in the source paper.
5
Stock chart has been designed specifically for plotting data related to stocks and shares.
True
Solution not available in the source paper.
1
Ritu is a student of class VII. Her geography teacher has asked her to prepare a chart on the population of four Metro cities of India. Suggest her the chart type that suits her project.
Show SolutionHide Solution↓
As Ritu needs to show only one data series which is the population of four Metro cities and as the number of cities is small (only 4) so a Pie chart will be best suited for her project.
2
Tripti has created a chart. She wants to improve the appearance of her chart by changing the background colour of its Plot area. Which option will you suggest her to perform this task?
Show SolutionHide Solution↓
Tripti can use the Format Plot Area option that comes on right-clicking the plot area.
1
What type of chart is used to emphasize the magnitude of change overtime?
- (a)Pie
- (b)Area ✓
- (c)Bar
Show SolutionHide Solution↓
2
.......... chart is designed specifically for plotting data values related to stocks and shares.
- (a)Pie
- (b)Area
- (c)Stock ✓
Show SolutionHide Solution↓
3
What is the other name for the horizontal axis of a chart?
- (a)Y-axis
- (b)Value axis
- (c)Category axis ✓
Show SolutionHide Solution↓
4
Which type of chart is used for representing huge amount of data?
- (a)Line ✓
- (b)Bar
- (c)Scatter
Show SolutionHide Solution↓
5
What is the other name for XY chart?
- (a)Area
- (b)Bar
- (c)Scatter ✓
Show SolutionHide Solution↓
1
What is a Chart?
Show SolutionHide Solution↓
A Chart is a graphical representation of data in a worksheet. It helps to provide a better understanding of large quantities of data. Charts make it easier to draw comparisons and see growth and relationship among the values and trends in data.
2
How is a Column chart different from a Bar chart?
Show SolutionHide Solution↓
In Column chart, categories are organized horizontally and values vertically to emphasize the magnitude of change over a period of time. In Bar chart, categories are represented on the vertical axis and values are represented on the horizontal axis.
3
Explain the different components of a chart.
Show SolutionHide Solution↓
The different components of a chart are:
- Chart Area — Chart area includes all the area and objects in the chart.
- Category Axis — Category axis or X-axis is the horizontal axis of a chart.
- Value Axis — Value axis or Y-axis is the vertical axis used to plot the values. It is located at the left side.
- Data Series — Data series are the bars, slices or other elements that show the data values. If there are multiple data series in the chart, each will have a different colour or style.
- Category Name — Category names are the labels, which are displayed on the X and Y-axis.
- Plot Area — Plot area is a window within the Chart area. It contains the actual chart itself, and includes plotted data, data series, category, and value axis.
- Legend — It depicts the colours, patterns or symbols assigned to the data series. It helps to differentiate the data.
- Chart Title — It describes the aim and contents of the chart.
- Gridlines — These can either be Horizontal or Vertical lines depending on the selected chart type. They extend across the plot area of the chart. Gridlines make it easier to read and understand the values.
4
What is a Pie chart? Describe its features.
Show SolutionHide Solution↓
Pie chart displays data in the form of a circle that is divided into a series of segments. These segments show the relative size of each item in the chart. It always shows only one data series and is useful when you want to emphasize on a significant element. This chart type works best with smaller number of values.
5
Differentiate between Category Axis and Value Axis of a chart.
Show SolutionHide Solution↓
Category axis or X-axis is the horizontal axis of a chart whereas Value axis or Y-axis is the vertical axis used to plot the values. It is located at the left side.
6
Explain the process of resizing a chart.
Show SolutionHide Solution↓
To resize the chart, position the mouse pointer on any of the corner border of the chart. The mouse pointer will change to a double-headed arrow. Now drag the handle in the desired direction to change the size accordingly.
7
How can a chart be moved to another location?
Show SolutionHide Solution↓
To move the chart, place the cursor on the chart area. A four headed arrow appears, press and drag it in order to move the chart in any direction. Release the mouse button to place it at the desired location.
Press ↓ to reveal a solution and move to the next question. Back to Class - 8: ICSE Kips Logix Computer Book Solutions with BlueJ.