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

A basic introduction to spreadsheets.

Extracts from this document...


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. ...read more.


E3 Q6. If the entry in cell D4 was changed, what other cell would change as a result? E4 Now you don't need to be a business studies student to realise that when you are running a night-club you are going to make more money then just from the tickets that you sell. You will sell drinks from the bar and maybe even charge people to have a table where they can sell clothing and other things. So in fact what we would have is a list of money coming in something like the worksheet below. As we can see from the spreadsheet on the previous page we can see that the income from lager, cider and bottles is worked out in the same way as the guest list - it's a simple multiplication just like before. ...read more.


The next screenshot shows the entire records of all the money in and out on the night. So we start with all our income at the top of the spreadsheet but of course we then have to list all of our costs and take them away. Let's focus on cell G23 where we can see that the costs (except drinks) for the night. Certainly if we add them all up one by one then we could end up with the formula =F18+F19+F20+F21+F22+F23 As you can see this is getting a bit long winded and it's pretty easy to make a mistake as you go along. This formula can be re-written as =SUM(F18:F23) In other words add up all the cells from F18 through to F23 inclusive. In that case to finish off this section. Q10 Using the SUM function write the formulae for cells G6, G11 and G28. =sum(G6+G11+G28) Q11 What formulae would be in cells G30 and G33? =G27+G33 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Molecules & Cells 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
  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work