Exploring microsoft excel
Download
1 / 24

Exploring Microsoft Excel - PowerPoint PPT Presentation


  • 846 Views
  • Updated 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

Related searches for Exploring Microsoft Excel

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 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
Excel XP

Exploring Microsoft Excel 2002 Chapter 1


Excel xp worksheet l.jpg
Excel XP Worksheet

Exploring Microsoft Excel 2002 Chapter 1


Slide9 l.jpg

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 l.jpg
Modifying the Worksheet

  • Insert command

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

Exploring Microsoft Excel 2002 Chapter 1


Modifying the worksheet11 l.jpg
Modifying the Worksheet

  • Delete command

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

Exploring Microsoft Excel 2002 Chapter 1


Modifying the worksheet12 l.jpg
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 l.jpg

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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg
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 l.jpg

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 l.jpg
Format Cells Command

Exploring Microsoft Excel 2002 Chapter 1


Hands on exercise 4 l.jpg
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 l.jpg
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 l.jpg
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


ad