Class 7 "Chapter 3 - Charts in Excel"

    CHAPTER 3

   Charts in Excel

A. Tick (ü) the correct answer and fill in the blank.

1. _F11_ key is used to insert a chart quickly.

2. A _Pie_ chart displays data in the form of a circle.

3. The format task pane appears on the _right_ of the screen.    

B. Identify the type of chart.

    

 C. Fill in the blanks using the given words.

1. Y-axis is also known as _Value _ axis.

2. Chart are easier to understand and _analyse_.

3. _Column charts display data in the form of a vertical bars.

4. The two tabs appear on creating a charts are _Format  and   Design.

5. _Legends_ helps to identify colors, patterns, symbols assigned to data series.  

D. Write T for true or F for false.

1. Charts are the useful tools for comparing the data values.  True

2. A line chart represents changing trends in data over a period of time. True

3. Y-axis is also known as category axis. False

4. Column charts can represent only one data series. False

5. In a bar chart, categories are represented on the vertical axis and values represented the horizontal axis. True

E. Answer in short.

 

Que 1 What are data series?

Ans -. Data Series:- The bars, lines, slices other elements represent the data value.

 

Que 2 Which chart component help to recognise different data series?

Ans -. Legends help to recognise different data series.

 

 

Que 3 What is the use of chart style commands?

Ans – The Chart Style command is used to change the visual look of the chart.

 

Que 4 What are legends?

Ans - Legend:- This helps to identify colors, patterns, symbols assigned to data series.

 

Que 5 Write the shortcut key to insert the chart in Excel spreadsheet.

Ans - F11

 

F. Answer in detail.

Que 1 What do you understand by chart? Explain the benefits of using chart.

Ans – A pictorial representation of numeric data is called a chart.

There are many advantages of charts.

*      Charts present data and information in an attractive manner.

*      Charts are easier to understand and analyse.

*      Charts have a more impressive and informative than a simple spreadsheet.

 

Que 2 What is difference between Bar and Column chart?

Ans – Column chart: A column chart displays data in the form of vertical bars. It is used to compare values over a period of time. In a column chart, categories are organised along the horizontal axis and values along the vertical axis.

          Bar chart: A bar chart displays data in the form of long rectangular horizontal bars. A bar chart illustrates comparisons among individual items. In a bar chart, categories are represented on the vertical axis and values are represented on the horizontal axis.

 

Que 3 Explain the two methods to insert a chart.

Ans - Method 1:

          Select the cells and press the F11 key. Excel automatically creates a chart for us and a new Chart tab appears along with the Sheet tabs.

Method 2:

             Step 1: Select the cells within the table.

          Step 2: Click on Insert tab on the Ribbon.

            Step 3: Select the type of chart from the Charts group. For example, Column charts type.

          Step 4: Now, select the chart subtype from the drop-down list. This creates the chart on the current worksheet.

Que 4. How will you change the chart type?

Ans -   The Change Chart Type command is used to change the type of the existing chart.

            Step 1: Select the chart and click on Design tab.

            Step 2: Click on Change Chart Type in the Type group. The Change Chart Type dialog box appears.