PPT-1 Excel Lesson 3 Organizing the Worksheet

Microsoft Office 2010 Introductory Pasewark amp Pasewark 2 2 2 Objectives Copy and move data in a worksheet Use the draganddrop method and Auto Fill options to add data to cells Insert and delete rows columns and cells. Ashley Delaney. Environment. Grade Level: Kindergarten. Subject: Math. Topic: Subtraction. Setting: Learning Center. Standards. K.OA 1. Represent addition and subtraction with objects, fingers, mental images, drawings, sounds (e.g., claps), acting out situations, verbal explanations, expressions, or equations.. 5. Working with Multiple Worksheets. and . Charts. Microsoft Office 2010 Introductory. Pasewark & Pasewark. Moving Between Worksheets. A workbook is a collection of worksheets. Each worksheet is identified with a sheet tab at the bottom of the workbook window.. Working with Multiple Worksheets. and Workbooks. Microsoft Office 2010 Introductory. Pasewark & Pasewark. 2. 2. 2. Objectives. Move between worksheets in a workbook.. Rename worksheets and change the sheet tab color.. Lesson 1 – Microsoft Excel 2010. History of Excel, Part 1. History of Excel, Part 2. Learning Goals. The goal of this lesson is for students to successfully explore and describe the Excel window and to create a new worksheet. The student will learn to edit a worksheet, save the workbook and properly exit the program.. Workbook. A workbook is another word for your Excel file. Excel automatically creates a blank workbook when you open it.. Open an Existing Workbook. To open a workbook you've created in the past, execute the following steps.. uses . a language . to implement all of the functional capability of the application.. VBA . (Visual Basic for Applications. ). . is that language.. Use VBA to tell Excel what to do:. C. reate your own new functions. and . Charts. Microsoft Office 2010 Introductory. Pasewark & Pasewark. Moving Between Worksheets. A workbook is a collection of worksheets. Each worksheet is identified with a sheet tab at the bottom of the workbook window.. Microsoft Office 2010 Introductory. Pasewark & Pasewark. 2. 2. 2. Objectives. Define the terms . spreadsheet . and . worksheet.. Identify the parts of a worksheet.. Start Excel, open an existing workbook, and save a workbook.. Objectives. Understand the use of spreadsheets and Excel. Learn the parts of the Excel window. Scroll through a worksheet and navigate between worksheets. Create and save a workbook file. Enter text, numbers, and dates into a worksheet. Fill in the Listening Guide as you view this presentation.. Excel Window. Label the parts of the Excel window as you view the next slide. G. File Tab. Quick Access toolbar. Title bar. Top Level Tabs. Microsoft Office 2010 Introductory. Pasewark & Pasewark. 2. 2. 2. Objectives. Define the terms . spreadsheet . and . worksheet.. Identify the parts of a worksheet.. Start Excel, open an existing workbook, and save a workbook.. Microsoft Office 2010 Introductory. Pasewark & Pasewark. 2. 2. 2. Objectives. Copy and move data in a worksheet.. Use the drag-and-drop method and Auto Fill options to add data to cells.. Insert and delete rows, columns, and cells.. Microsoft Office 2010 Introductory. Pasewark & Pasewark. 2. 2. 2. Objectives. Identify the parts of a function. . Enter formulas with functions. . Use functions to solve mathematical problems.. Use functions to solve statistical problems. . Microsoft Office Excel 2007 . Formulas, Functions, Formatting, and Web Queries. Objectives . . Chapter Topics .