Chapter 11 of the advanced Excel unit goes over how to use Autofilter and advanced filter. They both can be found in data then filter. When you click on autofilter these little arrows are put in each of the headings and when clicked on you can find all of the data that fits the criteria. Such as if you had a column for cost, you would be able to find data that has a certain cost or the top 10 of the list for cost. Also you are able to sort ascending and descending, which is very helpful. The advanced filter is a way to find data in your list and to copy it to another location. Activity 11.1 talks about it more in depth.
The first project asks you to use both autofilter and advanced filter to find information. It says, using autofilter to find products that cost less than $1.00 and print out that page. Next it says to use an advanced filter to find records with a quantity in stock that is less than 100. In activity 11.1 I was asked to do the same thing except with different numbers. So I followed those same steps and put in <100>$5,000.
The final project asks you just to use advanced filter to find products that are available in a small size. Then it asks you to print it in portrait orientation. Then it also asks you to find large sizes that have a sale price greater than $10.00. So that means that the advanced filter will be filtering on two criteria
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment