MAX Function

Returns the largest value in a set of values.

Syntax

MAX(number1,number2,...)

Number1, number2, ... are 1 to 30 numbers for which you want to find the maximum value.

Remarks

-        You can specify arguments that are numbers, empty cells, logical values, or text representations of numbers. Arguments that are error values or text that cannot be translated into numbers cause errors.

-        If an argument is an array or reference, only numbers in that array or reference are used. Empty cells, logical values, or text in the array or reference are ignored. If logical values and text must not be ignored, use MAXA instead.

-        If the arguments contain no numbers, MAX returns 0 (zero).

AVERAGE Function

Returns the average (arithmetic mean) of the arguments.

Syntax

AVERAGE(number1,number2,...)

Number1, number2, ... are 1 to 30 numeric arguments for which you want the average.

Remarks

-        The arguments must either be numbers or be names, arrays, or references that contain numbers.

-        If an array or reference argument contains text, logical values, or empty cells, those values are ignored; however, cells with the value zero are included.

How to Create SUM Function

Syntax

=SUM(number1,number2, ...)

Number1, number2, ... are 1 to 30 arguments for which you want the total value or sum.

Example

=SUM(3,4,7,8,2,5)

Adds 3,4,7,8,2,5 and 2 (result=29)

=SUM(C4:C9)

Adds number in cell C4 until cell C9 (result=29)

What is Spreadsheet in Excel?

A spreadsheet in excel is the computer equivalent of a paper ledger sheet. It consists of a grid made from columns and rows (256 coloums and 65,563 rows). It is an environment that can make number manipulation easy and somewhat painless.