Working with Multiple Workbooks. Lesson 4 – Microsoft Excel 2010. Learning Goals.
Lesson 4 – Microsoft Excel 2010
The goal of this lesson is for students to successfully work with an entire workbook in Microsoft Excel 2010. The student will learn to move between workbooks and worksheets, copy, move, freeze areas of a worksheet, insert and delete worksheets in a workbook as well as apply filters to data within the worksheet.
Ribbon Method: Home, Cells, Format, (Insert, Move or Copy, Rename, etc)
Home, Editing, Sort & Filter, choose method.
Worksheet names are different from file names—
they can contain up to 31 characters!
There is NO need to put the word “Sheet” at the end of a worksheet name.
Remember: File names can contain up to 255 characters!
FALSEThere are three methods to copy a worksheet.
FALSEAny sheet may be moved.
Please add the following vocabulary terms to your list of terms and definitions.
Complete the following assignments.
When complete, save and submit.
Excel Lesson 4 – Exercise 1
Excel Lesson 4 – Project 1