Page 81 - modular4.0
P. 81
Chapter Profile
2. Name and explain any three types of charts available in Excel.
3. Define Legend.
21 st
F. Competency-based/Application-based questions. Century #Information Literacy
Skills
1. Kriti wants to represent the statistical data of her company in the form of shares.
She aims to display a single data series in a circular format. Which specific chart
should she use for this?
2. Advit is analyzing the relationship between advertising spend and sales revenue
for a particular product. He wants to see if there is a correlation between these two variables.
Which chart would you recommend for Advit’s analysis?
21 st
In the Lab Century #Technology Literacy
Skills
Create the following worksheet:
(i) a. Create a column chart based on the above data. (B2 to G6)
b. Give the title as Marksheet.
c. Place the legend on the right side of the chart.
d. Display the gridlines.
(ii) a. Use formula to calculate total and percentage.
b. Create a pie chart showing the name and percentage of students.
c. Display the data labels.
Teacher's Corner
Describes the different types of charts provided by Excel 2019 to the students.
Talk to the students about the different styles which can be applied to a chart.
Charts in Excel 79

