Page 74 - Code & Click - 6
P. 74
COMMON FUNCTIONS IN EXCEL
The table given below lists some commonly used functions in Excel.
Function Description
SUM(number1, number2, ...) Adds the values specified in the argument list.
PRODUCT(number1, number2, ...) Multiplies the values specified in the argument list.
AVERAGE(number1, number2, ...) Calculates the average of the values specified in the argument
list.
COUNT(value1, value2,...) Finds the number of cells that contain numerical values in the
specified range in the argument list.
MAX(number1, number2, ...) Finds the highest of the values specified in the argument list.
MIN(number1, number2, ...) Finds the lowest of the values specified in the argument list.
CONCATENATE(text1, text2, …) Combines several text strings into one text string.
WRITING A FORMULA USING INSERT FUNCTION
The Insert Function button in the Formulas tab is used to write formulas using functions.
To write a formula using Insert Function:
1. Click the cell in which you want to enter the
formula. 2
2. On the Formulas tab, click the Insert Function
button.
The Insert Function dialog box opens and an
equal (=) sign appears in the cell.
3. Type the name of the function in the Search for
a function text box and click the Go button. 1
3
4
4. In the Select a function box, select the function that you want to insert and click the OK button.
The Function Arguments dialog box opens.
72
