• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month
Page
1. 1
1
2. 2
2
• Level: GCSE
• Subject: ICT
• Word count: 234

# All of the data in this spreadsheet corresponds with the information at the left of the screen, which shows the monthly charge, text charge and calls cost per minute

Extracts from this document...

Introduction

Annotation of my Spreadsheet This here is a print screen of my original spreadsheet, holding all of the relevant data. It shows the total calls in minutes, the amount of text sent in a month and the total. ...read more.

Middle

The formulae for finding the average of the total calls column is =AVERAGE(D12:D23). To find the average all I had to do was enter the data into one single cell and then drag the cell at the bottom right to replicate the original data into the specified cells. ...read more.

Conclusion

I then needed to find the averages for each row. The formula I used was "=AVERAGE(D23:F23)". I then found the rest of the averages by replicating and dragging along into the correct cells. The spreadsheet to the left shows my spreadsheet in the formulae view. By using these formulas I can work out the totals and averages of each column much more quickly. Richard Aldridge 10 Gordon ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE Software section.

## Found what you're looking for?

• Start learning 29% faster today
• 150,000+ documents available
• Just £6.99 a month

Not the one? Search for your essay title...
• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month

# Related GCSE Software essays

Validation is useful as it automatically tells you if you have typed in a wrong value, this helps you to not insert incorrect data. This warning is to let users know what type of data is to be entered e.g.

2. ## Spreadsheet. This coursework is based on the work of a spreadsheet, which is ...

TASK C: Spreadsheet coursework page 1 C: Specification of Solution From the information I gathered I could now finally begin to design my system. I am hoping to produce a spreadsheet that will help, with the organisation of the computer shop.

1. ## computerised spreadsheet for pupil attendance data

store data in an easy to read format and cannot do calculations, this is not what I need so I will not be using it, although it is a very big multi purpose system. Database packages include Lotus123 and Microsoft Works, effective at storing information in fields (row and column format)

2. ## Produce a spreadsheet for a successful and potential company

and to put data into a chart to visually illustrate the relationship between different items. The research I will need to conduct is information about the sales services of the company. I will find out the information by interviewing the manager josh brown.

• Over 160,000 pieces
of student written work
• Annotated by
experienced teachers
• Ideas and feedback to