Page 29 - TP_Prime_V2.2_Class7
P. 29
3. Long answer type questions.
a. Define any two types of charts provided by Excel.
b. What is the difference between sorting data and filtering data?
c. Write the names of the criteria on the basis of which conditional formatting can be applied
in Excel.
d. Write the steps to apply Custom Sort feature.
21 st ADVANCED FEATURES OF EXCEL
4. Competency-based/Application-based questions. Century #Critical Thinking
Skills
a. Suman wants to present the information in the form of a chart. She has a data of single
series and the graph must show the relative circular size of each value. Which chart type
must she use?
b. John is preparing a list of students with their marks obtained in exams. He
wants to arrange the data in ascending order according to the students names.
Suggest him a feature of Excel which helps him in doing his work quickly.
27
Activity Time 21 st
Century #Critical Thinking
Skills
Look at the grid shown below and find five terms related to Excel.
G R I D L I N E S P
D F Q R K S I E O L
F U C H A R T S R E
I S H T R E Z F T G
D E Y C N D X S I E
O S W L A L I D N N
F I L T E R I N G D
Find Out 21 st
Century #Communication
Skills
With the help of your teacher, find out about the previous two versions of Excel. Also, find
the differences between them and Excel 2016.

