Excell

Dear Chris

Thank you for attending Excel Intermediate course!! I hope you enjoyed the course and benefited from it.

I am not very clear of the question you have asked.
Do you want to know how to calculate Average and percentages?

If that is what you asked for then I hope this might help.

The syntax (or the structure) of Average function is

=AVERAGE(Cell range)

This means that you click on the cell you want the result and type =AVERAGE (then select the cells that you want the average of. Please remember to close the bracket.

Note: If the cells are not together then simply use, (Comma) to separate the cells or range of cells.


To calculate percentages there is specific function.

You simply divide the lower value by the higher value. Following is an example:

A B C

1 Name Sales ('000) Sales (%)

2 Raj 50 41.66 ( B2/$B$6)

3 Tom 25 20.83

4 Jill 35 29.16

5 Jane 10 8.33

6 Total 120

When you perform the calculation the result might be in decimal format (i.e. instead of 41.66 % you might see 0.4166). You can simply select the cells with the result and then click on the (%) button on eth Formatting toolbar. and then increase or decrease the decimal places by using the increase decimal place or decrease decimal places buttons on the Formatting toolbar.

I hope this has answered your query.

If this has answered your query then I would request you to please mark the question as resolved!! If not and you have a specific question related to this then please post it as a new question and we should be able to provide you the solution for it!!

Kindest Regards


Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007