Excel problem

[LorenzoBertola]

Hi guys can you please help me in doing points: 1,2 and 3 of the assignment here below:
(I also added below the excel file)

 

[Michael M]

A couple of points to note
1. we normally won't help with assignments unless the OP provides evidence of what they have tried so far
2. providing snapshots means we have to retype any / all data, which most responders won't do......try uploading the workbook via dropbox or similar OR have a look at using XL2BB to privde samples of of your data (XL2BB is at my Signature block)
3. Have you looked at using PivotTables