[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.

[General Winters]

I think it just wants you to enter the correct formula for calculating the sum of My Mark etc and the formula for showing the percentage.

Eg
My Mark, to show the sum of the data is =SUM(B5:B7)
Out Of, =SUM(C5:C7)

For the percentage its simply MyMark/OutOf, the cell is formatted as number-percentage already so that would be simply =B5/C5, and =B6/C6 etc etc

For the other data, make sure formatting is number and no decimal places, eg Format Cells - number tab - number - decimal places 0

[ztein]

Ok, thanks GW.

[General Winters]

With the percentage column formatted as number - percent, it does not show up too well on a chart.

If you change that column to a format - number - number, then you can have the values calculated as for example, =(B5/C5)*100 etc instead of the straight B5/C5 then it shows up properly in a chart.



Then maybe add data labels to the chart for easier reading.

[ztein]

I see now.
Great thanks again!