Page 265 - open office
P. 265
Function Result (Considering a number as X)
PRODUCT( ) It multiplies all the given arguments.
E.g., PRODUCT(5 2 3) 3 , PRODUCT(-5 6 )
N ot e s
AUTOSUM is a shortcut tool for adding the values of a range of cells. To do so:
f a range o
f cells. T
A A UT OSUM is a shor t t cut t ool for adding the v alues o f a range o f cells. T o do so:
OSUM is a shor
ool for adding the v
UT
alues o
cut t
o do so:
o be added
ar
o be added
mula b
ar
t
. The sum
f cells
. The sum
f cells
t
osum
on near
on near
butt
butt
osum
and click on the Aut
mula b
and click on the Aut
the for
the for
Select the range
Select the range
Select the range of cells to be added and click on the Autosum button near the formula bar. The sum
o
o
is displayed in the next cell.
is display ed in the next cell.
Date and Time Functions
We can add the date and time in a cell. Built into Open Office Calc are a number of DATE and TIME functions
that can be used to do this.
Function Result
TODA () Produces the current date; it contains no argument.
OW() Produces the current date and time; it contains no argument.
Returns the year from a date value. E.g.
YEAR(“Date”)
EAR(DATE(2 3 2))
Returns the month from a date value (1-12). E.g.,
MO TH( Date )
MO TH(DATE(2 3 2)) returns 3 for March.
Returns the day of the month from a date value. E.g.,
DAY(“Date”)
DA (DATE(2 3 2))
Statistical Functions
Statistical Functions take numeric argument(s) and produce results accordingly. Following are the different
types of statistical functions.
Function Result
AVERAGE( ) Produces the average (mean) of the given arguments.
E.g., A ERA E(1 2 3 ) Displays output: 2
A ERA E(A1 A2 A3) Displays the average of the cells A1, A2 and A3
A ERA E(A1:A1 ) Displays the average of the cells from the range A1 to A1
MAX( ) Produces the largest value from the given range of cells.
E.g., MA (1 2 15 25) Displays output:25
MA (A1:A5) Displays the largest value from cell A1 to A5.
=MAX(B2:C4) Displays the largest value of cells B2, B3, B4,C2, C3 and C4.
Working with Spreadsheet 265

