Task 1 Instructions

Using a spreadsheet

Dave needs to work out how much money he is getting in from his top sellers at i-Downloads. He has sent you a list of the current top download tracks with information about how much they sell for and how many have been sold.

Download the information and type it into a spreadsheet.

Adjust the fonts, row heights and column widths to make sure all the information is displayed.

Make sure you have used sensible headings for each column

Task 2 Instructions

Using formulae

In the next available column, write in a formula that will work out the total income raised from the sale of the Nirvana downloads.

Use a formula, don't just work it out yourself.

Copy down the formula so that it works out the amounts raised for the other downloads

Task 3 Instructions

Using functions

Use the SUM function to total up all the income from top-eight downloads.

Use the AVERAGE function to work out the average number times each single has been downloaded.

Task 4 Instructions

Formatting a spreadsheet

Format the spreasheet so that all of the CURRENCY items display with a pound sign. Screenshot how you do this.

Add borders and titles to make the spreadsheet easy to understand and to improve the way it looks.

Put the words CONFIDENTIAL, the date, and page numbers into the header

Save the spreadsheet and call it i-downloads top eight

Task 5 Instructions

Inserting rows

The work you have done so far is great but Dave needs to make some quick adjustment to the spreadsheet. He thinks a top 10 would be better than a top eight.

Insert two more rows under the Take That single. Screenshot how to do this.

Now add the information

• Kaiser Cheifs, Ruby, £0.45, 97 downloads
• Nelly Furtado, Say It Right, £0.80, 66 downloads
  
  Save the spreadsheet and call it i-downloads top ten

Task 6 Instructions

What if...

Dave wants to raise the amount he collects each month from sales. He thinks that a good way to do this would be to put up his prices. He knows if he puts them up too high, no-one will buy from his site.

Change the prices that Dave is charging. Try to raise the total amount of sales to £800. Make sure you do not put one price up too high, and don't change the numbers of singles sold.

Save the spreadsheet and call it new prices

Task 7 Instructions

More formulae

Dave has realised that he has not taken expenditure into account on the spreadsheet. He need to know how much profit he is making.

To do this you will need to include an area for expenditure on the spreadsheet. Download the information.

Find the total expenditure.

Find the total profit by subtracting this from the income.

Save the spreadsheet and call it i-downloads profits

Task 8 Instructions

Deleting Rows

Dave has had a dispute with the record company. He must give all of the income from the sale of Queen's Bohemian Rhapsody directly to the record company.

This means Dave will make no profit from these sales.

Delete the Queen row from the spreadsheet and shift cells up. Screenshot how to do this.

Save the spreadsheet and call it final spreadsheet

Task 9 Instructions

Create a chart

Create a chart showing the total number of downloads for each of the top-ten singles.

Format the chart so that it has a correct title, and use colour in the chart to make it suitable for use in a newletter to customers.

Task 10 Instructions

Final Printing Checklist

Use Set Print Area and suitable landscape or portrait and print:
i-downloads top eight spreadsheet
Screenshots showing currency
i-downloads top ten spreadsheet
Screenshots showing add row
i-downloads profits spreadsheet
final spreadsheet
final spreadsheet in formula view
Screenshots showing delete row
the chart you have created