EXCEL PROJECT 3

What-If Analysis and Working
with Large Worksheets

Essential Questions

How is text rotated within a cell? How is a series of month names created? What is the function of the Format Painter button? How are additional cells inserted or deleted from a worksheet? What are smart tags? How are numbers formatted using format symbols? What is the purpose of Freezing cells? How is the system date displayed and formatted? What is the purpose of an absolute cell reference? How is the IF function used to perform a logical test?

How is a drop shadow added to a range of cells? How is a 3-D Pie chart created on a separate chart sheet? How can color be added to worksheet tabs? How are worksheets rearranged within a workbook? How are multiple sheets previewed and printed? How is the Zoom box used to change the worksheet view? How can you view different parts of the worksheet through window panes? How can Excel be used to answer what-if questions?

TERMS FOR EXCEL PROJECT 3

1. Drawing toolbar 2. assumptions 3. Format Painter button 4. Increase Indent button 5. drag and drop 6. #REF! error message 7. format symbol 8. Freeze Panes command 9. NOW function 10. absolute referencing 11. mixed cell reference

12. IF function 13. logical test 14. comparison operator 15. floating toolbar 16. toolbar dock 17. pie chart 18. exploded pie chart 19. leader lines 20. Split commands 21. what-if analysis 22. Goal Seek command

ASSIGNMENTS

Excel Review and Classroom Procedures 1) Review classroom procedures 2) Distribute passwords and review network procedures 3) Review Excel from Applied I with demo 4) Complete Lab 2 from Excel project 2 pp. 2.71-2.73 (print) 5) Work on vocabulary definitions as presented in class. August 25-September 2 Creating a Table Using Excel Shortcuts for Formatting Rows and Columns pp. 3.04-3.24 1) Class follows demo of the creation of a table of Awesome Intranet's six-month finance al projections 2) Begin Lab 1 part 1 numbers 1- 5, 8 & 9 pp. 3.69-3.71 3) Continue with vocabulary September 3-5

Using Absolute Cell References and the If Function pp. 3.25-3.43 1) Class follows demo using formulas and if function to fill in the table data 2) Students complete Lab 1 part 1 pp. 3.69-3.71 3) Continue with vocabulary September 8-11 Adding a 3-D Pie Chart to the Workbook pp. 3.43-3.57 1) Class follows demo - creating a 3-D pie chart on a separate sheet within the workbook 2) Complete Lab 1 part 2 p. 3.71 (print the table and the chart) 3) Complete vocabulary (print) September 12-17 Additional exercises 1) Complete Learn It Online activities for review 2) Complete Practice Test located in the Handout Folder Tentative Test Date for Project 3 is Thursday September 19