Page 45 - Computer - 7

B. Fill in the blanks with the correct answer.

1. The _________ sparkline indicates whether a cell value is positive, negative, or zero.
2. _________ refers to the area within which all chart elements are placed.
3. A _________ chart represents categories by using larger rectangles in different colours.
4. A _________ uses different colours or symbols to identify different data series in a chart.

5. The _________ tab provides option to move the chart to a new location.
C. Write ‘T’ for True and ‘F’ for False statement.
1. You cannot change the type of a chart once it has been created. _______

2. You can move a chart within the same worksheet, to a new sheet or to another
worksheet. _______
3. Data labels display the values that are represented by the chart in a grid at the
bottom of the chart. _______

4. In a Scatter chart, both the horizontal and vertical axes represent numeric values. _______
5. A Radar chart represents data in the form of a spider web. _______
D. Answer the following questions.

1. What is a chart? Write the steps to move a chart to a new sheet.
2. Write in brief about the various elements of a chart.
3. Write short notes on the following:
(a) Column chart (b) Radar chart (c) Waterfall chart

(d) Sunburst chart (e) Funnel chart
4. Write the steps to add the following chart elements to a chart:
(a) Axes title (b) Data table (c) Chart title
5. What is a Combo chart? Write the steps to create it.

6. What are Sparklines? Write the steps to insert a sparkline in a cell in Excel.

Mind Stretching

1. Consider the chart given below and answer the questions that follow. Critical Thinking

(a) Identify the type of chart.
(b) Label the different elements of a chart.

43