Practical Exercises:
Go to the following website and do the exercise at the end of the page(which is also shown below):
http://www.homeandlearn.co.uk/excel2007/excel2007s7p4.html
Exercise 1.
You've had a meeting with your staff, and it has been decide that a price change from 25 to 35 is not a good idea. A better idea is to sell more items. You still want a profit of 35 000. Use Goal Seek to find out how many items you'll have to sell to meet your new profit figure.
Other References:
Exercise 2
You are required to purchase items for school for your little brother but you have to make a trade between how much to spend for each so that he goes to school with pocket money of KSh. 2000 out of the KSh. 20,000 you have.
shoes = 2,000
Milk = 1,500
Bread = 500
Socks = 500
Books = 10,000
Pens = 500
Pens = 1000
Uniform = 7,000
Using goal seek, adjust the necessary items above so that your little brother goes with 2,000 pocket money as the balance to school.
Make use of Absolute Cell referencing in this question.
http://www.acu.edu/technology/trainingcenter/prot/trainingcenter/documents/ExcelAdvanced/Excel_Advanced_Lesso16.pdf
Go to the following website and do the exercise at the end of the page(which is also shown below):
http://www.homeandlearn.co.uk/excel2007/excel2007s7p4.html
Exercise 1.
You've had a meeting with your staff, and it has been decide that a price change from 25 to 35 is not a good idea. A better idea is to sell more items. You still want a profit of 35 000. Use Goal Seek to find out how many items you'll have to sell to meet your new profit figure.
Other References:
Exercise 2
You are required to purchase items for school for your little brother but you have to make a trade between how much to spend for each so that he goes to school with pocket money of KSh. 2000 out of the KSh. 20,000 you have.
shoes = 2,000
Milk = 1,500
Bread = 500
Socks = 500
Books = 10,000
Pens = 500
Pens = 1000
Uniform = 7,000
Using goal seek, adjust the necessary items above so that your little brother goes with 2,000 pocket money as the balance to school.
Make use of Absolute Cell referencing in this question.
http://www.acu.edu/technology/trainingcenter/prot/trainingcenter/documents/ExcelAdvanced/Excel_Advanced_Lesso16.pdf
