Spreadsheet - Merit/Distinction
Spreadsheet - on the level -
Carry out these tasks and provide the appropriate evidence.
You will be making a number of changes to the spreadsheet, highlighting the changes and explaining what you have done and the effect it has had, so make sure you save each file as an appropriate version.
Your data must be accurate so check that you have entered all the data accurately.
Make sure your spreadsheet is appropriately formatted and 'looks easy to read'
You should be printing the gridlines and in landscape format, also add your name as a header/footer and the date and page number
-
the chocolution has discovered that it is in fact liable to pay VAT. Insert a
row and calculate VAT for each week.
You will need to calculate the VAT for each item, then for each week.
Reprint the spreadsheet, highlighting the change and explain what you have done and the effect it has had on the totals.
- Due to the nature of Tax Laws, you can only earn £104 per week with no tax being taken to be spent
on things like bombs and guns. Work out how many clients you can have per week within your unit that will keep you
below the Tax Limit of £104 per person per week.
Show all your working out.
Project your figures for one whole year - how much money can you earn collectively.
Spreadsheet - next level -
- Using the last version of the spreadsheet:
You need to calculate the income/expenditure for each of the 4 months. Put this information into a different section of the worksheet, include appropriate headings:
Income for month one / two / three / four -
Print out this part of the spreadsheet only, include a header/footer to explain what you have done.
Print out the formula
- You need to know the average amount of income and expenditure for each of the 4 months. Insert another column
and using an appropriate formula calculate the average sales and expenditure.
Print out this section of the spreadsheet only, include the appropriate header/footer explaining what you have done.
Print out the formula