1 / 17

Exploring Microsoft Excel 2003

Exploring Microsoft Excel 2003. Chapter 1 – Introduction to Excel: What is a Spreadsheet? Robert Grauer and Maryann Barber. Committed to Shaping the Next Generation of IT Experts. Introduction to Spreadsheets. Spreadsheet – a computerized ledger Divided into rows and columns

kerri
Download Presentation

Exploring Microsoft Excel 2003

An Image/Link below is provided (as is) to download presentation 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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Exploring Microsoft Excel 2003 Chapter 1 – Introduction to Excel: What is a Spreadsheet? Robert Grauer and Maryann Barber Committed to Shaping the Next Generation of IT Experts. Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  2. 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 Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  3. Rows, Columns, and Cells Cell referenced by column, then number Active cell surrounded by heavy border Column headings above each column. Columns designated with letters Row headings to the left of each row. Rows designated with numbers Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  4. Types of Cell Entries • Constant – an entry that does not change • Can be a numeric value or descriptive text • Function – a predefined computational task • Formula – a combination of numeric constants, cell references, arithmetic operators, and functions • Always begins with an equal sign Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  5. 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 Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  6. An Excel Workbook Menu bar gives lists of commands Formatting toolbar Title bar shows name of workbook Standard toolbar Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  7. The Active Cell, Formula Bar, and Worksheet Tabs Formula bar displays contents of active cell Active cell is highlighted Click tabs to move to a different worksheet Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  8. Modifying the Worksheet:The Insert Command Can be used to add rows, columns, or cells Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  9. Modifying the Worksheet:The Delete Command If deleting a cell, specify whether to move other cells up or to the left Specify whether you’re deleting cell, row, or column Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  10. Display the Cell Formulas Ctrl ~ Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  11. 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 Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  12. 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 Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  13. Absolute and Relative References Absolute references are used to refer to the weight of each exam. These weights do not change for each student, so absolute references are needed to keep those references constant as the formula is copied Relative references are used to refer to each student’s exam scores. These scores do change for each student, so relative references are needed to make sure each student’s average reflects his/her scores Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  14. Compute the Student Semester Averages Absolute and relative references used in formulas Create the formula in cell E4 and copy to other cells Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  15. Isolating the Assumptions New student averages are automatically recalculated Enter new exam weights in row 13 Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  16. 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 Exploring Office 2003 Vol 1 2/e - Grauer and Barber

  17. The Format Cells Command Number tab allows you to specify appearance of numbers Alignment tab specifies vertical and horizontal alignment Font tab allows you to specify font type and size Borders and Patterns tabs allow you to create special effects Exploring Office 2003 Vol 1 2/e - Grauer and Barber

More Related