1. SUM: Adds up all the numbers in a range of cells 2. AVERAGE: Calculates the average of a range of cells 3. MAX: Returns the largest number in a range of cells 4. MIN: Returns the smallest number in a range of cells 5. COUNT: Counts the number of cells in a range that contain numbers 6. COUNTA: Counts the number of cells in a range that are not empty 7. IF: Performs a logical test and returns one value if the test is true and another value if the test is false 8. VLOOKUP: Searches for a value in the first column of a table and returns a value in the same row from another column 9. CONCATENATE: Joins two or more text strings into one string 10. ROUND: Rounds a number to a specified number of digits 11. INDEX: Returns the value of a cell in a table based on the row and column number 12. MATCH: Searches for a specified value in a range of cells and returns the relative position of that item 13. SUMIF: Adds up all the numbers in a range of cells that meet a specified condition 14. AVERAGEIF: Calculates the average of a range of cells that meet a specified condition 15. COUNTIF: Counts the number of cells in a range that meet a specified condition.
0
Google Gemini AI
Jun 2
- AVERAGE: Calculates the average of a range of cells. - COUNT: Counts the number of cells in a range that contain a value. - COUNTIF: Counts the number of cells in a range that meet a specific criteria. - MAX: Returns the maximum value in a range of cells. - MIN: Returns the minimum value in a range of cells. - SUM: Calculates the sum of a range of cells. - IF: Performs a logical test and returns a value if the test is true, and a different value if the test is false. - VLOOKUP: Looks up a value in a table and returns the corresponding value in a specified column. - HLOOKUP: Looks up a value in a table and returns the corresponding value in a specified row. - INDIRECT: Returns the value of a cell that is specified by a text string. - OFFSET: Returns a range of cells that is offset from a specified cell by a specified number of rows and columns. - MATCH: Finds the position of a value in a range of cells. - INDEX: Returns the value of a cell in a range of cells that is specified by a row and column number. - RANK: Returns the rank of a value in a range of cells. - PERCENTILE: Returns the percentile of a value in a range of cells. - QUARTILE: Returns the quartile of a value in a range of cells. - SKEW: Returns the skewness of a range of cells. - KURTOSIS: Returns the kurtosis of a range of cells. - VAR: Returns the variance of a range of cells. - STDEV: Returns the standard deviation of a range of cells. - COVAR: Returns the covariance of two ranges of cells. - CORREL: Returns the correlation coefficient of two ranges of cells. - LINEST: Returns the linear regression coefficients for a range of cells. - LOGEST: Returns the exponential regression coefficients for a range of cells. - TREND: Returns the linear trendline for a range of cells. - GROWTH: Returns the exponential trendline for a range of cells. - FORECAST: Returns a forecast value based on a linear or exponential trendline. - MDETERM: Returns the coefficient of determination for a linear or exponential trendline. - RSQ: Returns the R-squared value for a linear or exponential trendline. - TINV: Returns the inverse of the Student's t-distribution. - FINV: Returns the inverse of the F-distribution. - CHIDINV: Returns the inverse of the chi-squared distribution. - NORMSINV: Returns the inverse of the standard normal distribution. - TTEST: Performs a Student's t-test on two ranges of cells. - ANOVA: Performs an analysis of variance on two or more ranges of cells. - REGRESSION: Performs a multiple linear regression on a range of cells. - CORREL: Calculates the correlation coefficient between two ranges of cells. - COVAR: Calculates the covariance between two ranges of cells. - BINOMDIST: Returns the probability of a binomial distribution. - POISSON: Returns the probability of a Poisson distribution. - HYPGEOMDIST: Returns the probability of a hypergeometric distribution. - --NORM