Introduction to Microsoft Excel: What is a Spreadsheet

1
Exploring Microsoft Excel

• Chapter 1
• Introduction to Microsoft Excel What is a
  Spreadsheet?

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

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

4
Excel XP
5
Excel XP Worksheet
6
Modifying the Worksheet

• Insert command
• can be used to add individual rows, columns, or
  cells

7
Modifying the Worksheet

• Delete command
• can be used to delete individual rows, columns,
  or cells

8
Modifying the Worksheet

• Page Setup command and dialog box
• A dialog box lets you give information to Excel

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

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)

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

12
Cell Referencing

• Absolute reference remains constant throughout
  a copy operation
• Specified with a dollar sign before the column
  and row, i.e. B4
• 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. B4

13
Excel XP Formatting

• Column widths
• Row Heights
• Numeric Format
• Alignment
• Fonts
• Borders, Patterns, and Shading

14
Types of Numeric Formats

• General
• Number
• Currency
• Accounting
• Date
• Time

• Percentage
• Fraction
• Scientific
• Text
• Special
• Custom

15
Format Cells Command