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
|