Scribd
Upload
108 views2 pages

Excel Charting & Data Features

Chapter 10 discusses advanced features of Excel, including the use of charts to display data visually, with specific focus on bar charts and their components like data series and legends. It covers true/false statements regarding Excel functionalities, application-based questions for practical use, and multiple-choice questions to test knowledge on chart types and data management features. Key features highlighted include sorting, filtering, and chart insertion.

Uploaded by

lasyanshu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
108 views2 pages

Excel Charting & Data Features

Chapter 10 discusses advanced features of Excel, including the use of charts to display data visually, with specific focus on bar charts and their components like data series and legends. It covers true/false statements regarding Excel functionalities, application-based questions for practical use, and multiple-choice questions to test knowledge on chart types and data management features. Key features highlighted include sorting, filtering, and chart insertion.

Uploaded by

lasyanshu
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

CHAPTER 10- ADVANCED FEATURES OF EXCEL

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 the Data Values

[Link] chart displays data in the form of long Rectangular rods.

4. Y-axis Is the vertical axis that is used to plot the values.

5. Legend Is a key that is used to identify the colours, patterns or symbol


assigned to a data series.

B. State True or False:

1. You can sort the data only in one field. Stop

Ans. False

2. Ye chart is updated automatically with the change in data.

Ans. True

3. We cannot modify the chart by changing its colours and patterns.

Ans. False

4. X axis is the horizontal axis.

Ans. True

5. Data start area contains the actual chart itself and includes data
series, category and value access as well.

Ans. True

C. Application Based Questions:

1. Kanika is a chartered accountant. She looks after the accounts of various


companies and it keeps their records in. Microsoft Excel. She does not have
any idea how to view only those records that she wants to see. Suggest her
the feature of Microsoft Excel using which she can perform the task.

Ans. Kanika can use the Filter feature of MS Excel that allows you to view
only those records that you want to see.
2. Ritu, US Geography teacher asked her to prepare a chart on the
population of 4 metro cities of India. Suggest her the best suited chart type
for her project.

Ans. Ritu should use Bar Chart to depict the population of four Metro cities of
India.

D. Multiple Choice Questions:

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

a. Data series b. Plot area c. Legend

Ans. a) Data Series

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

a. Line b. Pie c. Bar

Ans. b) Pie

3. Which function key is used to insert a chart in a worksheet?

a. F6 b. F8 c. F11

Ans. c) F11

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

a. Data sheet b. Database c. Sheet

Ans. b) Database

5. Which feature allows us to arrange the given data according to a


particular field, either in an ascending or descending order?

a. Data Form b. Sort c. Filter

Ans. b) Sort

You might also like