Just
below the formulas bar the dialoge box Function
Arguments
will
appear. It will ask you for the function arguments. The box will vary according to
the function chosen. In this case we have chosen the function SUM
().
In Number
1 text
box you must indicate the
first
argument ,
that will generally be a cell or a range of cells like A1:B4
.
To do that, you should click on the button
so
the box gets smaller and you can see all the spreadsheet. After that, select
the range of cells or the cell you wish as your first argument (to
select a range of cells click with the left button of the mouse on the first cell
of the range and without letting go drag to the last cell of the range) and press
the key ENTER
to
return to the dialoge box.
In
the box Number
2
you
must indicate your second
argument,
of course, only when there is one.
If
you introduce a second argument, another box will appear for the third argument,
and so on.
Once
you have introduced all the arguments, click on the button OK.
If
for whatever reason we
insert
a row in the middle of a function range, Excel
will expand automatically the range Including
the cell value in the range. For example: If you have in cell
A5 the
function =SUM(A1:A4)
and
you insert a row in position 3, the formula will expand automatically changing to =SUM(A1:A5) .
