Excel Lesson 1

1. Excel Lesson 1 • Define the terms spreadsheet and worksheet. • Identify the parts of the worksheet. • Move the highlight in the worksheet. • Select cells and enter data in the worksheet. • Edit cells. • Find and replace data. • Zoom in and out in a worksheet. • Save a worksheet. • Print a worksheet

2. Excel Lesson 2 • Change column width and row height. • Position text within a cell by wrapping, rotating, indenting, and aligning. • Change the appearance of cells using fonts, styles, colors, and borders. • Designate the format of a cell to accommodate different kinds of text and numerical data. • Apply and paint formats. • Create and use styles. • Find and replace cell formats.

3. Excel Lesson 3 • Copy data to other cells. • Move data to other cells. • Insert and delete columns and rows. • Freeze titles. • Split a workbook screen. • Use print options when printing a worksheet. • Check the spelling of words in a worksheet.

4. Excel Lesson 4 • Enter and edit formulas. • Distinguish between relative, absolute, and mixed cell references. • Use the AutoSum button and the point-and-click method of entering formulas. • Preview a calculation. • Display formulas in the worksheet. • Perform immediate and delayed calculations.

5. Excel Lesson 5 • Identify the parts of a function formula. • Use function formulas to solve mathematical problems. • Use function formulas to solve statistical problems. • Use function formulas to solve financial problems. • Use function formulas to insert times and dates in a worksheet. • Use logical function formulas to make decisions with worksheet data.

6. Excel Lesson 6 • Sort data in a worksheet. • Use the AutoFilter to extract specified data from the worksheet. • Hide worksheet columns or rows. • Use the Drawing toolbar. • Insert a picture in a worksheet. • Use Excel templates to format a worksheet. • Insert a hyperlink in a worksheet file. • Save a workbook in a different file format. • Add and edit comments.

7. Excel Lesson 7 • Name worksheets in a workbook. • Color worksheet tabs. • Hide and unhide a worksheet. • Change the position of a worksheet. • Insert and delete worksheets in a workbook. • Link data between worksheets. • Create three-dimensional references. • Print workbooks and portions of workbooks. • Arrange workbooks. • Move and copy worksheets.

8. Excel Lesson 8 • Identify the purpose of charting worksheet data. • Identify the types of worksheet charts. • Create a chart sheet and save a chart. • Switch between charts and worksheets, zoom, and rename a chart. • Preview and print a chart. • Create an embedded chart. • Edit a chart and change the type of chart.

9. EXCEL Projects/Activities • RQ Lesson 1Page 22 & 24, True/False & Project 1-1 • Lesson 1 Vocabulary Page 22 • Lesson 2 • Step by Steps, Nigel Budget • RQ Page 48 & 50, T/F & Project 2-1 • Project 2-4; Cell Bill • Lesson 3 • Step by Steps, Utilities Expenses (print) • RQ Page 76 & 78, T/F & Project 3-1 • Project 3-7;Booster Club (print) • Project 4-1 and Project 4-2, page 101 • RQ Lesson 4/5Page 100 & 121-122, T/F, T/F, and Fill in the blank • Lesson 4 • Step by Steps, Drink Sales • Lesson 5 • Step by Steps, Functions Worksheet & Occidental Optical • Lesson 4 & 5 Projects & Activities (refer to other board) • Lesson 6 • Step by Steps, Oil Production • Print Time Card • RQ Page 158, T/F & Matching • Project 6-7; Compact Cubicle • Lesson 8 • RQ Page 199, T/F & Fill in blank • Project 8-4; Family Expenses

10. TEST TODAY  Please remember no talking, looking at other people’s computer, using the Internet, etc. You will receive a ZERO!!! Once you are done, please sit quietly!

11. Place your belongings at your assigned seat. • Log in & open your Excel Unit Review Folder • Bring a pen or pencil with a sheet of paper to the desks along with your book. • Leave a desk in between you.