Scribd
Upload
2 views2 pages

Reference & Functions (Stat.&Math Fun)

The document explains different types of cell references in Excel: relative, absolute, and mixed, detailing how they behave when formulas are copied. It also covers references to other worksheets and workbooks, along with various statistical and mathematical functions available in Excel, providing examples for each. Key functions include AVERAGE, MAX, MIN, SUM, and others, illustrating their purposes and usage.

Uploaded by

savitaingole878
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2 views2 pages

Reference & Functions (Stat.&Math Fun)

The document explains different types of cell references in Excel: relative, absolute, and mixed, detailing how they behave when formulas are copied. It also covers references to other worksheets and workbooks, along with various statistical and mathematical functions available in Excel, providing examples for each. Key functions include AVERAGE, MAX, MIN, SUM, and others, illustrating their purposes and usage.

Uploaded by

savitaingole878
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Relative Reference: In this reference cell address (reference) change when you

copy formula to another cell.

Example: If the formula contains =A1+B1, copying it one row down changes it
to =A2+B2.

Absolute Reference: In this Reference address doesn’t change once you copy
the formula to another cell. The ‘$’ symbol is used to lock the row, column, or
both.

Example: If the cell reference is $A$1, it remains $A$1 even after copying the
formula to another cell.

Mixed Cell Reference: In a mixed cell reference, either the row or the column
is fixed using the $ symbol, while the other part changes when you copy the
formula to another cell.

Examples:

• $A1 → Column A is fixed, but the row changes.


• A$1 → Row 1 is fixed, but the column changes.

• Reference to Other Worksheet: A reference to another worksheet is


used to refer to a cell or range from a different sheet in the same
workbook.
Example: =Sheet2!A1

• Other Workbook Reference: A workbook reference is used to refer to


a cell or range from a different workbook (Excel file).
Example: =[[Link]] Sheet1!A1

Page 1|2
Functions: It is a Predefined formula in the excel that performs a specific
calculation or task.

Statistical Function:

Function Purpose Example


AVERAGE() Calculates average =AVERAGE(B1:B5)
MAX() Finds highest value =MAX(B1:B10)
MIN() Finds lowest value =MIN(B1:B10)

Mathematical
Functions:

Function Purpose Example


SUM() Adds numbers =SUM(A1:A5)
PRODUCT() Multiplies numbers =PRODUCT(A1:A3)
ROUND() Rounds a number =ROUND(12.567,2)
ABS() Returns absolute value =ABS(-25)
MOD() Returns remainder =MOD(10,3)
Removes decimal part and =INT(14,25)
INT()
Return integer part
Returns the result of a number raised to a =POWER(number,
POWER() given power (exponent) power)
COUNT() Counts the no. of selected cell =COUNT(4,3,2)

Page 2|2

You might also like