Kips IT Beans Class 7 Chapter 5 Solutions ADVANCED FEATURES OF EXCEL

|
TextbookKips IT Beans
Class7
SubjectComputer
Chapter5 ADVANCED FEATURES OF EXCEL
Other ChaptersChapter 1
Chapter 2
Chapter 3
Chapter 4
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10
Chapter 11
Chapter 12

Kips IT Beans Class 7 Chapter 5 Solutions ADVANCED FEATURES OF EXCEL

Brain Developer

A. Fill in the blanks:

1. Chart is an effective way to display data in pictorial form.

2. Data Series are the bars or slices that show data values.

3. Legend is a key that is used to identify the colours, patterns, or symbol assigned to data series.

4. Bar chart displays data in the form of long rectangular rods.

5. Value Axis is the vertical axis that is used to plot the values.

6. The purpose of grouping worksheets is to enter common Data, Formulas and Formatting Effects.

B. State True or False:

1. A chart is updated automatically with the change in data. – TRUE

2. We cannot modify the chart by changing its colours and patterns. – FALSE

3. X-axis is the horizontal axis. – TRUE

4. The Chart area contains the actual chart itself and includes data series, category and value axis as well. – FALSE

5. You can change the pattern of data series using Fill option. – TRUE

6. All the worksheets cannot be deleted in a workbook. – FALSE

C. Application Based Questions:

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 best suited chart type for her project.

Ritu can use Bar Chart.

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?

She can use the Format Plot Area options that comes on right-clicking the Plot Area.

D. Multiple Choice Questions:

1. Which feature is used to set a specific result for one cell by adjusting a value in another cell?

  • Grouping Worksheets
  • Legends
  • Goal Seek

2. Name the bars or slices that represent the data values on the chart.

  • Data Series
  • Plot Area
  • Legend

3. Which chart type displays data in the form of a circle?

  • Line
  • Pie
  • Bar

4. Which function key is used to insert a chart, instantly in a worksheet?

  • F6
  • F8
  • F11

5. Which key is used to group multiple worksheets?

  • Shift
  • Ctrl
  • Enter

6. Name the special window that displays data, when you insert a chart.

  • Datasheet
  • Database
  • Sheet

E. Answer the following:

What is Chart?

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

How is a Column chart different from a Bar chart?

Column Chart is used to display data in form of vertical bars. It is used to show changes in data over a period of time and Bar Chart displays data in the form of long rectangular rods called bars. A Bar Chart is used to illustrate comparision among the individual items.

What is the difference between Chart area and Plot area?

CHART AREA: The chart area includes all objects and elements in a chart.
PLOT AREA: The Plot area is a window within a Chart
area. It contains the actual chart and includes the plotted data, data series, category and value axis.

How will you group worksheets?

By default, three sheets are displayed in a workbook with the name Sheet1, Sheet2, and Sheet3. You can enter data in all three worksheets. The purpose of grouping the worksheets is to enter common data, formatting effects and formulas. Follow these steps to group the multiple worksheets:
• Create a new workbook. The Sheet1 worksheet is active.
• Press and hold the Shift key. Click on the Sheet3 tab.
• Release the Shift key. Note that all the three worksheet tabs have become white and the word ‘[Group]’ appears in the Title bar. It indicates that Sheet1, Sheet2 and Sheet3 are grouped together.

What do you understand by the term Data Consolidation?

Consolidation refers to combining of data. We can combine data of various ranges either in the same worksheet or in the other worksheet.

F. Briefly explain the following terms:

1. Data Series: Data series are the bars, slices or other elements that represent the data values.

2. Category Name: Category Names are labels which are displayed on X-axis and Y-axis.

3. Value Axis: Value axis or Y-axis is the vertical axis used to plot the values.

4. Goal Seek: Goal Seek is a wonderful feature for fixing a specific result for one cell, by adjusting a value in another cell.

Other Chapter Solutions

Leave a comment