Waste Management
Yr 10 Geography

Excel Basics

• A = Colum
• 4 = Row
• Fx = formula bar (this is where you type)

How to insert borders.

High light relevant cells

Here it is!

How to add number together.
1.
2.
3.
4.
5.
6.

7.
8.

What to do
Click on the cell that you want to hold the total in
e.g. B12
In the formula bar type the following
=
SUM (Means add together) (
Click on cell B5 go to the handle on the outside of the cell and drag down to
B10
)
Press enter

Your table now has a total!

How to create a column graph.

Here is your graph but it’s not complete!

How to insert a vertical axis.

How to label your axis.

Click and type in the details for the axis.

How to move the key or legend.

How to move the key or legend.

Here it is!

How to create a pie graph?

How to add numbers together.
1.
2.
3.
4.
5.
6.
7.
8.

What to do
Click on the cell that you want to hold the total in
e.g. B15
In the formula bar type the following
=
SUM (Means add together) (
Click on cell B5 go to the handle on the outside of the cell and drag down
)
Press enter

So it looks like this!

How to write a correct formula to calculate a percentage. 1.
2.
3.
4.
5.
6.
7.
8.
9.

In the formula bar type
=
(
The first cell with data e.g.
B5
/ (divided by sign)
$
The column letter e.g B
$
The cell number with the total in it.
Then hit enter

How to turn your answer in a %

What to do.
1. Highlight your cells 2. Click on number tab 3. Select Percentage

How to round up the percentage.

What to do.
1. Highlight percentages
2. Click on the number tab
3. Click on decrease decimal button Now it looks like this!

How to hide columns.
1.
2.
3.
4.

What to do.
Highlight cell B
Right Click on cell B
Select Hide
Now your table only has 2 columns

How to sort your data from largest to smallest What to do.
1. Highlight your percentage column.
2. Select Sort &Filter

How to sort your data from largest to smallest What