• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month
Page
1. 1
1
2. 2
2
3. 3
3
4. 4
4

# Using Formulas In Microsoft Excel.

Extracts from this document...

Introduction

Using Formulas In Microsoft Excel

Through using Microsoft Excel, I had completed a chart of Ten names, Age and shoe sizes. When working out the Total, Average, Highest and the lowest I used specific formulas, which worked out the exact answer. Below I will start to show you what I needed to do to complete this table and how the formulas helped me to discover the answer.

But first you may wonder, why do we need to use formulas?  It is a simple procedure in which you have to complete into an in depth and detailed formula before it can respond, whilst calculating to give you the accurate answer. Formula has a vast majority of definitions the one in which, I’d put is that it is a mathematical rule expressed in figures.

Total: ~ This calculated the sum of two numbers together to give me the answer that I would need to include on the table.  =SUM (B2:B11)

Average: ~

Middle

## Daniel

After completing the names you had to think about the list of the ages for each of them, now these, you can make up.

 14 13 11 12 16 9 10 15 8 5

For the last section you needed to include a range of shoe sizes (you can repeat them), they can range from size 10-9 or whichever individuals decided to choose.

 6 4 7 8 3 6 3 8 1 5

### Where there is an area underneath each of the three columns, in the names column you put Total, Average, Highest and lowest this will help you when you come to type up the formula so that you won’t confuse yourself.

 Total Average Highest Lowest

### In the age and shoe size column you type in a specific and detailed formulas for each of the above.

#### Total

Average

Highest

Lowest

Conclusion

finish and it should come up with a graph with your information and the information you typed in.

If you want to change the colours of your bars double click on to it and it should come up with a table of colours, choose which one you want. You can also change font, font size and the colour of your writing. When completed if you need to o another graph just follow these simple steps and you should archive your task.

B)

This graph tells me the numbers even before scanning across to find them for myself. This is another objective you can do because there are other buttons on the graph that you can move across to and add the numbers on top.

I completed these tables because I wanted to describe my information into another form.

This student written piece of work is one of many that can be found in our GCSE T-Total section.

## Found what you're looking for?

• Start learning 29% faster today
• 150,000+ documents available
• Just £6.99 a month

Not the one? Search for your essay title...
• Join over 1.2 million students every month
• Accelerate your learning by 29%
• Unlimited access from just £6.99 per month

# Related GCSE T-Total essays

1. ## I am going to investigate how changing the number of tiles at the centre ...

This will give you the equation, 8 - 4, which equals +4 and this is then added to give the pattern formula, 4N + 4. Testing my Pattern formula. I will test my formula to see if it is producing the same values as in Table 1. N=1, B= 4(1)

2. ## For this task we were required to create a model that can be used ...

The night period usually must last for about 7 hours. Most economy 7 suppliers have their night periods at about this length. The user can normally decide at what times he/she wants his/her night period. Economy 7 has a different cost per unit for day and a different cost for night.

• Over 160,000 pieces
of student written work
• Annotated by
experienced teachers
• Ideas and feedback to