CHAPTER 7 Introduction to Microsoft Excel 2007 OBJECTIVES
CHAPTER 7 Introduction to Microsoft Excel 2007
OBJECTIVES 1. Identify uses of the spreadsheet in general as well as for healthcare applications 2. Define basic terminology related to spreadsheets 3. Review selected functions for using Excel 2007
Common Spreadsheet Terms • Rows • Run horizontally across the spreadsheet • Columns • Go vertically down the spreadsheet • Cell • Placeholder for data • Cell Address (Cell Reference) • Label for each cell
Common Spreadsheet Terms • Active Cell • Cell that is currently being used • Range (Block) • Group of cells in a rectangular pattern • Workbook (Notebook) • A collection of spreadsheet pages • Worksheet • Spreadsheet made up of labels, values, lines or borders, and formulas
Spreadsheet Screen Display • Current Cell Address • Indicates the active cell • Formula Toolbar • Data entered appears in this location • Message Area • Shows which actions will occur when a function is activated
Getting Ready to Use a Spreadsheet • Which type of data is needed in the spreadsheet • Are monthly, quarterly, or yearly intervals needed • Is there a need to make comparisons of data • How many data elements or time intervals are there
Accomplishing Tasks in the Worksheet • Entering Data • Saving Worksheets • Using Charts • Axis • Categories • Chart type • Data series • Legend
Introduction to Excel 2007 • The Ribbon in Excel: Microsoft’s “Fluent User Interface: • Entering Data and Correcting Errors • The Mouse Pointer • Using Auto. Fill • Moving Around in the Worksheet • Viewing the Worksheet
Introduction to Excel 2007 • Working with Multiple Worksheets • Working with Multiple Workbooks • Numbers and Formulas • Formulas and Functions • Absolute Cell Addresses • Sorting Data • Scenarios
- Slides: 9