exploring office 2003 - grauer and barber

1. Exploring Office 2003 - Grauer and Barber 1 Exploring Microsoft Excel 2003

2. Exploring Office 2003 - Grauer and Barber 2

3. Exploring Office 2003 - Grauer and Barber 3 Introduction to Spreadsheets Spreadsheet – a computerized ledger Divided into rows and columns Columns identified with alphabetic headings Rows identified with numeric headings Cell – the intersection of a row and a column Cell reference uniquely identifies a cell Consists of column letter and row number

4. Exploring Office 2003 - Grauer and Barber 4 Rows, Columns, and Cells

5. Exploring Office 2003 - Grauer and Barber 5 Types of Cell Entries Labels Constant – an entry that does not change Letters, Numbers, Titles Values – Contain the numeric data Function – a predefined computational task Formula – a combination of numeric constants, cell references, arithmetic operators, and functions Always begins with an equal sign

6. Exploring Office 2003 - Grauer and Barber 6 Introduction to Microsoft Excel Common user interface with other Office applications Menus and toolbars are similar to Word and Power Point Workbook – contains one or more worksheets Worksheet – an Excel spreadsheet

7. Exploring Office 2003 - Grauer and Barber 7 Toolbars Appear beneath the menu bar Contain buttons that perform commonly-used commands Standard toolbar – buttons correspond to most basic commands in Excel Examples include opening, closing, and saving a workbook Formatting toolbar – buttons correspond to common formatting operations Examples include boldface and cell alignment

8. Exploring Office 2003 - Grauer and Barber 8 The File Menu Contains most common commands related to Excel files Examples: New command creates a new workbook Open command opens an existing workbook Save command saves a workbook Save As command saves a copy of an existing workbook under a different name or file type Print command prints all or part of a worksheet

9. Exploring Office 2003 - Grauer and Barber 9 An Excel Workbook

10. Exploring Office 2003 - Grauer and Barber 10 Opening a Workbook

11. Exploring Office 2003 - Grauer and Barber 11 The Save As Command

12. Exploring Office 2003 - Grauer and Barber 12 The Active Cell, Formula Bar, and Worksheet Tabs

13. Exploring Office 2003 - Grauer and Barber 13 Using the Help System

14. Exploring Office 2003 - Grauer and Barber 14 Modifying the Worksheet:The Insert Command

15. Exploring Office 2003 - Grauer and Barber 15 Modifying the Worksheet:The Delete Command

16. Exploring Office 2003 - Grauer and Barber 16 Page Setup

17. Exploring Office 2003 - Grauer and Barber 17 Page Setup (continued)

18. Exploring Office 2003 - Grauer and Barber 18 Display the Cell Formulas

19. Exploring Office 2003 - Grauer and Barber 19 The Print Preview Command

20. Exploring Office 2003 - Grauer and Barber 20 Using Cell Ranges Range – a rectangular group of cells May be a single cell or the entire worksheet May consist of a row (or part of a row), a column (or part of a column) or multiple rows and/or columns To select a range: Click left mouse button at the beginning of the range Hold left mouse button as you drag the mouse Release left mouse button at the end of the range

21. Exploring Office 2003 - Grauer and Barber 21 Copying and Moving Cells Copy command – duplicates the contents of a cell or range of cells Source range – the cell(s) you are copying from Destination range – the cell(s) you are copying to You can copy to more than one destination ranges Move operation – transfers the contents of a cell or range to another cell or range You must use both the Copy (or Cut) command and the Paste command

22. Exploring Office 2003 - Grauer and Barber 22 Cell Referencing Absolute reference: remains constant when copied Specified with dollar signs before the column and row Relative reference: adjusts during a copy operation Specified without dollar signs, i.e. B4 Mixed reference: either the row or the column is absolute; the other is relative Specified with a dollar sign before the absolute part of the reference, i.e. B$4

23. Exploring Office 2003 - Grauer and Barber 23 Absolute and Relative References

24. Exploring Office 2003 - Grauer and Barber 24 Compute the Student Semester Averages

25. Exploring Office 2003 - Grauer and Barber 25 Isolating the Assumptions

26. Exploring Office 2003 - Grauer and Barber 26 Formatting Cells Format Cells command – controls the formatting for numbers, alignment, fonts, borders, and patterns (color) Select-then-do Select the cells to which the formatting will apply Execute the Format Cells command

27. Exploring Office 2003 - Grauer and Barber 27 The Format Cells Command

28. Exploring Office 2003 - Grauer and Barber 28 The Completed Worksheet

29. Exploring Office 2003 - Grauer and Barber 29 Summary Spreadsheet - the computerized equivalent of an accountant’s ledger Divided into rows and columns Worksheet - an Excel spreadsheet Workbook - contains one or more worksheets Cells can contain label, value, formula or function Insert and Delete commands Cells Rows columns The Page Setup command provides complete control over the printed page

30. Exploring Office 2003 - Grauer and Barber 30 Summary (continued) Range - a cell or range of cells Formulas in a cell may be copied or moved to other cells Absolute reference remains the same when it is copied Relative reference adjusts when it is copied Cells can be formatted in a variety of ways Select cells, then apply formatting