[Excel] Help with a simple table

[ztein]

Hi,

I'm reading an ebook about Excel and it has excercises in it.
But the following excercise is confusing for me. Here's what it says:

1. "Recreate the following data set. Be sure to copy the font and border formatting as shown in the graphic.*Did that, see atached file please*"

2. *This is the confusing part*"Enter the appropriate formulas/functions to complete the empty cells for totals and percentages, and ensure that the number format is set to 'no decimal places'"

3. *This part as not confusing, but the question is 'All of the data?'* "Make a column chart to illustrate the data"

Thank you.

Regards.