Excel for Macintosh 2016

  1. Are you sure that you want to stop using the List Manager? If you do, column settings defined by the List Manager will be ...
  2. 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 ...
  3. Are you sure you want to turn off macro virus protection permanently?If you click Yes, you can turn macro virus protection ...
  4. arguments were entered for this function.For assistance with entering arguments for this function, use the Formula Builder.chid://4003Help ...
  5. 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 ...
  6. array!Returns the inverse matrix for the matrix stored in an array!is a numeric array with an equal number of rows and columns, ...
  7. array!Returns the matrix determinant of an array!is a numeric array with an equal number of rows and columns, either a cell ...
  8. 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 ...
  9. 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 ...
  10. 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 ...
  11. 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 ...
  12. 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 ...
  13. 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 ...
  14. array,k!This function is available for compatibility with Excel 2008 and earlier.Returns the k-th percentile of values in ...
  15. 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 ...
  16. array,quart!Returns the quartile of a data set, based on percentile values from 0.1, exclusive!is the array or cell range ...
  17. array,quart!Returns the quartile of a data set, based on percentile values from 0.1, inclusive!is the array or cell range ...
  18. array,quart!This function is available for compatibility with Excel 2008 and earlier.Returns the quartile of a data set!is ...
  19. array,row_num,column_num!reference,row_num,column_num,area_num!Returns a value or reference of the cell at the intersection ...
  20. 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 ...
  21. array,x,sigma!This function is available for compatibility with Excel 2008 and earlier.Returns the one-tailed P-value of ...
  22. 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) ...
  23. 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) ...
  24. array,x,significance!This function is available for compatibility with Excel 2008 and earlier.Returns the rank of a value ...
  25. array1,array2!Returns population covariance, the average of the products of deviations for each data point pair in two data ...
  26. array1,array2!Returns sample covariance, the average of the products of deviations for each data point pair in two data sets!is ...
  27. array1,array2!Returns the correlation coefficient between two data sets!is a cell range of values. The values should be numbers, ...
  28. array1,array2!Returns the matrix product of two arrays, an array with the same number of rows as array1 and columns as array2!is ...
  29. array1,array2!Returns the Pearson product moment correlation coefficient, r!is a set of independent values!is a set of dependent ...
  30. array1,array2!Returns the result of an F-test, the two-tailed probability that the variances in Array1 and Array2 are not ...
  31. array1,array2!This function is available for compatibility with Excel 2008 and earlier.Returns covariance, the average of ...
  32. array1,array2!This function is available for compatibility with Excel 2008 and earlier.Returns the result of an F-test, the ...
  33. array1,array2,array3,.!Returns the sum of the products of corresponding ranges or arrays!are 2 to 255 arrays for which you ...
  34. array1,array2,tails,type!Returns the probability associated with a Student's t-Test!is the first data set!is the second data ...
  35. array1,array2,tails,type!This function is available for compatibility with Excel 2008 and earlier.Returns the probability ...
  36. array_x,array_y!Returns the sum total of the sums of squares of numbers in two corresponding ranges or arrays!is the first ...
  37. array_x,array_y!Sums the differences between the squares of two corresponding ranges or arrays!is the first range or array ...
  38. array_x,array_y!Sums the squares of the differences in two corresponding ranges or arrays!is the first range or array of ...
  39. As a shortcut for adding or deleting major gridlines for the value axis of a chart, click the Value Axis Gridlines button ...
  40. As a shortcut for changing the color of the selected graphic object, cell, or chart, click the Fill Color button that is ...
  41. As a shortcut for changing the orientation of the selected text to rotated and facing down, click the Rotate Text Down button. ...
  42. As a shortcut for changing the orientation of the selected text to rotated and facing up, click the Rotate Text Up button. ...
  43. As a shortcut for finding the next occurrence of a number or text, press COMMAND+G. To find the previous occurrence, press ...
  44. As a shortcut for inserting a function into a formula, click the Edit Formula button (the = button) on the Formula bar, and ...
  45. As a shortcut for making text or numbers bold, click the Bold button on the Standard toolbar. To remove the bold format, ...
  46. As a shortcut for printing, click the Print button on Standard toolbar. This prints with current settings and does not display ...
  47. As you change these settings, check the preview chart to make sure you get the look you want. To see more settings, click ...
  48. At least one field in this PivotTable has Top 10 AutoShow applied. Top 10 filtering has been improved in Microsoft Excel ...
  49. At least one item must be showing. If you don't want to show the field at all, click the Delete button in the PivotTable ...
  50. At least one of the changing cells you specified contains a formula.Formulas in changing cells will be replaced by constant ...
  51. AutoFill can increment both the quarter and the year at the same time. For example: 1Q93, Q193, 1st Qtr 93, 1st Quarter 1993. ...
  52. Automates formatting of new items added to the end of a data range to match the format of the rest of the data range. Formulas ...
  53. Automatically checks cells for errors while you work. If a cell is found to have an error, Excel flags it with a green indicator ...
  54. Automatically makes a workbook recovery file at the interval you enter. If your computer stops responding or you lose power ...
  55. AutoSort and AutoShow cannot be used with custom calculations that use positional references. Do you want to turn off AutoSort/Show? ...
  56. average_range,criteria_range,criteria,.!Finds average(arithmetic mean) for the cells specified by a given set of conditions ...
  57. Because the maximum indentation limit for a cell has been reached, the next field will be displayed in a separate column. ...
  58. Because the query for this page field does not return any items, the options for the field cannot be changed. If you expected ...
  59. Because you selected only one cell and the surrounding cells are blank, Microsoft Excel cannot determine which cells to apply ...
  60. Because your source data has automatic subtotals, Microsoft Excel cannot create a PivotTable report from it. For information ...
  61. Both the existing name, and name you are attempting to use are currently referenced in cell formulas.Please enter a different ...
  62. bottom,top!Returns a random number between the numbers you specify!is the smallest integer RANDBETWEEN will return!is the ...
  63. Breaking links permanently converts formulas and external references to their existing values. Because this cannot be undone, ...
  64. Calculates all dependent formulas every time you make a change to a value, formula, or name. This is the preferred calculation ...
  65. Calculates formulas in open workbooks only when you click Calc Now in the Calculation pane. Selecting this option automatically ...
  66. Cannot apply a conditional format to a range on multiple sheets or a different sheet than where the current selection is. ...
  67. Cannot apply a conditional format to a range that has cells outside of a PivotTable data region. Make sure that all the cells ...
  68. cannot be accessed.The file may be read-only, or you may be trying to access a read-only location. Or, the server the document ...
  69. cannot be merged into the current workbook.Workbooks to be merged must be copies made from the same shared workbook, and ...
  70. Cannot complete operation. Select the entire table, including the total row if present, and then try the operation again. ...
  71. Cannot complete operation: A table cannot overlap with a PivotTable report, query results, a table, merged cells, or an XML ...
  72. Cannot complete operation: Operations that include cells both inside and outside a table range or XML mapping, and operations ...
  73. Cannot complete operation: You are attempting to change a portion of a table row or column in a way that is not allowed. ...
  74. Cannot create a table in the last row of the workbook. A table must have at least two rows, one for the table header, and ...
  75. Cannot create this table while the AutoFilter command is turned on. Creating a table from a range without headers may cause ...