- Perform The Following Tasks In Data Tab 1 Turn On Filter For The Table In Data Tab 2 Sort Data A To Z By Product B 1 (16.95 KiB) Viewed 26 times
2. Sort data A to Z by product by using filter.
3. Freeze panes at cell C2 of the data table.
4. Change format for Column D to show 2 decimal points with
1000 separator.
5. Sum Amount Total. Format the total wih "top and
double bottom" borders.
6.Create Pivot Table in New Tab to sum amount by Product by
Country.
Order ID Product Category Amount Due Date Country 1 Carrots Vegetables 4270 1/6/2012 United States 2 Broccoli Vegetables 8329 1/7/2012 United Kingdom 3 Banana Fruit 617 1/8/2012 United States 4 Banana Fruit 8384 1/10/2012 Canada 5 Beans Vegetables 2626 1/10/2012 Germany 6 Orange Fruit 3610 1/11/2012 United States 7 Broccoli Vegetables 9062 1/11/2012 Australia 8 Banana Fruit 6906 1/16/2012 New Zealand 9 Apple Fruit 2417 1/16/2012 France 10 Apple Fruit 7131 1/16/2012 Canada