Page 30 - CG_v2.1_flipBooks_class_6
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. =(A1 - A2) * A3
2. =A3 + (A1 * A2)
3. =A1 * ((A2 + A3) – 10)
4. =A1 / ((A3 – A1) –5)
Functions
Functions are predefined formulas in Excel to perform both simple and complex calculations. They
accept arguments and return values. Arguments are input given to the functions. These arguments can
be numbers or text. The arguments should be given in between the opening and closing ( ) parenthesis.
Rules for using Functions
All Excel functions must begin with the = sign.
Function name must be a valid name.
Function must be followed by opening and closing parenthesis.
Most of the functions contain an argument within it.
Categories of Functions
Excel provides the following categories of functions:
Statistical Functions: Calculate the maximum, minimum, average, etc. of a set of numeric data.
Financial Functions: Calculate interest on a loan, the number of instalment of a loan, the amount
of every instalment, etc.
Date and Time Functions: Calculate the day, month, and year of a date and the hour, minute,
and second of a particular time.
Mathematical Functions: Calculate the square root or absolute value of a number, product of
numbers, etc.
Logical Functions: Evaluate conditions such as X > 5 and give the result as true or false.
Text Functions: Perform a number of operations on strings (i.e., a collection of characters like
'hello', 'friend', 'computer', etc.), such as finding the length of a string, joining two strings,
searching for one string inside another, etc.
Database Functions: Query a database based on the data contained in the database.
Information Functions: Provide information about a specific cell, such as the type of data it
contains, whether it is textual or numeric.
Lookup and Reference Functions: Locate specific values in specific cells.
28 Computer Genius (V2.1)-VI

