Class Test: Absolute cell Referencing and Goal Seek Exercises

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

References download powerpoint slides

http://oc.course.com/np/office2007/excel.cfm


Download nice powerpoint slides here

Student Data Files

Follow these links to get your data files for New Perspectives on Microsoft Excel 2007:

• Managing Your Files
• Getting Started with Office 2007
• Excel Tutorial 1
• Excel Tutorial 2
• Excel Tutorial 3
• Excel Tutorial 4
• Excel Tutorial 5
• Excel Tutorial 6
• Excel Tutorial 7
• Excel Tutorial 8
• Excel Tutorials 9-12
• Excel Appendix A
• Excel Appendix B
• Excel Appendix C
• Excel Appendix D
• Excel Additional Cases
•  
•  
•  

• New Perspectives on Microsoft PowerPoint 2007

  Welcome to the New Perspectives on Microsoft PowerPoint 2007 home page. From this page you can access your Student Data Files, Internet Assignments, and PowerPoint Presentations.
  Go to: Student Data Files | Internet Assignments | PowerPoint Presentations| CourseCasts
  Student Data Files
  Follow these links to get your data files for New Perspectives on Microsoft PowerPoint 2007:
• Managing Your Files
• Getting Started with Office 2007
• PowerPoint Presentation Concepts Tutorial 1
• PowerPoint Presentation Concepts Tutorial 2
• PowerPoint Tutorial 1
• PowerPoint Tutorial 2
• PowerPoint Tutorials 3-4
• PowerPoint Tutorials 5-6

back to top

Internet Assignments

Follow these links if your instructor has assigned you an Internet Assignment:

• PowerPoint Presentation Concepts Tutorial 1
• PowerPoint Presentation Concepts Tutorial 2
• PowerPoint Tutorial 1
• PowerPoint Tutorial 2
• PowerPoint Tutorial 3
• PowerPoint Tutorial 4
• PowerPoint Tutorial 5
• PowerPoint Tutorial 6

back to top

PowerPoint Presentations

Follow these links to access the PowerPoint Presentations to accompany your text:

• Managing Your Files
• Getting Started with Office 2007
• PowerPoint Tutorial 1
• PowerPoint Tutorial 2
• PowerPoint Tutorial 3
• PowerPoint Tutorial 4
• PowerPoint Tutorial 5
• PowerPoint Tutorial 6
• PowerPoint Presentation 1
• PowerPoint Presentation 2

•  
•  

• New Perspectives on Microsoft Word 2007

  Welcome to the New Perspectives on Microsoft Word 2007 home page. From this page you can access your Student Data Files, Internet Assignments, PowerPoint Presentations.
  Go to: Student Data Files | Internet Assignments | PowerPoint Presentations| CourseCasts
  Student Data Files
  Follow these links to get your data files for New Perspectives on Microsoft Word 2007:
• Managing Your Files
• Getting Started with Office 2007
• Word Tutorial 1
• Word Tutorial 2
• Word Tutorial 3
• Word Tutorial 4
• Word Tutorial 5
• Word Tutorial 6
• Word Tutorial 7
• Word Tutorials 8-10
• Word Appendix A
• Word Additional Cases

back to top

Internet Assignments

Follow these links if your instructor has assigned you an Internet Assignment:

• Word Tutorial 1
• Word Tutorial 2
• Word Tutorial 3
• Word Tutorial 4
• Word Tutorial 5
• Word Tutorial 6
• Word Tutorial 7
• Word Tutorial 8
• Word Tutorial 9
• Word Tutorial 10

back to top

PowerPoint Presentations

Follow these links to access the PowerPoint Presentations to accompany your text:

• Managing Your Files
• Getting Started with Office 2007
• Word Tutorial 1
• Word Tutorial 2
• Word Tutorial 3
• Word Tutorial 4
• Word Tutorial 5
• Word Tutorial 6
• Word Tutorial 7
• Word Tutorial 8
• Word Tutorial 9
• Word Tutorial 10

•  
•  
•  

• New Perspectives on Microsoft Access 2007

  Welcome to the New Perspectives on Microsoft Access 2007 home page. From this page you can access your Student Data Files, Internet Assignments, and PowerPoint Presentations.
  Go to: Student Data Files | Internet Assignments | PowerPoint Presentations| CourseCasts
  Student Data Files
  Follow these links to get your data files for New Perspectives on Microsoft Access 2007:
• Managing Your Files
• Getting Started with Office 2007
• Access Tutorials 1-4
• Access Tutorials 5-8
• Access Tutorials 9-12
• Access Additional Cases

back to top

Internet Assignments

Follow these links if your instructor has assigned you an Internet Assignment:

• Access Tutorial 1
• Access Tutorial 2
• Access Tutorial 3             Clubs.accdb
• Access Tutorial 4
• Access Tutorial 5             Adventure Outdoors.accdb
• Access Tutorial 6
• Access Tutorial 7
• Access Tutorial 8
• Access Tutorial 9
• Access Tutorial 10
• Access Tutorial 11
• Access Tutorial 12

back to top

PowerPoint Presentations

Follow these links to access the PowerPoint Presentations to accompany your text:

• Managing Your Files
• Getting Started with Office 2007
• Access Tutorial 1
• Access Tutorial 2
• Access Tutorial 3
• Access Tutorial 4
• Access Tutorial 5
• Access Tutorial 6
• Access Tutorial 7
• Access Tutorial 8
• Access Tutorial 9
• Access Tutorial 10
• Access Tutorial 11
• Access Tutorial 12

•  

Microcomputer Resources: Links

http://oc.course.com/np/office2007/FirstCoursepremium.cfm

More resources will be posted out soon

What if for polynomials

How to Use Excel to Solve a Polynomial

A polynomial in mathematics is the sum of a number of terms that are added, subtracted, or multiplied. A polynomial can have one term like 1, x, y, or z, or it can have multiples terms: for example, x^3 + 10 ^ 2 + 4 is a polynomial. Solving a polynomial means that you have to find a value for the X in the equation. This is sometimes called finding a root of a polynomial or finding the zeros. Excel can do this task for you.

Instructions

1.       

• 1

Input the coefficients into separate cells in row 4 in Excel, starting at cell "B4." for example, if you have a cubic equation x^3 - 2x^2 - 3x, then your coefficients are 1, -2, 6 and -3. Click on cell "B4" and type "1", then click on cell "C4" and type "-2," then click on cell "D4" and type "6," then click on cell "E4" and type "-3."

• 2

Click on cell "B6" and type a guess for the value of X. If you have no idea of what the value might be, just type "0."

 3

Click on cell "G4" and then type the full equation into the cell. In this example, the equation would be "x^3 - 2x^2 - 3x."

• 4

Click on the "Data" tab, then click on "What-If Analysis," in the Data Tools group and then click "Goal Seek."

• 5

Click on the "Set cell" text box and type "G4."

• 6

Click on the "To value" text box and then type "0."

• 7

Click on the "By changing cell" text box and then type "$B$6."

• 8

Click on "OK." Excel will solve the polynomial and return the result in cell B6 (the initial guess box).

Read more: How to Use Excel to Solve a Polynomial | eHow.com http://www.ehow.com/how_6824958_use-excel-solve-polynomial.html#ixzz25WzuEQJ2

10.6.1.Create a 'What-If' Scenario with Goal Seek

Click any cell within the list range.            Click the Data tab.             Click the What-If Analysis button, and then click Goal Seek.

Click the Set Cell box, and then type the cell address.            Click the To Value box, and then type the result value.            Click the By Changing Cell box, and then type the cell address you want Excel to change.            Click OK.

The Goal Seek Status dialog box, opens displaying the goal seek results.