csci-235 micro-computers in science microsoft excel 2002 chapter 1 introduction to microsoft excel:...

CSCI-235Micro-Computers in Science

Microsoft Excel 2002

Chapter 1Introduction to Microsoft Excel:

What is a Spreadsheet?

Exploring Microsoft Excel 2002 Chapter 1

2

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

3

Excel XP Worksheet

Exploring Microsoft Excel 2002 Chapter 1

4

Modifying the Worksheet Insert command

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

Exploring Microsoft Excel 2002 Chapter 1

5

Modifying the Worksheet Delete command

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

Exploring Microsoft Excel 2002 Chapter 1

6

Modifying the Worksheet Page Setup command and dialog

box A dialog box lets you give information

to Excel

Exploring Microsoft Excel 2002 Chapter 1

7

Excel Features 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

Exploring Microsoft Excel 2002 Chapter 1

8

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

9

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

Exploring Microsoft Excel 2002 Chapter 1

10

Types of Numeric FormatsGeneral NumberCurrencyAccountingDateTime

PercentageFractionScientificTextSpecialCustom

Exploring Microsoft Excel 2002 Chapter 1

11

Format Cells Command