Transcript PPT

Exploring Microsoft
Excel 2003
Chapter 1 – Introduction to
Excel: What is a Spreadsheet?
Robert Grauer and Maryann Barber
Officethe
2003Next
Vol 1 2/e
- Grauer and of IT Experts.
Committed toExploring
Shaping
Generation
Barber
1
Introduction to Spreadsheets


Spreadsheet – a computerized ledger
Divided into rows and columns



Columns identified with alphabetic headings
Rows identified with numeric headings
Cell – the intersection of a row and a column

Cell reference uniquely identifies a cell

Consists of column letter and row number
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
2
Rows, Columns, and Cells
Cell referenced by
column, then number
Active cell surrounded
by heavy border
Row headings to the left
of each row. Rows
designated with numbers
Column headings above
each column. Columns
designated with letters
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
3
Types of Cell Entries

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
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
4
Introduction to Microsoft Excel

Common user interface with other Office
applications



Menus and toolbars are similar to Word and
Power Point
Workbook – contains one or more
worksheets
Worksheet – an Excel spreadsheet
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
5
An Excel Workbook
Menu bar gives lists of
commands
Formatting toolbar
Standard toolbar
Title bar shows name
of workbook
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
6
The Active Cell, Formula Bar, and
Worksheet Tabs
Formula bar displays
contents of active cell
Active cell is
highlighted
Click tabs to move to a
different worksheet
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
7
Modifying the Worksheet:
The Insert Command
Can be used to add
rows, columns, or cells
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
8
Modifying the Worksheet:
The Delete Command
If deleting a cell, specify
whether to move other cells
up or to the left
Specify whether you’re
deleting cell, row, or
column
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
9
Display the Cell Formulas
Ctrl ~
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
10
The Print Preview Command
View and adjust
margins by clicking
the Margins button
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
11
Using Cell Ranges

Range – a rectangular group of cells



May be a single cell or the entire worksheet
May consist of a row (or part of a row), a column
(or part of a column) or multiple rows and/or
columns
To select a range:



Click left mouse button at the beginning of the
range
Hold left mouse button as you drag the mouse
Release left mouse button at the end of the range
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
12
Cell Referencing

Absolute reference: remains constant when
copied


Relative reference: adjusts during a copy
operation


Specified with dollar signs before the column and
row
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 Office 2003 Vol 1 2/e - Grauer and
Barber
13
Absolute and Relative References
Absolute references are used to refer to the weight of
each exam. These weights do not change for each
student, so absolute references are needed to keep
those references constant as the formula is copied
Relative references are used to refer to each student’s exam scores.
These scores do change for each student, so relative references are
needed to make sure each student’s average reflects his/her scores
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
14
Compute the Student Semester
Averages
Absolute and
relative references
used in formulas
Create the formula
in cell E4 and copy
to other cells
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
15
Isolating the Assumptions
New student averages
are automatically
recalculated
Enter new exam
weights in row 13
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
16
Formatting Cells


Format Cells command – controls the
formatting for numbers, alignment, fonts,
borders, and patterns (color)
Select-then-do


Select the cells to which the formatting will apply
Execute the Format Cells command
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
17
The Format Cells Command
Number tab allows you to
specify appearance of
numbers
Alignment tab specifies
vertical and horizontal
alignment
Font tab allows you to
specify font type and size
Borders and Patterns
tabs allow you to create
special effects
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
18
The Completed Worksheet
Shading is used to
identify labels and
assumptions, and to
show class averages.
Exploring Office 2003 Vol 1 2/e - Grauer and
Barber
19