Case 5

This case is a tuff one. It asks to freeze panes which is very useful for long lists or tables. Second, it tests you on conditional formatting and on filtering data. These help you to get some first information by looking at the data. You are also asked to find subtotals by salesperson. This is asked alot of times in the business world. The last part of this case tests you about a pivot table and pivot chart.  It is a very handy tool but it was hard to find out how to do it. Finally, I did it but I do not really understand what it is for...