[go: up one dir, main page]
Scribd
Upload
11 views1 page

G6 Chapter2

chapter2

Uploaded by

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

G6 Chapter2

chapter2

Uploaded by

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

1.

FORMULAS AND FUNCTIONS IN MS EXCEL

Answer the following

1. What are the different types of charts?


ANS) Different types of charts are: Column chart, line chart, bar chart, pie chart, Doughnut chart,
Area chart, XY (Scatter) chart, radar chart, 3D line chart etc.

2. Why do we use a chart?


ANS) We use charts for various reasons:
• Charts are an efficient way of presenting data.
• We use charts when some data can be better understood with the help of visual
representation.
• Charts make comparison easy.
• It helps us to look at the bigger picture of data.
• Large amounts of information can be studied at a glance by using charts.

3. What is the difference between a line chart and a pie chart?


ANS) Line charts are used to show trends in values over a period of time. The data points are
connected by lines, which makes the interpretation of the increasing or decreasing values of the
data easy.
Pie charts are used when values can be added to form a total. It is a circular structure resembling
a pie, with each portion showing the contribution of a value to the total.

4. Give the steps to change the style of a chart.


ANS) There are two ways to change the chart styles:
(i) Using the Charts Styles under the Design tab. Select the style that you want to apply.
(ii) By clicking on the paintbrush icon on the right-hand side of the chart. Select the style that
you want to apply

5. Write a short note on sparklines in MS excel.


ANS) A sparkline is a graphic representation used to convey information in the text. By just taking
the space of one cell, a sparkline conveys information such as various changes in trends over the
time.

You might also like