Transcript Lesson 1: Excel Basics Spreadsheets are used to maintain schedules, track expenses, and manage large-scale projects in a variety of careers.

2
Lesson 1: Excel Basics
Spreadsheets are used to maintain schedules,
track expenses, and manage large-scale
projects in a variety of careers.
2
Lesson 1: Excel Basics
An Excel file is called a workbook.
A workbook
contains one or
more sheets called
worksheets, also
known as
spreadsheets.
A worksheet contains data such
as numbers and formulas.
2
Lesson 1: Excel Basics
When you create
a new workbook,
it contains three
worksheets.
Click the sheet tabs to move from one worksheet to another.
2
Lesson 1: Excel Basics
A folder
helps you
organize
your files so
you can find
them
quickly.
One way to create a new folder is to use the Save As dialog box.
2
Lesson 1: Excel Basics
Worksheets
are made up
of boxes
called cells
that are
organized
into
horizontal
rows and
vertical
columns.
Cell
You can insert or edit data directly into
the cell or by using the formula bar.
2
Lesson 1: Excel Basics
A cell is
named by its
cell reference,
or its column
letter and row
number.
For example, cell A1 is in column A, row 1.
2
Lesson 1: Excel Basics
If you change
your mind or
make a
mistake while
working with
Excel, choose
Undo. This
will undo, or
reverse, your
last action.
To revert to the original choice, choose Redo.
2
Lesson 1: Excel Basics
To calculate a sum in Excel 2007, use a formula.
A formula is an equation
that begins with an
equal sign (=) and
includes values or cell
references.
2
Lesson 1: Excel Basics
The formula bar displays the formulas
and contents of selected cells.
Formulas allow you to
perform different
actions, such as adding
a column of numbers.
2
Lesson 1: Excel Basics
To print your worksheet, click the Print
button to open Print dialog box.
The Print
dialog box
allows choose
the printer, the
number of
copies that will
print, and
where the
document will
print.
2
Lesson 1: Excel Basics
Use Help to find
answers to any
questions you have
about using Excel.
Click the Help button to
open Help window, and
search for a topic.
2
Lesson 1: Excel Basics
Tech Check
How can you make everything in a
worksheet appear larger or smaller?
Answer:
To change the size of things in a
worksheet, choose the Zoom option.
2
Lesson 1: Excel Basics
Tech Check
How can you reverse your last action in
Excel if you make a mistake?
Answer:
To reverse your last action, choose
Undo.
2
Lesson 1: Excel Basics
Vocabulary Review
workbook
An Excel file that contains one or
more worksheets.
2
Lesson 1: Excel Basics
Vocabulary Review
worksheet
A sheet of cells organized into rows
and columns, sometimes also called
a spreadsheet.
2
Lesson 1: Excel Basics
Vocabulary Review
sheet tab
A small tab at the bottom of a
worksheet that allows you to move
from one worksheet to another
within the same workbook.
2
Lesson 1: Excel Basics
Vocabulary Review
ScreenTip
A description that appears when
you point to a button.
2
Lesson 1: Excel Basics
Vocabulary Review
cell
The intersection of a row and a
column in a table or worksheet.
2
Lesson 1: Excel Basics
Vocabulary Review
cell reference
The column letter and row number
of a cell.
2
Lesson 1: Excel Basics
Vocabulary Review
formula
An equation containing values, cell
references, or both.
2
Lesson 1: Excel Basics
Vocabulary Review
group
An organized set of commands
that relates to a specific activity.
2
Lesson 1: Excel Basics
Vocabulary Review
Quick Access Toolbar
An organized set of commands
that relates to a specific activity.