When we want to hide the records which are not satisfying a given condition, then we use ________ command.

Related MCQs

• To search a value in the first row of a given range, we use _______.
• We can add constraints while using __________ command.
• To convert uppercase alphabets to lowercase we use _____
• To find number of characters in a string we use _____
• To count non blank cells, we use _____.
• To count number of cells that contains numbers, we use _____.
• To make data interesting, attractive and easy to read and evaluate, we use ______
• If cell B1 contains text MUMBAI then what will be the answer of =LOWER(B1)?
• If cell A1 contains a number 100, then what will be the answer of =IF(A1< 200, A1+10, A1-10)?
• Which of the following is not a valid chart type in Excel.