Introduction to Microsoft Excel: What is a Spreadsheet

1
Exploring Microsoft Excel

• Chapter 1
• Introduction to Microsoft Excel What is a
  Spreadsheet?
• By
• Robert T. Grauer
• Maryann Barber

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

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

4
Overview

• Introduction to spreadsheets and Excel
• Show wide diversity of spreadsheet applications
• Fundamentals of spreadsheets using Excel
• Worksheet recalculates automatically after changes

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

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

7
Excel XP
8
Excel XP Worksheet
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

10
Modifying the Worksheet

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

11
Modifying the Worksheet

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

12
Modifying the Worksheet

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

13
Hands-On Exercise 2

• Objective To open an existing workbook to
  insert and delete rows and columnsto 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

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

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)

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

17
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

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

19
Excel XP Formatting

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

20
Types of Numeric Formats

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

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

21
Format Cells Command
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

23
Summary (1 of 2)

• Spreadsheet is computerized accountants 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!!

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