Lookup & Reference, Stat & Text, Sorting & Filtering

The sort option is available in _______ tab.

• Developer

• View

• Data

• Home

Multilevel sorting cannot be done without using sort dialog box

• TRUE

• FALSE

Keyboard shortcut for filtering option is

• Ctrl + Shift + L

• Ctrl + Alt + L

• Alt + Shift + L

• None of the mentioned

r will filter all values having r in it

• TRUE

• FALSE

How can we clear the filers applied to a data?

• Using clear option in home tab

• Using clear option in data tab

• Both the mentioned

• None of the mentioned

Conditional formatting can be applied to _______.

• Text

• Numbers

• Both text and numbers

• None of the mentioned

Conditional formatting is available in the _______ tab.

• Data

• Home

• Developer

• Formulas

How can we clear a conditional formatting that is applied to a data?

• Using clear option in home tab

• Using clear option in data tab

• Using clear rule option in conditional formatting

• None of the mentioned

Formulas can be used to create conditional formatting

• TRUE

• FALSE

Advanced filter option is available in the _______ tab.

• Data

• Home

• Developer

• Formulas