Part of microsoft excel and their function

Horizontal Scroll Bar — Scroll bar to use when you want to scroll horizontally through the worksheet window. Zoom Controls — Used for magnifying and shrinking of the active worksheet. View Shortcuts — Buttons used to change how the worksheet content is displayed.

Sheet Tabs — Tabs the display the name of the worksheet in the workbook, by default its name sheet 1, sheet 2, etc. You can rename this to any name the best represent to your sheet.

Sheet Tab Scrolling Buttons — Buttons to scroll the sheet tabs in the workbook. Row Headings — The number that appears on the left of the worksheet window to identify the different rows.

Name Box — A box that displays the cell reference of the active cell. Formula Bar — A bar that displays the value or formula entered in the active cell. You will notice that in Excel there is a circle Office button while on the Excel it replace with File Tab. Spreadsheets can help organize information, such as alphabetizing a list of names or ordering records, and calculate and analyze information using mathematical formulas. The menu bar displays all of the menus available for use in Excel XP.

The contents of any menu can be displayed by left-clicking the menu name. Some commands in the menus have pictures or icons associated with them.

These pictures may also appear as shortcuts in the toolbar. Each Excel spreadsheet contains columns. Each column is named by a letter or combination of letters. The formula bar isplays information entered—or being entered as you type—in the current or active cell. The contents of a cell can also be edited in the formula bar. A cell is an intersection of a column and row. Each cell has a unique cell address.

In the picture above, the cell address of the selected cell is B3. The heavy border around the selected cell is called the cell pointer. Navigation buttons allow you to move to another worksheet in an Excel workbook. They are used to display the first, previous, next, and last worksheets in the workbook.

Sheet tabs separate a workbook into specific worksheets. A workbook defaults to three worksheets. A workbook must contain at least one worksheet. A workbook automatically shows in the workspace when you open Microsoft Excel XP. Each workbook contains three worksheets. A worksheet is a grid of cells consisting of 65, rows by columns. Spreadsheet information—text, numbers, or mathematical formulas—is entered into different cells.

Column headings are referenced by alphabetic characters in the gray boxes that run across the Excel screen, beginning with column A and ending with column IV. Rows are referenced by numbers that appear on the left and then run down the Excel screen. Statistical: Returns values along an exponential trend. Engineering: Converts a hexadecimal number to binary. Engineering: Converts a hexadecimal number to decimal. Engineering: Converts a hexadecimal number to octal.

Lookup and reference: Looks in the top row of an array and returns the value of the indicated cell. HOUR function. Date and time: Converts a serial number to an hour. Lookup and reference: Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet.

Statistical: Returns the hypergeometric distribution. Compatibility: Returns the hypergeometric distribution. IF function. Logical: Returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. IFNA function. IFS function. Logical: Checks whether one or more conditions are met and returns a value that corresponds to the first TRUE condition. IMABS function. Engineering: Returns the absolute value modulus of a complex number.

Engineering: Returns the imaginary coefficient of a complex number. Engineering: Returns the argument theta, an angle expressed in radians. Engineering: Returns the complex conjugate of a complex number. IMCOS function. Engineering: Returns the cosine of a complex number. Engineering: Returns the hyperbolic cosine of a complex number. IMCOT function. Engineering: Returns the cotangent of a complex number.

IMCSC function. Engineering: Returns the cosecant of a complex number. Engineering: Returns the hyperbolic cosecant of a complex number. IMDIV function. Engineering: Returns the quotient of two complex numbers. IMEXP function. Engineering: Returns the exponential of a complex number. IMLN function. Engineering: Returns the natural logarithm of a complex number.

IMLOG10 function. Engineering: Returns the base logarithm of a complex number. IMLOG2 function. Engineering: Returns the base-2 logarithm of a complex number. Engineering: Returns a complex number raised to an integer power. Engineering: Returns the product of complex numbers. Engineering: Returns the real coefficient of a complex number. IMSEC function. Engineering: Returns the secant of a complex number.

Engineering: Returns the hyperbolic secant of a complex number. IMSIN function. Engineering: Returns the sine of a complex number. Engineering: Returns the hyperbolic sine of a complex number.

Engineering: Returns the square root of a complex number. IMSUB function. Engineering: Returns the difference between two complex numbers. IMSUM function. Engineering: Returns the sum of complex numbers. IMTAN function. Engineering: Returns the tangent of a complex number. INDEX function. Lookup and reference: Uses an index to choose a value from a reference or array.

Lookup and reference: Returns a reference indicated by a text value. INFO function. Information: Returns information about the current operating environment.

INT function. Math and trigonometry: Rounds a number down to the nearest integer. Statistical: Returns the intercept of the linear regression line. Financial: Returns the interest rate for a fully invested security. IPMT function. Financial: Returns the interest payment for an investment for a given period.

IRR function. Financial: Returns the internal rate of return for a series of cash flows. ISERR function. ISNA function. ISODD function. ISREF function. Math and trigonometry: Returns a number that is rounded up to the nearest integer or to the nearest multiple of significance. Date and time: Returns the number of the ISO week number of the year for a given date. ISPMT function. Financial: Calculates the interest paid during a specific period of an investment.

JIS function. Text: Changes half-width single-byte characters within a string to full-width double-byte characters. KURT function. Statistical: Returns the kurtosis of a data set. LARGE function. Statistical: Returns the k-th largest value in a data set. LCM function. Math and trigonometry: Returns the least common multiple. Text: Returns the leftmost characters from a text value.

Text: Returns the number of characters in a text string. LET function. Math and trigonometry: Assigns names to calculation results to allow storing intermediate calculations, values, or defining names inside a formula. Statistical: Returns the parameters of a linear trend.

LN function. Math and trigonometry: Returns the natural logarithm of a number. LOG function. Math and trigonometry: Returns the logarithm of a number to a specified base. LOG10 function. Math and trigonometry: Returns the base logarithm of a number. Statistical: Returns the parameters of an exponential trend.

Compatibility: Returns the inverse of the lognormal cumulative distribution. Statistical: Returns the cumulative lognormal distribution. Compatibility: Returns the cumulative lognormal distribution. Statistical: Returns the inverse of the lognormal cumulative distribution. Lookup and reference: Looks up values in a vector or array. LOWER function. MATCH function. Lookup and reference: Looks up values in a reference or array. MAX function.

Statistical: Returns the maximum value in a list of arguments. MAXA function. Statistical: Returns the maximum value in a list of arguments, including numbers, text, and logical values. Statistical: Returns the maximum value among cells specified by a given set of conditions or criteria.

Math and trigonometry: Returns the matrix determinant of an array. Statistical: Returns the median of the given numbers. Text: Returns a specific number of characters from a text string starting at the position you specify.

MIN function. Statistical: Returns the minimum value in a list of arguments. Statistical: Returns the minimum value among cells specified by a given set of conditions or criteria. MINA function. Statistical: Returns the smallest value in a list of arguments, including numbers, text, and logical values.

Date and time: Converts a serial number to a minute. Math and trigonometry: Returns the matrix inverse of an array. MIRR function. Financial: Returns the internal rate of return where positive and negative cash flows are financed at different rates. MMULT function. Math and trigonometry: Returns the matrix product of two arrays.

MOD function. Math and trigonometry: Returns the remainder from division. MODE function. Compatibility: Returns the most common value in a data set. MULT function. Statistical: Returns a vertical array of the most frequently occurring, or repetitive values in an array or range of data.

SNGL function. Statistical: Returns the most common value in a data set. MONTH function. Date and time: Converts a serial number to a month. Math and trigonometry: Returns a number rounded to the desired multiple.

Math and trigonometry: Returns the multinomial of a set of numbers. MUNIT function. Math and trigonometry: Returns the unit matrix or the specified dimension. N function. Information: Returns a value converted to a number. NA function. Statistical: Returns the negative binomial distribution. Compatibility: Returns the negative binomial distribution. Date and time: Returns the number of whole workdays between two dates. INTL function. Date and time: Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days.

Financial: Returns the annual nominal interest rate. Statistical: Returns the normal cumulative distribution. Compatibility: Returns the normal cumulative distribution. Statistical: Returns the inverse of the normal cumulative distribution. Compatibility: Returns the inverse of the normal cumulative distribution. Statistical: Returns the standard normal cumulative distribution. Compatibility: Returns the standard normal cumulative distribution.

Statistical: Returns the inverse of the standard normal cumulative distribution. Compatibility: Returns the inverse of the standard normal cumulative distribution. NOT function. NOW function. Date and time: Returns the serial number of the current date and time. NPER function. Financial: Returns the number of periods for an investment. NPV function. Financial: Returns the net present value of an investment based on a series of periodic cash flows and a discount rate.

Text: Converts text to number in a locale-independent manner. Engineering: Converts an octal number to binary. Engineering: Converts an octal number to decimal. Engineering: Converts an octal number to hexadecimal.

ODD function. Math and trigonometry: Rounds a number up to the nearest odd integer. Financial: Returns the yield of a security with an odd first period. Financial: Returns the yield of a security with an odd last period. Lookup and reference: Returns a reference offset from a given reference.

OR function. Financial: Returns the number of periods required by an investment to reach a specified value. Statistical: Returns the Pearson product moment correlation coefficient. EXC function. Statistical: Returns the k-th percentile of values in a range, where k is in the range INC function. Statistical: Returns the k-th percentile of values in a range.

Compatibility: Returns the k-th percentile of values in a range. Statistical: Returns the rank of a value in a data set as a percentage Statistical: Returns the percentage rank of a value in a data set. Compatibility: Returns the percentage rank of a value in a data set.

Statistical: Returns the number of permutations for a given number of objects. Statistical: Returns the number of permutations for a given number of objects with repetitions that can be selected from the total objects.

PHI function. Statistical: Returns the value of the density function for a standard normal distribution. Text: Extracts the phonetic furigana characters from a text string. PI function. Math and trigonometry: Returns the value of pi. PMT function. Financial: Returns the periodic payment for an annuity. Compatibility: Returns the Poisson distribution. POWER function. Math and trigonometry: Returns the result of a number raised to a power. PPMT function. Financial: Returns the payment on the principal for an investment for a given period.

PRICE function. PROB function. Statistical: Returns the probability that values in a range are between two limits. Math and trigonometry: Multiplies its arguments. Text: Capitalizes the first letter in each word of a text value. PV function. Financial: Returns the present value of an investment. Compatibility: Returns the quartile of a data set. Statistical: Returns the quartile of the data set, based on percentile values from Statistical: Returns the quartile of a data set.

Math and trigonometry: Returns the integer portion of a division. Math and trigonometry: Converts degrees to radians. RAND function. Math and trigonometry: Returns a random number between 0 and 1. Math and trigonometry: Returns an array of random numbers between 0 and 1.

However, you can specify the number of rows and columns to fill, minimum and maximum values, and whether to return whole numbers or decimal values.

Math and trigonometry: Returns a random number between the numbers you specify. AVG function. Statistical: Returns the rank of a number in a list of numbers. EQ function. RANK function.

Compatibility: Returns the rank of a number in a list of numbers. RATE function. Financial: Returns the interest rate per period of an annuity. Financial: Returns the amount received at maturity for a fully invested security. ID function. Add-in and Automation: Returns the register ID of the specified dynamic link library DLL or code resource that has been previously registered.

REPT function. Text: Returns the rightmost characters from a text value. ROMAN function. Math and trigonometry: Converts an arabic numeral to roman, as text. ROUND function. Math and trigonometry: Rounds a number to a specified number of digits. Math and trigonometry: Rounds a number down, toward zero. Math and trigonometry: Rounds a number up, away from zero.

ROW function. Lookup and reference: Returns the row number of a reference. ROWS function. Lookup and reference: Returns the number of rows in a reference. RRI function. Financial: Returns an equivalent interest rate for the growth of an investment. RSQ function.