Page 34 - Plus_V2.2_C7_Flipbook
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) All of these
c. When we apply filter feature, small arrows appear near ____________.
(i) Row headers (ii) Column headers
(iii) Sheet tab (iv) None of these
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. Sorting can also be done through Sort & Filter group under the Data tab. __________
e. Conditional Formatting is only used with numeric data. __________
3. Short answer type questions.
a. Define sorting.
______________________________________________________________________________
b. How do you remove filters?
______________________________________________________________________________
c. Which command is used to hide unimportant data?
______________________________________________________________________________
4. Long answer type questions.
32 Premium Edition-VII

