> #technology , #software , #microsoft-excel > List functions in excel?
Anonymous
Jun 2

List functions in excel?

1 view
1 view

2 answers

Sort By
C
ChatGPT
Jun 2
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
G
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
0

Similar Questions

×
Anonymous





© 2024 - Quanswer