6. Which of the following is NOT a type of filter available in Excel 2010? a) AutoFilter b) Filter c) Advanced Filter 7. How can you move the d
Answers
Answer: (b) Filter
Explanation:
Answer:
In Microsoft Excel 2010, there are three types of filters available: AutoFilter, Filter, and Advanced Filter.
a) AutoFilter: AutoFilter allows you to quickly filter data in a table or range based on a single criterion. You can use this filter to view specific data in a range or table by selecting a value from a drop-down list.
b) Filter: The Filter option is similar to the AutoFilter option but provides more flexibility in filtering data. You can use the Filter option to filter data based on multiple criteria and you can also specify more complex filtering criteria using logical operators.
c) Advanced Filter: The Advanced Filter option provides the most advanced filtering capabilities in Excel 2010. You can use this filter to extract data from a range or table based on complex criteria and you can also use it to copy filtered data to a new location.
Therefore, the option which is NOT a type of filter available in Excel 2010 is option "d".
Moving data in Excel 2010 is simple and can be done in several ways. You can use the Cut and Paste commands to move data within a worksheet or between worksheets. You can also use the Drag and Drop method to move data by selecting the data and dragging it to a new location. Additionally, you can use the Copy and Paste commands to copy data and then paste it in a new location.
#SPJ3