A To Z of Excel Functions | New Functions Introduced in 2010

 

EXCEL FUNCTIONS IN 2010

New Functions in 2010

Excel 2010 Introduced 61 New Worksheet Functions.

Read up other functions here.


AGGREGATEReturns an aggregate in a list or database. Replaces SUBTOTAL.
BETA.DISTReturns the cumulative beta probability density function. Replaces BETADIST.
BETA.INVReturns the inverse of the cumulative beta probability density function. Replaces BETAINV.
BINOM.DISTReturns the individual term binomial distribution probability. Replaces BINOMDIST.
BINOM.INVReturns the smallest number which is the cumulative binomial distribution that is greater than a criterion value. Replaces CRITBINOM.
CEILING.PRECISERounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
CHISQ.DISTReturns the cumulative beta probability density function.
CHISQ.DIST.RTReturns the one tailed probability of the chi-squared distribution. Replaces CHIDIST.
CHISQ.INVReturns the random variable where the probability of getting 'less than' it is P.
CHISQ.INV.RTReturns the inverse of the one tailed probability of the chi-squared distribution. Replaces CHIINV.
CHISQ.TESTReturns the value from the chi-squared distribution. Replaces CHITEST.
CONFIDENCE.NORMReturns the confidence interval for a population mean. Replaces CONFIDENCE.
CONFIDENCE.TReturns the confidence interval for a population mean, using a Student's t distribution.
COVARIANCE.PReturns the covariance of two lists of numbers. Replaces COVAR.
COVARIANCE.SReturns the sample covariance, the average of the products deviations for each data point pair in two data sets.
ERF.PRECISEReturns the error function.
ERFC.PRECISEReturns the complementary ERF function integrated between x and infinity.
EXPON.DISTReturns the exponential distribution. Replaces EXPONDIST.
F.DISTReturns the F probability distribution.
F.DIST.RTReturns the F probability distribution. Replaces FDIST.
F.INVReturns the inverse of the F probability distribution.
F.INV.RTReturns the inverse of the F probability distribution. Replaces FINV.
F.TESTReturns the result of an F-test. Replaces FTEST.
FLOOR.PRECISERounds a number the nearest integer or to the nearest multiple of significance. Regardless of the sign of the number, the number is rounded up.
GAMMA.DISTReturns the gamma distribution. Replaces GAMMADIST.
GAMMA.INVReturns the inverse of the gamma distribution. Replaces GAMMAINV.
GAMMALN.PRECISEReturns the natural logarithm of the gamma function, G(x).
HYPGEOM.DISTReturns the hyper geometric distribution for a finite population. Replaces HYPGEOMDIST.
ISO.CEILINGRounds a number up to the nearest integer or to the nearest multiple of significance.
LOGNORM.DISTReturns the cumulative lognormal distribution of x, where ln(x) is normally distributed with parameters mean and standard_dev. Replaces LOGNORMDIST.
LOGNORM.INVReturns the inverse of the lognormal cumulative distribution function of x, where ln(x) is normally distributed with parameters mean and standard_dev. Replaces LOGINV.
MODE.MULTReturns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.
MODE.SNGLReturns the number that occurs most frequently in a range. Replaces MODE.
NEGBINOM.DISTReturns the negative binomial distribution. Replaces NEGBINOMDIST.
NETWORKDAYS.INTLReturns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days. Replaces NETWORKDAYS.
NORM.DISTReturns the normal cumulative distribution. Replaces NORMDIST.
NORM.INVReturns the inverse of the normal cumulative distribution. Replaces NORMINV.
NORM.S.DISTReturns the standard normal cumulative distribution. Replaces NORMSDIST.
NORM.S.INVReturns the inverse of the standard normal cumulative distribution. Replaces NORMSINV.
PERCENTILE.EXCReturns the Kth percentile of values in a range, where k is in the range 0..1, exclusive.
PERCENTILE.INCThe Kth percentile of values in an array of numbers. Replaces PERCENTILE.
PERCENTRANK.EXCReturns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set.
PERCENTRANK.INCReturns the rank of a value in a data set as a percentage of the data set. Replaces PERCENTRANK.
POISSON.DISTReturns the Poisson distribution. Replaces POISSON.
QUARTILE.EXCReturns the quartile of the data set, based on percentile values from 0..1, exclusive.
QUARTILE.INCReturns the quartile of a data set. Replaces QUARTILE.
RANK.AVGReturns the rank of a number in a list of numbers: its size relative to other values in the list; if more than one value has the same rank, the average rank is returned.
RANK.EQReturns the rank of a number in a list of numbers. Replaces RANK.
STDEV.PReturns the standard deviation based on the entire population. Replaces STDEVP.
STDEV.SReturns the standard deviation based on a sample. Replaces STDEV.
T.DISTReturns the Percentage Points (probability) for the Student's t-distribution.
T.DIST.2TReturns the two-tailed Student's t-distribution. Replaces TDIST.
T.DIST.RTReturns the right-tailed Student's t-distribution. Replaces TDIST.
T.INVReturns the T-value of the Student's t-distribution as a function of the probability and the degrees of freedom.
T.INV.2TReturns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. Replaces TINV.
T.TESTReturns the probability associated with the F-Test. Replaces TTEST.
VAR.PReturns the variance based on the entire population. Replaces VARP.
VAR.SReturns the variance based on a sample. Replaces VAR.
WEIBULL.DISTReturns the Weibull distribution. Replaces WEIBULL.
WORKDAY.INTLReturns the serial number that is a given number of days before or after a date. Replaces WORKDAY.
Z.TESTReturns the two-tailed P-value of a z-test. Replaces ZTEST.

EXCEL FUNCTIONS BANK WORKBOOK




EXCEL FUNCTIONS INTRODUCED IN 2013


Comments

Post a Comment

Popular posts from this blog

Number Bond App

Image
INTRODUCTION Number bond is a mental picture of the relationship between a number and the parts that combine to make it. The concept of number bonds is very basic, an important foundation for understanding how numbers work. A whole thing is made up of parts. If you know the parts, you can put them together (add) to find the whole. If you know the whole and one of the parts, you take away the part you know (subtract) to find the other part. Number bonds let children see the inverse relationship between addition and subtraction. Subtraction is not a totally different thing from addition; they are mirror images. To subtract means to figure out how much more you would have to add to get the whole thing. Children start to learn about number bonds in the Foundation stage, when they might be given a number, such as 5, and then asked to select two groups of objects that will add up to that number. Number bonds in Year 1 Children are expected to know
Read more

A To Z of Excel Functions | Series 1

Image
  INTRODUCTION Excel is a spreadsheet program that helps calculate and organize data. It has many functions that allow you to do more than just calculations with your data. There are so many different functions in Excel that it is impossible to cover all of them in one article. But we will cover all in 5 different sections. We will show their functionalities, as well as how to use them for a range of purposes from data calculations to data visualizations. What is a Function? How to Find and Insert Functions on a Spreadsheet A function is a set of instructions for the spreadsheet that allows you to perform calculations on data. Functions can be inserted into a spreadsheet by typing them in, or selecting from a list. A function is typically made up of three components: a name, an argument, and an instruction. The name identifies what type of calculation the function will perform. Arguments are values that correspond to the data you want to use within the function. Instructions tell the s
Read more

Download Excel Functions Bank Workbook

Image
  Download the Excel Functions Bank for FREE. Where should we send your workbook? Put In Your Info To Download The Workbook. Name: Email: We respect your email privacy Excel With Excel | Prime Tech Academy  Microsoft Excel Online Course | Start Course Today
Read more

QUIZ WHIZ APP

Image
SimpleSchool QUIZ WHIZ- An editable and interactive quiz platform for both individual and group assessment with 1000+ Questions Bank and Timer. Good for mental drills, reviews, set induction, evaluation of concepts, group quiz competition and more… It can be used on PC and on Interactive White Board. It Contains 3 sections: 1. Instruction Page The Instruction/Home page is what you see when you load the application. It contains information and instruction on how to use the App. 2. Questions Bank This is a database where questions are stored. You can store up to 1000 questions under 10 categories (100 questions per category). You can make each category store questions on different subjects. To Upload or Type Questions in the Questions Bank Double-Click and type in the Category/Subject. Double-Click and type the questions in the questions box one after the other under your chosen
Read more

Excel Formula Expert 2

Image
Excel Formula  Excel Formulas in View If you're new to Excel, you'll soon find that it's more than just a grid in which you enter numbers in columns or rows. Sure, you can use Excel to find totals for a column or row of numbers, but you can also calculate a mortgage payment, solve math or engineering problems, or find a best case scenario based on variable numbers that you plug in. Excel does this by using formulas in cells. A formula performs calculations or other actions on the data in your worksheet. A formula always starts with an equal sign (=), which can be followed by numbers, math operators (like a + or - sign for addition or subtraction), and built-in Excel functions, which can really expand the power of a formula. For example, the following formula multiplies 2 by 3 and then adds 5 to that result to come up with the answer, 11. =2*3+5 Here are some additional examples of formulas that you can enter in a worksheet. =A1+A2+A3
Read more

Number Bond App 2- With 10 Timed Questions

Image
INTRODUCTION This is an updated version of 'My Number Bond App.' This version includes the 10 timed self graded questions with instant result. All the functionalities of the previous version remains. To get details of the other component Go to My Number Bond App 1 My Number Bond App 2 In order to make the teaching and learning of this important fundamental Mathematical concept easy to understand, Prime Academy Resource made this Microsoft Excel App called "My Number Bond." NUMBER BOND 1 VIDEO NUMBER BOND 2 VIDEO GET MY NUMBER BOND APP How Does My Number Bond App Works? When you load the Workbook you have this interface: You are required to update the setting form to suit your needs. The Setting Form Here you set the following: DECIMAL PLACE:  The decimal place tab has 3 options None 1 Decimal Place and 2 Decimal Place You click the drop  down arrow to select your preference. MATH OP
Read more