1 / 17

Exploring Microsoft Excel

Exploring Microsoft Excel. Chapter 1 Introduction to Microsoft Excel: What is a Spreadsheet? By Robert T. Grauer Maryann Barber. Introduction to Spreadsheets. Spreadsheet is a computerized ledger Divided into rows and columns Columns identified with alphabetic headings

kort
Download Presentation

Exploring Microsoft Excel

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 Chapter 1 Introduction to Microsoft Excel: What is a Spreadsheet? By Robert T. Grauer Maryann Barber Exploring Microsoft Excel 2002 Chapter 1

  2. Introduction to Spreadsheets • Spreadsheet is a computerized ledger • Divided into rows and columns • Columns identified with alphabetic headings • Rows identified with numeric headings • Cell references • Constants--entries that do not change • Formulas--combination of constants and functions Exploring Microsoft Excel 2002 Chapter 1

  3. Introduction to Excel • Common user interface on all Office applications • Menus and toolbars are similar to Word and Power Point • Worksheet is an Excel spreadsheet • Workbook contains one or more worksheets • Toolbars--Standard and Formatting • File menu--Save, Save As, Open and Print commands Exploring Microsoft Excel 2002 Chapter 1

  4. Excel XP Exploring Microsoft Excel 2002 Chapter 1

  5. Excel XP Worksheet Exploring Microsoft Excel 2002 Chapter 1

  6. Modifying the Worksheet • Insert command • can be used to add individual rows, columns, or cells Exploring Microsoft Excel 2002 Chapter 1

  7. Modifying the Worksheet • Delete command • can be used to delete individual rows, columns, or cells Exploring Microsoft Excel 2002 Chapter 1

  8. Modifying the Worksheet • Page Setup command and dialog box • A dialog box lets you give information to Excel Exploring Microsoft Excel 2002 Chapter 1

  9. Excel Features and Commands (1 of 2) • Active cell • cell is surrounded by a heavy black border • entries are made into the active cell • Formula bar displays the contents of the active cell • located near the top of the worksheet • Status bar keeps you informed of what is happening as you work • located at the bottom of the worksheet Exploring Microsoft Excel 2002 Chapter 1

  10. Excel Features and Commands (2 of 2) • Toolbars contain icons that perform common commands • ScreenTips give helpful hints • appear when you hold the mouse over an icon or a commented cell • File Type compatible with Excel 2000 and Excel 97 • Save as Command • save as a different file name • save as a different file type (Excel 95 or another spreadsheet program) Exploring Microsoft Excel 2002 Chapter 1

  11. Getting around the Worksheet • A rectangular group of cells is a range • Copy duplicates contents of a cell from a source range to a destination range • Move transfer contents of a cell from one location to another Exploring Microsoft Excel 2002 Chapter 1

  12. Cell Referencing • Absolute reference: remains constant throughout a copy operation • Specified with a dollar sign before the column and row, i.e. $B$4 • 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 Microsoft Excel 2002 Chapter 1

  13. Excel XP Formatting • Column widths • Row Heights • Numeric Format • Alignment • Fonts • Borders, Patterns, and Shading Exploring Microsoft Excel 2002 Chapter 1

  14. General Number Currency Accounting Date Time Percentage Fraction Scientific Text Special Custom Types of Numeric Formats Exploring Microsoft Excel 2002 Chapter 1

  15. Format Cells Command Exploring Microsoft Excel 2002 Chapter 1

  16. Summary (1 of 2) • Spreadsheet is computerized accountant’s ledger • Spreadsheet is generic term; worksheet is an Excel term • Cells contain formulas or constants • A formula always begins with an equal sign • Formulas can be copied or moved anywhere within the worksheet. • Make sure you understand absolute, relative, and mixed cell referencing and when to use each!! Exploring Microsoft Excel 2002 Chapter 1

  17. Summary (2 or 2) • Page Setup gives you control over the appearance of the printed worksheet • Formatting is done by selecting the cell(s) you want to format, then applying the format you want • Use the Ctrl key to select non-contiguous cells or ranges of cells • Print worksheets with displayed values and formulas Exploring Microsoft Excel 2002 Chapter 1

More Related