REPRESENTATION OF DATA IN EXCEL 2016

-

 

 

               CHAPTER 4 CLASS VII

REPRESENTATION OF DATA IN EXCEL 2016

 

Chart -A chart is a pictorial representation of data used to compare, analyze, observe patterns and trends in data.

Advantages of charts:

1. They present data in a more attractive way.
2. The make it easy to compare and understand data.

Components of a Chart
1. Data Series: data entries from which a chart is derived.
2. X-Axis: horizontal axis (also known as category axis).
3. Y-Axis: vertical axis (also known as value axis).
4. Chart Title: tells what the chart represents.
5. Chart Area: covers all the components of the chart.
6. Plot Area: area bounded by the two axes.
7. Legend: identifies each data series by giving a unique color or pattern to each data series.

8. Gridlines: lines that run from X Axis and Y axis.

 

A.Fill in the blanks

1.  COLUMN chart represents information in vertical bars.

2.  SCATTER.. chart is used to compare pairs of value.

3.  X-axis or CATEGORY axis is the horizontal axis of the chart.

4.  GRIDLINES…..shows the exact value of each data points in a chart.

5.  To add data table, I should go to DESIGN tab.

B.                       Tick the correct answer.

1.            A chart that compares proportions is

ans- b. Pie Chart

2.            This type of data shows the changing trends in data.

ans c. Line chart

3.            The purpose of legend in a chart is

ans- a. To identify the data series

4.            The……….. tab provides various chart style options.

Ans- c. Design

5.            It is the area in which all the components of a chart are present.

Ans- a. Chart Area

 

C.                       Answer the following questions-

1.            What is a chart? What is its purpose?

Ans1. A chart is a pictorial representation of data. Charts are used to compare, analyze, observe patterns and trends in data.

2.Name and describe the component of a chart.

ANS2. PAGE 51

 

 

 

 

3.Compare the column and bar charts.

·         Ans3. Column Chart: This chart displays data using vertical bars. Each bar represents a category, and the height of the bar indicates the value of that category. It is the most commonly used chart for comparing different sets of information.

  • Bar Chart: This chart uses horizontal bars to represent data. Each bar's length corresponds to the value of the category it represents. It helps to compare individual items quickly and easily.

4.Do you think it is important to add a chart title and axis title to a chart?

Ans- Yes, it is important to add a chart title and axis titles to a chart because both chart and axis titles improve communication, interpretation, and overall effectiveness of the chart.

 

 

 

 

 

 

 

 

 

 

 

5.      How will you move a chart to another worksheet?

   Ans5. Steps to Move a Chart to Another Worksheet:

1.On the design tab, in the location group, click Move Chart. The Move chart dialog box appears.

2.In the object in, select any of the existing worksheets.

To move the char to a new worksheet, click the New sheet radio button and type the name of the new worksheet.

3.Click Ok

 

 

 

 

Comments

Post a Comment

Popular posts from this blog

CLASS 8 DATA TYPES IN PYTHON

-
  DATA TYPES IN PYTHON A. Tick the correct option 1.   Which of the following is not a valid variable name? ANS1. a. Print 2.   Which of the following is not a string?   ANS2. a. 89 3.   How many types of number data type are there in Python? ANS C. 4 4.   Which of the following is a data type? ANS A. TUPLE 5.   Which of the following will you use to access a value stored in a dictionary? ANS C. [ ] B. Fill in the blanks 1.   A multiline string spreads across multiple lines. 2.   Data type is used to represent data in the memory of the computer. 3.   A tuple can consist of different types of values. 4.     A conditional statement can also be called a decision making statement. 5.     The IF conditional statement has code for the condition being true only. C  Write the output of the following code snippets. 1. >>> number_of_pages=200 >>>print( number_of_pag...
Read more

CHAPTER 4 RAISING QUERIES CLASS 8 COMPUTER

-
CLASS 8 CHAPTER 4 RAISING QUERIES A. Fill in the blanks with the help of the given words. 1. Connecting tables in a database is the concept of relational database. 2. A foreign key is the primary key of another table which creates a link between two tables based on a common column. 3. If you modify the primary key value, Cascade update related fields  allows you to update all the related foreign key values. 4. A query   allows you to pull information from one or more tables based on a set of defined search conditions. 5. The query design view allows you to customise the query.     B. Tick the correct answer. 1. Which of the following options allows you to delete the related records from the foreign key table, if you delete records from the primary key table? ANS B. Cascade delete related records 2. Which option in Edit Relationships dialog box prevents you from entering a value in the foreign key field? ANS B. Enforce referential integrity 3. Press.......... to...
Read more

HTML 1 TEST ONLINE 20 MAY 2025

-
Image
                   QUESTION 3. Which HTML Tag is used to underline the text?                                 a. <U>   b. <I>    c. <TT>   d. <B>                               QUESTION 4. HTML Tags are written in                                 a. Capital letters                                b. Small letters                                c. Both Capital and Small letters                                d. No...
Read more