What is the Cell ADDRESS Function? The cell ADDRESS Function is categorized under Excel Lookup and Reference functions. It will provide a cell reference (its “address”) by taking the row number and column letter. The cell reference will be provided as a string of text. The function can return an address in a relative or…
What is the STANDARDIZE Z-Score Function? The STANDARDIZE Function is available under Excel Statistical functions. It will return a normalized value (z-score) based on the mean and standard deviation. A z-score, or standard score, is used for standardizing scores on the same scale by dividing a score’s deviation by the standard deviation in a data…
What is the SLOPE Function? The SLOPE Function is categorized under Excel Statistical functions. It will return the slope of the linear regression line through the data points in known_y’s and known_x’s. In financial analysis, the SLOPE function can be used to calculate the beta of a stock. Slope / Beta Formula =SLOPE(known_y’s, known_x’s) The…
What is the Maturity RECEIVED Function? The RECEIVED Function is categorized under Excel Financial functions. It will calculate the amount received at maturity for a fully invested security. As a financial analyst, the RECEIVED function helps calculate the amount that we will get from an investment if the duration of the investment and interest rate…
What is the F Distribution Function? The F.DIST Function is categorized under Excel Statistical functions. It will calculate the probability density function or the Cumulative Distribution Function for the F Distribution. It measures the degree of diversity between two data sets. For example, if we wish to find out the variability in the IQ scores…
What is the F.INV (Inverse F Distribution) Function? The F.INV Function is categorized under Excel Statistical functions. It will calculate the inverse of the Cumulative F Distribution for a supplied probability. As a financial analyst, the function is useful in understanding the variability of two data sets. One example is when we wish to analyze…
What is the F.TEST Probability Function? The F.TEST Function is categorized under Excel Statistical functions. It will return the result of an F-test for two given arrays or ranges. The function will return the two-tailed probability that the variances in the two supplied arrays are not significantly different. As a financial analyst, the function is…
What is the “Insert Data From Picture” Function? The “Insert Data From Picture” button is a function that can be found on the mobile version of Microsoft Excel. Using this function will open up the camera and allow the user to take a picture of numbers or text. This text will then be converted into spreadsheet…
What is the NPV Function? The NPV Function is an Excel Financial function that will calculate the Net Present Value (NPV) for a series of cash flows and a given discount rate. It is important to understand the Time Value of Money, which is a foundational building block of various Financial Valuation methods. In financial modeling, the NPV function…
