Your Status: Logged out Log in

A basic introduction to spreadsheets.  

Member rating: 9 out of 10 stars (2 votes) | Words: | Submitted: Mon Nov 24 2003

Page Preview
Preview
Previous 1 of 4 Next

On the left is an image preview of every page of this document, and below are the first 150 words with formatting removed:

A basic introduction to spreadsheets We are going to build up a pretty large spreadsheet at the end of this exercise but first we need to start at the very beginning. Let's consider the screen shot below with regards to the ticket sales at a nightclub. We can work out that if we sell 300 tickets and charge £10 per ticket then we would make £3000. The key to spreadsheet design is that the spreadsheet will do the maths for you. To do this you need to understand the basics of "formula". To work out a revenue of £3000 then what happened is that we multiplied £10 by 300 tickets. The formula for this is worked out as =C3*D3 This is because £10 is in cell C3, * is the symbol to multiply and finally the 300 is in cell D3. Q1. If I changed cell D3 to 400, then what number would appear in...

Get instant access



  • Instant, unlimited access to our documents in full
  • Swap your work for free access, or pay £4.99
  • To see the full version of this document and 145,970 others
Register Now
OR

Receive email updates for this category



  • Simply tell us your email address and receive a weekly Study Help Email for FREE
  • Receive 3 FREE essay views with each email
  • Get all the latest essays from Coursework.Info & discussion from TheStudentRoom.co.uk