• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

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: ~

...read more.

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

...read more.

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)

image01.png

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.

...read more.

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

See related essaysSee related essays

Related GCSE T-Total essays

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

    the difference between 2N( subtracted from original number and 2(2)( subtracted from the original number. The final part of the equation is to add on the number of centre tiles. So the formulae for total tiles, T, for patterns with six centre tiles is: T= 2N� + 8N + 6 Testing my formula.

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

    The night cost is usually less than the day cost. For npower, the cost for day is 7.3p and the cost for night is 2.85p. Separate unit totals are worked out for day and night and the costs are applied to each of these unit totals.

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