Page 42 - TP_Pluse_V2.2_Class_6
P. 42
21 st
Let’s PraCtiCe Century #Critical Thinking
Skills
If the cells A1, A2 and A3 contain 30, 40 and 50 respectively, then what will be the output of
the following formulas:
1. (A1 - A2) * A3 ____________________________________________________
2. A3 + (A1 * A2) ____________________________________________________
3. A1 * (A2 + A3) – 10 ____________________________________________________
FUNCTIONS
Functions are predefined formulas in Excel to perform both simple and complex calculations.
These accept arguments and return values. Arguments are input to the functions. These
arguments can be numbers or text. The values should be given in between opening and closing
( ) parenthesis.
Rules for using Functions
All Excel functions must begin with the = sign.
Function name must be a valid Excel name.
Function must be followed by opening and closing parentheses.
Most of the functions must contain an argument within them.
Categories of Functions
Excel provides many categories of functions. Some of them are:
Mathematical Functions: Calculates the square root or absolute value of a number, product of
numbers etc.
Text Functions: Performs 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.
Logical Functions: Evaluates conditions such as X > 5 and gives the result as true or false.
Statistical Functions: Calculates the maximum, minimum, average etc., of a set of numeric
data.
Date and Time Functions: Calculates the day, month and year in a date and the hour, minute and
second at a particular time.
Let us discuss these categories in detail.
40 Plus (Ver. 2.2)-VI

