Year 9

Autumn2-Week3-HW (To bring on the 23-11-17)

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?
2)Explain the alternative method to enter a function using just the mouse ( not the keyboard )

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)

  1. What is the difference between a function and a formula?
  2. What is the function to count the number of items in a range? Give an example.
  3. 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

  1. What is a spreadsheet?
  2. What are the different parts of a spreadsheet?
  3. What is a formula? give some examples.
  4. what is a function? give some examples.
  5. 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

Cambridge IGCSE ICT

Assalamu Alaikum everyone, To find out about the Cambridge IGCSE course, please press the link below: Cambridge IGCSE 0417   To do...