Download
exploring microsoft excel n.
Skip this Video
Loading SlideShow in 5 Seconds..
Exploring Microsoft Excel PowerPoint Presentation
Download Presentation
Exploring Microsoft Excel

Exploring Microsoft Excel

935 Vues Download Presentation
Télécharger la présentation

Exploring Microsoft Excel

- - - - - - - - - - - - - - - - - - - - - - - - - - - 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. Objectives (1 of 2) • Describe what a spreadsheet is and potential applications • Explain how the rows and columns of a spreadsheet are identified, and how its cells are labeled. • Distinguish between a formula and a constant • Open, save, print a workbook; insert and delete rows and columns Exploring Microsoft Excel 2002 Chapter 1

  3. Objectives (2 of 2) • Describe the three-dimensional nature of a workbook; distinguish between a workbook and a worksheet • Print worksheet with values or formulas • Copy and/or move cells within a worksheet • Differentiate between relative, absolute, and mixed references • Use Page Setup to print worksheet and preview before printing • Format a worksheet to include changing the font or appearance, borders, and alignment Exploring Microsoft Excel 2002 Chapter 1

  4. Overview • Introduction to spreadsheets and Excel • Show wide diversity of spreadsheet applications • Fundamentals of spreadsheets using Excel • Worksheet recalculates automatically after changes Exploring Microsoft Excel 2002 Chapter 1

  5. 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

  6. 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

  7. Excel XP Exploring Microsoft Excel 2002 Chapter 1

  8. Excel XP Worksheet Exploring Microsoft Excel 2002 Chapter 1

  9. Hands-On Exercise 1 • Objective: To start Microsoft Excel, to open, modify, and save an existing workbook • Welcome to Windows • Obtain the practice files • Start Microsoft Excel • Open the workbook • The Save As command • The Active Cell, Formula Bar and Worksheet tabs • Experiment (What If?) • The Office Assistant Exploring Microsoft Excel 2002 Chapter 1

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

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

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

  13. Hands-On Exercise 2 • Objective: To open an existing workbook; to insert and delete rows and columns;to modify the appearance of a printed workbook. • Open the workbook • Delete a row • Insert a row • Use the AutoComplete feature • Insert a column • Display the cell formulas • The Page Setup command • The Print Preview command • Insert and Delete a worksheet Exploring Microsoft Excel 2002 Chapter 1

  14. 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

  15. 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

  16. 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

  17. 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

  18. Hands-On Exercise 3 • Objective: to create a new worksheet; to copy formulas containing relative and absolute references • Start Excel • Save the workbook • Enter student data and literal information • Compute the student semester average • Copy the semester average • Compute class averages • What If? Change exam weights Exploring Microsoft Excel 2002 Chapter 1

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

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

  21. Format Cells Command Exploring Microsoft Excel 2002 Chapter 1

  22. Hands-On Exercise 4 • Objective: to format a worksheet using boldface, italics, shading, and borders; to change the font and/or alignment of an entry. • Center the title across selection • Format the exam weights • Format the class averages • Borders and color • Print the workbook • Use the Page Setup command to modify the appearance of the printed workbook • Print the cell formulas Exploring Microsoft Excel 2002 Chapter 1

  23. 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

  24. 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