Assignment
Download and try
How to Do
Doing it manually or by using links will take a lot of time
Hence,we can use Pivot table
How to Use Pivot table
Select Table (including heading but not total)
Insert-->Pivot table--Ok
For Q1
Right Click Department---Add to Columns
Right Click Expense---Add to Rows
Right Click Amounr-Add to Rows
Extra item if important-Add to Report Filters