Transcript Introduction to Excel

Introduction to Excel
• Cells are referenced by column then by
row. For example A1
• To enter data just click on the cell you
want.
• You may need to format the cell to show in
the style you want.
Calculations in Excel
• If you want to do any calculation in Excel
just start with an = sign.
• Note that the formula bar then becomes
active
Operations
•
•
•
•
•
Plus +
Minus –
Divide /
Multiply *
Exponents
=A1 + A2
=A1 - A2
= A1/A2
= A1 * A2
=A1^A2
Charts
• To create a chart highlight the data you
want to chart, then select the chart wizard
and the type of chart you want.
• If the data does not plot the way you want
you may need to edit the source data and
make sure the data is being treated
properly.
Graphing Functions
• To graph a function like y = 5x-10 we must
create a two column table of x and y values.
• Start the x-values with the smallest x then in the
cell below, type = then click on the cell above
and then add the step size you want. Enter to
finish the calculation.
• To fill down the formula place the cursor over the
lower left corner of the cell you just created and
when it looks like a black cross, click, hold and
drag down.
Graphing Functions
• To create your column of y-values start in
the column to the right of the column
containing your first x-value.
• Type = 5* then click on the x-value in the
same row, then -10 and enter.
• Now fill down as you did with the x’s.
• Lastly, highlight both columns and select a
scatter plot to graph them.
Fibonacci Sequence
• A man has one pair of rabbits at a certain
place entirely surrounded by a wall. We
wish to know how many pairs can be bred
from it in one year, if the nature of these
rabbits is such that they breed every
month one other pair and begin to breed in
the second month after their birth.
• F1 = 1, F2 = 2,
• In general, Fn = Fn-1 +Fn-2
Babylonian Square Roots
• To find the square root of x, you make a guess
call it a.
• If a is too small then x/a is larger than the square
root.
• If a is too big then x/a is smaller than the square
root.
• Thus a better guess for square root of x is the
average of a and x/a.
Babylonian Square Roots