## Important function in Excel 2007

### Important function in Excel:

Some important function in Excel 2007 are as follows:

Auto sum

The Auto sum function is use to add the contents of adjacent cells.

• Select the cell where you want to display the sum.
• Click the Auto sum button on standard toolbar.
• Highlight the group of cells that will be summed.
• Press Enter or click green check mark button on formula bar.

Sum function:

The sum function adds all numbers in a range of cells and returns the result. So The syntax for the sum function is :

Sum (number1,number2,…..number n) or sum (cell1:cell2)

• Enter the value of cells A2 through A5.
• Click on a cell to display the result.
• Type =SUM.
• Type a left parenthesis.
• Click add drag mouse over range of values.
• Click on the green check mark on the formula bar or press enter.

Average function:

The average function is use to get the average.The syntax of average function is :

Average ((number 1,number 2,…..number n)

(number1,number2,…..number n are numeric values.

They can be numbers. Name ranges, arrays or references to numbers. There can be up to 30 values entered.

• Enter the value of cells A2 through A5.
• Click on blank cell below or to the right of the numbers to be averaged.
• Type =
• Write the word average.and
• type a left parenthesis.
• Click and drag the mouse over the range to be averaged.
• You do not have to enter the right parentheses.
• Click on green check mark on formula bar  OR
• Press enter.

#### MAX function:

max function is also use to get the maximum number from different number.The syntax of Max function is Max ((number1,number2,…..number n)

(number1,number2,…..number n are numeric values.So they can be numbers, named ranges, arrays or references to numbers. There can be up to 30 values entere.

• Enter the value of cells A2 through A5
• Click on blank cell to display maximum number.
• Type
• Write the word Max.
• Type a left parenthesis.
• Click and drag the mouse over the range.
• Click on the green check mark on the formula bar
• OR press Enter.

#### MIN Function:

Min function is also use to get the maximum number from different number. So The syntax of Min function is;

Min ((number1,number2,…..number n)

(number1,number2,…..number n are numeric values.So They can be numbers, named ranges, arrays or references to numbers. and There can be up to 30 values entere.

• Enter the value of cells A2 through A5
• Click on blank cell to display maximum number.
• Type =
• Write the word MIN.
• Type a left parenthesis.
• Click and drag the mouse over the range.
• Click on the green check mark on the formula bar
• OR press Enter.

Count Function

The count function counts the number of cells that contain numbers as well as the numbers as well as the number of arguments that contain numbers. so

The syntax of Count Function is:

Count (argument1 argument 2 ….argument n)

argument 1,  argument 2 ….and argument n are either ranges of cells or values. There can be up to 30 arguments.

• Enter the value of cells A2 through A5.
• Click on a cell to display the result of function.
• Type =
• Write the word count.
• Type a left parenthesis.
• Click and drag mouse over the range of values.
• Click on the green check mark on the formula bar or press Enter.

Concatenate function:

The concatenate function joins two or more strings.So it can concatenate up to 30 strings

Together. The syntax of  concatenate function

Concatenate (text 1,text 2….text n)

Based on the excel spreadsheet above:

 =concatenate(A1,A2) Would return “Alphabet” =And concatenate(Tech on the,” “Net”) and Would return “Tech on the Net” =concatenate (A1,”bet soup”) Would return “Alphabet soup”

(Visited 7 times, 1 visits today)