Page 45 - KEC Khaitan C6 Flipbook
P. 45
e. What is the term for the rectangular area that contains the actual chart and
includes the plotted data? ___________
f. What command do you use to change the background of a chart in Excel? ___________
4. Think and answer.
a. Aniket has a dataset that shows the sales figures for different regions over the past
year. He wants to display this data to highlight the relationship between sales in different
regions. Which chart type should he use?
______________________________________________________________________________________
______________________________________________________________________________________
b. Ramesh wants to show how two different variables, such as advertising spend and sales revenue,
are related to each other. Which type of chart is most suitable for this purpose?
______________________________________________________________________________________
______________________________________________________________________________________
c. Your school conducted a survey on students favourite sports. How would you represent this data
visually using excel charts.
______________________________________________________________________________________
______________________________________________________________________________________
21 st
Century #Media Literacy
Skills
Video based question Scan the
Watch the video and answer the question. QR Code
Under which tab, can we change the background of the chart?
21 st
LAB ACTIVITY Century #Technology Literacy
Skills
Visit your computer lab and perform the following actions:
▶ Open MS Excel and perform the following tasks:
Enter the following data in Excel:
Charts in Excel 2021 43

