the filter feature excel allows you to look at what data?
A. Only the data you select from the filter options
B. Only data in the columns labeled filter••
C. Only data that have been sorted first
D. Only data in alphabetical order
Correct me if I'm wrong!!
a
c
a
a
Just took test. Mudman is correct! Thanks for the 100% Mudman
1 . A
2 . C
3 . A
4 . A
1 0 0 %
c o r r e c t
Mudman is magic. He is right just took test.
Incorrect.
http://www.excelfunctions.net/ExcelFilter.html
Is it A??
Yes, A.
Yes, Mud man is 100% correct.
The correct answer is A. Only the data you select from the filter options.
The filter feature in Excel allows you to selectively display data based on specific criteria you choose. By applying a filter to a column or multiple columns, you can temporarily hide rows that do not meet your specified conditions, thus displaying only the data that matches your criteria.
To use the filter feature in Excel, follow these steps:
1. Select the range of data you want to filter (make sure your data has headers).
2. Go to the "Data" tab on the Excel ribbon.
3. Click on the "Filter" button in the "Sort & Filter" group.
4. Dropdown buttons will appear in the header row for each column. Click on the dropdown button for the column you want to filter.
5. Select the specific options or values you want to filter by from the dropdown list.
6. Excel will only display the rows that meet your specified filter criteria, hiding all other rows.
So, in conclusion, the filter feature in Excel allows you to look at only the data you select from the filter options, not limiting you to only the data in specific columns, sorted data, or data in alphabetical order.