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.
