Page 86 - PlusGPT_V2.1_C7_Flipbook
P. 86
Tech Hint
Pressing F4 key repeatedly over a reference (cell) will allow you to switch between
making the column, the row, or nothing ‘Absolute’.
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. They
accept arguments and return values. Arguments are input to the functions. These arguments can
be number or text. The values should be given in between opening and closing ( ) parenthesis.
Rules for Using Functions
All Excel functions must begin with = sign.
Function name must be a valid Excel name.
Function must be followed by opening and closing parenthesis.
Most of the functions contain an argument within it.
Categories of Functions
Excel 2016 provides the following categories of functions:
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 in a particular time.
Mathematical Functions: Calculates the square root or absolute value of a number, product of
numbers etc.
Logical Functions: Compares conditions such as =IF(X>5) and give the result as true or false.
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.
Let us discuss some of these categories in detail.
84 Premium Edition-VII

