Excel 2007 what does mean

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. Statistical: Returns the square of the Pearson product moment correlation coefficient.

RTD function. Lookup and reference: Retrieves real-time data from a program that supports COM automation. Text: Finds one text value within another not case-sensitive. SEC function. Math and trigonometry: Returns the secant of an angle. SECH function. Math and trigonometry: Returns the hyperbolic secant of an angle.

Date and time: Converts a serial number to a second. Math and trigonometry: Generates a list of sequential numbers in an array, such as 1, 2, 3, 4. Math and trigonometry: Returns the sum of a power series based on the formula. SHEET function. Information: Returns the sheet number of the referenced sheet. Information: Returns the number of sheets in a reference. SIGN function. Math and trigonometry: Returns the sign of a number.

SIN function. Math and trigonometry: Returns the sine of the given angle. SINH function. Math and trigonometry: Returns the hyperbolic sine of a number.

SKEW function. Statistical: Returns the skewness of a distribution. Statistical: Returns the skewness of a distribution based on a population: a characterization of the degree of asymmetry of a distribution around its mean.

SLN function. Financial: Returns the straight-line depreciation of an asset for one period. SLOPE function. Statistical: Returns the slope of the linear regression line. SMALL function. Statistical: Returns the k-th smallest value in a data set.

SORT function. Lookup and reference: Sorts the contents of a range or array. Lookup and reference: Sorts the contents of a range or array based on the values in a corresponding range or array. SQRT function. Math and trigonometry: Returns a positive square root. STDEV function. Compatibility: Estimates standard deviation based on a sample.

Statistical: Calculates standard deviation based on the entire population. Statistical: Estimates standard deviation based on a sample. Statistical: Estimates standard deviation based on a sample, including numbers, text, and logical values. Compatibility: Calculates standard deviation based on the entire population. Statistical: Calculates standard deviation based on the entire population, including numbers, text, and logical values.

STEYX function. Statistical: Returns the standard error of the predicted y-value for each x in the regression. Text: Substitutes new text for old text in a text string. Math and trigonometry: Returns a subtotal in a list or database. SUM function. SUMIF function. Math and trigonometry: Adds the cells specified by a given criteria. Math and trigonometry: Adds the cells in a range that meet multiple criteria.

Math and trigonometry: Returns the sum of the products of corresponding array components. SUMSQ function. Math and trigonometry: Returns the sum of the squares of the arguments. Math and trigonometry: Returns the sum of the difference of squares of corresponding values in two arrays. Math and trigonometry: Returns the sum of the sum of squares of corresponding values in two arrays.

Math and trigonometry: Returns the sum of squares of differences of corresponding values in two arrays. Logical: Evaluates an expression against a list of values and returns the result corresponding to the first matching value. If there is no match, an optional default value may be returned.

SYD function. Financial: Returns the sum-of-years' digits depreciation of an asset for a specified period. TAN function. Math and trigonometry: Returns the tangent of a number.

TANH function. Math and trigonometry: Returns the hyperbolic tangent of a number. Financial: Returns the bond-equivalent yield for a Treasury bill. Financial: Returns the yield for a Treasury bill. Statistical: Returns the Percentage Points probability for the Student t-distribution.

Statistical: Returns the Student's t-distribution. TDIST function. Compatibility: Returns the Student's t-distribution. TEXT function. Text: Formats a number and converts it to text. If the delimiter is an empty text string, this function will effectively concatenate the ranges.

TIME function. Date and time: Returns the serial number of a particular time. Date and time: Converts a time in the form of text to a serial number. Statistical: Returns the t-value of the Student's t-distribution as a function of the probability and the degrees of freedom. Statistical: Returns the inverse of the Student's t-distribution. TINV function. Compatibility: Returns the inverse of the Student's t-distribution. TODAY function.

Date and time: Returns the serial number of today's date. Lookup and reference: Returns the transpose of an array.

TREND function. Statistical: Returns values along a linear trend. TRIM function. Statistical: Returns the mean of the interior of a data set. TRUE function. TRUNC function. Math and trigonometry: Truncates a number to an integer. Statistical: Returns the probability associated with a Student's t-test. TTEST function. Compatibility: Returns the probability associated with a Student's t-test. Information: Returns a number indicating the data type of a value.

Text: Returns the Unicode character that is references by the given numeric value. Text: Returns the number code point that corresponds to the first character of the text. Lookup and reference: Returns a list of unique values in a list or range. UPPER function. VALUE function. VAR function. Compatibility: Estimates variance based on a sample. Statistical: Calculates variance based on the entire population.

Statistical: Estimates variance based on a sample. VARA function. Statistical: Estimates variance based on a sample, including numbers, text, and logical values. VARP function. Compatibility: Calculates variance based on the entire population. VARPA function.

Statistical: Calculates variance based on the entire population, including numbers, text, and logical values. VDB function. Financial: Returns the depreciation of an asset for a specified or partial period by using a declining balance method. Lookup and reference: Looks in the first column of an array and moves across the row to return the value of a cell. Date and time: Converts a serial number to a day of the week.

Date and time: Converts a serial number to a number representing where the week falls numerically with a year. Compatibility: Calculates variance based on the entire population, including numbers, text, and logical values. Date and time: Returns the serial number of the date before or after a specified number of workdays. Date and time: Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days.

XIRR function. Financial: Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. Lookup and reference: Searches a range or an array, and returns an item corresponding to the first match it finds. Lookup and reference: Returns the relative position of an item in an array or range of cells. XNPV function. Financial: Returns the net present value for a schedule of cash flows that is not necessarily periodic.

XOR function. Logical: Returns a logical exclusive OR of all arguments. YEAR function. Date and time: Converts a serial number to a year. YIELD function. Financial: Returns the yield on a security that pays periodic interest.

Financial: Returns the annual yield for a discounted security; for example, a Treasury bill. Financial: Returns the annual yield of a security that pays interest at maturity. Statistical: Returns the one-tailed probability-value of a z-test. ZTEST function. Compatibility: Returns the one-tailed probability-value of a z-test. You can always ask an expert in the Excel Tech Community or get support in the Answers community. Excel functions by category.

Overview of formulas in Excel How to avoid broken formulas Detect errors in formulas. Formulas and functions. Excel functions alphabetical. Need more help? Expand your skills. Get new features first. Was this information helpful? Yes No. Thank you! Any more feedback? The more you tell us the more we can help. Can you help us improve? Resolved my issue. Clear instructions. Easy to follow. No jargon.

Pictures helped. Didn't match my screen. Incorrect instructions. Too technical. Not enough information. Not enough pictures. Any additional feedback? Submit feedback. Thank you for your feedback! Compatibility: Returns the beta cumulative distribution function In Excel , this is a Statistical function. Compatibility: Returns the inverse of the cumulative distribution function for a specified beta distribution In Excel , this is a Statistical function.

Compatibility: Returns the individual term binomial distribution probability In Excel , this is a Statistical function. Information: Returns information about the formatting, location, or contents of a cell This function is not available in Excel for the web. Compatibility: Returns the one-tailed probability of the chi-squared distribution Note: In Excel , this is a Statistical function.

Compatibility: Returns the inverse of the one-tailed probability of the chi-squared distribution Note: In Excel , this is a Statistical function. Compatibility: Returns the test for independence Note: In Excel , this is a Statistical function. Compatibility: Returns the confidence interval for a population mean In Excel , this is a Statistical function. Compatibility: Returns covariance, the average of the products of paired deviations In Excel , this is a Statistical function.

Compatibility: Returns the smallest value for which the cumulative binomial distribution is less than or equal to a criterion value In Excel , this is a Statistical function. Cube: Returns the number of items in a set. Database: Counts nonblank cells in a database. What to do In the Compatibility Checker, click Find to locate cells that have overlapping conditional formatting ranges, and then make the necessary changes to avoid overlap.

One or more cells in this workbook contain a conditional formatting type that is not supported in earlier versions of Excel, such as data bars, color scales, or icon sets. What it means In Excel , you will not see conditional formatting types, such as data bars, color scales, icon sets, top or bottom ranked values, above or below average values, unique or duplicate values, and table column comparison to determine which cells to format. What to do In the Compatibility Checker, click Find to locate cells that have conditional formatting types that are new in Excel and later, and then make the necessary changes to use only formatting types that are supported in the earlier versions of Excel.

Some cells contain conditional formatting with the 'Stop if True' option cleared. Earlier versions of Excel do not recognize this option and will stop after the first true condition.

What it means In Excel , conditional formatting without stopping when the condition has been met is not an option. Conditional formatting is no longer applied after the first condition is true. What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting with the Stop if True option cleared, and then click Fix to resolve the compatibility issue.

This is not supported in earlier versions of Excel. What it means In Excel , you will not see conditional formatting in nonadjacent cells. What to do In the Compatibility Checker, click Find to locate cells that contain a conditional formatting type on a nonadjacent range, and then make the necessary changes to use conditional formatting rules that are available in earlier versions of Excel.

Some PivotTables in this workbook contain conditional formatting that may not function correctly in earlier versions of Excel. The conditional formatting rules will not display the same results when you use these PivotTables in earlier versions of Excel.

What it means Conditional formatting results you see in Excel PivotTable reports will not be the same as in PivotTable reports created in Excel and later. What to do In the Compatibility Checker, click Find to locate PivotTable report fields that contain conditional formatting rules, and then apply conditional formatting rules that are available in the earlier versions of Excel. One or more cells in this workbook contain conditional formatting which refers to values on other worksheets.

These conditional formats will not be supported in earlier versions of Excel. What it means In Excel , conditional formatting that refers to values on other worksheets is not displayed. What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting that refers to values on other worksheets, and then apply conditional formatting that does not refer to values on other worksheets.

One or more cells in this workbook contain conditional formatting using the 'Text that contains' format with a cell reference or formula. What it means In Excel , conditional formatting that use formulas for text that contains rules is not displayed on the worksheet.

What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting that uses formulas for text that contains rules, and then apply conditional formatting that is supported in earlier versions of Excel.

One or more cells in this workbook contain a rule that will not be supported in earlier versions of Excel because there is a formula error in its range. What it means In Excel , conditional formatting that use range-based rules cannot be displayed correctly on the worksheet when the range-based rules contain formula errors.

What to do In the Compatibility Checker, click Find to locate cells that contain range-based rules that contain formula errors, and then make the necessary changes so that range-based rules do not contain formula errors. One or more cells in this workbook contain a conditional formatting icon set arrangement that is not supported in earlier versions of Excel. What it means In Excel , conditional formatting that displays a specific icon set arrangement is not supported and the icon set arrangement is not displayed on the worksheet.

However, all conditional formatting rules remain available in the workbook and are applied when the workbook is opened again in Excle and later, unless the rules were edited in Excel What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting that display a specific icon set arrangement, and then make sure that conditional formatting does not display that icon set arrangement.

One or more cells in this workbook contain a data bar rule that uses a "Negative Value" setting. These data bars will not be supported in earlier versions of Excel. What it means In Excel , conditional formatting that contains a data bar rule that uses a negative value is not displayed on the worksheet. What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting that contains negative data bars because the negative value format is set to Automatic in the New Formatting Rule dialog box or the Axis Settings have been set to Automatic or Cell midpoint in the Negative Value and Axis Settings dialog box, and then make the necessary changes.

One or more cells in this workbook contain conditional formatting which refers to more than discontinuous areas of cells. These conditional formats will not be saved. What it means In Excel , conditional formatting that refers to more than discontinuous areas of cells is not displayed on the worksheet. What to do In the Compatibility Checker, click Find to locate cells that contain conditional formatting that refer to more than discontinuous areas of cells, and then change the number of discontinuous areas of cells the conditional formatting refers to.

One or more cells in this workbook contain a data bar rule that uses a fill, border, or "bar direction" setting. What it means In Excel , conditional formatting that contains a data bar rule that uses a solid color fill or border or left to right and right to left bar direction settings for data bars is not displayed on the worksheet. However, all conditional formatting rules remain available in the workbook and are applied when the workbook is opened again in Excel or later, unless the rules were edited in Excel What to do In the Compatibility Checker, click Find to locate cells that contain a conditional formatting data bar rule that uses a solid color fill or border or left to right and right to left settings for data bars, and then and then make the necessary changes.

Unsupported charting features can cause the following compatibility issues, leading to a significant loss of functionality. A chart contains a title or data label with more than characters. Characters beyond the character limit will not be saved. What it means Chart or axis titles and data labels are limited to characters in Excel , and any characters beyond this limit will be lost. What to do In the Compatibility Checker, click Find to locate the titles or data labels that exceed the character limit, select the titles or data labels, and then edit them so that they contain or fewer characters.

Some formatting on charts in this workbook is not supported in earlier versions of Excel and will not be displayed. What it means Custom shape fills, shape outlines, and shape effects such as glow and bevel effects, or gradient line formatting are not available in Excel and cannot be displayed.

What to do In the Compatibility Checker, click Find to locate the custom formatting that is not supported, and then change that custom formatting to formatting that is supported in the earlier versions of Excel. Earlier versions of Excel only support the colors from the color palette. When the workbook is opened in an earlier version of Excel, all line colors will be mapped to the closest color in the color palette, and a chart may display multiple series in the same color.

What it means Beginning with Excel , there is support up to 16 million colors, but Excel limits the colors to those that are available on the standard color palette. Colors that are not supported will be changed to the closest color on the standard color palette, which may be a color that is already used.

What to do In the Compatibility Checker, click Find to locate the custom colors that are not supported, and then change the unsupported color formatting by using the standard color palette. This workbook contains charts with more data points than can be displayed by earlier versions of Excel. Only the first 32, data points per series in 2-D charts, and the first 4, data points per series in 3-D charts, will be displayed when the workbook is opened in a version of Excel prior to the current version.

What it means Beginning with Excel , you can use more than 32, data points per series in 2-D charts and more than 4, data points per series in 3-D charts. This exceeds the limits of data points per series in Excel What to do In the Compatibility Checker, click Find to locate the chart that exceeds the limit of data points per series, and then make the necessary changes to keep data points within the limit.

Unsupported graphics, object, and ActiveX features can cause the following compatibility issues, leading to a significant loss of functionality.

Any effects on this object will be removed. Any text that overflows the boundaries of this graphic will appear clipped. What it means Beginning with Excel , you can use special effects, such as transparent shadows that are not supported in Excel The special effects will be removed.

Also, beginning with Excel , when you insert text in a shape that is wider than the shape, the text displays across the boundaries of the shape. In Excel , this text is truncated. To avoid truncated text, you can adjust the size of the shape for a better fit. What to do In the Compatibility Checker, click Find to locate the objects that have special effects applied so that you can remove those effects as needed. What it means Embedded objects that are created in Excel and later cannot be edited in Excel What to do In the Compatibility Checker, click Find to locate the objects that contain text that will not be editable, and then make the necessary changes.

Uninitialized ActiveX controls cannot be transferred to the selected file format. The controls will be lost if you continue. What it means If a workbook contains ActiveX controls that are considered to be Unsafe for Initialization UFI , they are lost when you save the workbook to an earlier Excel file format.

What to do If you open a workbook that contains uninitialized ActiveX controls, and the workbook is set to high security, you must first use the Message Bar to enable them before they can be initialized. One or more objects in this workbook such as shapes, WordArt, or text boxes may allow text to overflow the object boundaries. Earlier versions of Excel do not recognize this option and will hide overflowing text. What it means Beginning with Excel , you can display text boxes on objects such as shapes and display the text beyond the boundaries of those objects.

In Excel , text that overflows the boundaries of an object will not be visible. What to do In the Compatibility Checker, click Find to locate the text box that contains text that overflows the boundaries of the shape, and then make the necessary changes to keep the text within the boundaries, and then turn the option to overflow text off Right-click the shape, Format Shape , Text Box category, Allow text to overflow shape check box.

This workbook contains Textboxes with text formatting not available in earlier versions of Excel. The text in the Textboxes will appear differently in the earlier versions of Excel. What it means Beginning with Excel , you can use a text box on objects such as shapes that displays more than one column of text.

In Excel , the text will be displayed but in a different format. What to do In the Compatibility Checker, click Find to locate the text box that displays more than one columns of text, and then make the necessary changes to display the text in one column only Right-click the shape, Format Shape , Text Box category, Columns button. Unsupported customization features can cause the following compatibility issues, leading to a minor loss of fidelity. These custom features will not be available in earlier versions of Excel.

What it means Because the Ribbon interface that was introduced with Office is very different from the menus and toolbars in Excel , any Quick Access Toolbar customizations that were made in Excel and later are not available in Excel What to do In Excel , you can add similar custom commands to toolbars and menus.

The following unsupported feature can cause compatibility issues, leading to a minor loss of fidelity. This workbook will be read-only and shared workbook features will not be available when someone opens it in an earlier version of Excel by using a file converter. To allow users to continue using the workbook as a shared workbook in earlier versions of Excel, you must save it in the file format of the earlier versions.

What it means If you turn on the Allow changes by more than one user What to do Save the workbook to the Excel file format, and then work with that workbook in Compatibility Mode. When you open a workbook that was created in Excel , and you no longer plan for anyone to work on this workbook in this earlier version, you can convert the workbook to the current XML-based file format.

When you convert to the current file format, you will have access to all new and enhanced features and functionality that newer versions of Excel offer, and the file size will generally be smaller. Convert the workbook to the current file format When you convert an Excel workbook, it is replaced with a copy of the workbook in the current file format of your choice. After the workbook is converted, it is no longer available in the original file format.

Note The workbook is opened in Compatibility Mode. In Excel , click the Office button. Tip If you do not want to see this message about converting workbooks, select the Do not ask me again about converting workbooks.

To work in the current file format, click Yes to close and reopen the workbook. Save the workbook in the current file format If you want to keep a copy of the workbook in the original file format, instead of converting the workbook, you can save a copy of the workbook in one of the current file formats. In the File name box, accept the suggested name or type a new name for the workbook. If the workbook contains macros that you want to retain, and you want to save the workbook as a template, click.

When you open a workbook in Excel or later that was created in Excel , some features of the earlier version of Excel are not supported in the workbook. Unsupported features have either been replaced by new features and functionality, or they have been removed because they were rarely used. Tip If features are not available on the ribbon but are still available in Excel, you can still use those features by adding them to the Quick Access Toolbar or the ribbon.

The following Excel features may function differently, have been removed, or are not available on the ribbon. You can use the AutoFormat feature to apply one of several autoformats to quickly format a range of data. Style galleries for tables, cells, and PivotTables provide a set of professional formats that can be applied quickly. You can choose from many predefined styles or create custom styles as needed.

Styles replace AutoFormat as the simplest way to apply formatting to a range of cells. You can also still use the AutoFormat command, but you have to add the command to the Quick Access Toolbar first. You can create an Excel list to make it easier to manage and analyze groups of related data in a worksheet. Excel lists are now referred to as Excel tables to match this feature in other Microsoft Office programs, such as Word and PowerPoint.

You can use an insert row a special row in Excel lists to quickly add a new row of data at the end of a list. The insert row is no longer available. To add new rows to a table, press TAB, or type, paste the data that you want to include just below a table. You can also insert rows to include additional rows of data. When you create a table, a defined name for the same range is created at the same time. This name can be used to reference the table in formulas that use the new, structured referencing feature.

Names that are used for lists in earlier versions of Excel might not meet the requirements for range names in Excel and later, and therefore cannot be used for referencing the table in formulas that use the new structured referencing feature. To use table names in structured references, you must change the defined names.

Two-way synchronization of Excel tables with SharePoint lists is no longer supported. When you export table data to a SharePoint list, you can only create a one-way connection to the data in the SharePoint list. With a one-way connection to the data in the SharePoint list, changes that are made to the data in the SharePoint list can be incorporated in Excel and later.

When you refresh the table data in Excel and later, the latest data from the SharePoint site overwrites the table data on the worksheet, including any changes that you made to the table data. In Excel and later,, you can no longer update a SharePoint list to include changes that you make to the table data in Excel, after that data has been exported. To preserve a two-way connection, you have to keep the workbook in Excel file format instead of converting it to the Excel and later file format.

For more information about how to replace or work around an unsupported feature, see the following articles:. Various types of simple use cases made Microsoft Excel a key end-user technology as well, useful in training and professional development. For a number of years, MS Excel has been included in basic business diploma courses on business computing, and temporary work agencies may assess individuals on their skills with Microsoft Word and Microsoft Excel for a wide range of clerical duties.

However, as the world of business technology has advanced, Microsoft Excel has become largely obsolete in some ways. Generally, companies and vendors have come up with neat new ways to present data visually that do not involve end users looking at a traditional spreadsheet with columns of numbers and identifiers.

Instead, they look at graphs and charts and other sophisticated presentations, to understand the numbers better and more quickly. The principle of data visualization has shifted the use cases for Microsoft Excel. Where businesses may have used Microsoft Excel in the past for, say, hundreds of records, most of today's business use cases involve spreadsheets that handle less than a few dozen values for any particular project.

The idea is that if the spreadsheet is longer than a couple of dozen rows, it will be more effective to display the information on a visual dashboard than in a traditional spreadsheet format. By: Justin Stoltzfus Contributor, Reviewer. By: Satish Balakrishnan. Dictionary Dictionary Term of the Day. One of the key benefits of functions is that they can save you time because you do not have to write the formula yourself.

For example, you could use an Excel function called Average to quickly find the average of a range of numbers or the Sum function to find the sum of a cell range. Download the example to work along with the video.