Introduction to Spreadsheet

1
Chapter 1

• Introduction to Spreadsheet

2
Agenda

• Download the practice files
• Spreadsheet application
• Workbook and worksheet
• Toolbar
• Cell
• Formatting
• Printing

3
Download Files

• http//www.prenhall.com/grauer
• Office 2003
• Student Download tab
• Exploring Excel 2003 Revised Edition
• Save to selected the drive and folder

4
Unzip Files

• Double click exp2003_xlsrev_data.exe
• Click run
• Click ok
• Click unzip
• Double click Exploring_Excel directory to look
  files

5
Spreadsheet Application

• A managerial tool to perform what if repetitive
  calculation
• To improve decision making
• To increase productivity

6
Workbook and Worksheet

• Workbook includes one or more worksheet
• Worksheet is a spreadsheet
• Spreadsheet
• A computerized ledger
• Divided into rows and columns to form cells
• Operation
• Open, close, save, save as, print
• Insert, delete, move, copy, rename

7
Toolbar

• Appear beneath the menu bar
• Standard toolbar buttons correspond to most
  basic commands in Excel
• Opening, closing, and saving a workbook
• Formatting toolbar buttons correspond to common
  formatting operations
• Boldface and cell alignment
• Display toolbar
• View, toolbar
• View, toolbar, customize, options

8
Cell

• The intersection of a row and a column
• Cell reference uniquely identifies a cell with
  its column letter and row number

9
Cell - Type of Cell Entry

• Constant an entry that does not change
• Can be a numeric value or descriptive text
• Function a predefined computational task
• Formula a combination of numeric constants, cell
  references, arithmetic operators, and functions
• Always begins with an equal sign

10
Cell - Range

• Range a rectangular group of cells
• A single cell
• The entire worksheet
• A row (or part of a row)
• A column (or part of a column)
• Multiple rows and/or columns

11
Cell - Reference

• Absolute reference remains constant when copied
• With dollar signs before the column and row
• Relative reference adjusts during a copy
  operation
• Without dollar signs before the column and row
• Mixed reference either the row or the column is
  absolute the other is relative
• With a dollar sign before the absolute part of
  the reference

12
Cell - Operation

• Select cells with Ctrl key and Shift key
• Delete or insert cell, row, or column
• Column or row width
• Formula, calculation
• Copy, cut, paste
• AutoCompete (tool, option, edit)
• Display cell formula
• Tool, options, view, formula
• Press Ctrl
• Display formula auditing toolbar (view, toolbar)

13
formatting

• Method
• Format menu
• Format toolbar
• Right click the selected cell or cells
• Clear format edit, clear
• Merge cells format, cells, alignment

14
Printing

• Page setup
• Page, margin, header, footer, sheet
• Print preview

15
Points to Remember

• Spreadsheet application
• Workbook and worksheet
• Toolbar
• Cell
• Formatting
• Printing

16
Assignment

• Practice exercises 3 and 4
• Due date