Microsoft Excel Essay

828 Words2 Pages

As Miss White needed help to keep track of monthly payments made by the 10 pupils in her group and to keep a monthly record of individual payments, a running total for each pupil, the overall total collected each month and the average amount per pupil collected each month. The overall cost of the trip is £500 per pupil between the months of October to March excluding December.

Choice of Application Used

To do this I needed to use the software Microsoft Excel 2003 as it was easier to use than other software products. As well Microsoft Excel can perform more useful functions such as Absolute Cell Reference, Functions (MIN, MAX and AVERAGE),Conditional Formatting and many more. Each of these useful in a case such as this.

Information …show more content…

After this the outstanding balance would be worked out, and any pupil who has an outstanding balance to be highlighted with a different colour, as shown in the screenshot below.

To work out the values and other functions such as average and total I needed to use certain functions and formulae to do this. This was done by going to the function tool and choosing which function I needed to use whether it be SUM, MAX, MIN or AVERAGE these could all be done by selecting the cell and clicking which function I needed and automatically it allowed me to choose which cells I wanted and automatically worked out the value.
The screenshot below shows the formulae being shown and each of the formulae used.

Absolute Cell Reference

In the outstanding balance column I used absolute cell references (for £500) which by using a dollar sign to represent this value as well as other functions.

AVERAGE function used.

AUTOSUM function used.

ABSOLUTE CELL

Open Document