 Connect with us

# Excel Formulas & Functions in PDF List Published

on Functions Excel Formulas Description AVERAGE =AVERAGE(number1,number2,…) Returns the average of its arguments AVERAGEIF =AVERAGEIF(range,criteria,[average_range]) Returns the average (arithmetic mean) of all the cells in a range that meet a given criteria COUNT =COUNT(value1,value2,…) Counts how many numbers are in the list of arguments COUNTA =COUNTA(value1,value2,…) Counts how many values are in the list of arguments COUNTBLANK =COUNTBLANK(range) Counts the number of blank cells within a range COUNTIF =COUNTIF(range,criteria) Counts the number of cells within a range that meet the given criteria COUNTIFS =COUNTIFS(criteria_range,criteria,…) Counts the number of cells within a range that meet multiple criteria MAX =MAX(number1,number2,…) Returns the maximum value in a list of arguments MEDIAN =MEDIAN(number1,number2,…) Returns the median of the given numbers MIN =MIN(number1,number2,…) Returns the minimum value in a list of arguments TEXT =TEXT(value,format_text) Formats a number and converts it to text AVERAGEA =AVERAGEA(value1,value2,…) Returns the average of its arguments, including numbers, text, and logical values AVERAGEIFS =AVERAGEIFS(average_range,criteria_range,criteria,…) Returns the average (arithmetic mean) of all cells that meet multiple criteria GEOMEAN =GEOMEAN(number1,number2,…) Returns the geometric mean INTERCEPT =INTERCEPT(known_y’s,known_x’s) Returns the intercept of the linear regression line LARGE =LARGE(array,k) Returns the k-th largest value in a data set LINEST =LINEST(known_y’s,known_x’s,const,stats) Returns the parameters of a linear trend LOGEST =LOGEST(known_y’s,known_x’s,const,stats) Returns the parameters of an exponential trend MAXA =MAXA(value1,value2,…) Returns the maximum value in a list of arguments, including numbers, text, and logical values MINA =MINA(value1,value2,…) Returns the smallest value in a list of arguments, including numbers, text, and logical values MODE.MULT

=MODE.MULT(number1,number2,…)

Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data MODE.SNGL =MODE.SNGL(number1,number2,…) Returns the most common value in a data set PROB =PROB(x_range,prob_range,lower_limit,upper_limit) Returns the probability that values in a range are between two limits RANK.AVG =RANK.AVG(number,ref,order) Returns the rank of a number in a list of numbers RANK.EQ =RANK.EQ(number,ref,order) Returns the rank of a number in a list of numbers SKEW =SKEW(number1,number2,…) Returns the skewness of a distribution SLOPE =SLOPE(known_y’s,known_x’s) Returns the slope of the linear regression line SMALL =SMALL(array,k) Returns the k-th smallest value in a data set STANDARDIZE =STANDARDIZE(x,mean,standard_dev) Returns a normalized value TREND =TREND(known_y’s,known_x’s,new_x’s,const) Returns values along a linear trend NORM.S.INV =NORM.S.INV(probability) Returns the inverse of the standard normal cumulative distribution AVEDEV =AVEDEV(number1,number2,…) Returns the average of the absolute deviations of data points from their mean BETA.DIST =BETA.DIST(x,alpha,beta,cumulative,A,B) Returns the beta cumulative distribution function BETA.INV =BETA.INV(probability,alpha,beta,A,B) Returns the inverse of the cumulative distribution function for a specified beta distribution BINOM.DIST =BINOM.DIST(number_s,trials,probability_s,cumulative) Returns the individual term binomial distribution probability BINOM.INV =BINOM.INV(trials,probability_s,alpha) Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value CHISQ.DIST =CHISQ.DIST(x,deg_freedom,cumulative) Returns the cumulative beta probability density function CHISQ.DIST.RT =CHISQ.DIST.RT(x,deg_freedom) Returns the one-tailed probability of the chi-squared distribution CHISQ.INV =CHISQ.INV(probability,deg_freedom) Returns the cumulative beta probability density function CHISQ.INV.RT =CHISQ.INV.RT(probability,deg_freedom) Returns the inverse of the one-tailed probability of the chi-squared distribution CHISQ.TEST =CHISQ.TEST(actual_range,expected_range) Returns the test for independence CONFIDENCE.NORM =CONFIDENCE.NORM(alpha,standard_dev,size) Returns the confidence interval for a population mean CONFIDENCE.T =CONFIDENCE.T(alpha,standard_dev,size) Returns the confidence interval for a population mean, using a Student’s t distribution CORREL =CORREL(array1,array2) Returns the correlation coefficient between two data sets COVARIANCE.P =COVARIANCE.P(array1,array2) Returns covariance, the average of the products of paired deviations COVARIANCE.S =COVARIANCE.S(array1,array2) Returns the sample covariance, the average of the products deviations for each data point pair in two data sets DEVSQ =DEVSQ(number1,number2,…) Returns the sum of squares of deviations EXPON.DIST =EXPON.DIST(x,lambda,cumulative) Returns the exponential distribution F.DIST =F.DIST(x,deg_freedom1,deg_freedom2,cumulative) Returns the F probability distribution F.DIST.RT =F.DIST.RT(x,deg_freedom1,deg_freedom2) Returns the F probability distribution F.INV =F.INV(probability,deg_freedom1,deg_freedom2) Returns the inverse of the F probability distribution F.INV.RT =F.INV.RT(probability,deg_freedom1,deg_freedom2) Returns the inverse of the F probability distribution F.TEST =F.TEST(array1,array2) Returns the result of an F-test FISHER =FISHER(x) Returns the Fisher transformation FISHERINV =FISHERINV(y) Returns the inverse of the Fisher transformation FREQUENCY =FREQUENCY(data_array,bins_array) Returns a frequency distribution as a vertical array GAMMA.DIST =GAMMA.DIST(x,alpha,beta,cumulative) Returns the gamma distribution GAMMA.INV =GAMMA.INV(probability,alpha,beta) Returns the inverse of the gamma cumulative distribution GAMMALN =GAMMALN(x) Returns the natural logarithm of the gamma function, G(x) GAMMALN.PRECISE =GAMMALN.PRECISE(x) Returns the natural logarithm of the gamma function, G(x) GROWTH =GROWTH(known_y’s,known_x’s,new_x’s,const) Returns values along an exponential trend HARMEAN =HARMEAN(number1,number2,…) Returns the harmonic mean HYPGEOM.DIST =HYPGEOM.DIST(sample_s,number_sample,population_s,number_pop,cumulative) Returns the hypergeometric distribution KURT =KURT(number1,number2,…) Returns the kurtosis of a data set LOGNORM.DIST =LOGNORM.DIST(x,mean,standard_dev,cumulative) Returns the cumulative lognormal distribution LOGNORM.INV =LOGNORM.INV(probability,mean,standard_dev) Returns the inverse of the lognormal cumulative distribution NEGBINOM.DIST =NEGBINOM.DIST(number_f,number_s,probability_s,cumulative) Returns the negative binomial distribution NORM.DIST =NORM.DIST(x,mean,standard_dev,cumulative) Returns the normal cumulative distribution NORM.INV =NORM.INV(probability,mean,standard_dev) Returns the inverse of the normal cumulative distribution NORM.S.DIST =NORM.S.DIST(z,cumulative) Returns the standard normal cumulative distribution PEARSON =PEARSON(array1,array2) Returns the Pearson product moment correlation coefficient PERCENTILE.EXC =PERCENTILE.EXC(array,k) Returns the k-th percentile of values in a range, where k is in the range 0..1, exclusive PERCENTILE.INC =PERCENTILE.INC(array,k) Returns the k-th percentile of values in a range PERCENTRANK.EXC =PERCENTRANK.EXC(array,x,significance) Returns the rank of a value in a data set as a percentage (0..1, exclusive) of the data set PERCENTRANK.INC =PERCENTRANK.INC(array,x,significance) Returns the percentage rank of a value in a data set PERMUT =PERMUT(number,number_chosen) Returns the number of permutations for a given number of objects POISSON.DIST =POISSON.DIST(x,mean,cumulative) Returns the Poisson distribution QUARTILE.EXC =QUARTILE.EXC(array,quart) Returns the quartile of the data set, based on percentile values from 0..1, exclusive QUARTILE.INC =QUARTILE.INC(array,quart) Returns the quartile of a data set RSQ =RSQ(known_y’s,known_x’s) Returns the square of the Pearson product moment correlation coefficient STDEV.P =STDEV.P(number1,number2,…) Calculates standard deviation based on the entire population STDEV.S =STDEV.S(number1,number2,…) Estimates standard deviation based on a sample STDEVA =STDEVA(value1,value2,…) Estimates standard deviation based on a sample, including numbers, text, and logical values STDEVPA =STDEVPA(value1,value2,…) Calculates standard deviation based on the entire population, including numbers, text, and logical values STEYX =STEYX(known_y’s,known_x’s) Returns the standard error of the predicted y-value for each x in the regression T.DIST =T.DIST(x,deg_freedom,cumulative) Returns the Percentage Points (probability) for the Student t-distribution T.DIST.2T =T.DIST.2T(x,deg_freedom) Returns the Percentage Points (probability) for the Student t-distribution T.DIST.RT =T.DIST.RT(x,deg_freedom) Returns the Student’s t-distribution T.INV =T.INV(probability,deg_freedom) Returns the t-value of the Student’s t-distribution as a function of the probability and the degrees of freedom T.INV.2T =T.INV.2T(probability,deg_freedom) Returns the inverse of the Student’s t-distribution T.TEST =T.TEST(array1,array2,tails,type) Returns the probability associated with a Student’s t-test TRIMMEAN =TRIMMEAN(array,percent) Returns the mean of the interior of a data set VAR.P =VAR.P(number1,number2,…) Calculates variance based on the entire population VAR.S =VAR.S(number1,number2,…) Estimates variance based on a sample VARA =VARA(value1,value2,…) Estimates variance based on a sample, including numbers, text, and logical values VARPA =VARPA(value1,value2,…) Calculates variance based on the entire population, including numbers, text, and logical values WEIBULL.DIST =WEIBULL.DIST(x,alpha,beta,cumulative) Returns the Weibull distribution Z.TEST =Z.TEST(array,x,sigma) Returns the one-tailed probability-value of a z-test

# upGrad Acquires TGA, Forays Into the INR 400 Billion Test Preparation Market in India Published

on upGrad Acquires TGA, Forays Into the INR 400 Billion Test Preparation Market in India

# Get Google Certified This Winter! Published

on Get Google Certified This Winter! | Shake Up Learning

# Blended Learning with Google (Part 2: Storytelling) – SULS089 Published

on Blended Learning with Google (Part 2: Storytelling) – SULS089 | Shake Up Learning

# Top 5 Essential Tech Devices for College Students Published

on It might be hard to spend a day without using a technological device, as these tools offer the desired convenience during our day to day activities. Likewise, at school, students need to break the tedious studying process, and the use of these modern devices can easily make them achieve this desired break.

As entertainment tools, technological devices can be used to ensure the utmost convenience when learning. Therefore, college and university students need to consider the following education gears and gadgets, as they enhance learning and play. As a parent, the guide below will help you choose the right device for your young ones.

### Laptops and Tablets

The recent tech advancements have seen incredible growth in online education. Therefore, it is right to say that most learning in the coming months will be web-based. As a result, investing in laptops or tablets will offer your kid the convenience they need to access the course materials and enjoy their free time through the available entertainment features. When purchasing school laptops and tablet, it is essential to consider the following features:

### Speed

To enjoy the maximum speed, go for laptops and tablets fitted with the latest 10th gen Intel i5 or i7 processors. The device should also have over 8 GB of ram and 128 GB Solid State Drive. Avoid purchasing HDD laptops because, even though their cost is relatively low, they are extremely slow compared to SSD counterparts.

### Portability

This is mainly affected by screen and overall machine size. Desktop and all-in-one computers are good for in-house use. They are powerful, and they ideally fit application as workstations. However, their portability issues make them a rare choice for those seeking computers for use in school. Therefore, ensure the student or essay helper gets a device that they can carry to class with ease.

### Screen Size and Resolution

Small screen laptops are easily portable. However, if you want a big screen, a desktop will be perfect for you, as it’s fixed. For resolution, go for a device that has over 1080p.

### Cost

There are multiple options available for purchase, depending on your budget. So, if you are looking for a mid-budget laptop, be ready to spend about \$500. However, it’s worth noting that with such a budget, you will be required to forgo some features such as:

• Battery life
• Webcam quality
• Speakers
• Mouse and typing experience

Besides, you can look for traditional laptops that are worth the \$500 price. For students looking for flexible gadgets, it is important to check the 2-in-1 tablets, which offer both laptops and tablets features.

### Smartphones

Fortunately, you can easily get a good smartphone even with a considerably low budget. For instance, even though many flagship phones go for over \$1000, you can easily get a top phone with a budget of less than \$450. Such phones also come with incredible features, including:

• High-resolution camera
• Superb software
• Auto-transcribing app

Around the said budget, you can also get a 5g phone that’s ideally worth the cost. The best thing to note is that the gadgets you get here offer premium security features, good battery life, incredible performance, and exceptional screen resolution.

Their main advantage is the incredibly fitted features that can help bolster your concentration in relatively noisy places. Therefore, you will be in a position to read with minimal disturbances, thanks to:

• The incredibly incorporated noise-cancellation features;
• The top-notch build quality making them super convenient
• Their high compatibility with multiple devices

### Note-Taking Apps

Cost and convenience here are the main factors to consider. For instance, Evernote and MS’s OneNote offer this convenience at a price that ideally fits under your budget. Evernote is compatible with all devices, and it has a free basic package. Here, you will have up to 60mbs storage capacity for text and photo uploading every month.

Evernote premium is available at highly affordable monthly subscriptions. For annual subscriptions, you access the service at half its price. With the package, you will have over 10 GB of uploads monthly. Besides, you can use the app on every device. Finally, it is worth noting that these apps support:

• Texts
• Images
• Handwriting
• Attachments
• Audio recordings
• Drawings

## Final Thoughts

These technological devices and apps offer students the utmost convenience in their studies. However, choosing the right device is highly important as the tool provides the desired value for money for all parties. Therefore, you can use the guide above to know some of the essential features that you ought to consider during the purchase of each educational tool.

Source: George Thompson. Georg is a stellar writer and a prominent journalist. His research studies in writing have helped thousands of students achieve better results. He shares valuable insights on writing that resonate with the readers. His articles garner a striking number of views, likes, and shares, and she finds this recognition as his biggest career achievement so far.