Formative Task 3 - Using Formulas and Formatting

Open your previous T2_Music Spreadsheet and then resave it using Save As - call the new version surname_firstname_T3_FF

You are now going to modify your spreadsheet by doing the following:

Insert three new columns at the end - Total, Revenue and iTunes Profit (28%)

Format the cells in your Spreadsheet to make it look more interesting. (It should look something like the image below.)

You now need to create the Formulas you need for each of these new columns!

1) To calculate Total you need to add up everything from Monday to Saturday e.g. K3 =SUM(E3:J3)

2) To calculate the Revenue you need to multiply the Total number of songs sold by the Song Cost. e.g. L3 =D3*K3

3) To calculate iTunes Profit you need to work out 28% of Revenue e.g. M3 =(L3*28/100)