• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

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

See related essaysSee related essays

Related GCSE Software essays

  1. Spreadsheet Technical report. My task was to produce a grade book for primary ...

    used for and can easily select the worksheet she specifically wants, I also inserted worksheets accordingly. Step 23 After I had completed worksheets showing data for each subject including reports and charts, I decided to include an annual report, which summarised which students required help; number of merits each child

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

    * Should calculate the profit and loss of the company. * Will notify any mistyped data on the system. This will be accomplished by using validation checks. * Retrieve data rapidly TASK C: Spreadsheet coursework page 2 * Clear and simple instructions for both beginners and advanced users.

  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.

  1. Produce a spreadsheet for a successful and potential company "Belle Du Jour".

    * You can also produce graphs from the spreadsheet. These are more accurate. * You also save a lot of time as computer are more effective. I will set this spreadsheet up by using Microsoft excel. This is a software package that allows you to create financial spreadsheets and reports

  2. Publisher.I have been recruited to help Steven make the Programmes, Banners, Information Cards and ...

    ==> A Word Processing Program could be used to type up the Programs. The Word Processor will allow easy typing up of the Program and will allow easy making of the Banner. However the Information Cards will be very hard to produce as the Pictures and the size of the

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