Microsoft Excel 2007 Level 1 & 2
Rutkosky, Seguin, Rutkosky
2008 by Paradigm Publishing, Inc
Chapter 1
Pages 7-36
• Identify the various elements of an Excel Workbook
• Create, Save, and print a workbook
• Enter data in a workbook
• Edit data in a workbook
• Insert a formula using the Sum button
• Apply predesigned formatting to cells in a workbook
• Use the Help feature
Skills Check
Pages 33-34 1-4
Chapter 2
Pages 37-66
• Write formulas with mathematical operators
• Type a formula in the Formula bar
• Copy a formula
• Use the Insert Function feature to insert a formula in a cell
• Write formulas with AVERAGE, MAX, MIN, COUNT, PMT, FV, DATE, NOW and IF functions
• Create an absolute and mixed cell reference