Main Functions and Formula used in Excel.

There are many pre-defined functions in Excel but the most important pre­defined functions are:

  • SUM function.

  • AVERAGE function

  • MAX function

  • MIN function

  • PRODUCT function

  • IF function

SUM Function

It is used to add numbers given as parameters. These may be numeric values or cell references. Its general syntax is:

SUM(numberl,number2, .,.) Where

numberl, number2,... : specifies arguments which you want to add.

Example, = SUM (3, 2) returns 5. Similarly, to add values of cell range Al to A30, the function is written as:

=SUM (A1:A30)

AVERAGE Function

It is used to calculate the average of values given as parameters. These may be numeric values or cell references. Its general syntax is:

AVERAGE (numberI, number2, ...) Where

numberl, number2,... : specifies arguments for which you want to

calculate average. For example. AVERAGI. (3, 2) returns 2.5. Similarly, to calculate average of values of cell range Al to A30. the function is written as:

=AVERAGE(A1:A30)

MAX Function

It returns the largest or maximum value from a list of values. The parameters may be numeric values or cell references. Its general syntax is:

MAX (numberl, number2, ...) Where

numberl, number2,... : specifies arguments from which you want to find maximum, for example, =MAX(3. 2,45,23) returns 45.

MIN Function

It returns the lowest or minimum value From a list of values. The parameters may be numeric values or cell references, its general syntax is:

MIN(number 1, number2….) Where

numberl, number2,... : specifies arguments from which you want to

find minimum. For example, =M1N(3, 2,45,23) returns 2.PRODUCT Function

It is used to multiply numbers given as parameters. These may be numeric values or cell references. Its general syntax is:

PRODUCT (number1 ,number2, ...) where

numberl, number2,... : specifies arguments which you want to multiply. For example, =PRODUCT (13, 2) returns 26. Similarly, to multiply values of cell range Al to A30, the function is written as:

=PRODUCT (A 1:A30).

sumber http://www.computerfreetips.com/Office_Tips/t_autocorrect_office.html

Komentar

Postingan populer dari blog ini

Cara Setting LAN jaringan Setting Server dan Client

Download video yang sudah tidak ada pada youtube.

Mengenal Beberapa Fungsi Tool CorelDraw X5