Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
334 Cards in this Set
- Front
- Back
ABS |
Returns the absolute value of a number ( Removes + or - sign) |
|
ACCRINT |
Returns the accrued interest for a security that pays periodic interest |
|
ACCRINTM |
Returns the accrued interest for a security that pays interest at maturity |
|
ACOS |
Returns the arccosine of a number |
|
ACOSH |
Returns the inverse hyperbolic cosine of a number |
|
ADDRESS |
Returns a reference as text to a single cell in a worksheet |
|
AMORDEGRC |
Returns the depreciation for each accounting period by using a depreciation coefficient |
|
AMORLINC |
Returns the depreciation for each accounting period |
|
AND |
Returns the value TRUE if all of the arguments are TRUE |
|
AREAS |
Returns the number of areas in a reference |
|
ASC |
Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters |
|
ASIN |
Returns the arcsine of a number |
|
ASINH |
Returns the inverse hyperbolic sine of a number |
|
ATAN |
Returns the arctangent of a number |
|
ATAN2 |
Returns the arctangent from x- and y-coordinates |
|
ATANH |
Returns the inverse hyperbolic tangent of a number |
|
AVEDEV |
Returns the average of the absolute deviations of data points from their mean |
|
AVERAGE |
Returns the average of its arguments |
|
AVERAGEA |
Returns the average of its arguments, including numbers, text, and logical values |
|
BAHTTEXT |
Converts a number to text, using the ? (baht) currency format |
|
BESSELI |
Returns the modified Bessel function In(x) |
|
BESSELJ |
Returns the Bessel function Jn(x) |
|
BESSELK |
Returns the modified Bessel function Kn(x) |
|
BESSELY |
Returns the Bessel function Yn(x) |
|
BETADIST |
Returns the beta cumulative distribution function |
|
BETAINV |
Returns the inverse of the cumulative distribution function for a specified beta distribution |
|
BIN2DEC |
Converts a binary number to decimal |
|
BIN2HEX |
Converts a binary number to hexadecimal |
|
BIN2OCT |
Converts a binary number to octal |
|
BINOMDIST |
Returns the individual term binomial distribution probability |
|
CEILING |
Rounds a number to the nearest integer or to the nearest multiple of significance |
|
Cell |
Returns info about the format, location, or contents of a cell |
|
CHAR |
Returns the character specified by the code number |
|
CHIDIST |
Returns the one-tailed probability of the chi-squared distribution |
|
CHIINV |
Returns the inverse of the one-tailed probability of the chi-squared distribution |
|
CHITEST |
Returns the test for independence |
|
CHOOSE |
Chooses a value from a list of values |
|
CLEAN |
Removes all nonprintable characters from text |
|
Clean |
Removes all nonprintable characters from text |
|
CODE |
Returns a numeric code for the first character in a text string |
|
COLUMN |
Returns the column number of a reference |
|
COLUMNS |
Returns the number of columns in a reference |
|
COMBIN |
Returns the number of combinations for a given number of objects |
|
COMPLEX |
Converts real and imaginary coefficients into a complex number |
|
Concatenate |
Joins multiple text items into one text item |
|
CONFIDENCE |
Returns the confidence interval for a population mean |
|
CONVERT |
Converts a number from one measurement system to another |
|
CORREL |
Returns the correlation coefficient between two data sets |
|
COS |
Returns the cosine of a number |
|
COSH |
Returns the hyperbolic cosine of a number |
|
COUNT |
Counts how many numbers are in the list of arguments |
|
COUNTA |
Counts how many values are in the list of arguments |
|
COUNTBLANK |
Counts the number of blank cells within a range |
|
COUNTIF |
Counts the number of nonblank cells within a range that meet the given criteria |
|
COUPDAYBS |
Returns the number of days from the beginning of the coupon period to the settlement date |
|
COUPDAYS |
Returns the number of days in the coupon period that contains the settlement date |
|
COUPDAYSNC |
Returns the number of days from the settlement date to the next coupon date |
|
COUPNCD |
Returns the next coupon date after the settlement date |
|
COUPNUM |
Returns the number of coupons payable between the settlement date and maturity date |
|
COUPPCD |
Returns the previous coupon date before the settlement date |
|
COVAR |
Returns covariance, the average of the products of paired deviations |
|
CRITBINOM |
Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |
|
CUMIPMT |
Returns the cumulative interest paid between two periods |
|
CUMPRINC |
Returns the cumulative principal paid on a loan between two periods |
|
DATE |
Returns the serial number of a particular date |
|
DATEVALUE |
Converts a date in the form of text to a serial number |
|
DAVERAGE |
Returns the average of selected database entries |
|
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 |
|
DB |
Returns the depreciation of an asset for a specified period by using the fixed-declining balance method |
|
DCOUNT |
Counts the cells that contain numbers in a database |
|
DCOUNTA |
Counts nonblank cells in a database |
|
DDB |
Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify |
|
DEC2BIN |
Converts a decimal number to binary |
|
DEC2HEX |
Converts a decimal number to hexadecimal |
|
DEC2OCT |
Converts a decimal number to octal |
|
DEGREES |
Converts radians to degrees |
|
DELTA |
Tests whether two values are equal |
|
DEVSQ |
Returns the sum of squares of deviations |
|
DGET |
Extracts from a database a single record that matches the specified criteria |
|
DISC |
Returns the discount rate for a security |
|
DMAX |
Returns the maximum value from selected database entries |
|
DMIN |
Returns the minimum value from selected database entries |
|
DOLLAR |
Converts a number to text, using the $ (dollar) currency format |
|
DOLLARDE |
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number |
|
DOLLARFR |
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction |
|
DPRODUCT |
Multiplies the values in a particular field of records that match the criteria in a database |
|
DSTDEV |
Estimates the standard deviation based on a sample of selected database entries |
|
DSTDEVP |
Calculates the standard deviation based on the entire population of selected database entries |
|
DSUM |
Adds the numbers in the field column of records in the database that match the criteria |
|
DURATION |
Returns the annual duration of a security with periodic interest payments |
|
DVAR |
Estimates variance based on a sample from selected database entries |
|
DVARP |
Calculates variance based on the entire population of selected database entries |
|
EDATE |
Returns the serial number of the date that is the indicated number of months before or after the start date |
|
EFFECT |
Returns the effective annual interest rate |
|
EOMONTH |
Returns the serial number of the last day of the month before or after a specified number of months |
|
ERF |
Returns the error function |
|
ERFC |
Returns the complementary error function |
|
ERROR.TYPE |
Returns a number corresponding to an error type |
|
EUROCONVERT |
Converts a number to euros, converts a number from euros to a euro member currency, or converts a number from one euro member currency to another by using the euro as an intermediary (triangulation) |
|
EVEN |
Rounds a number up to the nearest even integer |
|
EXACT |
Checks to see if two text values are identical |
|
EXP |
Returns e raised to the power of a given number |
|
EXPONDIST |
Returns the exponential distribution |
|
FACT |
Returns the factorial of a number |
|
FACTDOUBLE |
Returns the double factorial of a number |
|
FALSE |
Returns the logical value FALSE |
|
FDIST |
Returns the F probability distribution |
|
FIND, FINDB |
Finds one text value within another (case-sensitive) |
|
FINV |
Returns the inverse of the F probability distribution |
|
FISHER |
Returns the Fisher transformation |
|
FISHERINV |
Returns the inverse of the Fisher transformation |
|
FIXED |
Formats a number as text with a fixed number of decimals |
|
FLOOR |
Rounds a number down, toward zero |
|
FORECAST |
Returns a value along a linear trend |
|
FREQUENCY |
Returns a frequency distribution as a vertical array |
|
FTEST |
Returns the result of an F-test |
|
FV |
Returns the future value of an investment |
|
FVSCHEDULE |
Returns the future value of an initial principal after applying a series of compound interest rates |
|
GAMMADIST |
Returns the gamma distribution |
|
GAMMAINV |
Returns the inverse of the gamma cumulative distribution |
|
GAMMALN |
Returns the natural logarithm of the gamma function, G(x) |
|
GCD |
Returns the greatest common divisor |
|
GEOMEAN |
Returns the geometric mean |
|
GESTEP |
Tests whether a number is greater than a threshold value |
|
GETPIVOTDATA |
Returns data stored in a PivotTable |
|
GROWTH |
Returns values along an exponential trend |
|
HARMEAN |
Returns the harmonic mean |
|
HEX2BIN |
Converts a hexadecimal number to binary |
|
HEX2DEC |
Converts a hexadecimal number to decimal |
|
HEX2OCT |
Converts a hexadecimal number to octal |
|
HLOOKUP |
Looks in the top row of an array and Returns the value of the indicated cell |
|
HOUR |
Converts a serial number to an hour |
|
HYPERLINK |
Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet |
|
HYPGEOMDIST |
Returns the hypergeometric distribution |
|
IF |
Specifies a logical test to perform |
|
IMABS |
Returns the absolute value (modulus) of a complex number |
|
IMAGINARY |
Returns the imaginary coefficient of a complex number |
|
IMARGUMENT |
Returns the argument theta, an angle expressed in radians |
|
IMCONJUGATE |
Returns the complex conjugate of a complex number |
|
IMCOS |
Returns the cosine of a complex number |
|
IMDIV |
Returns the quotient of two complex numbers |
|
IMEXP |
Returns the exponential of a complex number |
|
IMLN |
Returns the natural logarithm of a complex number |
|
IMLOG10 |
Returns the base-10 logarithm of a complex number |
|
IMLOG2 |
Returns the base-2 logarithm of a complex number |
|
IMPOWER |
Returns a complex number raised to an integer power |
|
IMPRODUCT |
Returns the product of from 2 to 29 complex numbers |
|
IMREAL |
Returns the real coefficient of a complex number |
|
IMSIN |
Returns the sine of a complex number |
|
IMSQRT |
Returns the square root of a complex number |
|
IMSUB |
Returns the difference between two complex numbers |
|
IMSUM |
Returns the sum of complex numbers |
|
INDEX |
Uses an index to choose a value from a reference or array |
|
INDIRECT |
Returns a reference indicated by a text value |
|
INFO |
Returns information about the current operating environment |
|
INT |
Rounds a number down to the nearest integer |
|
INTERCEPT |
Returns the intercept of the linear regression line |
|
INTRATE |
Returns the interest rate for a fully invested security |
|
IPMT |
Returns the interest payment for an investment for a given period |
|
IRR |
Returns the internal rate of return for a series of cash flows |
|
ISBLANK |
Returns TRUE if the value is blank |
|
ISERR #N/A |
Returns TRUE if the value is any error value except #N/A |
|
ISERROR |
Returns TRUE if the value is any error value |
|
ISEVEN |
Returns TRUE if the number is even |
|
ISLOGICAL |
Returns TRUE if the value is a logical value |
|
ISNA #N/A |
Returns TRUE if the value is the #N/A error value |
|
ISNONTEXT |
Returns TRUE if the value is not text |
|
ISNUMBER |
Returns TRUE if the value is a number |
|
ISODD |
Returns TRUE if the number is odd |
|
ISPMT |
Calculates the interest paid during a specific period of an investment |
|
ISREF |
Returns TRUE if the value is a reference |
|
ISTEXT |
Returns TRUE if the value is text |
|
JIS |
Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters |
|
KURT |
Returns the kurtosis of a data set |
|
LARGE |
Returns the k-th largest value in a data set |
|
LCM |
Returns the least common multiple |
|
LEFT, LEFTB |
Returns the leftmost characters from a text value |
|
LEN, LENB |
Returns the number of characters in a text string |
|
LINEST |
Returns the parameters of a linear trend |
|
LN |
Returns the natural logarithm of a number |
|
LOG |
Returns the logarithm of a number to a specified base |
|
LOG10 |
Returns the base-10 logarithm of a number |
|
LOGEST |
Returns the parameters of an exponential trend |
|
LOGINV |
Returns the inverse of the lognormal distribution |
|
LOGNORMDIST |
Returns the cumulative lognormal distribution |
|
LOOKUP |
Looks up values in a vector or array |
|
LOWER |
Converts text to lowercase |
|
MATCH |
Looks up values in a reference or array |
|
MAX |
Returns the maximum value in a list of arguments |
|
MAXA |
Returns the maximum value in a list of arguments, including numbers, text, and logical values |
|
MDETERM |
Returns the matrix determinant of an array |
|
MDURATION |
Returns the Macauley modified duration for a security with an assumed par value of 100 |
|
MEDIAN |
Returns the median of the given numbers |
|
MID, MIDB |
Returns a specific number of characters from a text string starting at the position you specify |
|
MIN |
Returns the minimum value in a list of arguments |
|
MINA |
Returns the smallest value in a list of arguments, including numbers, text, and logical values |
|
MINUTE |
Converts a serial number to a minute |
|
MINVERSE |
Returns the matrix inverse of an array |
|
MIRR |
Returns the internal rate of return where positive and negative cash flows are financed at different rates |
|
MMULT |
Returns the matrix product of two arrays |
|
MOD |
Returns the remainder from division |
|
MODE |
Returns the most common value in a data set |
|
MONTH |
Converts a serial number to a month |
|
MROUND |
Returns a number rounded to the desired multiple |
|
MULTINOMIAL |
Returns the multinomial of a set of numbers |
|
N |
Returns a value converted to a number |
|
NA #N/A |
Returns the error value #N/A |
|
NEGBINOMDIST |
Returns the negative binomial distribution |
|
NETWORKDAYS |
Returns the number of whole workdays between two dates |
|
NOMINAL |
Returns the annual nominal interest rate |
|
NORMDIST |
Returns the normal cumulative distribution |
|
NORMINV |
Returns the inverse of the normal cumulative distribution |
|
NORMSDIST |
Returns the standard normal cumulative distribution |
|
NORMSINV |
Returns the inverse of the standard normal cumulative distribution |
|
NOT |
Reverses the logic of its argument |
|
NOW |
Returns the serial number of the current date and time |
|
NPER |
Returns the number of periods for an investment |
|
NPV |
Returns the net present value of an investment based on a series of periodic cash flows and a discount rate |
|
OCT2BIN |
Converts an octal number to binary |
|
OCT2DEC |
Converts an octal number to decimal |
|
OCT2HEX |
Converts an octal number to hexadecimal |
|
ODD |
Rounds a number up to the nearest odd integer |
|
ODDFPRICE |
Returns the price per 100 face value of a security with an odd first period |
|
ODDFYIELD |
Returns the yield of a security with an odd first period |
|
ODDLPRICE |
Returns the price per 100 face value of a security with an odd last period |
|
ODDLYIELD |
Returns the yield of a security with an odd last period |
|
OFFSET |
Returns a reference offset from a given reference |
|
OR |
Returns TRUE if any argument is TRUE |
|
PEARSON |
Returns the Pearson product moment correlation coefficient |
|
PERCENTILE |
Returns the k-th percentile of values in a range |
|
Percentrank |
Returns the percent rank of a specific value in a data set |
|
PERMUT |
Returns the number of permutations for a given number of objects |
|
PHONETIC |
Extracts the phonetic (furigana) characters from a text string |
|
PI |
Returns the value of pi |
|
PMT |
Returns the periodic payment for an annuity |
|
POISSON |
Returns the Poisson distribution |
|
POWER |
Returns the result of a number raised to a power |
|
PPMT |
Returns the payment on the principal for an investment for a given period |
|
PRICE |
Returns the price per 100 face value of a security that pays periodic interest |
|
PRICEDISC |
Returns the price per 100 face value of a discounted security |
|
PRICEMAT |
Returns the price per 100 face value of a security that pays interest at maturity |
|
PROB |
Returns the probability that values in a range are between two limits |
|
PRODUCT |
Multiplies its arguments |
|
PROPER |
Capitalizes the first letter in each word of a text value |
|
PV |
Returns the present value of an investment |
|
QUARTILE |
Returns the quartile of a data set |
|
QUOTIENT |
Returns the integer portion of a division |
|
RADIANS |
Converts degrees to radians |
|
RAND |
Returns a random number between 0 and 1 |
|
RANDBETWEEN |
Returns a random number between the numbers you specify |
|
RANK |
Returns the rank of a number in a list of numbers |
|
RATE |
Returns the interest rate per period of an annuity |
|
RECEIVED |
Returns the amount received at maturity for a fully invested security |
|
REPLACE, REPLACEB |
Replaces characters within text |
|
REPT |
Repeats text a given number of times |
|
RIGHT, RIGHTB |
Returns the rightmost characters from a text value |
|
ROMAN |
Converts an arabic numeral to roman, as text |
|
ROUND |
Rounds a number to a specified number of digits |
|
ROUNDDOWN |
Rounds a number down, toward zero |
|
ROUNDUP |
Rounds a number up, away from zero |
|
ROW |
Returns the row number of a reference |
|
ROWS |
Returns the number of rows in a reference |
|
RSQ |
Returns the square of the Pearson product moment correlation coefficient |
|
RTD |
Retrieves real-time data from a program that supports COM automation (Automation: A way to work with an application's objects from another application or development tool. Formerly called OLE Automation, Automation is an industry standard and a feature of the |
|
SEARCH, SEARCHB |
Finds one text value within another (not case-sensitive) |
|
SECOND |
Converts a serial number to a second |
|
SERIESSUM |
Returns the sum of a power series based on the formula |
|
SIGN |
Returns the sign of a number |
|
SIN |
Returns the sine of the given angle |
|
SINH |
Returns the hyperbolic sine of a number |
|
SKEW |
Returns the skewness of a distribution |
|
SLN |
Returns the straight-line depreciation of an asset for one period |
|
SLOPE |
Returns the slope of the linear regression line |
|
SMALL |
Returns the k-th smallest value in a data set |
|
SQL.REQUEST |
Connects with an external data source and runs a query from a worksheet, then Returns the result as an array without the need for macro programming |
|
SQRT |
Returns a positive square root |
|
SQRTPI |
Returns the square root of (number * pi) |
|
STANDARDIZE |
Returns a normalized value |
|
STDEV |
Estimates standard deviation based on a sample |
|
STDEVA |
Estimates standard deviation based on a sample, including numbers, text, and logical values |
|
STDEVP |
Calculates standard deviation based on the entire population |
|
STDEVPA |
Calculates standard deviation based on the entire population, including numbers, text, and logical values |
|
STEYX |
Returns the standard error of the predicted y-value for each x in the regression |
|
SUBSTITUTE |
Substitutes new text for old text in a text string |
|
SUBTOTAL |
Returns a subtotal in a list or database |
|
SUM |
Adds its arguments |
|
SUMIF |
Adds the cells specified by a given criteria |
|
SUMPRODUCT |
Returns the sum of the products of corresponding array components |
|
SUMSQ |
Returns the sum of the squares of the arguments |
|
SUMX2MY2 |
Returns the sum of the difference of squares of corresponding values in two arrays |
|
SUMX2PY2 |
Returns the sum of the sum of squares of corresponding values in two arrays |
|
SUMXMY2 |
Returns the sum of squares of differences of corresponding values in two arrays |
|
SYD |
Returns the sum-of-years' digits depreciation of an asset for a specified period |
|
T |
Converts its arguments to text |
|
TAN |
Returns the tangent of a number |
|
TANH |
Returns the hyperbolic tangent of a number |
|
TBILLEQ |
Returns the bond-equivalent yield for a Treasury bill |
|
TBILLPRICE |
Returns the price per 100 face value for a Treasury bill |
|
TBILLYIELD |
Returns the yield for a Treasury bill |
|
TDIST |
Returns the Student's t-distribution |
|
TEXT |
Formats a number and converts it to text |
|
TIME |
Returns the serial number of a particular time |
|
TIMEVALUE |
Converts a time in the form of text to a serial number |
|
TINV |
Returns the inverse of the Student's t-distribution |
|
TODAY |
Returns the serial number of today's date |
|
TRANSPOSE |
Returns the transpose of an array |
|
TREND |
Returns values along a linear trend |
|
TRIM |
Removes spaces from text |
|
TRIMMEAN |
Returns the mean of the interior of a data set |
|
TRUE |
Returns the logical value TRUE |
|
TRUNC |
Truncates a number to an integer |
|
TTEST |
Returns the probability associated with a Student's t-test |
|
TYPE |
Returns a number indicating the data type of a value |
|
UPPER |
Converts text to uppercase |
|
VALUE |
Converts a text argument to a number |
|
VAR |
Estimates variance based on a sample |
|
VARA |
Estimates variance based on a sample, including numbers, text, and logical values |
|
VARP |
Calculates variance based on the entire population |
|
VARPA |
Calculates variance based on the entire population, including numbers, text, and logical values |
|
VDB |
Returns the depreciation of an asset for a specified or partial period by using a declining balance method |
|
VLOOKUP |
Looks in the first column of a set of data and Finds a match, then moves across the row and returns a value in another column. |
|
WEEKDAY |
Converts a serial number to a day of the week |
|
WEEKNUM |
Converts a serial number to a number representing where the week falls numerically with a year |
|
WEIBULL |
Returns the Weibull distribution |
|
WORKDAY |
Returns the serial number of the date before or after a specified number of workdays |
|
XIRR |
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic |
|
XNPV |
Returns the net present value for a schedule of cash flows that is not necessarily periodic |
|
YEAR |
Converts a serial number to a year |
|
YEARFRAC |
Returns the year fraction representing the number of whole days between start_date and end_date |
|
YIELD |
Returns the yield on a security that pays periodic interest |
|
YIELDDISC |
Returns the annual yield for a discounted security; for example, a Treasury bill |
|
YIELDMAT |
Returns the annual yield of a security that pays interest at maturity |
|
ZTEST |
Returns the one-tailed probability-value of a z-test |