Practice Test

Q1) Filter is available for only one list in a worksheet. Show Answer

Q2) In advanced filter you must type the criteria before you use the command. Show Answer

Q3) In Filter you must type the criteria before you use the command Show Answer

Q4) In Filter you can copy the data to new location which is satisfying the given condition. Show Answer

Q5) Filter option allows the user to sort the data. Show Answer

Q6) You can give name to a range Show Answer

Q7) Range name can be used in the formulas Show Answer

Q8) You can not refer to a cell from another workbook, while using a formula. Show Answer

Q9) In Advanced Filter you can copy the data to new location which is satisfying the given condition. Show Answer

Q10) Filter means getting only those records which are satisfying a given condition. Show Answer