Excel 2016
- After you share a workbook, you cannot sort or filter by cell color, font color, or cell icon on a filtered range, and any ...
- alpha,standard_dev,size!Returns the confidence interval for a population mean, using a normal distribution!is the significance ...
- alpha,standard_dev,size!Returns the confidence interval for a population mean, using a Student's T distribution!is the significance ...
- alpha,standard_dev,size!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the confidence ...
- Alternative text is applied to a PivotTable in this workbook. Alternative text on PivotTables will be removed in versions ...
- Alternative text is applied to a table in this workbook. Alternative text on tables will be removed in versions prior to ...
- An AllDifferent Constraint must have either no bounds, or a lower bound of 1 and an upper bound of N, where N is the number ...
- An array formula can't be entered in this range of cells. Make sure the cells you select are either all locked or all unlocked ...
- An embedded object in this worksheet is created in a newer version of Office. You cannot edit it in an earlier version of ...
- An error occurred during an attempt to establish a connection to the external data source. The following connections failed ...
- An error occurred while accessing application id {1} from Secure Store Service. The following connections failed to refresh:{2} ...
- An error occurred while adding this word to the custom dictionary. The dictionary file may be read-only. There may be a disk ...
- An error occurred while attempting to perform this operation.Reload the workbook, and then try to perform this operation ...
- An error occurred while attempting to set one or more of the parameters in this workbook.As a result, none of the parameters ...
- An error occurred while returning data to |. What do you want to do?* To discard your changes and close Microsoft Graph, ...
- An inactive relationship already exists between these two columns. Inactive relationships cannot be used by PivotTables and ...
- An inactive relationship already exists between these two columns. Inactive relationships cannot be used by PivotTables and ...
- An item name cannot be found. Check that you've typed the name correctly and the item is present in the PivotTable report. ...
- An item name in the formula does not match any of the items in the field.Check the field in the PivotTable report to make ...
- An item name is ambiguous. Another field in the PivotTable report may have an item with the same name.Use the syntax field[item]. ...
- An operation that uses the database driver could not be completed.If the driver is a Microsoft driver, make sure the driver ...
- An unexpected error has occurred during AutoRecover save. It may be possible to AutoRecover a minimal version of the file, ...
- Any data that you do not include in the cube file will not be available to the PivotTable until you reconnect to the server. ...
- Any data that you do not include in the local file cube will not be available to the PivotTable until you reconnect to the ...
- Any effects on this object will be removed. Any text that overflows the boundaries of this graphic will appear truncated. ...
- appears to have Worksheet Protection enabled. You must unprotect this worksheet to clean it.Would you like to continue processing ...
- Are you sure that you want to use a | chart type as the default for creating new charts? To use this chart type as the default ...
- Are you sure you want to open this workbook in {0:Excel}? While the workbook is open in {0:Excel}, no one will be able to ...
- array!Converts a vertical range of cells to a horizontal range, or vice versa!is a range of cells on a worksheet or an array ...
- array!Returns the inverse matrix for the matrix stored in an array!is a numeric array with an equal number of rows and columns, ...
- array!Returns the matrix determinant of an array!is a numeric array with an equal number of rows and columns, either a cell ...
- array!Returns the number of columns in an array or reference!is an array or array formula, or a reference to a range of cells ...
- array!Returns the number of rows in a reference or array!is an array, an array formula, or a reference to a range of cells ...
- array,k!Returns the k-th largest value in a data set. For example, the fifth largest number!is the array or range of data ...
- array,k!Returns the k-th percentile of values in a range, where k is in the range 0.1, exclusive!is the array or range of ...
- array,k!Returns the k-th percentile of values in a range, where k is in the range 0.1, inclusive!is the array or range of ...
- array,k!Returns the k-th smallest value in a data set. For example, the fifth smallest number!is an array or range of numerical ...
- array,k!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the k-th percentile of values ...
- array,percent!Returns the mean of the interior portion of a set of data values!is the range or array of values to trim and ...
- array,quart!Returns the quartile of a data set, based on percentile values from 0.1, exclusive!is the array or cell range ...
- array,quart!Returns the quartile of a data set, based on percentile values from 0.1, inclusive!is the array or cell range ...
- array,quart!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the quartile of a data ...
- array,row_num,column_num!reference,row_num,column_num,area_num!Returns a value or reference of the cell at the intersection ...
- array,x,sigma!Returns the one-tailed P-value of a z-test!is the array or range of data against which to test X!is the value ...
- array,x,sigma!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the one-tailed P-value ...
- array,x,significance!Returns the rank of a value in a data set as a percentage of the data set as a percentage (0.1, exclusive) ...
- array,x,significance!Returns the rank of a value in a data set as a percentage of the data set as a percentage (0.1, inclusive) ...
- array,x,significance!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the rank of ...
- array1,array2!Returns population covariance, the average of the products of deviations for each data point pair in two data ...
- array1,array2!Returns sample covariance, the average of the products of deviations for each data point pair in two data sets!is ...
- array1,array2!Returns the correlation coefficient between two data sets!is a cell range of values. The values should be numbers, ...
- array1,array2!Returns the matrix product of two arrays, an array with the same number of rows as array1 and columns as array2!is ...
- array1,array2!Returns the Pearson product moment correlation coefficient, r!is a set of independent values!is a set of dependent ...
- array1,array2!Returns the result of an F-test, the two-tailed probability that the variances in Array1 and Array2 are not ...
- array1,array2!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns covariance, the average ...
- array1,array2!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the result of an F-test, ...
- array1,array2,array3,.!Returns the sum of the products of corresponding ranges or arrays!are 2 to 255 arrays for which you ...
- array1,array2,tails,type!Returns the probability associated with a Student's t-Test!is the first data set!is the second data ...
- array1,array2,tails,type!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the probability ...
- array_x,array_y!Returns the sum total of the sums of squares of numbers in two corresponding ranges or arrays!is the first ...
- array_x,array_y!Sums the differences between the squares of two corresponding ranges or arrays!is the first range or array ...
- array_x,array_y!Sums the squares of the differences in two corresponding ranges or arrays!is the first range or array of ...
- as a picture. This format is better than Bitmap for printing to high quality printers. Also the Picture format takes less ...
- As you change these settings, check the preview chart to make sure you get the look you want. To see more settings, click ...
- At least one field in this PivotTable has Top 10 AutoShow applied. Top 10 filtering has been improved in (!idspnExcel_2007) ...
- At least one item must be showing. If you don't want to show the field at all, cancel the current operation, and then drag ...
- At least one of the changing cells you specified contains a formula. Formulas in changing cells will be replaced by constant ...
- AutoSort and AutoShow can't be used with custom calculations that use positional references. Do you want to turn off AutoSort/AutoShow? ...
- average_range,criteria_range,criteria,.!Finds average(arithmetic mean) for the cells specified by a given set of conditions ...
- Be careful what information you share. Make sure you know who is requesting it and how that information is going to be used ...
- Be careful. The query to get the data might be unsafe so you should only refresh the workbook if you trust its source.Do ...
- Be careful. This workbook contains one or more queries that might be unsafe.And remember, workbooks automatically save periodically. ...
- Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and then choose ...
- Because the maximum indentation limit for a cell has been reached, the next field will be displayed in a separate column. ...
- Because the query for this page field does not return any items, the options for the field cannot be changed. If you expected ...