Waste Management Graphs demo Essay

Submitted By MN11001
Words: 596
Pages: 3
Open Document
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
Show More

Related Documents: Waste Management Graphs demo Essay

Staples Case Essay

year. Formulating the idea was next on Stemberg agenda, he sought information on manufacturers and wholesalers and ways he could capitalize on genuine discounts. Next he assembled a team of people he knew who was experienced in various areas of management and whom he convinced to give up secure jobs, high salaries and annual bonuses for a 2% share in the company. Refining the concept, the team secured a $4.5 million from Bain Venture Capital and other investors, the team also convinced manufacturers…

Words 7737 - Pages 31

Comparative Study Of HUL P G Www Essay

AND P &G. To get practical touch to theoretical knowledge. To study on the assessment of working capital. To study on Capital profitability management. Compare Competitors Identify Opportunities and Threats Understand Strengths and Weaknesses SWOT Analysis To study on the assessment of working capital. To study on Capital profitability management. II. SCOPE OF THE STUDY The scope for this organizational study is limited in national or our country area. The information collected for…

Words 6545 - Pages 27