**Introduction:**

Function are one of the most important features of Excel. It helps you to perform the basic calculations as well complex.

A

Excel includes many common functions that can be used to quickly find the

You'll need to understand the different

A

**function**is a**predefined formula**that performs calculations using specific values in a particular order.Excel includes many common functions that can be used to quickly find the

**sum, average, count, maximum value**and**minimum**value for a range of cells.You'll need to understand the different

**parts of a function**and how to create arguments to calculate values and cell references.**The part of a function:**

In order to work correctly, a function must be written a specific way, which is called the syntax. The basic syntax for a function is the equals sign(=), the function name (MIN, for example), and one or more arguments. Arguments contain the information you want to calculate. The function in the example below would find the minimum value of the cell renge A1:A10.

**Below is a listing of function in Microsoft Excel.**

DATE | Create a date with year, month, and day. |

DAY | Get the day as a number from a date. |

HOUR | Get hour as a number from a Time. |

MINUTE | Get minute as a number from a time. |

MONTH | Get month as a number from a date. |

NOW | Get the current date and time. |

SECOND | Get the Second as a number from a time. |

TIME | Create a time with hours, minutes, and seconds. |

TODAY | Get the current date. |

YEAR | Get the year as a number from a date. |

ABS | Find the absolute value of a number. |

SUM | Adds all the numbers in a range of cells. |

COUNT | A number representing a count of numbers. |

COUNTA | A number representing a count of non-blank cells. |

LARGE | picks the Largest value at a user specified position in the list. |

MAX | Returns the largest value in a set of values. |

MIN | Returns the smallest value in a set of values. |

SMALL | picks the Smallest value at a user specified position in the list. |

CHAR | Get the character from a number. |

CLEAN | Get the length of given text string. |

CODE | Get the code for a character. |

CONCATENATE | Joins separate pieces of text into one item. |

DOLLAR | A number as text in currency format. |

EXACT | Compares two text strings when text is case-sensitive. |

FIND | Get the location of text in a string. |

LEN | Get the length of given text string. |

LOWER | Convert text to lower case (small letters). |

PROPER | Capitalize the first letter in each word. |

REPLACE | Replaces a portion of text with a new piece of text. |

REPT | Repeats a piece of text a specified number of times. |

SEARCH | Get the location of text in a string. |

SUBSTITUTE | Replace text based on content. |

TEXT | Convert the numeric values into a text format. |

TRIM | Remove extra spaces from text. |

UPPER | Convert text to upper case (capital letters). |

## No comments:

## Post a Comment