Task C
1. In cell I4, enter the word “New” and in cell I5 enter the word “salary”. Make sure that they are both bold and centred in their cells.
2. In cell I6, enter a formula to calculate a new salary. Everyone in the sales department are going to get a pay rise of £200. All other departments are only going to receive £100. Use the =IF function to do the calculation. For example, if the value in cell D6 is “Sales” then add 200 to cell E6, otherwise add 100 to cell E6.
3. Copy this formula down to cells I7 to I12.
4. Format column I so that each value appears with a comma separator for thousands and no decimal places.
5. Save the spreadsheet with the name S3Exercise2C
Your worksheet should look like the following:
