Page 44 - TP_Pro_V5.1_Class6
P. 44
4. Think and answer.
a. Define a chart in Excel. Name any two of its types.
______________________________________________________________________________________
______________________________________________________________________________________
b. List two advantages of using charts to represent data.
______________________________________________________________________________________
______________________________________________________________________________________
c. Explain how you can update a chart when new rows and columns are added to the data range.
______________________________________________________________________________________
______________________________________________________________________________________
______________________________________________________________________________________
d. What is the purpose of gridlines in a chart?
______________________________________________________________________________________
______________________________________________________________________________________
e. How can you move a chart in Excel?
______________________________________________________________________________________
______________________________________________________________________________________
21 st
5. Competency-based/Application-based questions. Century #Critical Thinking
Skills
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. Anjali has data on the monthly temperature and rainfall for her city over the past year. She wants to
analyse the relationship between temperature and rainfall to see if there is any correlation between
the two. Which type of chart should she use, and why?
d. Manoj is a teacher who wants to track the progress of his students' scores in multiple subjects over
the entire academic year. He has data for each subject for every month. Which type of chart would
best help him identify trends and patterns in student performance over time, and why?
21 st
Century #Media Literacy
Skills
Video based question Scan the
QR Code
Watch the video and answer the question.
Under which tab, can we change the background of the chart?
42 Pro (V5.1)-VI

