Office for Mac 2016
- Area ChartFormats the graph, active chart, or selected embedded chart as an area chart, replacing any formatting already ...
- Arrange (Window menu)Displays all open files in separate windows on the screen. The Arrange command makes it easier to drag ...
- Arrange objects on the slide by changing their order, position, and rotation.You can also group multiple objects together ...
- Arrange the current selection in alphabetical or numerical order.This is especially useful if you're trying to organize data ...
- 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 Excel 2008 and earlier.Returns the k-th percentile of values in ...
- 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 Excel 2008 and earlier.Returns the quartile of a data set!is ...
- 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 Excel 2008 and earlier.Returns the one-tailed P-value of ...
- 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 Excel 2008 and earlier.Returns the rank of a value ...
- 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 Excel 2008 and earlier.Returns covariance, the average of ...
- array1,array2!This function is available for compatibility with Excel 2008 and earlier.Returns the result of an F-test, the ...
- 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 Excel 2008 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 ...
- ArrowInserts a line with an arrowhead where you click or drag in the active window. To constrain the line to draw at 15-degree ...
- At least one field in this PivotTable has Top 10 AutoShow applied. Top 10 filtering has been improved in Microsoft Excel ...
- Attach a callout to the selected shape.Use callouts to add annotations to shapes in the diagram. Callouts are moved, copied, ...
- Attach your calendar information to this message.The person receiving the message does not have to use Outlook in order to ...
- Auto OutlineAutomatically outlines a selected range of cells or the entire sheet, based on formulas and the direction of ...
- AutoCorrect (Tools menu)Sets the options used to correct text automatically as you type, or to store and reuse text and other ...
- AutoFormat (Format menu)Applies a built-in combination of formats, called an autoformat, to a cell range or a PivotTable. ...
- Automatically adjusts kerning, or the amount of space between certain combinations of characters, so that the entire word ...
- Automatically calculate the Start, Finish, and Duration values for this task based on dependencies, constraints, calendar, ...
- Automatically create an organization chart using data imported from a data source, such as a Microsoft Exchange Server directory ...
- Automatically fill in values. Enter a couple of examples you want as output and keep the active cell in the column you want ...
- Automatically generate names from the selected cells.Many people choose to use the text in the top row or the leftmost column ...
- Automatically move tasks so that resources do not become overallocated, because of changes made in this view.All existing ...
- Automatically remove unwanted portions of the picture.If needed, use marks to indicate areas to keep or remove from the picture. ...
- Automatically resize the columns in your table.Set your columns to be the same width as your content or choose for your table ...
- AutoShapes MenuDisplays the AutoShape categories you can insert. Click an AutoShape category, click the AutoShape you want, ...
- AutoShapesDisplays the AutoShape categories you can insert. Click an AutoShape category, click the AutoShape you want, and ...
- AutoShapesInserts a shape where you click or drag in the active file. To draw a shape circumscribed within a perfect square, ...
- AutoSort and AutoShow cannot be used with custom calculations that use positional references. Do you want to turn off AutoSort/Show? ...
- AutoSumAdds numbers automatically with the SUM function. Microsoft Excel suggests the range of cells to be added. If the ...
- average_range,criteria_range,criteria,.!Finds average(arithmetic mean) for the cells specified by a given set of conditions ...
- Background Color for New Equations Menu!Commands for items appearing on the Background Color for New Equations submenu of ...
- Bar ChartFormats the graph, active chart, or selected embedded chart as a bar chart, replacing any formatting already in ...
- 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 ...
- Basic Shapes MenuClick the AutoShape you want to insert, and then click or drag in the active window where you want to insert ...
- 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 ...
- Because your source data has automatic subtotals, Microsoft Excel cannot create a PivotTable report from it. For information ...
- Bent ArrowDraws a bent arrow where you click or drag in the active window. To draw a bent arrow that retains its default ...
- 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 ...
- BevelDraws a beveled rectangle where you click or drag in the active window. To draw a beveled square, hold down SHIFT and ...
- 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 ...
- Bold (Formatting toolbar)Makes selected text and numbers bold. If the selection is already bold, clicking the Bold button ...
- Bookmarks work with hyperlinks to let you jump to a specific place in your document.Here's how it works:1) Select the content ...
- BordersAdds a border to the selected cell or range.To format a cell or range with the last selected border, click the Borders ...
- Bottom BorderAdds or removes a border from the bottom edge of selected text, paragraphs, cells, pictures, or other object. ...
- Bottom Double BorderAdds a double border along the bottom edge of the selected cells. If you click the button again, the ...