Binomial Distribution Worksheet: Fill & Download for Free

From Google search: Description. The Microsoft Excel BINOMDIST function returns the individual term binomial distribution probability. The BINOMDIST function is a built-in function in Excel that is categorized as a Statistical Function. It can be used as a worksheet function (WS) in Excel.MS Excel: How to use the BINOMDIST Function (WS)

Business Statistics MCQs: Multiple Choice Questions and AnswersBusiness statistics multiple choice questions has 576 MCQs. Business statistics quiz questions and answers, MCQs on probability distributions, probability theory, measures of dispersion, measures of central tendency, introduction to business statistics MCQs with answers, sampling distributions, confidence intervals and estimation, data classification, tabulation and presentation, skewness and kurtosis, moments MCQs and quiz to test study skills for CBAP/CCBA/PMI-PBA certifications. Business statistics multiple choice quiz questions and answers, statistics exam revision and study guide with practice tests for CBAP/CCBA/PMI-PBA for online exam prep and interviews. Business statistician interview questions and answers for data and statistical analyst to ask, to prepare and to study for jobs interviews and career MCQs with answer keys. Confidence intervals quiz has 21 multiple choice questions. Data classification, tabulation and presentation of data quiz has 65 multiple choice questions. Introduction to probability quiz has 64 multiple choice questions. Introduction to statistics quiz has 64 multiple choice questions with answers. Measures of central tendency in statistics quiz has 71 multiple choice questions. Measures of dispersion quiz has 97 multiple choice questions. Probability distributions quiz has 83 multiple choice questions. Sampling distributions quiz has 53 multiple choice questions. Skewness, kurtosis and moments quiz has 58 multiple choice questions. Business statistician interview questions and answers for data and statistical, MCQs on histograms, measures of dispersion, measures of central tendency, skewness and kurtosis, relative measure of skewness, coefficient of skewness, frequency distribution, relative frequency, frequency curve, arithmetic mean, average deviation measures, averages of position, Bayes theorem, binomial distribution, binomial probability distribution, exponential distribution, hypergeometric distribution, calculating moments, Chebyshev theorem, class width in statistics, classification and cluster sampling, confidence interval interpretation, definition of probability, discrete probability distributions, continuous probability distribution, normal distribution, Poisson distribution, data classification, data measurement in statistics, data tables and types, distance measures, empirical values, expected value and variance, harmonic mean, squared deviation, interquartile deviation, interquartile range of deviation, introduction of estimation, introduction to statistics, mean absolute deviation, measurements in statistics, measures of skewness, measuring dispersion, median, mean and mode, multiplication rules of probability, percentiles, population parameters and sample statistic, principles of measurement, principles of sampling, probability and counting rules, probability experiments, probability rules, random variable classes, rectangular distribution, mean and standard deviation relationship, relationship between mean median and mode, rules of probability and algebra, sample space, sample statistics, sampling distribution in statistics, sampling distributions, sampling techniques, skewness and skewed distribution, sources of data, standard errors in statistics, standard normal probability distribution, statistical analysis methods, statistical data analysis, statistical measures, statistical techniques, statistics formulas, stratified sampling, structured data, symmetrical distribution, types of bias, types of events, types of statistical methods, uniform distribution, standard deviation in statistics, variance and standard deviation, variance in statistics, business statistics worksheets for competitive exams preparation.

As of 8 Dec 2019, Excel has 479 Functions1. ABS function - Returns the absolute value of a number (Math and trigonometry)2. ACCRINT function - Returns the accrued interest for a security that pays periodic interest (Financial)3. ACCRINTM function - Returns the accrued interest for a security that pays interest at maturity (Financial)4. ACOS function - Returns the arccosine of a number (Math and trigonometry)5. ACOSH function - Returns the inverse hyperbolic cosine of a number (Math and trigonometry)6. ACOT function - Returns the arccotangent of a number (Math and trigonometry)7. ACOTH function - Returns the hyperbolic arccotangent of a number (Math and trigonometry)8. AGGREGATE function - Returns an aggregate in a list or database (Math and trigonometry)9. ADDRESS function - Returns a reference as text to a single cell in a worksheet (Lookup and reference)10. AMORDEGRC function - Returns the depreciation for each accounting period by using a depreciation coefficient (Financial)11. AMORLINC function - Returns the depreciation for each accounting period (Financial)12. AND function - Returns TRUE if all of its arguments are TRUE (Logical)13. ARABIC function - Converts a Roman number to Arabic, as a number (Math and trigonometry)14. AREAS function - Returns the number of areas in a reference (Lookup and reference)15. ASC function - Changes full-width (double-byte) English letters or katakana within a character string to half-width (single-byte) characters (Text)16. ASIN function - Returns the arcsine of a number (Math and trigonometry)17. ASINH function - Returns the inverse hyperbolic sine of a number (Math and trigonometry)18. ATAN function - Returns the arctangent of a number (Math and trigonometry)19. ATAN2 function - Returns the arctangent from x- and y-coordinates (Math and trigonometry)20. ATANH function - Returns the inverse hyperbolic tangent of a number (Math and trigonometry)21. AVEDEV function - Returns the average of the absolute deviations of data points from their mean (Statistical)22. AVERAGE function - Returns the average of its arguments (Statistical)23. AVERAGEA function - Returns the average of its arguments, including numbers, text, and logical values (Statistical)24. AVERAGEIF function - Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria (Statistical)25. AVERAGEIFS function - Returns the average (arithmetic mean) of all cells that meet multiple criteria. (Statistical)26. BAHTTEXT function - Converts a number to text, using the ß (baht) currency format (Text)27. BASE function - Converts a number into a text representation with the given radix (base) (Math and trigonometry)28. BESSELI function - Returns the modified Bessel function In(x) (Engineering)29. BESSELJ function - Returns the Bessel function Jn(x) (Engineering)30. BESSELK function - Returns the modified Bessel function Kn(x) (Engineering)31. BESSELY function - Returns the Bessel function Yn(x) (Engineering)32. BETADIST function - Returns the beta cumulative distribution function (Compatibility)33. BETA.DIST function - Returns the beta cumulative distribution function (Statistical)34. BETAINV function - Returns the inverse of the cumulative distribution function for a specified beta distribution (Compatibility)35. BETA.INV function - Returns the inverse of the cumulative distribution function for a specified beta distribution (Statistical)36. BIN2DEC function - Converts a binary number to decimal (Engineering)37. BIN2HEX function - Converts a binary number to hexadecimal (Engineering)38. BIN2OCT function - Converts a binary number to octal (Engineering)39. BINOMDIST function - Returns the individual term binomial distribution probability (Compatibility)40. BINOM.DIST function - Returns the individual term binomial distribution probability (Statistical)41. BINOM.DIST.RANGE function - Returns the probability of a trial result using a binomial distribution (Statistical)42. BINOM.INV function - Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value (Statistical)43. BITAND function - Returns a 'Bitwise And' of two numbers (Engineering)44. BITLSHIFT function - Returns a value number shifted left by shift_amount bits (Engineering)45. BITOR function - Returns a bitwise OR of 2 numbers (Engineering)46. BITRSHIFT function - Returns a value number shifted right by shift_amount bits (Engineering)47. BITXOR function - Returns a bitwise 'Exclusive Or' of two numbers (Engineering)48. CALL function - Calls a procedure in a dynamic link library or code resource (Add-in and Automation)49. CEILING function - Rounds a number to the nearest integer or to the nearest multiple of significance (Math and trigonometry)50. CEILING.MATH function - Rounds a number up, to the nearest integer or to the nearest multiple of significance (Math and trigonometry)51. CEILING.PRECISE function - Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. (Math and trigonometry)52. CELL function - Returns information about the formatting, location, or contents of a cell (Information)53. CHAR function - Returns the character specified by the code number (Text)54. CHIDIST function - Returns the one-tailed probability of the chi-squared distribution (Compatibility)55. CHIINV function - Returns the inverse of the one-tailed probability of the chi-squared distribution (Compatibility)56. CHITEST function - Returns the test for independence (Compatibility)57. CHISQ.DIST function - Returns the cumulative beta probability density function (Statistical)58. CHISQ.DIST.RT function - Returns the one-tailed probability of the chi-squared distribution (Statistical)59. CHISQ.INV function - Returns the cumulative beta probability density function (Statistical)60. CHISQ.INV.RT function - Returns the inverse of the one-tailed probability of the chi-squared distribution (Statistical)61. CHISQ.TEST function - Returns the test for independence (Statistical)62. CHOOSE function - Chooses a value from a list of values (Lookup and reference)63. CLEAN function - Removes all nonprintable characters from text (Text)64. CODE function - Returns a numeric code for the first character in a text string (Text)65. COLUMN function - Returns the column number of a reference (Lookup and reference)66. COLUMNS function - Returns the number of columns in a reference (Lookup and reference)67. COMBIN function - Returns the number of combinations for a given number of objects (Math and trigonometry)68. COMBINA function - Returns the number of combinations with repetitions for a given number of items (Math and trigonometry)69. COMPLEX function - Converts real and imaginary coefficients into a complex number (Engineering)70. CONCAT function - Combines the text from multiple ranges and/or strings, but it doesn't provide the delimiter or IgnoreEmpty arguments. (Text)71. CONCATENATE function - Joins several text items into one text item (Text)72. CONFIDENCE function - Returns the confidence interval for a population mean (Compatibility)73. CONFIDENCE.NORM function - Returns the confidence interval for a population mean (Statistical)74. CONFIDENCE.T function - Returns the confidence interval for a population mean, using a Student's t distribution (Statistical)75. CONVERT function - Converts a number from one measurement system to another (Engineering)76. CORREL function - Returns the correlation coefficient between two data sets (Statistical)77. COS function - Returns the cosine of a number (Math and trigonometry)78. COSH function - Returns the hyperbolic cosine of a number (Math and trigonometry)79. COT function - Returns the hyperbolic cosine of a number (Math and trigonometry)80. COTH function - Returns the cotangent of an angle (Math and trigonometry)81. COUNT function - Counts how many numbers are in the list of arguments (Statistical)82. COUNTA function - Counts how many values are in the list of arguments (Statistical)83. COUNTBLANK function - Counts the number of blank cells within a range (Statistical)84. COUNTIF function - Counts the number of cells within a range that meet the given criteria (Statistical)85. COUNTIFS function - Counts the number of cells within a range that meet multiple criteria (Statistical)86. COUPDAYBS function - Returns the number of days from the beginning of the coupon period to the settlement date (Financial)87. COUPDAYS function - Returns the number of days in the coupon period that contains the settlement date (Financial)88. COUPDAYSNC function - Returns the number of days from the settlement date to the next coupon date (Financial)89. COUPNCD function - Returns the next coupon date after the settlement date (Financial)90. COUPNUM function - Returns the number of coupons payable between the settlement date and maturity date (Financial)91. COUPPCD function - Returns the previous coupon date before the settlement date (Financial)92. COVAR function - Returns covariance, the average of the products of paired deviations (Compatibility)93. COVARIANCE.P function - Returns covariance, the average of the products of paired deviations (Statistical)94. COVARIANCE.S function - Returns the sample covariance, the average of the products deviations for each data point pair in two data sets (Statistical)95. CRITBINOM function - Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value (Compatibility)96. CSC function - Returns the cosecant of an angle (Math and trigonometry)97. CSCH function - Returns the hyperbolic cosecant of an angle (Math and trigonometry)98. CUBEKPIMEMBER function - Returns a key performance indicator (KPI) name, property, and measure, and displays the name and property in the cell. A KPI is a quantifiable measurement, such as monthly gross profit or quarterly employee turnover, used to monitor an organization's performance. (Cube)99. CUBEMEMBER function - Returns a member or tuple in a cube hierarchy. Use to validate that the member or tuple exists in the cube. (Cube)100. CUBEMEMBERPROPERTY function - Returns the value of a member property in the cube. Use to validate that a member name exists within the cube and to return the specified property for this member. (Cube)101. CUBERANKEDMEMBER function - Returns the nth, or ranked, member in a set. Use to return one or more elements in a set, such as the top sales performer or top 10 students. (Cube)102. CUBESET function - Defines a calculated set of members or tuples by sending a set expression to the cube on the server, which creates the set, and then returns that set to Microsoft Office Excel. (Cube)103. CUBESETCOUNT function - Returns the number of items in a set. (Cube)104. CUBEVALUE function - Returns an aggregated value from a cube. (Cube)105. CUMIPMT function - Returns the cumulative interest paid between two periods (Financial)106. CUMPRINC function - Returns the cumulative principal paid on a loan between two periods (Financial)107. DATE function - Returns the serial number of a particular date (Date and time)108. DATEDIF function - Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. (Date and time)109. DATEVALUE function - Converts a date in the form of text to a serial number (Date and time)110. DAVERAGE function - Returns the average of selected database entries (Database)111. DAY function - Converts a serial number to a day of the month (Date and time)112. DAYS function - Returns the number of days between two dates (Date and time)113. DAYS360 function - Calculates the number of days between two dates based on a 360-day year (Date and time)114. DB function - Returns the depreciation of an asset for a specified period by using the fixed-declining balance method (Financial)115. DBCS function - Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters (Text)116. DCOUNT function - Counts the cells that contain numbers in a database (Database)117. DCOUNTA function - Counts nonblank cells in a database (Database)118. DDB function - Returns the depreciation of an asset for a specified period by using the double-declining balance method or some other method that you specify (Financial)119. DEC2BIN function - Converts a decimal number to binary (Engineering)120. DEC2HEX function - Converts a decimal number to hexadecimal (Engineering)121. DEC2OCT function - Converts a decimal number to octal (Engineering)122. DECIMAL function - Converts a text representation of a number in a given base into a decimal number (Math and trigonometry)123. DEGREES function - Converts radians to degrees (Math and trigonometry)124. DELTA function - Tests whether two values are equal (Engineering)125. DEVSQ function - Returns the sum of squares of deviations (Statistical)126. DGET function - Extracts from a database a single record that matches the specified criteria (Database)127. DISC function - Returns the discount rate for a security (Financial)128. DMAX function - Returns the maximum value from selected database entries (Database)129. DMIN function - Returns the minimum value from selected database entries (Database)130. DOLLAR function - Converts a number to text, using the $ (dollar) currency format (Text)131. DOLLARDE function - Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number (Financial)132. DOLLARFR function - Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction (Financial)133. DPRODUCT function - Multiplies the values in a particular field of records that match the criteria in a database (Database)134. DSTDEV function - Estimates the standard deviation based on a sample of selected database entries (Database)135. DSTDEVP function - Calculates the standard deviation based on the entire population of selected database entries (Database)136. DSUM function - Adds the numbers in the field column of records in the database that match the criteria (Database)137. DURATION function - Returns the annual duration of a security with periodic interest payments (Financial)138. DVAR function - Estimates variance based on a sample from selected database entries (Database)139. DVARP function - Calculates variance based on the entire population of selected database entries (Database)140. EDATE function - Returns the serial number of the date that is the indicated number of months before or after the start date (Date and time)141. EFFECT function - Returns the effective annual interest rate (Financial)142. ENCODEURL function - Returns a URL-encoded string (Web)143. EOMONTH function - Returns the serial number of the last day of the month before or after a specified number of months (Date and time)144. ERF function - Returns the error function (Engineering)145. ERF.PRECISE function - Returns the error function (Engineering)146. ERFC function - Returns the complementary error function (Engineering)147. ERFC.PRECISE function - Returns the complementary ERF function integrated between x and infinity (Engineering)148. ERROR.TYPE function - Returns a number corresponding to an error type (Information)149. EUROCONVERT function - 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). (Add-in and Automation)150. EVEN function - Rounds a number up to the nearest even integer (Math and trigonometry)151. EXACT function - Checks to see if two text values are identical (Text)152. EXP function - Returns e raised to the power of a given number (Math and trigonometry)153. EXPON.DIST function - Returns the exponential distribution (Statistical)154. EXPONDIST function - Returns the exponential distribution (Compatibility)155. FACT function - Returns the factorial of a number (Math and trigonometry)156. FACTDOUBLE function - Returns the double factorial of a number (Math and trigonometry)157. FALSE function - Returns the logical value FALSE (Logical)158. F.DIST function - Returns the F probability distribution (Statistical)159. FDIST function - Returns the F probability distribution (Compatibility)160. F.DIST.RT function - Returns the F probability distribution (Statistical)161. FILTER function - Filters a range of data based on criteria you define (Lookup and reference)162. FILTERXML function - Returns specific data from the XML content by using the specified XPath (Web)163. FIND, FINDB functions - Finds one text value within another (case-sensitive) (Text)164. F.INV function - Returns the inverse of the F probability distribution (Statistical)165. F.INV.RT function - Returns the inverse of the F probability distribution (Statistical)166. FINV function - Returns the inverse of the F probability distribution (Statistical)167. FISHER function - Returns the Fisher transformation (Statistical)168. FISHERINV function - Returns the inverse of the Fisher transformation (Statistical)169. FIXED function - Formats a number as text with a fixed number of decimals (Text)170. FLOOR function - Rounds a number down, toward zero (Compatibility)171. FLOOR.MATH function - Rounds a number down, to the nearest integer or to the nearest multiple of significance (Math and trigonometry)172. FLOOR.PRECISE function - Rounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up. (Math and trigonometry)173. FORECAST function - Returns a value along a linear trend (Statistical)175. FORECAST.ETS function - Returns a future value based on existing (historical) values by using the AAA version of the Exponential Smoothing (ETS) algorithm (Statistical)176. FORECAST.ETS.CONFINT function - Returns a confidence interval for the forecast value at the specified target date (Statistical)177. FORECAST.ETS.SEASONALITY function - Returns the length of the repetitive pattern Excel detects for the specified time series (Statistical)178. FORECAST.ETS.STAT function - Returns a statistical value as a result of time series forecasting (Statistical)179. FORECAST.LINEAR function - Returns a future value based on existing values (Statistical)180. FORMULATEXT function - Returns the formula at the given reference as text (Lookup and reference)181. FREQUENCY function - Returns a frequency distribution as a vertical array (Statistical)182. F.TEST function - Returns the result of an F-test (Statistical)183. FTEST function - Returns the result of an F-test (Compatibility)184. FV function - Returns the future value of an investment (Financial)185. FVSCHEDULE function - Returns the future value of an initial principal after applying a series of compound interest rates (Financial)186. GAMMA function - Returns the Gamma function value (Statistical)187. GAMMA.DIST function - Returns the gamma distribution (Statistical)188. GAMMADIST function - Returns the gamma distribution (Compatibility)189. GAMMA.INV function - Returns the inverse of the gamma cumulative distribution (Statistical)190. GAMMAINV function - Returns the inverse of the gamma cumulative distribution (Compatibility)191. GAMMALN function - Returns the natural logarithm of the gamma function, Γ(x) (Statistical)192. GAMMALN.PRECISE function - Returns the natural logarithm of the gamma function, Γ(x) (Statistical)193. GAUSS function - Returns 0.5 less than the standard normal cumulative distribution (Statistical)194. GCD function - Returns the greatest common divisor (Math and trigonometry)195. GEOMEAN function - Returns the geometric mean (Statistical)196. GESTEP function - Tests whether a number is greater than a threshold value (Engineering)197. GETPIVOTDATA function - Returns data stored in a PivotTable report (Lookup and reference)198. GROWTH function - Returns values along an exponential trend (Statistical)199. HARMEAN function - Returns the harmonic mean (Statistical)200. HEX2BIN function - Converts a hexadecimal number to binary (Engineering)201. HEX2DEC function - Converts a hexadecimal number to decimal (Engineering)202. HEX2OCT function - Converts a hexadecimal number to octal (Engineering)203. HLOOKUP function - Looks in the top row of an array and returns the value of the indicated cell (Lookup and reference)204. HOUR function - Converts a serial number to an hour (Date and time)205. HYPERLINK function - Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet (Lookup and reference)206. HYPGEOM.DIST function - Returns the hypergeometric distribution (Statistical)207. HYPGEOMDIST function - Returns the hypergeometric distribution (Compatibility)208. IF function - Specifies a logical test to perform (Logical)209. IFERROR function - Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula (Logical)210. IFNA function - Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression (Logical)211. IFS function - Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. (Logical)212. IMABS function - Returns the absolute value (modulus) of a complex number (Engineering)213. IMAGINARY function - Returns the imaginary coefficient of a complex number (Engineering)214. IMARGUMENT function - Returns the argument theta, an angle expressed in radians (Engineering)215. IMCONJUGATE function - Returns the complex conjugate of a complex number (Engineering)216. IMCOS function - Returns the cosine of a complex number (Engineering)217. IMCOSH function - Returns the hyperbolic cosine of a complex number (Engineering)218. IMCOT function - Returns the cotangent of a complex number (Engineering)219. IMCSC function - Returns the cosecant of a complex number (Engineering)220. IMCSCH function - Returns the hyperbolic cosecant of a complex number (Engineering)221. IMDIV function - Returns the quotient of two complex numbers (Engineering)222. IMEXP function - Returns the exponential of a complex number (Engineering)223. IMLN function - Returns the natural logarithm of a complex number (Engineering)224. IMLOG10 function - Returns the base-10 logarithm of a complex number (Engineering)225. IMLOG2 function - Returns the base-2 logarithm of a complex number (Engineering)226. IMPOWER function - Returns a complex number raised to an integer power (Engineering)227. IMPRODUCT function - Returns the product of complex numbers (Engineering)228. IMREAL function - Returns the real coefficient of a complex number (Engineering)229. IMSEC function - Returns the secant of a complex number (Engineering)230. IMSECH function - Returns the hyperbolic secant of a complex number (Engineering)231. IMSIN function - Returns the sine of a complex number (Engineering)232. IMSINH function - Returns the hyperbolic sine of a complex number (Engineering)233. IMSQRT function - Returns the square root of a complex number (Engineering)234. IMSUB function - Returns the difference between two complex numbers (Engineering)235. IMSUM function - Returns the sum of complex numbers (Engineering)236. IMTAN function - Returns the tangent of a complex number (Engineering)237. INDEX function - Uses an index to choose a value from a reference or array (Lookup and reference)238. INDIRECT function - Returns a reference indicated by a text value (Lookup and reference)239. INFO function - Returns information about the current operating environment (Information)240. INT function - Rounds a number down to the nearest integer (Math and trigonometry)241. INTERCEPT function - Returns the intercept of the linear regression line (Statistical)242. INTRATE function - Returns the interest rate for a fully invested security (Financial)243. IPMT function - Returns the interest payment for an investment for a given period (Financial)244. IRR function - Returns the internal rate of return for a series of cash flows (Financial)245. ISBLANK function - Returns TRUE if the value is blank (Information)246. ISERR function - Returns TRUE if the value is any error value except #N/A (Information)247. ISERROR function - Returns TRUE if the value is any error value (Information)248. ISEVEN function - Returns TRUE if the number is even (Information)249. ISFORMULA function - Returns TRUE if there is a reference to a cell that contains a formula (Information)250. ISLOGICAL function - Returns TRUE if the value is a logical value (Information)251. ISNA function - Returns TRUE if the value is the #N/A error value (Information)252. ISNONTEXT function - Returns TRUE if the value is not text (Information)253. ISNUMBER function - Returns TRUE if the value is a number (Information)254. ISODD function - Returns TRUE if the number is odd (Information)255. ISREF function - Returns TRUE if the value is a reference (Information)256. ISTEXT function - Returns TRUE if the value is text (Information)257. ISO.CEILING function - Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance (Math and trigonometry)258. ISOWEEKNUM function - Returns the number of the ISO week number of the year for a given date (Date and time)259. ISPMT function - Calculates the interest paid during a specific period of an investment (Financial)260. JIS function - Changes half-width (single-byte) characters within a string to full-width (double-byte) characters (Text)261. KURT function - Returns the kurtosis of a data set (Statistical)262. LARGE function - Returns the k-th largest value in a data set (Statistical)263. LCM function - Returns the least common multiple (Math and trigonometry)264. LEFT, LEFTB functions - Returns the leftmost characters from a text value (Text)265. LEN, LENB functions - Returns the number of characters in a text string (Text)266. LINEST function - Returns the parameters of a linear trend (Statistical)267. LN function - Returns the natural logarithm of a number (Math and trigonometry)268. LOG function - Returns the logarithm of a number to a specified base (Math and trigonometry)269. LOG10 function - Returns the base-10 logarithm of a number (Math and trigonometry)270. LOGEST function - Returns the parameters of an exponential trend (Statistical)271. LOGINV function - Returns the inverse of the lognormal cumulative distribution (Compatibility)272. LOGNORM.DIST function - Returns the cumulative lognormal distribution (Statistical)273. LOGNORMDIST function - Returns the cumulative lognormal distribution (Compatibility)274. LOGNORM.INV function - Returns the inverse of the lognormal cumulative distribution (Statistical)275. LOOKUP function - Looks up values in a vector or array (Lookup and reference)276. LOWER function - Converts text to lowercase (Text)277. MATCH function - Looks up values in a reference or array (Lookup and reference)278. MAX function - Returns the maximum value in a list of arguments (Statistical)279. MAXA function - Returns the maximum value in a list of arguments, including numbers, text, and logical values (Statistical)280. MAXIFS function - Returns the maximum value among cells specified by a given set of conditions or criteria (Statistical)281. MDETERM function - Returns the matrix determinant of an array (Math and trigonometry)282. MDURATION function - Returns the Macauley modified duration for a security with an assumed par value of $100 (Financial)283. MEDIAN function - Returns the median of the given numbers (Statistical)284. MID, MIDB functions - Returns a specific number of characters from a text string starting at the position you specify (Text)285. MIN function - Returns the minimum value in a list of arguments (Statistical)286. MINIFS function - Returns the minimum value among cells specified by a given set of conditions or criteria. (Statistical)287. MINA function - Returns the smallest value in a list of arguments, including numbers, text, and logical values (Statistical)288. MINUTE function - Converts a serial number to a minute (Date and time)289. MINVERSE function - Returns the matrix inverse of an array (Math and trigonometry)290. MIRR function - Returns the internal rate of return where positive and negative cash flows are financed at different rates (Financial)291. MMULT function - Returns the matrix product of two arrays (Math and trigonometry)292. MOD function - Returns the remainder from division (Math and trigonometry)293. MODE function - Returns the most common value in a data set (Compatibility)294. MODE.MULT function - Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data (Statistical)295. MODE.SNGL function - Returns the most common value in a data set (Statistical)296. MONTH function - Converts a serial number to a month (Date and time)297. MROUND function - Returns a number rounded to the desired multiple (Math and trigonometry)298. MULTINOMIAL function - Returns the multinomial of a set of numbers (Math and trigonometry)299. MUNIT function - Returns the unit matrix or the specified dimension (Math and trigonometry)300. N function - Returns a value converted to a number (Information)301. NA function - Returns the error value #N/A (Information)302. NEGBINOM.DIST function - Returns the negative binomial distribution (Statistical)303. NEGBINOMDIST function - Returns the negative binomial distribution (Compatibility)304. NETWORKDAYS function - Returns the number of whole workdays between two dates (Date and time)305. NETWORKDAYS.INTL function - Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days (Date and time)306. NOMINAL function - Returns the annual nominal interest rate (Financial)307. NORM.DIST function - Returns the normal cumulative distribution (Statistical)308. NORMDIST function - Returns the normal cumulative distribution (Compatibility)309. NORMINV function - Returns the inverse of the normal cumulative distribution (Statistical)310. NORM.INV function - Returns the inverse of the normal cumulative distribution (Compatibility)311. NORM.S.DIST function - Returns the standard normal cumulative distribution (Statistical)312. NORMSDIST function - Returns the standard normal cumulative distribution (Compatibility)313. NORM.S.INV function - Returns the inverse of the standard normal cumulative distribution (Statistical)314. NORMSINV function - Returns the inverse of the standard normal cumulative distribution (Compatibility)315. NOT function - Reverses the logic of its argument (Logical)316. NOW function - Returns the serial number of the current date and time (Date and time)317. NPER function - Returns the number of periods for an investment (Financial)318. NPV function - Returns the net present value of an investment based on a series of periodic cash flows and a discount rate (Financial)319. NUMBERVALUE function - Converts text to number in a locale-independent manner (Text)320. OCT2BIN function - Converts an octal number to binary (Engineering)321. OCT2DEC function - Converts an octal number to decimal (Engineering)322. OCT2HEX function - Converts an octal number to hexadecimal (Engineering)323. ODD function - Rounds a number up to the nearest odd integer (Math and trigonometry)324. ODDFPRICE function - Returns the price per $100 face value of a security with an odd first period (Financial)325. ODDFYIELD function - Returns the yield of a security with an odd first period (Financial)326. ODDLPRICE function - Returns the price per $100 face value of a security with an odd last period (Financial)327. ODDLYIELD function - Returns the yield of a security with an odd last period (Financial)328. OFFSET function - Returns a reference offset from a given reference (Lookup and reference)329. OR function - Returns TRUE if any argument is TRUE (Logical)330. PDURATION function - Returns the number of periods required by an investment to reach a specified value (Financial)331. PEARSON function - Returns the Pearson product moment correlation coefficient (Statistical)332. PERCENTILE.EXC function - Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive (Statistical)333. PERCENTILE.INC function - Returns the k-th percentile of values in a range (Statistical)334. PERCENTILE function - Returns the k-th percentile of values in a range (Compatibility)335. PERCENTRANK.EXC function - Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set (Statistical)336. PERCENTRANK.INC function - Returns the percentage rank of a value in a data set (Statistical)337. PERCENTRANK function - Returns the percentage rank of a value in a data set (Compatibility)338. PERMUT function - Returns the number of permutations for a given number of objects (Statistical)339. PERMUTATIONA function - Returns the number of permutations for a given number of objects (with repetitions) that can be selected from the total objects (Statistical)340. PHI function - Returns the value of the density function for a standard normal distribution (Statistical)341. PHONETIC function - Extracts the phonetic (furigana) characters from a text string (Text)342. PI function - Returns the value of pi (Math and trigonometry)343. PMT function - Returns the periodic payment for an annuity (Financial)344. POISSON.DIST function - Returns the Poisson distribution (Statistical)345. POISSON function - Returns the Poisson distribution (Compatibility)346. POWER function - Returns the result of a number raised to a power (Math and trigonometry)347. PPMT function - Returns the payment on the principal for an investment for a given period (Financial)348. PRICE function - Returns the price per $100 face value of a security that pays periodic interest (Financial)349. PRICEDISC function - Returns the price per $100 face value of a discounted security (Financial)350. PRICEMAT function - Returns the price per $100 face value of a security that pays interest at maturity (Financial)351. PROB function - Returns the probability that values in a range are between two limits (Statistical)352. PRODUCT function - Multiplies its arguments (Math and trigonometry)353. PROPER function - Capitalizes the first letter in each word of a text value (Text)354. PV function - Returns the present value of an investment (Financial)355. QUARTILE function - Returns the quartile of a data set (Compatibility)356. QUARTILE.EXC function - Returns the quartile of the data set, based on percentile values from 0..1, exclusive (Statistical)357. QUARTILE.INC function - Returns the quartile of a data set (Statistical)358. QUOTIENT function - Returns the integer portion of a division (Math and trigonometry)359. RADIANS function - Converts degrees to radians (Math and trigonometry)360. RAND function - Returns a random number between 0 and 1 (Math and trigonometry)361. RANDARRAY function - Returns an array of random numbers between 0 and 1. However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values. (Math and trigonometry)362. RANDBETWEEN function - Returns a random number between the numbers you specify (Math and trigonometry)363. RANK.AVG function - Returns the rank of a number in a list of numbers (Statistical)364. RANK.EQ function - Returns the rank of a number in a list of numbers (Statistical)365. RANK function - Returns the rank of a number in a list of numbers (Compatibility)366. RATE function - Returns the interest rate per period of an annuity (Financial)367. RECEIVED function - Returns the amount received at maturity for a fully invested security (Financial)368. http://REGISTER.ID function - Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered (Add-in and Automation)369. REPLACE, REPLACEB functions - Replaces characters within text (Text)370. REPT function - Repeats text a given number of times (Text)371. RIGHT, RIGHTB functions - Returns the rightmost characters from a text value (Text)372. ROMAN function - Converts an arabic numeral to roman, as text (Math and trigonometry)373. ROUND function - Rounds a number to a specified number of digits (Math and trigonometry)374. ROUNDDOWN function - Rounds a number down, toward zero (Math and trigonometry)375. ROUNDUP function - Rounds a number up, away from zero (Math and trigonometry)376. ROW function - Returns the row number of a reference (Lookup and reference)377. ROWS function - Returns the number of rows in a reference (Lookup and reference)378. RRI function - Returns an equivalent interest rate for the growth of an investment (Financial)379. RSQ function - Returns the square of the Pearson product moment correlation coefficient (Statistical)380. RTD function - Retrieves real-time data from a program that supports COM automation (Lookup and reference)381. SEARCH, SEARCHB functions - Finds one text value within another (not case-sensitive) (Text)382. SEC function - Returns the secant of an angle (Math and trigonometry)383. SECH function - Returns the hyperbolic secant of an angle (Math and trigonometry)384. SECOND function - Converts a serial number to a second (Date and time)385. SEQUENCE function - Generates a list of sequential numbers in an array, such as 1, 2, 3, 4 (Math and trigonometry)386. SERIESSUM function - Returns the sum of a power series based on the formula (Math and trigonometry)387. SHEET function - Returns the sheet number of the referenced sheet (Information)388. SHEETS function - Returns the number of sheets in a reference (Information)389. SIGN function - Returns the sign of a number (Math and trigonometry)390. SIN function - Returns the sine of the given angle (Math and trigonometry)391. SINH function - Returns the hyperbolic sine of a number (Math and trigonometry)392. SKEW function - Returns the skewness of a distribution (Statistical)393. SKEW.P function - Returns the skewness of a distribution based on a population : a characterization of the degree of asymmetry of a distribution around its mean (Statistical)394. SLN function - Returns the straight-line depreciation of an asset for one period (Financial)395. SLOPE function - Returns the slope of the linear regression line (Statistical)396. SMALL function - Returns the k-th smallest value in a data set (Statistical)397. SORT function - Sorts the contents of a range or array (Lookup and reference)398. SORTBY function - Sorts the contents of a range or array based on the values in a corresponding range or array (Lookup and reference)399. SQRT function - Returns a positive square root (Math and trigonometry)400. SQRTPI function - Returns the square root of (number * pi) (Math and trigonometry)401. STANDARDIZE function - Returns a normalized value (Statistical)402. STDEV function - Estimates standard deviation based on a sample (Compatibility)403. STDEV.P function - Calculates standard deviation based on the entire population (Statistical)404. STDEV.S function - Estimates standard deviation based on a sample (Statistical)405. STDEVA function - Estimates standard deviation based on a sample, including numbers, text, and logical values (Statistical)406. STDEVP function - Calculates standard deviation based on the entire population (Compatibility)407. STDEVPA function - Calculates standard deviation based on the entire population, including numbers, text, and logical values (Statistical)408. STEYX function - Returns the standard error of the predicted y-value for each x in the regression (Statistical)409. SUBSTITUTE function - Substitutes new text for old text in a text string (Text)410. SUBTOTAL function - Returns a subtotal in a list or database (Math and trigonometry)411. SUM function - Adds its arguments (Math and trigonometry)412. SUMIF function - Adds the cells specified by a given criteria (Math and trigonometry)413. SUMIFS function - Adds the cells in a range that meet multiple criteria (Math and trigonometry)414. SUMPRODUCT function - Returns the sum of the products of corresponding array components (Math and trigonometry)415. SUMSQ function - Returns the sum of the squares of the arguments (Math and trigonometry)416. SUMX2MY2 function - Returns the sum of the difference of squares of corresponding values in two arrays (Math and trigonometry)417. SUMX2PY2 function - Returns the sum of the sum of squares of corresponding values in two arrays (Math and trigonometry)418. SUMXMY2 function - Returns the sum of squares of differences of corresponding values in two arrays (Math and trigonometry)419. SWITCH function - Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned. (Logical)420. SYD function - Returns the sum-of-years' digits depreciation of an asset for a specified period (Financial)421. T function - Converts its arguments to text (Text)422. TAN function - Returns the tangent of a number (Math and trigonometry)423. TANH function - Returns the hyperbolic tangent of a number (Math and trigonometry)424. TBILLEQ function - Returns the bond-equivalent yield for a Treasury bill (Financial)425. TBILLPRICE function - Returns the price per $100 face value for a Treasury bill (Financial)426. TBILLYIELD function - Returns the yield for a Treasury bill (Financial)427. T.DIST function - Returns the Percentage Points (probability) for the Student t-distribution (Statistical)428. T.DIST.2T function - Returns the Percentage Points (probability) for the Student t-distribution (Statistical)429. T.DIST.RT function - Returns the Student's t-distribution (Statistical)430. TDIST function - Returns the Student's t-distribution (Compatibility)431. TEXT function - Formats a number and converts it to text (Text)432. TEXTJOIN function - Combines the text from multiple ranges and/or strings, and includes a delimiter you specify between each text value that will be combined. If the delimiter is an empty text string, this function will effectively concatenate the ranges. (Text)433. TIME function - Returns the serial number of a particular time (Date and time)434. TIMEVALUE function - Converts a time in the form of text to a serial number (Date and time)435. T.INV function - Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom (Statistical)436. T.INV.2T function - Returns the inverse of the Student's t-distribution (Statistical)437. TINV function - Returns the inverse of the Student's t-distribution (Compatibility)438. TODAY function - Returns the serial number of today's date (Date and time)439. TRANSPOSE function - Returns the transpose of an array (Lookup and reference)440. TREND function - Returns values along a linear trend (Statistical)441. TRIM function - Removes spaces from text (Text)442. TRIMMEAN function - Returns the mean of the interior of a data set (Statistical)443. TRUE function - Returns the logical value TRUE (Logical)444. TRUNC function - Truncates a number to an integer (Math and trigonometry)445. T.TEST function - Returns the probability associated with a Student's t-test (Statistical)446. TTEST function - Returns the probability associated with a Student's t-test (Compatibility)447. TYPE function - Returns a number indicating the data type of a value (Information)448. UNICHAR function - Returns the Unicode character that is references by the given numeric value (Text)449. UNICODE function - Returns the number (code point) that corresponds to the first character of the text (Text)450. UNIQUE function - Returns a list of unique values in a list or range (Lookup and reference)451. UPPER function - Converts text to uppercase (Text)452. VALUE function - Converts a text argument to a number (Text)453. VAR function - Estimates variance based on a sample (Compatibility)454. VAR.P function - Calculates variance based on the entire population (Statistical)455. VAR.S function - Estimates variance based on a sample (Statistical)456. VARA function - Estimates variance based on a sample, including numbers, text, and logical values (Statistical)457. VARP function - Calculates variance based on the entire population (Compatibility)458. VARPA function - Calculates variance based on the entire population, including numbers, text, and logical values (Statistical)459. VDB function - Returns the depreciation of an asset for a specified or partial period by using a declining balance method (Financial)460. VLOOKUP function - Looks in the first column of an array and moves across the row to return the value of a cell (Lookup and reference)461. WEBSERVICE function - Returns data from a web service. (Web)462. WEEKDAY function - Converts a serial number to a day of the week (Date and time)463. WEEKNUM function - Converts a serial number to a number representing where the week falls numerically with a year (Date and time)464. WEIBULL function - Calculates variance based on the entire population, including numbers, text, and logical values (Compatibility)465. WEIBULL.DIST function - Returns the Weibull distribution (Statistical)466. WORKDAY function - Returns the serial number of the date before or after a specified number of workdays (Date and time)467. WORKDAY.INTL function - Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days (Date and time)468. XIRR function - Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic (Financial)469. XLOOKUP function - Searches a range or an array, and returns an item corresponding to the first match it finds. If a match doesn't exist, then XLOOKUP can return the closest (approximate) match. (Lookup and reference)470. XMATCH function - Returns the relative position of an item in an array or range of cells. (Lookup and reference)471. XNPV function - Returns the net present value for a schedule of cash flows that is not necessarily periodic (Financial)472. XOR function - Returns a logical exclusive OR of all arguments (Logical)473. YEAR function - Converts a serial number to a year (Date and time)474. YEARFRAC function - Returns the year fraction representing the number of whole days between start_date and end_date (Date and time)475. YIELD function - Returns the yield on a security that pays periodic interest (Financial)476. YIELDDISC function - Returns the annual yield for a discounted security; for example, a Treasury bill (Financial)477. YIELDMAT function - Returns the annual yield of a security that pays interest at maturity (Financial)478. Z.TEST function - Returns the one-tailed probability-value of a z-test (Statistical)479. ZTEST function - Returns the one-tailed probability-value of a z-test (Compatibility)