Question

1 .we use Sort A to Z option to Sort ______
(i) Numbers ii) Symbols iii) Text iv) All of these

2. when we apply filter feature, small arrows appers near _______
(i) row headers (ii) column headers (iii) sheet tab (iv) none of these

3. _________ is not a category used in conditional formatting?
(I) data bar (ii) A to Z (iii) top/bottom rules (iv) icon sets

4. the __________ option is used to remove conditional formatting.
(I) new rules (ii) clear rules (iii) remove rules (iv) delete rules​

Answer 1

we use A to Z option to sort

Answer 2

Fill in the blanks questions consists of a blank space in a sentence which needs to be filled to make a meaningful sentence.

• The given sentences belong to the various commands in the computing language.
• The correct sentences after filling the blanks are -

1 .we use Sort A to Z option to Sort the text. ( The command easily sorts the entire text)

2. when we apply the filter feature, small arrows appear near the Column header. ( It is a grey-coloured row containing used to identify each column in the worksheet)

3. A to Z is not a category used in conditional formatting. ( While Icon Sets provide a particular icon to each column based on value, Data Bars add horizontal bars to each cell, Top/Bottom Rules allow to apply formatting to cells)

4. The clear rules option is used to remove conditional formatting. ( The cells are selected and the clear rules tab is selected to remove the formatting)

#SPJ2