Office for Mac 2016

  1. Area ChartFormats the graph, active chart, or selected embedded chart as an area chart, replacing any formatting already ...
  2. Arrange (Window menu)Displays all open files in separate windows on the screen. The Arrange command makes it easier to drag ...
  3. Arrange objects on the slide by changing their order, position, and rotation.You can also group multiple objects together ...
  4. Arrange the current selection in alphabetical or numerical order.This is especially useful if you're trying to organize data ...
  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. ArrowInserts a line with an arrowhead where you click or drag in the active window. To constrain the line to draw at 15-degree ...
  40. At least one field in this PivotTable has Top 10 AutoShow applied. Top 10 filtering has been improved in Microsoft Excel ...
  41. Attach a callout to the selected shape.Use callouts to add annotations to shapes in the diagram. Callouts are moved, copied, ...
  42. Attach your calendar information to this message.The person receiving the message does not have to use Outlook in order to ...
  43. Auto OutlineAutomatically outlines a selected range of cells or the entire sheet, based on formulas and the direction of ...
  44. AutoCorrect (Tools menu)Sets the options used to correct text automatically as you type, or to store and reuse text and other ...
  45. AutoFormat (Format menu)Applies a built-in combination of formats, called an autoformat, to a cell range or a PivotTable. ...
  46. Automatically adjusts kerning, or the amount of space between certain combinations of characters, so that the entire word ...
  47. Automatically calculate the Start, Finish, and Duration values for this task based on dependencies, constraints, calendar, ...
  48. Automatically create an organization chart using data imported from a data source, such as a Microsoft Exchange Server directory ...
  49. Automatically fill in values. Enter a couple of examples you want as output and keep the active cell in the column you want ...
  50. Automatically generate names from the selected cells.Many people choose to use the text in the top row or the leftmost column ...
  51. Automatically move tasks so that resources do not become overallocated, because of changes made in this view.All existing ...
  52. Automatically remove unwanted portions of the picture.If needed, use marks to indicate areas to keep or remove from the picture. ...
  53. Automatically resize the columns in your table.Set your columns to be the same width as your content or choose for your table ...
  54. AutoShapes MenuDisplays the AutoShape categories you can insert. Click an AutoShape category, click the AutoShape you want, ...
  55. AutoShapesDisplays the AutoShape categories you can insert. Click an AutoShape category, click the AutoShape you want, and ...
  56. AutoShapesInserts a shape where you click or drag in the active file. To draw a shape circumscribed within a perfect square, ...
  57. AutoSort and AutoShow cannot be used with custom calculations that use positional references. Do you want to turn off AutoSort/Show? ...
  58. AutoSumAdds numbers automatically with the SUM function. Microsoft Excel suggests the range of cells to be added. If the ...
  59. average_range,criteria_range,criteria,.!Finds average(arithmetic mean) for the cells specified by a given set of conditions ...
  60. Background Color for New Equations Menu!Commands for items appearing on the Background Color for New Equations submenu of ...
  61. Bar ChartFormats the graph, active chart, or selected embedded chart as a bar chart, replacing any formatting already in ...
  62. Basic constant for a single Null character (ASCII value 0); equivalent to Chr20 20 404 12 61 79 80 81 98 701 402 406 405 ...
  63. Basic Shapes MenuClick the AutoShape you want to insert, and then click or drag in the active window where you want to insert ...
  64. Because the maximum indentation limit for a cell has been reached, the next field will be displayed in a separate column. ...
  65. Because the query for this page field does not return any items, the options for the field cannot be changed. If you expected ...
  66. Because your source data has automatic subtotals, Microsoft Excel cannot create a PivotTable report from it. For information ...
  67. Bent ArrowDraws a bent arrow where you click or drag in the active window. To draw a bent arrow that retains its default ...
  68. Bent-Up ArrowDraws a bent-up arrow where you click or drag in the active window. To draw a bent-up arrow that retains its ...
  69. BevelDraws a beveled rectangle where you click or drag in the active window. To draw a beveled square, hold down SHIFT and ...
  70. Block ArcDraws a block arc where you click or drag in the active window. To draw a block arc that retains its default height-to-width ...
  71. Bold (Formatting toolbar)Makes selected text and numbers bold. If the selection is already bold, clicking the Bold button ...
  72. Bookmarks work with hyperlinks to let you jump to a specific place in your document.Here's how it works:1) Select the content ...
  73. BordersAdds a border to the selected cell or range.To format a cell or range with the last selected border, click the Borders ...
  74. Bottom BorderAdds or removes a border from the bottom edge of selected text, paragraphs, cells, pictures, or other object. ...
  75. Bottom Double BorderAdds a double border along the bottom edge of the selected cells. If you click the button again, the ...