Excel: Perform the calculations, in order to get the total amount spent for the year

ThruBeingCool 

I replied that way because there are many precedents of students (college, elsewhere) coming here to get their homework done. The question you posed and the spreadsheet accompanying it bore all the indicators of falling into that same category. Note, for example, the header of the spreadsheet you linked to:

"MDM Test 2": That's why I responded as I did. This has all the characteristics of a homework assignment.

That said, the best way to learn Excel is to keep plugging away, looking at resources that explain the various functions. So I'll point you in the right directions, but leave a good deal of the work to you. 

For Task #2, I'd like to assume you can figure out the basic math to determine how to take 8% from $400 to yield the amount actually spent. The way to write that in an Excel formula is almost the same as writing it in an arithmetic formula. Multiplication is accomplished by the * character. So =$400 * .08 would give you the discount. Looked at another way, =$400 * .92 would give the discounted amount itself. So you do that with all those amounts and percentages and then add up the results.

For task #3, things get a lot tricker. And part of the solution could depend on what version of Excel you have. I was able to solve it using the FILTER and UNIQUE functions to get the names of the individuals associated with the location "Havana". 

Then the SUMIF function to identify how much each person had spent.

Here is a link to learn about the FILTER and UNIQUE functions, but be forewarned you'll need a current version of Excel to take advantage of those very useful functions.

Here is a link to learn how SUMIF works.