A basic introduction to spreadsheets.
Member rating:
(2 votes)
| Words:
| Submitted: Mon Nov 24 2003
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...


