1) Cell referencing
- a)Why do we use absolute cell referencing?
- b)Give an example of where would you use absolute cell referencing?
- c)What is the shortcut to enter an absolute cell reference in a formula?
3)Give two reasons for naming cells or ranges?
4)Give two reasons, apart from cost, why computer models are often used instead of the real thing.
YOU DO NOT NEED EXCEL FOR THIS HOMEWORK.
Please provide you're HW in a presentable A4 paper
Autumn2-Week2-HW(To bring on the 16-11-17)
- What is the difference between a function and a formula?
- What is the function to count the number of items in a range? Give an example.
- What is the function to use when you have a condition? Give an example.
**************************************
Autumn2- Week1 HW(To bring on the 9-11-17)
Your topic next half term is Spreadsheets
- What is a spreadsheet?
- What are the different parts of a spreadsheet?
- What is a formula? give some examples.
- what is a function? give some examples.
- What is the most used application for spreadsheets?
Task:
Design a spreadsheet that can be used by a school tuck shop to find income, expenditure and profit over a period of time.(weekly, monthly or yearly)
* if you have any questions write them on the log comments. *Use your notebook to do this homewok
Make sure you show your formulas
you can use the template below
Resources and guidance : Click Here
No comments:
Post a Comment