FEBRUARY 18-22, 2008 END OF THE 6 WEEKS!

http://www.quia.com/quiz/1266409.html--QUIZ STUDENT EXPECTATION THIS WEEK: Consolidate data from two or more worksheets add subtotals to a worksheet outline a list of data create a "Best case" & Worst Case scenariou use goal seek & solver create a pivot table and pivotchart report manipulate pivot table create a pivotchart report from web data refresh Pivottable and PivotChart data 1) Warm-Up- Learn2type -http://learn2type.com/TypingTest 2)ASSIGNMENTS THIS WEEK CLICK ON ASSIGNMENT TO DOWNLOAD 3)REVIEW FOR QUIZ RAGS TO RICHES--> http://www.quia.com/rr/312824.html - 2/19/08, pg 252-254, Statement of Operations, create a best case scenario 2/19/08, pg 254-255, Open yesterdays->xxxStatement of Operations, create a worst case scenario 2/20/08, pg 255-256,Open yesterdays->xxxStatement of operations, Create a trendline 2/20/08, pg257-260, Open yesterdays->xxxStatement of Operations, Use goal seek& solver 2/21/08, pg 264-268, Sales by Groups, Create a pivotTable report&chart 2/22/08, pg 278, Loan Options, Compare home loans

3) Freerice.com-http://www.freerice.com/index.php
FRIDAY'S QUIZ IN QUIA OVER Vocabulary& concepts covered.
VOCABULARY ORGANIZER

1. 3-D Reference
2. consolidate
3. constraint
4. goal seek
5. outline
6. PivotChart
7. PivotTable
8. PivotTable & PivotChart Wizard
9. Polynomial trendline
10. refresh
11. scenario
12. solver
13. subtotals
14. summary function
15. trendline

REVIEW FOR QUIA QUIZ-->http://www.quia.com/rr/312824.html