Let

1
(No Transcript)
2
Lets learn a bit about Excel
Excel is used to create spreadsheets which keep
track of numerical data
They help to answer How Many?
3
Spreadsheets are used to organize data that
includes numbers.
People who track budgets, inventories, payrolls,
and scientific data,
might also use spreadsheets to create
charts graphs.
4
Spreadsheets are made up of vertical columns and
horizontal rows.
------------------------This is a row
------------------------
This is a column.
a cell
Each of the boxes in a spreadsheet is called a
cell.
5
Each cell has a specific name consisting of a
column letter and a row number.
C1
D5
E9
What information is in cell A6? B2?
6
If you dont know where to find something LOOK!!
You will find Chart in the Insert menu. Choose
the type in the directions.
7
Select Cells A1 to F1. Go to the Format menu and
choose Format Cells
Choose the Alignment Tab and click on Merge
cells, then click on OK
8
Lets Change the Font. Go to the Format menu and
choose Format Cells.
Choose the Font Tab and select a font, color, and
size, then click on OK
9

• Put 25 in cell B2
• Go to the Edit menu
• Choose Fill
• Choose Down

Put your heading in the merged cells. Write the
colors of the color wheel in column A.
10

• Go to the Insert menu
• Choose Chart

Click and drag to select all the colors in column
A and numbers in column B
11
The Chart Wizard will pop up Choose Pie Chart
Click to get a preview
12
We now have a chart but the colors do not match
the labels!
13
Click into the little colored box to the left of
the word Red

• There is a little trick to selecting that box
• First select the box with all the labels
• Then select the word
• Then select the little box

Choose the color closest to the label and click OK
14
Now we have a proper color wheel!
15
Change the number for the primary colors so they
are larger.
Change the number for the tertiary colors so they
are smaller.
16
Double clicking into the slices will give you a
Format Data Series pop up window for changing how
the slices look

Selecting specific slices will also allow you to
move them The BEST LOOKING pie chart will get a
PRIZE!!
17
(No Transcript)
18
Select Cells A1 to F1. Go to the Format menu and
choose Format Cells
Choose the Alignment Tab and click on Merge
cells, then click on OK
19
Lets Change the Font. Go to the Format menu and
choose Format Cells.
Choose the Font Tab and select a font, color, and
size, then click on OK
20
(No Transcript)
21

• Put your heading in the merged cells.
• Open your package of Skittles.
• Write down the colors in Column A
• Write down how many of each color in Column B

No Eating Yet!!!
22

• Click into Cell B7
• Go to the Insert Menu
• Choose Function

Functions start with an equals sign Choose Sum
OK
23
The formula for addition is SUM (cell cell
) We are adding cells B2 to B6 If you change
any of the numbers, the sum will change
24
Make a Bar Graph!
The Best Looking bar graph will get a Prize!!!
25
(No Transcript)
26
Select Cells A1 to F1. Go to the Format menu and
choose Format Cells
Choose the Alignment Tab and click on Merge
cells, then click on OK
27
Lets Change the Font. Go to the Format menu and
choose Format Cells.
Choose the Font Tab and select a font, color, and
size, then click on OK
28
Decide on a theme for your party and reflect that
in your spreadsheet
List up to 10 party items in column A label
Party Items Column B is for Cost of Each,
Column C is for Amount or Quantity
29
We will insert a space for a picture in front of
column A
Select the whole Column A by clicking into the
cell labeled A Go to the Insert menu and choose
Columns
30
(No Transcript)
31
If you have a pic to use, go to the Insert menu,
Choose Picture and From File
You could also copy and paste something from the
internet Adjust your column width to fit your
image
32
When we work with money we need to format the
cells for currency.

• Select cells C2 to C11 only
• Choose the Format menu
• Click on Cells
• Click on the Number tab
• Choose Currency

33
Put a price for each item in column C. The format
will put in the dollar sign.
Put in a number for the amount based on the
number of guests, etc.
34

• Select cell E2 only
• Go to the Insert menu and choose Function
• We want to multiply the cost of each item by the
  quantity
• Choose the function PRODUCT Click on OK

35
The function automatically chooses the correct
cells to multiply. The formula is PRODUCT (C2
D2)
Click on OK The formula does the work and the
cell is filled with the correct answer
36
Click and drag from cell E2 to cell E11 Go to
Edit and Choose Fill Down The formula will copy
down in direct relation to the cells in that row
Format the cells in column E for currency
37
In Cell E 12, put the formula that will add up
all your expenses.
There will be a prize for the Best Looking
Correct Spreadsheet!