Excel 2016

  1. After you share a workbook, you cannot sort or filter by cell color, font color, or cell icon on a filtered range, and any ...
  2. alpha,standard_dev,size!Returns the confidence interval for a population mean, using a normal distribution!is the significance ...
  3. alpha,standard_dev,size!Returns the confidence interval for a population mean, using a Student's T distribution!is the significance ...
  4. alpha,standard_dev,size!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the confidence ...
  5. Alternative text is applied to a PivotTable in this workbook. Alternative text on PivotTables will be removed in versions ...
  6. Alternative text is applied to a table in this workbook. Alternative text on tables will be removed in versions prior to ...
  7. 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 ...
  8. 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 ...
  9. An embedded object in this worksheet is created in a newer version of Office. You cannot edit it in an earlier version of ...
  10. An error occurred during an attempt to establish a connection to the external data source. The following connections failed ...
  11. An error occurred while accessing application id {1} from Secure Store Service. The following connections failed to refresh:{2} ...
  12. An error occurred while adding this word to the custom dictionary. The dictionary file may be read-only. There may be a disk ...
  13. An error occurred while attempting to perform this operation.Reload the workbook, and then try to perform this operation ...
  14. An error occurred while attempting to set one or more of the parameters in this workbook.As a result, none of the parameters ...
  15. An error occurred while returning data to |. What do you want to do?* To discard your changes and close Microsoft Graph, ...
  16. An inactive relationship already exists between these two columns. Inactive relationships cannot be used by PivotTables and ...
  17. An inactive relationship already exists between these two columns. Inactive relationships cannot be used by PivotTables and ...
  18. An item name cannot be found. Check that you've typed the name correctly and the item is present in the PivotTable report. ...
  19. 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 ...
  20. An item name is ambiguous. Another field in the PivotTable report may have an item with the same name.Use the syntax field[item]. ...
  21. An operation that uses the database driver could not be completed.If the driver is a Microsoft driver, make sure the driver ...
  22. An unexpected error has occurred during AutoRecover save. It may be possible to AutoRecover a minimal version of the file, ...
  23. Any data that you do not include in the cube file will not be available to the PivotTable until you reconnect to the server. ...
  24. Any data that you do not include in the local file cube will not be available to the PivotTable until you reconnect to the ...
  25. Any effects on this object will be removed. Any text that overflows the boundaries of this graphic will appear truncated. ...
  26. appears to have Worksheet Protection enabled. You must unprotect this worksheet to clean it.Would you like to continue processing ...
  27. 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 ...
  28. 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 ...
  29. 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 ...
  30. array!Returns the inverse matrix for the matrix stored in an array!is a numeric array with an equal number of rows and columns, ...
  31. array!Returns the matrix determinant of an array!is a numeric array with an equal number of rows and columns, either a cell ...
  32. 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 ...
  33. 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 ...
  34. 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 ...
  35. 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 ...
  36. 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 ...
  37. 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 ...
  38. array,k!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the k-th percentile of values ...
  39. 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 ...
  40. array,quart!Returns the quartile of a data set, based on percentile values from 0.1, exclusive!is the array or cell range ...
  41. array,quart!Returns the quartile of a data set, based on percentile values from 0.1, inclusive!is the array or cell range ...
  42. array,quart!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the quartile of a data ...
  43. array,row_num,column_num!reference,row_num,column_num,area_num!Returns a value or reference of the cell at the intersection ...
  44. 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 ...
  45. array,x,sigma!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the one-tailed P-value ...
  46. 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) ...
  47. 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) ...
  48. array,x,significance!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the rank of ...
  49. array1,array2!Returns population covariance, the average of the products of deviations for each data point pair in two data ...
  50. array1,array2!Returns sample covariance, the average of the products of deviations for each data point pair in two data sets!is ...
  51. array1,array2!Returns the correlation coefficient between two data sets!is a cell range of values. The values should be numbers, ...
  52. array1,array2!Returns the matrix product of two arrays, an array with the same number of rows as array1 and columns as array2!is ...
  53. array1,array2!Returns the Pearson product moment correlation coefficient, r!is a set of independent values!is a set of dependent ...
  54. array1,array2!Returns the result of an F-test, the two-tailed probability that the variances in Array1 and Array2 are not ...
  55. array1,array2!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns covariance, the average ...
  56. array1,array2!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the result of an F-test, ...
  57. array1,array2,array3,.!Returns the sum of the products of corresponding ranges or arrays!are 2 to 255 arrays for which you ...
  58. array1,array2,tails,type!Returns the probability associated with a Student's t-Test!is the first data set!is the second data ...
  59. array1,array2,tails,type!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the probability ...
  60. array_x,array_y!Returns the sum total of the sums of squares of numbers in two corresponding ranges or arrays!is the first ...
  61. array_x,array_y!Sums the differences between the squares of two corresponding ranges or arrays!is the first range or array ...
  62. array_x,array_y!Sums the squares of the differences in two corresponding ranges or arrays!is the first range or array of ...
  63. as a picture. This format is better than Bitmap for printing to high quality printers. Also the Picture format takes less ...
  64. As you change these settings, check the preview chart to make sure you get the look you want. To see more settings, click ...
  65. At least one field in this PivotTable has Top 10 AutoShow applied. Top 10 filtering has been improved in (!idspnExcel_2007) ...
  66. 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 ...
  67. At least one of the changing cells you specified contains a formula. Formulas in changing cells will be replaced by constant ...
  68. AutoSort and AutoShow can't be used with custom calculations that use positional references. Do you want to turn off AutoSort/AutoShow? ...
  69. average_range,criteria_range,criteria,.!Finds average(arithmetic mean) for the cells specified by a given set of conditions ...
  70. Be careful what information you share. Make sure you know who is requesting it and how that information is going to be used ...
  71. Be careful. The query to get the data might be unsafe so you should only refresh the workbook if you trust its source.Do ...
  72. Be careful. This workbook contains one or more queries that might be unsafe.And remember, workbooks automatically save periodically. ...
  73. Because of your security settings, macros have been disabled. To run macros, you need to reopen this workbook, and then choose ...
  74. Because the maximum indentation limit for a cell has been reached, the next field will be displayed in a separate column. ...
  75. Because the query for this page field does not return any items, the options for the field cannot be changed. If you expected ...