Page 49 - modular4.0
P. 49
Chapter Profile
In Book2, click to select cell A2. Press Enter key once you've selected cell A2 in Book2. After doing
this, the formula in cell A1 of Book1 should look like this: =[Book2]Sheet1!$A$2
This reference has 3 parts:
1. The workbook Book2 in square brackets
2. The worksheet Sheet1 followed by ! sign
3. The cell having absolute reference
Hence, referencing cells in the external workbooks are done by selecting the workbook, then
worksheet, and then the cell you want to link reference to.
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 2019 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.
Mathematical Functions
Function Purpose Example
Input: =SUM(4,8,12,16)
SUM(range) It returns the sum of a range.
Output: 40
It multiplies the values in a range Input: =PRODUCT(4,2,8)
PRODUCT(range)
of cells. Output: 64
Formulas and Functions 47

