Question

GEMS
Date:
WORKSHEET - 2F
ar
Charts in MS Excel
The following po
and display
program.
The following worksheet shows the sales made by an online bookstore in three
REM to calculate
years.
CLS
Insert Delete Format
20
Cera Format
Farming Tables
sum =
1 TO
AA
FOR I
H
1
E
1
D
PRINT “Ente
INPUT
perce
OPHIE VOR STOR (SALES ANALYUS)
Year 2017
Yew 2016
sum = sum
1000
2000
B000
phile Andersphies
G000
1030
NEXT I
sur
7 Alderphy Design
4000
700
1500
7500
2000
1900
1000
2700
average
PRINT "The av
1. Plot a bar chart, line chart and doughnut chart showing the variation in sales made by
the Online Book Store in three years.
2. Plot a column chart showing the variation in sales in the various book categories in the
years 2016 and 2018. (Hint: Press the Ctrl key to select discontinuous range of cells)
3. Plot a Pie chart showing the distribution of sales across various book categories in the
year 2017
Write the cor
1. Which of
statements
(a) DO UN
(c) None
2. The defau
(a) 1
(c) -
Place the printouts of the charts in the given space.
3. How mar
X = 0
DO WHI
F
LOOP
(a) 5
(c) 9​

Answer 1

Explanation:

vvhjjgxgkdwt I I fd y jb x tog g jfr g