Excel for Macintosh 2016
- Are you sure that you want to stop using the List Manager? If you do, column settings defined by the List Manager will be ...
- 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 turn off macro virus protection permanently?If you click Yes, you can turn macro virus protection ...
- arguments were entered for this function.For assistance with entering arguments for this function, use the Formula Builder.chid://4003Help ...
- 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 ...
- As a shortcut for adding or deleting major gridlines for the value axis of a chart, click the Value Axis Gridlines button ...
- As a shortcut for changing the color of the selected graphic object, cell, or chart, click the Fill Color button that is ...
- As a shortcut for changing the orientation of the selected text to rotated and facing down, click the Rotate Text Down button. ...
- As a shortcut for changing the orientation of the selected text to rotated and facing up, click the Rotate Text Up button. ...
- As a shortcut for finding the next occurrence of a number or text, press COMMAND+G. To find the previous occurrence, press ...
- As a shortcut for inserting a function into a formula, click the Edit Formula button (the = button) on the Formula bar, and ...
- As a shortcut for making text or numbers bold, click the Bold button on the Standard toolbar. To remove the bold format, ...
- As a shortcut for printing, click the Print button on Standard toolbar. This prints with current settings and does not display ...
- 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 Microsoft Excel ...
- 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 ...
- At least one of the changing cells you specified contains a formula.Formulas in changing cells will be replaced by constant ...
- AutoFill can increment both the quarter and the year at the same time. For example: 1Q93, Q193, 1st Qtr 93, 1st Quarter 1993. ...
- 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 ...
- Automatically checks cells for errors while you work. If a cell is found to have an error, Excel flags it with a green indicator ...
- Automatically makes a workbook recovery file at the interval you enter. If your computer stops responding or you lose power ...
- AutoSort and AutoShow cannot be used with custom calculations that use positional references. Do you want to turn off AutoSort/Show? ...
- average_range,criteria_range,criteria,.!Finds average(arithmetic mean) for the cells specified by a given set of conditions ...
- 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 you selected only one cell and the surrounding cells are blank, Microsoft Excel cannot determine which cells to apply ...
- Because your source data has automatic subtotals, Microsoft Excel cannot create a PivotTable report from it. For information ...
- Both the existing name, and name you are attempting to use are currently referenced in cell formulas.Please enter a different ...
- bottom,top!Returns a random number between the numbers you specify!is the smallest integer RANDBETWEEN will return!is the ...
- Breaking links permanently converts formulas and external references to their existing values. Because this cannot be undone, ...
- Calculates all dependent formulas every time you make a change to a value, formula, or name. This is the preferred calculation ...
- Calculates formulas in open workbooks only when you click Calc Now in the Calculation pane. Selecting this option automatically ...
- Cannot apply a conditional format to a range on multiple sheets or a different sheet than where the current selection is. ...
- Cannot apply a conditional format to a range that has cells outside of a PivotTable data region. Make sure that all the cells ...
- 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 ...
- cannot be merged into the current workbook.Workbooks to be merged must be copies made from the same shared workbook, and ...
- Cannot complete operation. Select the entire table, including the total row if present, and then try the operation again. ...
- Cannot complete operation: A table cannot overlap with a PivotTable report, query results, a table, merged cells, or an XML ...
- Cannot complete operation: Operations that include cells both inside and outside a table range or XML mapping, and operations ...
- Cannot complete operation: You are attempting to change a portion of a table row or column in a way that is not allowed. ...
- 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 ...
- Cannot create this table while the AutoFilter command is turned on. Creating a table from a range without headers may cause ...