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

Loading in 2 Seconds...

play fullscreen
1 / 24

Exploring Microsoft Excel - PowerPoint PPT Presentation


  • 865 Views
  • Uploaded on

Exploring Microsoft Excel Chapter 1 Introduction to Microsoft Excel: What is a Spreadsheet? By Robert T. Grauer Maryann Barber Objectives (1 of 2) Describe what a spreadsheet is and potential applications

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Exploring Microsoft Excel' - lotus


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
exploring microsoft excel

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

slide2

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

slide3

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

overview
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

introduction to spreadsheets
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

introduction to excel
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

excel xp
Excel XP

Exploring Microsoft Excel 2002 Chapter 1

excel xp worksheet
Excel XP Worksheet

Exploring Microsoft Excel 2002 Chapter 1

slide9

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

modifying the worksheet
Modifying the Worksheet
  • Insert command
    • can be used to add individual rows, columns, or cells

Exploring Microsoft Excel 2002 Chapter 1

modifying the worksheet11
Modifying the Worksheet
  • Delete command
    • can be used to delete individual rows, columns, or cells

Exploring Microsoft Excel 2002 Chapter 1

modifying the worksheet12
Modifying the Worksheet
  • Page Setup command and dialog box
    • A dialog box lets you give information to Excel

Exploring Microsoft Excel 2002 Chapter 1

slide13

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

excel features and commands 1 of 2
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

excel features and commands 2 of 2
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

getting around the worksheet
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

cell referencing
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

hands on exercise 3
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

excel xp formatting
Excel XP Formatting
  • Column widths
  • Row Heights
  • Numeric Format
  • Alignment
  • Fonts
  • Borders, Patterns, and Shading

Exploring Microsoft Excel 2002 Chapter 1

types of numeric formats
General

Number

Currency

Accounting

Date

Time

Percentage

Fraction

Scientific

Text

Special

Custom

Types of Numeric Formats

Exploring Microsoft Excel 2002 Chapter 1

format cells command
Format Cells Command

Exploring Microsoft Excel 2002 Chapter 1

hands on exercise 4
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

summary 1 of 2
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

summary 2 or 2
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