Business Spreadsheet
Every year, companies must produce a set of business accounts. They will do this using a spreadsheet or a special accounting program. For this task you will need to create a spreadsheet for Downloadable Tunes to track their sales and expenditure, which will help them to produce their accounts at the end of the year.
Use the template here to complete your work to pass standard. 
FOLLOW THESE STEPS CAREFULLY…
| (A) Download and open this
YOU MUST PRINT SCREEN THE TABLE WITH NO CHANGES DONE TO A BLANK WORD FILE!!!
The is the spreadsheet without any changes done to it. Take a screenshot of this before doing anything to it. |
here is an example of what it might look like once you have completed all the tasks | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| (B)
Format your spreadsheet to make it look more professional and easy to read. See an example (taken from ulearnit)
PRINT SCREEN ANY CANGES YOU HAVE DONE TO THE SAME WORD FILE UNDER THE LAST SCREEN SHOT
Here I have formatted using some of the techniques and not all. This makes the headings stand out & cells that a money are made clear. |
Click here to see videos of how you can format your spreadsheet. (from teach-ict.com)
|
||||||||
| (C)
Add formulae to calculate the profit/loss for the business. To do this, you should do the following:
SCREEN SHOT THAT YOU HAVE ADDED THE TOTALS TO YOUR WORD FILE
In this screen shot I have just added the totals and also given them a row heading. They have been coloured to make them stand out. |
|
||||||||
| (D) Make the following changes to your spreadheet and than comment about the changes it makes to your total. Screenshot any changes you made and use comments in your annotation to show changes.
SCREEN SHOT EACH ONE OF THESE TASKS NOTING THE DIFFERENCES THEY ARE MAKING TO YOUR TOTALS AS YOU MAKE THE CHANGES 1. The owner of Downloadable Tunes has made a mistake on order number 1001 – the Amount should be £18 (not £15) and the VAT should be £3.15 (not £2.63). 2. Order 1014 has now been paid and needs to be entered into the spreadsheet. You will need to add a new row and make sure that the formulae still work (check they include the new row).
3. Delete order 1006 as the customer has returned the item. You simply need to delete this row. 
This screen shot shows I have changed order 1001. You should comment on what changes it made to your totals 
Here I have highlighted that I have inserted a row and added order number 1014. 
Here I have highlighted that I have deleted order number 1006 which as been cancelled by a customer. |
Inserting a new row | ||||||||
| NOW PRINT YOUR SPREADSHEET OUT IN EXCEL AFTER making sure you have used PRINT PREVIEW to check your work fits on one page. | |||||||||
| You must also print your work in formula view so that we can see what formulae or functions you may have used. See the video below on how to do this. |
How to use formula view in Excel
[local /wp-content/uploads/2010/05/formula_view.flv nolink]
How to use the sum function
[local /wp-content/uploads/2010/06/using-sum-function.flv]
How to format your cells
[local /wp-content/uploads/2010/06/Formatting-cells.flv]
How to use the average function
[local /wp-content/uploads/2010/06/using-average-function.flv]
How to insert headers and footers in Excel
[local /wp-content/uploads/2010/06/inserting-headers-and-footers-in-excel.flv]
