Working with spreadsheets/Spreadsheet calculations/Formulas
|Working with spreadsheets|
|Spreadsheet calculations||Introduction | Arithmetic | Functions | Formulas | Key points | Assessment|
Occasionally its handy to be able see all of your formulas (insead of the results) in your spreadsheet. Click on:
- Formulas > Formula Auditing > Show Formulas
Or use the keyboard shortcut Ctrl ~
If you print from this view you will print your formulas out. Press Ctrl~ again to revert the sheet back to normal.
Formatting a spreadsheet
Before we go on to add more data and formulas to the spreadsheet, lets look at how to use some more features for formatting in Excel :
Please note: the following link will open in a new window/tab. When you have finished, simply close the window/tab and you'll return to this page.
Extending the spreadsheet
We often need to change a spreadsheet to meet future needs. In the next activity we will add more data and formulas.
Mr Mann has provided us with some more information for his spreadsheet. He knows that this year there will be some increases in his expenses. He would also like to start drawing some income from his shop.
Mr Mann has given us some figures based on previous years sales, for projected income for the rest of the year:
You will need to:
Mr Mann would like a grand total for the year. If he adds up all his monthly totals he can see if he is in the black, or in the red!
Mr Mann can see that he is going to end the year at a loss. As we are already in April for the current business year, how much extra income per month is Mr Mann going to have to generate to come out in the black by the end of December? (Hint, use the extra line in your income section.)