Respective Excel Functions

It is simply basic upon relief about the function and features of the excel. But then again, how many function does this program makes to make out the advantage in using this in almost everything this program designed for - Reports, accounting, calculating, making grades and much much more...









           In this article, here is the table - list of features that make your excel experience even better...

                                               I.            Date & Time Category Functions

Function	Description
DATE	Returns the serial number of a particular date.
DAY	Converts a serial number to a day of the month.
DAYS360	Calculates the number of days between two dates, based on a 360-day year.
HOUR	Converts a serial number to an hour.
MINUTE	Converts a serial number to a minute.
MONTH	Converts a serial number to a month.
NETWORKDAYS	Returns the number of whole workdays between two dates.
NOW	Returns the serial number of the current date and time.
SECOND	Converts a serial number to a second.
TIME	Returns the serial number of a particular time.
TODAY	Returns the serial number of today’s date.
WEEKDAY	Converts a serial number to a day of the week.
WEEKNUM	Returns the week number in the year.
WORKDAY	Returns the serial number of the date before or after a specifiednumber of workdays.
YEAR	Converts a serial number to a year.
YEARFRAC	Returns the year fraction representing the number of whole daysbetween start_date and end_date.

                                         II.            Functions Used in Lookup Formulas

Function	Description
CHOOSE	Returns a specific value from a list of values supplied as arguments.
HLOOKUP	Horizontal lookup. Searches for a value in the top row of a table and returns avalue in the same column from a row you specify in the table.
IF	Returns one value if a condition you specify is TRUE, and returns another value if the condition is FALSE.
IFERROR	If the first argument returns an error, the second argument is evaluated andreturned. If the first argument does not return an error, then it is evaluated andreturned.
INDEX	Returns a value (or the reference to a value) from within a table or range.
LOOKUP	Returns a value either from a one-row or one-column range. Another form of theLOOKUP function works like VLOOKUP but is restricted to returning a value fromthe last column of a range.
MATCH	Returns the relative position of an item in a range that matches a specified value.
OFFSET	Returns a reference to a range that is a specified number of rows and columnsfrom a cell or range of cells.
VLOOKUP	Vertical lookup. Searches for a value in the first column of a table and returns avalue in the same row from a column you specify in the table.

 III.            Counting and Summing Functions

Function	Description
COUNT	Returns the number of cells that contain a numeric value.
COUNTA	Returns the number of nonblank cells. This function counts cells that contain values, text, or logical values (TRUE orFALSE).
COUNTBLANK	Returns the number of blank cells.
COUNTIF	Returns the number of cells that meet a specified criterion.
COUNTIFS	Returns the number of cells that meet multiple criteria.
DCOUNT	Counts the number of records that meet specified criteria; used with aworksheet database.
DCOUNTA	Counts the number of nonblank records that meet specified criteria; usedwith a worksheet database.
DSUM	Returns the sum of a column of values that meet specified criteria; usedwith a worksheet database.
FREQUENCY	Calculates how often values occur within a range of values and returns avertical array of numbers. Used only in a multicell array formula.
SUBTOTAL	When used with a first argument of 2, 3, 102, or 103, returns a count ofcells that comprise a subtotal; when used with a first argument of 9 or 109,returns the sum of cells that comprise a subtotal.
SUM	Returns the sum of its arguments.
SUMIF	Returns the sum of cells that meet a specified criterion.
SUMIFS	Returns the sum of cells that meet multiple criteria.
SUMPRODUCT	Multiplies corresponding cells in two or more ranges and returns the sum of those products.

IV.            Logical Category Functions

Function	Description
AND	Returns TRUE if all its arguments are TRUE.
FALSE	Returns the logical value FALSE.
IF	Specifies a logical test to perform.
IFERROR	Returns a different result if the first argument evaluates to an error.
NOT	Reverses the logic of its argument.
OR	Returns TRUE if any argument is TRUE.
TRUE	Returns the logical value TRUE.

V.            Text Category Functions

Function	Description
CHAR	Returns the character specified by the code number.
CLEAN	Removes all nonprintable characters from text.
CONCATENATE	Joins several text items into one text item.
DOLLAR	Converts a number to text, using currency format. It takes two arguments: the number to convert and the number of decimal places to display. The DOLLAR function uses the regional currency symbol
EXACT	Checks to see whether two text values are identical.
FIND	Finds one text value within another (case-sensitive).
FIXED	Formats a number as text with a fixed number of decimals.
LEFT	Returns the leftmost characters from a text value.
LEN	Returns the number of characters in a text string.
LOWER	Converts text to lowercase.
MID	Returns a specific number of characters from a text string, starting at the position you specify.
PROPER	Capitalizes the first letter in each word of a text value.
REPLACE	Replaces characters within text. Use this function when you know the position of the text to be replaced but not the actual text.
REPT	Repeats text a given number of times.
RIGHT	Returns the rightmost characters from a text value.
SEARCH	Finds one text value within another (not case sensitive).
SUBSTITUTE	Substitutes new text for old text in a text string. Use this function when you know the character(s) to be replaced but not the position.
T	Returns the text referred to by value.
TEXT	Formats a number and converts it to text.
TRIM	Removes excess spaces from text.
UPPER	Converts text to uppercase.
VALUE	Converts a text argument to a number.

           This table shows you different features that the excel has. It usually applies in the formula tab in the program.Watch instead the video below for more details involving excel formulas and functions...

          

          ________________________________________________



          Updates:

          There is another article involving excel programs here. Link will be provided here...

Share: