CHAPTER 3 ANALYSE DATA IN EXCEL 2016
Q1. Fill in the blanks with the help of the given words. 1.............. is the rearragement of data in either ascending or descending order. ans- SORTING 2. .......................in Microsoft Excel helps to retrieve data to edit, analyse, format or print it. ans- FILTER 3. Auto Filter is used to filter a column or row to view the data based on a ...........condition. ANS SPECIFIED 4. To apply conditional formatting, i will click on.................group under Home tab. ANS Style 5. Sort A to Z option will sort data in......................order ANS Asceding B. Tick the correct answer. 1. Which option will you choose to sort data in descending order? ANS- Sort Z to A 2. Which of these is not a type of filter in Microsoft Excel? Ans- Conditional 3. Which of the following key combinations will you press to filter the data? ANS Ctrl+Shift +L 4. Which button will you click to remove all the conditional formatting from a cell? ANS- Clear rules 5. On the Home tab, in ...