0
Filters allow you to show rows of data based on the content of cells and conditions applied to them. If you had a list of salesmen and their total sales made you could do something like show all the salesmen that had made a total sales above a certain amount, or ones that had made sales under a certain amount or ones that had sales of an exact level. You can also do combinations of conditions across different ranges. So if you also had the names of the offices that they were working in, you could find all the salesmen who made over a certain amount of sales and worked in a particular office. A filter allows you to bring in some databasing operations into a spreadsheet. You can also do things like sorting values.
You can use an Auto-filter which can do quick filters based on what cells are already there and their values. You can select various columns to be used as the filter and do things like already mentioned and do things like show a set amount of values, like the top 10 values. There is also a feature called an Advanced Filter which allows you to set up more complex criteria and do things like get the values that result from the filter and put them into another part of the spreadsheet.
Wiki User
∙ 13y ago
Wiki User
∙ 11y agoYou have the Auto Filter and the Advanced Filter as the main two categories of filters.
You have the Auto Filter and the Advanced Filter as the main two categories of filters.
You have the Auto Filter and the Advanced Filter as the main two categories of filters.
You have the Auto Filter and the Advanced Filter as the main two categories of filters.
You have the Auto Filter and the Advanced Filter as the main two categories of filters.
You have the Auto Filter and the Advanced Filter as the main two categories of filters.
You have the Auto Filter and the Advanced Filter as the main two categories of filters.
You have the Auto Filter and the Advanced Filter as the main two categories of filters.
You have the Auto Filter and the Advanced Filter as the main two categories of filters.
You have the Auto Filter and the Advanced Filter as the main two categories of filters.
You have the Auto Filter and the Advanced Filter as the main two categories of filters.
Wiki User
∙ 11y agoYou have the Auto Filter and the Advanced Filter as the main two categories of filters.
Wiki User
∙ 11y agoTo find which person
Add your answer:
Earn +20 pts
Can a person complete calculations in Microsoft Excel 2003?
Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.Yes they can. It is what Microsoft Excel is for.
Does the sort feature have to be applied before the filter on Microsoft Excel?
No, not necessarily. You can filter on a list of data that is not sorted.
What are examples of types of data in Microsoft Excel?
numbers and text
Are graphs free on Microsoft Excel?
Charts, as they are known, are part of Excel, so if you do have Excel then you have charts in it and other types of graphs.
How do you create filters in Microsoft Excel?
Excel 2007:Highlight the range you want to filter, but whatever method you choose.From the Menu ribbon, click on the Data Tab.In the Sort & Filter section, click on the Filter icon.
Who are the creators of Microsoft Excel?
Microsoft excel was created by Microsoft
How do you launch Microsoft Excel?
Programs->Microsoft Office->Microsoft Excel
What is the spreadsheet program in Microsoft office 2007?
I believe the only Microsoft program used to create spreadsheets is Microsoft Excel.
Is there any hidden game in Excel 2003?
There are no hidden games in Microsoft Excel after Microsoft Excel 2000, so there are none in Microsoft Excel 2003.
Who created Microsoft Excel?
Microsoft Excel was created by Microsoft Corporation. It was first released in 1985.
How would you filter a list of names or numbers in a column in Microsoft excel Excel?
By means using Filter . From filtered column We should select Custom , In custom we should select begins with where we can give the name or number
Which keyboard key using for filter removing in Microsoft Excel?
Ctrl - Shift - L can turn filters on and off.
