Class 7 - Chapter 5: Advanced Features of Excel

 Chapter 5: Advanced Features of Excel

A. Fill in the blanks.

1. Chart

2. Data Series 

3. Legend

4. Bar

5. Grouping

B. State True or False. 

1. True

2. False 

3. False 

4. True 

5. True

C. Select the correct option. 

1. b. Axis Titles

2. b. Pie 

3. a. Shift

4. c. Sparklines 

5. b. Sort

D. Competency-based question.

A suitable chart type would be a bar chart or a column chart. 

E. Answer the following questions.

1. A chart is an effective way to display data in a pictorial form. Charts make it easier to draw comparison, analyse the growth, and find the relationship and trends among the values in a range. They provide more accurate analysis of information.

2. Grouping of worksheets facilitates the editing of multiple worksheets at the same time. We can enter common data, formatting effects, and formulas in the grouped sheets.

3. Sparklines are mini charts that fit into a single worksheet cell to provide visual representation of the data. These can be used to analyse the trends in your data.

4. A column chart displays data in the form of vertical bars. They are represented on the horizontal axis and values along the vertical axis. Whereas, a bar chart displays data in the form of long rectangular bars that are placed horizontally.

5. The chart area includes all the objects and elements in a chart. Whereas, the plot area is a window within the chart area. It contains the actual chart and includes the plotted data, data series, category axis, and value axis.