ROAD TRIP

1
ROAD TRIP!

• If you could go anywhere in the USA, where would
  you go?

2
Pick a Destination

• Go to www.mapquest.com and find out how far your
  destination is from the school.
• Now, figure out the round trip mileage.
• (there and back)
• How many MPG (miles per gallon) does your car
  get? If you dont know, guess!
• How much is one gallon of gasoline?

3
Spreadsheets

• A Spreadsheet is an easy way to calculate how
  much your trip will cost you.
• After today you will be able to
• Explain the uses and advantages of spreadsheets
• Explain basic spreadsheet terms

4
Microsoft Excel

• Just like our database software, Access, there
  are many types of spreadsheets.
• We will be using
• Microsoft Excel

5
Example of an Excel Spreadsheet

• Basic Terminology for Spreadsheets
• Worksheet
• Workbook
• Columns
• Rows
• Cells
• Labels
• Values
• Formulas

6
Worksheet
A worksheet is one page in an Excel workbook.
To change which sheet you are looking at, click
here.
7
Workbook
A Workbook is the collectionof worksheets that
make up the Excel file.So, Sheet 1, Sheet
2,and Sheet 3 are the Workbook.
8
Columns
Columns are vertical (up and down) series of
cells identified by a letter of the alphabet.
9
Rows
Rows are a horizontal seriesof cells identified
by a number.
10
Cells
Cells are the intersection of columnsand rows
(letter and number). EXAMPLE Area (sq. in.) is
in columnC and in Row 1. So it is cell C1.
11
Labels
Labels are text or anything thatis non-numerical
(not a number). So, the labels in this worksheet
are Length (in.), Width (in), and
Area (sq. in.)
12
Values
Values are numerical data that can beused in
calculations. Every number in this worksheet is
a Value.
13
Formulas

• Formulas are mathematical equations used to
  calculate values.
• Formulas take values (numbers in a spreadsheet)
  and do math with them to create another value.

14
Tutorial

• There is a good tutorial at this website if you
  want more practice
• http//spreadsheets.about.com/od/excel101/a/Exc
  el_beg_guide.htm