QuickTips Index - page 4
Excel 2007 MODE Function
The MODE function, one of Excel's statistical functions, tells you the most frequently occurring value in a list of numbers. This article includes an example to walk you through using Excel's MODE function.
Excel 2007 ISNUMBER Function
The ISNUMBER function's job is to check to see if a certain cell contains a number or not. This article shows you how to use this function.
Excel 2007 ISBLANK Function
The ISBLANK function's job is to check to see if a certain cell is empty or not. This article shows you how to use this function
Excel 2007 SIN Function
Excel's list of functions includes a number of the most common trigonometric functions. These include the SIN function which gives you the sine of an angle measured in radians.
Excel 2007 SUM Function
The Excel SUM function is used to quickly add up the values in a
range of cells. This article shows you how to use this function.
Excel 2007 PRODUCT Function
Multiplying numbers in Excel can be done with the PRODUCT function. This article shows you how to use the function along with a step by step example
Excel 2007 TRANSPOSE Function
The TRANSPOSE function, one of Excel's Lookup & Reference functions, is used to transfer data located in a row into a column or data located in a column into a row.
Excel 2007 COS Function
Excel's list of functions includes a number of the most common trigonometric functions. These include the COS function which gives you the cosine of an angle measured in radians.
Excel 2007 RADIANS Function
Since Excel's, trig functions use radians, we often need a way of converting angles measured in degrees to radians. The RADIANS function, one of Excel's math functions, does just that.
Excel 2007 TAN Function
Excel's list of functions includes a number of the most common trigonometric functions. These include the TAN function which gives you the tangent of an angle measured in radians.
Excel 2007 QUOTIENT Function
The QUOTIENT function, one of Excel’s math functions, is used to divide numbers in Excel. This article includes an example to walk you through using the QUOTIENT function.
Excel 2007 CONVERT Function
The CONVERT function, one of Excel's engineering functions, is used to convert measurement data from one set of units to another.
Excel 2007 AVERAGE IF
The AVERAGE IF function, one of Excel's statistical functions, is used to find the average of values in cells that meet certain criteria.
Excel 2007 SUMIF
The SUMIF function, one of Excel's MATH functions, is used to sum up the number of cells in a selected range that meet certain criteria.