Vocabulary

⚫ active cell ⚫ Formula Bar

⚫ active worksheet ⚫ landscape orientation
⚫ adjacent range ⚫ Microsoft Excel 2010
Excel Lesson 1

⚫ cell (Excel)
⚫ cell reference ⚫ Name Box
⚫ column ⚫ nonadjacent range
⚫ formula ⚫ portrait orientation

1 Pasewark & Pasewark Microsoft Office 2010 Introductory

 Vocabulary (continued)

⚫ range
⚫ range reference
⚫ row
Excel Lesson 1

⚫ sheet tab
⚫ spreadsheet
⚫ workbook
⚫ worksheet

2 Pasewark & Pasewark Microsoft Office 2010 Introductory

 Introduction to Spreadsheets

⚫ Microsoft Excel 2010 is the spreadsheet

program in Microsoft Office 2010.
⚫ A spreadsheet is a grid of rows and columns
Excel Lesson 1

in which you enter text, numbers, and the

results of calculations.
⚫ In Excel, a computerized spreadsheet is
called a worksheet. The file used to store
worksheets is called a workbook.
3 Pasewark & Pasewark Microsoft Office 2010 Introductory
 Starting Excel

⚫ You start Excel from the Start menu in

Windows. Click the Start button, click All
Programs, click Microsoft Office, and then
Excel Lesson 1

click Microsoft Excel 2010.

⚫ The Excel program window has the same
basic parts as all Office programs: the title
bar, the Quick Access Toolbar, the Ribbon,
Backstage view, and the status bar.

4 Pasewark & Pasewark Microsoft Office 2010 Introductory

 Starting Excel (continued)

⚫ Excel program window

Excel Lesson 1

5 Pasewark & Pasewark Microsoft Office 2010 Introductory

 Exploring the Parts of the
Workbook

⚫ Each workbook contains three worksheets by

default. The worksheet displayed in the work
area is the active worksheet.
Excel Lesson 1

⚫ Columns appear vertically and are identified

by letters. Rows appear horizontally and are
identified by numbers.
⚫ A cell is the intersection of a row and a
column. Each cell is identified by a unique
cell reference.
6 Pasewark & Pasewark Microsoft Office 2010 Introductory
 Exploring the Parts of the
Workbook (continued)

⚫ The cell in the worksheet in which you can type

data is called the active cell.
⚫ The Name Box, or cell reference area, displays
Excel Lesson 1

the cell reference of the active cell.

⚫ The Formula Bar displays a formula when a
worksheet cell contains a calculated value.
⚫ A formula is an equation that calculates a new
value from values currently in a worksheet.

7 Pasewark & Pasewark Microsoft Office 2010 Introductory

 Opening an Existing Workbook

⚫ Opening a workbook means loading an

existing workbook file from a drive into the
program window.
Excel Lesson 1

⚫ To open an existing workbook, you click the

File tab on the Ribbon to display Backstage
view, and then click Open in the navigation
bar. The Open dialog box appears.

8 Pasewark & Pasewark Microsoft Office 2010 Introductory

 Opening an Existing Workbook
(continued)

⚫ Frogs workbook open in Excel

Excel Lesson 1

9 Pasewark & Pasewark Microsoft Office 2010 Introductory

 Saving a Workbook

⚫ The Save command saves an existing

workbook, using its current name and save
location.
Excel Lesson 1

⚫ The Save As command lets you save a

workbook with a new name or to a new
location.

10 Pasewark & Pasewark Microsoft Office 2010 Introductory

 Moving the Active Cell in a
Worksheet

⚫ The easiest way to change the active cell in a

worksheet is to move the pointer to the cell
you want to make active and click.
Excel Lesson 1

⚫ You can display different parts of the

worksheet by using the mouse to drag the
scroll box in the scroll bar to another position.
⚫ You can also move the active cell to different
parts of the worksheet using the keyboard or
the Go To command.
11 Pasewark & Pasewark Microsoft Office 2010 Introductory
 Selecting a Group of Cells

⚫ A group of selected cells is called a range.

The range is identified by its range reference,
for example, A3:C5.
Excel Lesson 1

⚫ In an adjacent range, all cells touch each

other and form a rectangle.
– To select an adjacent range, click the cell in a
corner of the range, drag the pointer to the cell in
the opposite corner of the range, and release the
mouse button.
12 Pasewark & Pasewark Microsoft Office 2010 Introductory
 Selecting a Group of Cells
(continued)

⚫ A nonadjacent range includes two or more

adjacent ranges and selected cells.
– To select a nonadjacent range, select the first
Excel Lesson 1

adjacent range or cell, press the Ctrl key as you

select the other cells or ranges you want to
include, and then release the Ctrl key and the
mouse button.

13 Pasewark & Pasewark Microsoft Office 2010 Introductory

 Entering Data in a Cell

⚫ Worksheet cells can contain text, numbers,

or formulas.
– Text is any combination of letters and numbers
Excel Lesson 1

and symbols.
– Numbers are values, dates, or times.
– Formulas are equations that calculate a value.
⚫ You enter data in the active cell.

14 Pasewark & Pasewark Microsoft Office 2010 Introductory

 Changing Data in a Cell

⚫ You can edit, replace, or clear data.

⚫ You can edit cell data in the Formula Bar or
in the cell. The contents of the active cell
Excel Lesson 1

always appear in the Formula Bar.

⚫ To replace cell data, select the cell, type new
data, and press the Enter button on the
Formula Bar or the Enter key or the Tab key.
⚫ To clear the active cell, you can use the
Ribbon, the keyboard, or the mouse.
15 Pasewark & Pasewark Microsoft Office 2010 Introductory
 Searching for Data

⚫ The Find command locates data in a

worksheet, which is particularly helpful when
a worksheet contains a large amount of data.
Excel Lesson 1

You can use the Find command to locate

words or parts of words.
⚫ The Replace command is an extension of the
Find command. Replacing data substitutes
new data for the data that the Find command
locates.
16 Pasewark & Pasewark Microsoft Office 2010 Introductory
 Searching for Data (continued)

⚫ Find and Replace options

Excel Lesson 1

17 Pasewark & Pasewark Microsoft Office 2010 Introductory

 Zooming a Worksheet

⚫ You can change the magnification of a

worksheet using the Zoom controls on the
status bar.
Excel Lesson 1

⚫ The default magnification for a workbook is

100%.
⚫ For a closer view of a worksheet, click the
Zoom In button or drag the Zoom slider to
the right to increase the zoom percentage.
18 Pasewark & Pasewark Microsoft Office 2010 Introductory
 Zooming a Worksheet (continued)

⚫ Zoom dialog box and controls

Excel Lesson 1

19 Pasewark & Pasewark Microsoft Office 2010 Introductory

 Previewing and Printing a
Worksheet

⚫ You can print a worksheet by clicking the File

tab on the Ribbon, and then clicking Print in
the navigation bar to display the Print tab.
Excel Lesson 1

⚫ The Print tab enables you to choose print

settings.
⚫ The Print tab also allows you to preview your
pages before printing.

20 Pasewark & Pasewark Microsoft Office 2010 Introductory

 Closing a Workbook and Exiting
Excel

⚫ You can close a workbook by clicking the File

tab on the Ribbon, and then clicking Close in
the navigation bar. Excel remains open.
Excel Lesson 1

⚫ To exit the workbook, click the Exit command

in the navigation bar.

21 Pasewark & Pasewark Microsoft Office 2010 Introductory