Working with Multiple Workbooks. Lesson 4 – Microsoft Excel 2010. Learning Goals.
Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.
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