Introduction
In this activity you will build on what we did last time.
Start by downloading and opening this spreadsheet.
This is what it should look like
Task SP1
Improve the appearance of the spreadsheet by…
- Formatting cell B20 to currency
- Adding outline borders to cells D10, D18, D20 and D22
- Changing the fill colour of all the cells with titles to pale blue
- Changin the fill colour of all the cells containing text to pale yellow
- Changing the fill colour of all the cells containing a formula to pale green
- Changing the fill colour of all the cells with a "sum function" to pale red
- Add the title SP1 to the header
- Add your name to the footer
- Save the spreadsheet as SP1
- Print the spreadsheet
How the spreadsheet should look at the end of this stage
SP2
You need to make some changes to the layout of the spreadsheet
- Insert THREE extra ROWS above the heading "Staffing Budget"
- Add the title "EXPENDITURE" in cell A4
- Make the font size 18
- Make the text bold
- Set the background colour to Pale Blue
- Add the title SP2 to the header
- Add your name to the footer
- Save the spreadsheet as SP2
- Print the spreadsheet
SP3
You are now going to add the INCOME part of the spreadsheet
- Type the word INCOME in cell F4
- Make the font size 18
- Make the text bold
- Set the background colour to Pale Blue
- Type the words "Projected Monthly Income Figures" in cell F6
- Make the text bold
- Set the background colour to Pale Blue
- Add the headings "Item", "Monthly Income" and "Annual Income" to cells F8, G8 and H8.
- Add the other data as show in the screenshot below
- Adjust the width of columns so the contents fit
- Add the title SP3 to the header
- Add your name to the footer
- Save the spreadsheet as SP3
- Print the spreadsheet
SP4
The Annual Income is calculated by multplying the Monthly Income x 12
- Enter the formula =G9*12 into cell H9
- Copy the formula down the column
Add a formula to calculate the total of the annual income
- Enter the formula into cell H15
- Adjust the spreadsheet so that it is in formula view (Excel > Preferences > View > select "show formulas")
- Adjust the width of columns so the contents fit
- Add the title SP4 to the header
- Add your name to the footer
- Save the spreadsheet as SP4
- Print the spreadsheet
SP5
Make some final adjustments to the spreadsheet before the final printout
- Change back to data view (Excel > Preferences > View > de-select "show formulas")
- Format the relevant cells to currency
- Format the colour of the cells
- Add the word Total
- Draw a box round the total
After Stage Five
- Adjust the width of columns so the contents fit
- Add the title SP5 to the header
- Add your name to the footer
- Save the spreadsheet as SP5
- Print the spreadsheet