CLASS 7:Lesson 03 Advanced features of Excel

Lesson 03: Advanced Features of Excel

Section A

A:  Fill in the Blanks

1.     Chart

2.     Data Series

3.     Legend

4.     Bar

5.     Value Axis

6.     Data, Formatting Effects , Formula

B: State True of False

1.     True

2.     True

3.     True

4.     True

5.     True

6.     False

C: Application based question

1.     Column Chart

2.     She should right click on plot area then select the format plot area to change the background colour.

Section B

A: Multiple Choice Questions:

1.     Goal Seek

2.     Axis Titles

3.     Pie

4.     F11

5.     Shift

6.     Spark lines

B: Answer the following:

1.     Chart is an effective way to display data in pictorial form. Charts make it easier to draw comparison, analyse the growth, relationship and trends among the values in a range.

2.     Column chart displays data in the form of vertical bars where the bar chart displays data in the form of long rectangular rods.

3.     Chart area includes all objects and elements in a chart. Where the plot area is window with in a chart area. It contains actual chart, Plotted Area, Data Series, Category and Value Axis.

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

5.     Data Consolidations helps in combining the data of multiple worksheets. We can combine data of various ranges either in the same sheet or in different sheets.