Page 28 - TP_Prime_V2.2_Class7
P. 28
d. When we apply filter feature, small arrows appear near _______________.
(i) Row headers (ii) Column headers
(iii) Sheet tab (iv) Second Row
e. Which of these is not a category used in conditional formatting?
(i) Data Bars (ii) A to Z
Prime (Ver. 2.2)-VII 2. Write ‘T’ for true and ‘F’ for false. ________
(iv) Icon Sets
(iii) Top/Bottom Rules
a. Excel can arrange data in ascending order only.
b. You cannot sort more than one columns at a time in a
selected range of cells.
________
c. The Add Level button is available under the Insert tab. ________
26 d. Sorting can also be done through Sort & Filter group under the
Data tab. ________
e. Conditional Formatting is only used with numeric data. ________
Evaluation Time
1. Fill in the blanks using the hints given below:
Styles, Filters, Column, Conditional Formatting, Custom sort
a. _______________ chart is used to compare values across categories.
b. _______________ is used when data is to be sorted on the basis of more than one
criteria.
c. The Conditional Formatting option is available in _______________ group under the Home
tab.
d. Color Scales is a feature available in _______________.
e. _______________ are used to separate required data from a set of data.
2. Short answer type questions.
a. What is a Pie chart?
b. Define sorting.
c. How do you remove filters?
d. Which command is used to hide unimportant data?

