Page 34 - TP_Pluse_V2.2_Class_7
P. 34
test Your skiLLs
1. Tick ( ) the correct option.
a. Under which tab, Sort & Filter command is present?
(i) Home (ii) Insert
(iii) Formula (iv) View
b. We use Sort A to Z option to sort ____________.
(i) Numbers (ii) Text
(iii) Symbols (iv) Punctuation Marks
c. When we apply filter feature, small arrows appear near ____________.
(i) Row headers (ii) Column headers
(iii) Sheet tab (iv) Formula Bar
d. Which of the following is not a category used in conditional formatting?
(i) Data Bars (ii) A to Z
(iii) Top/Bottom Rules (iv) Icon Sets
e. Which option is used to remove conditional formatting?
(i) New Rule (ii) Clear Rules
(iii) Remove Rules (iv) Delete Rules
2. Write ‘T’ for true and ‘F’ for false.
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. __________
d. Data bars open a sub-list showing bars of different types and colours that can
be added to the cells. __________
e. Conditional Formatting is only used with numeric data. __________
3. Short answer type questions.
a. Name the criteria for applying conditional formatting.
______________________________________________________________________________
b. How do you remove filters?
______________________________________________________________________________
c. Which command is used to hide unimportant data?
______________________________________________________________________________
32 Plus (Ver. 2.2)-VII

