Page 30 - Computer Genius Class 06
P. 30
Information Literacy
Quest Technology Literacy
If the cells A1, A2 and A3 contain 30, 40 and 50 respectively, then calculate and write
the output of the following formulas:
1. 1 2
2. 1 2
. 1 2 1
. 1 1
Functions
Functions are predefined ormulas in cel to per orm oth simple and comple calculations. They
accept arguments and return alues. rguments are input gi en to the unctions. These arguments
can e num ers or te t. The alues should e gi en in et een the opening and closing parenthesis.
Rules for using Functions
ll cel unctions must egin ith the sign.
Function name must e a alid name.
Function must e ollo ed y opening and closing parenthesis.
Categories of Functions
cel pro ides the ollo ing categories o unctions
Statistical Functions: alculate the ma imum minimum a erage etc. o a set o numeric data.
Financial Functions: Calculate interest on a loan, the number of instalment of a loan, the amount
o e ery instalment etc.
Date and Time Functions: Calculate the day, month, and year of a date and the hour, minute,
and second o a particular time.
Mathematical Functions: Calculate the square root or absolute value of a number, product of
num ers etc.
Logical Functions: aluate conditions such as and gi e the result as true or alse.
Text Functions: er orm a num er o operations on strings i.e. a collection o characters li e
hello riend computer etc. such as inding the length o a string oining t o strings
searching or one string inside another etc.
Database Functions: uery a data ase ased on the data contained in the data ase.
Information Functions: Provide information about a specific cell, such as the type of data it
contains hether it is te tual or numeric.
Lookup and Reference Functions: ocate speci ic alues in speci ic cells.
et us discuss some o these categories in detail.
28 Computer Genius-VI

