The Visibooks Guide To Excel 2003.pdf

(13475 KB) Pobierz
The Visibooks Guide to Excel 2003
82062808.001.png
Table of Contents
Performing Basic Calculations ....................... 1
Add ..............................................................................................16
Subtract.......................................................................................24
Multiply........................................................................................27
Divide...........................................................................................31
Calculate averages .....................................................................35
Find the maximum value............................................................39
Formatting Worksheets ................................ 43
Format text..................................................................................44
Format cells ................................................................................55
Adjust columns and rows..........................................................63
Adjust columns and rows..........................................................64
Print worksheets.........................................................................71
TABLE OF CONTENTS
i
Manipulating Data .........................................81
Move, copy, and paste............................................................... 82
Add/delete columns ................................................................... 88
Add/delete rows ......................................................................... 94
Employ multiple worksheets..................................................... 99
Employ AutoFill........................................................................ 101
Insert/delete worksheets ......................................................... 107
Advanced Calculations ...............................113
Create formulas across worksheets....................................... 114
Employ absolute references ................................................... 120
Employ the function wizard .................................................... 129
Making Data Visible ....................................139
Add comments ......................................................................... 140
Freeze panes ............................................................................ 143
Create charts ............................................................................ 147
ii
TABLE OF CONTENTS
Performing Basic
Calculations
In this section, you’ll learn how to:
•
Add
•
Subtract
•
Multiply
•
Divide
•
Calculate averages
•
Find the maximum value
PERFORMING BASIC CALCULATIONS
1
1. Click the
button.
When the menu appears, click All Programs , Microsoft Office ,
then Microsoft Office Excel 2003 .
2
PERFORMING BASIC CALCULATIONS
82062808.002.png 82062808.003.png

Plik z chomika:

Inne pliki z tego folderu:

Inne foldery tego chomika:

Zgłoś jeśli naruszono regulamin