अगर आप Microsoft Excel चलाते है या फिर इक्सेल को चलना सीख रहे है ये पोस्ट आपके लिए ही है, क्योंकि मे आपके लिए कुछ MS Excel Compatibility Functions हिन्दी मे ले कर आया हु, जोकी आपको बहुत काम आने वाले है।
MS Excel Compatibility Function in Hindi
अगर आप Ms Excel मे Accounts या कोई ऐसा काम करते है जहा Finance या Insurance को ले के excel sheet बनानी पड़ती है तो नीचे दिए गए Compatibility Function आपके काम को बहुत ही आसान बना सकते है।
Function | Description |
---|---|
BETADIST function | Returns the beta cumulative distribution function |
BETAINV function | Returns the inverse of the cumulative distribution function for a specified beta distribution |
BINOMDIST function | Returns the individual term binomial distribution probability |
CHIDIST function | Returns the one-tailed probability of the chi-squared distribution |
CHIINV function | Returns the inverse of the one-tailed probability of the chi-squared distribution |
CHITEST function | Returns the test for independence |
CONCATENATE function | Joins two or more text strings into one string. |
CONFIDENCE function | Returns the confidence interval for a population mean |
COVAR function | Returns covariance, the average of the products of paired deviations |
CRITBINOM function | Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value |
EXPONDIST function | Returns the exponential distribution |
FDIST function | Returns the F probability distribution |
FINV function | Returns the inverse of the F probability distribution |
FORECAST function | Returns a value along a linear trend Note: In Excel 2016, this function is replaced with the new Forecasting functions, but it’s still available for compatibility with earlier versions. |
FLOOR function | Rounds a number down, toward zero |
FTEST function | Returns the result of an F-test |
GAMMADIST function | Returns the gamma distribution |
GAMMAINV function | Returns the inverse of the gamma cumulative distribution |
HYPGEOMDIST function | Returns the hypergeometric distribution |
LOGINV function | Returns the inverse of the lognormal cumulative distribution function |
LOGNORMDIST function | Returns the cumulative lognormal distribution |
MODE function | Returns the most common value in a data set |
NEGBINOMDIST function | Returns the negative binomial distribution |
NORMDIST function | Returns the normal cumulative distribution |
NORMINV function | Returns the inverse of the normal cumulative distribution |
NORMSDIST function | Returns the standard normal cumulative distribution |
NORMSINV function | Returns the inverse of the standard normal cumulative distribution |
PERCENTILE function | Returns the k-th percentile of values in a range |
PERCENTRANK function | Returns the percentage rank of a value in a data set |
POISSON function | Returns the Poisson distribution |
QUARTILE function | Returns the quartile of a data set |
RANK function | Returns the rank of a number in a list of numbers |
STDEV function | Estimates standard deviation based on a sample |
STDEVP function | Calculates standard deviation based on the entire population |
TDIST function | Returns the Student’s t-distribution |
TINV function | Returns the inverse of the Student’s t-distribution |
TTEST function | Returns the probability associated with a Student’s t-test |
VAR function | Estimates variance based on a sample |
VARP function | Calculates variance based on the entire population |
WEIBULL function | Returns the Weibull distribution |
ZTEST function | Returns the one-tailed probability-value of a z-test |
CALL function | Calls a procedure in a dynamic link library or code resource |
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). |
REGISTER.ID function | Returns the register ID of the specified dynamic link library (DLL) or code resource that has been previously registered |
MS Excel Compatibility Functions PDF Download
MS Excel Compatibility Function की PDF को डाउनलोड करना चाहते है तो हमारे Telegram Group से जुड़ कर आसानी से Excel Pdf को अपने मोबाईल computer मे डाउनलोड कर सकते है।
हमने यहा पर लगभग सभी MS Excel के Compatibility के Functions को हिन्दी मे इस लिस्ट मे समिल किया है, अगर आपके पास कोई Function है जोकी इस लिस्ट मे समिल हो सके तो हमे Comment मे बताए।
- MS Excel Logical Functions PDF List Download
- MS Excel Compatibility Functions List PDF Download
- MS Excel Engineering Functions List PDF Download
- MS Excel Statistical Functions List PDF Download
- MS Excel Text Functions List PDF Download
- MS Excel Financial Functions List PDF Download
- MS Excel Database Functions in Hindi
- MS Excel Date and Time Functions
- MS Excel Web Functions PDF Download
- MS Excel Lookup and Reference Functions List PDF Download
- MS Excel Math and Trigonometry Functions List PDF Download