Excel for Macintosh 2016
- x,known_y's,known_x's!Calculates, or predicts, a future value along a linear trend by using existing values!is the data point ...
- x,lambda,cumulative!Returns the exponential distribution!is the value of the function, a nonnegative number!is the parameter ...
- x,lambda,cumulative!This function is available for compatibility with Excel 2008 and earlier.Returns the exponential distribution!is ...
- x,mean,cumulative!Returns the Poisson distribution!is the number of events!is the expected numeric value, a positive number!is ...
- x,mean,cumulative!This function is available for compatibility with Excel 2008 and earlier.Returns the Poisson distribution!is ...
- x,mean,standard_dev!Returns a normalized value from a distribution characterized by a mean and standard deviation!is the ...
- x,mean,standard_dev!This function is available for compatibility with Excel 2008 and earlier.Returns the cumulative lognormal ...
- x,mean,standard_dev,cumulative!Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters ...
- x,mean,standard_dev,cumulative!Returns the normal distribution for the specified mean and standard deviation!is the value ...
- x,mean,standard_dev,cumulative!This function is available for compatibility with Excel 2008 and earlier.Returns the normal ...
- x,n!Returns the Bessel function Jn(x)!is the value at which to evaluate the function!is the order of the Bessel function! ...
- x,n!Returns the modified Bessel function In(x)!is the value at which to evaluate the function!is the order of the Bessel ...
- x,n!Returns the modified Bessel function Kn(x)!is the value at which to evaluate the function!is the order of the function! ...
- x,n,m,coefficients!Returns the sum of a power series based on the formula!is the input value to the power series!is the initial ...
- XML Data is not valid according to the XML Schema. The data was successfully exported.Click 'Details.' for more information. ...
- XML Data Tables are locked for editing while in design mode.Click on 'Finish' on the structured Document task pane, then ...
- x_num,y_num!Returns the arctangent of the specified x- and y- coordinates, in radians between -Pi and Pi, excluding -Pi!is ...
- x_range,prob_range,lower_limit,upper_limit!Returns the probability that values in a range are between two limits or equal ...
- y!Returns the inverse of the Fisher transformation: if y = FISHER(x), then FISHERINV(y) = x!is the value for which you want ...
- year,month,day!Returns the number that represents the date in Microsoft Excel date-time code!is a number from 1900 to 9999 ...
- You already have specified a custom chart type. To create a different type of chart, click another custom type, or click ...
- You are about to sort together columns from multiple external data ranges. If you continue, your column sorting, filtering ...
- You are attempting to put grouped items and property fields in the same dimension. This action is not supported. After clicking ...
- You are no longer connected to this file.Another user may have removed you from it, or saved over it.To preserve your unsaved ...
- You are pasting a new data series, which will affect the existing information along the category axis in your chart.You can ...
- You are trying to delete a column or a row that contains a locked cell. Locked cells can not be deleted while the sheet is ...
- You can add buttons you use often to the Standard toolbar. Click the toolbar while holding down CONTROL, choose Customize, ...
- You can add gridlines to a chart by clicking Chart Options on the Chart menu, clicking the Gridlines tab, and selecting the ...
- You can add the chart template as a user-defined autoformat and use it later by choosing Autoformat from the Format menu. ...
- You can add words to a custom dictionary by using the Add Words To option in the Spelling dialog box. These words will be ...
- You can also select items in the chart by single-clicking them. In some cases you need to double-click the chart first to ...
- You can change the cells to which a picture is linked. Select the picture, and then type an equal sign (=) in the formula ...
- You can change the chart type for a series by selecting the series and clicking the Chart Type button on the Chart toolbar. ...
- You can change the formats and settings used for new workbooks. Customize a workbook, then save it as a template with the ...
- You can change the pattern of a region of a chart by first selecting the marker for that region in the legend and then double-clicking ...
- You can check the spelling on a group of sheets at one time. Hold down COMMAND while you click the tabs of the sheets, and ...
- You can choose the AutoFormat command from the Format menu to format your subtotaled list so that it is easier to read and ...
- You can click the title bar of a workbook while holding down CONTROL to display a menu of commands that apply to workbooks. ...
- You can control the order in which your pages are printed. Choose Page Setup from the File menu, then select one of the Page ...
- You can convert a chart sheet into an embedded chart. Select the entire chart, copy it, and then paste it onto another sheet. ...
- You can copy a chart's data and formats to another chart. Select the chart, copy it, select the other chart, and then paste. ...
- You can create a chart on its own sheet so you can print it independently. Select the data to chart, click the Chart Wizard ...
- You can delete more than one sheet at a time. Hold down COMMAND while you click the sheet tabs, and then choose Delete Sheet ...
- You can display more than one line of text in a cell. Choose Cells from the Format menu, and then select the Wrap Text check ...
- You can drag fields onto any PivotTable area. After you drag a field to the layout diagram, you can customize how it summarizes ...
- You can enter carriage returns in a cell to make the text easier to read. To enter a carriage return, press COMMAND+OPTION+RETURN. ...
- You can extend the selection from the active cell to another cell on the sheet by holding down SHIFT while clicking that ...
- You can filter your database to show a subset of the records. Point to Filter on the Data menu, then choose AutoFilter. Click ...
- You can format a cell so that a number is treated as text. Click Cells on the Format menu, and then select Text on the Number ...
- You can format the same area on a group of sheets. Hold down COMMAND while you click the tabs of the sheets, and then apply ...
- You can help improve Excel by allowing your iPad to automatically send us information about your hardware configuration and ...
- You can hide more than one sheet at a time. First select the sheets by holding down COMMAND while you click the sheet tabs, ...
- You can hold down SHIFT while you click the Print button to preview before printing. If you use this shortcut, you can remove ...
- You can hold down SHIFT while you click the Print Preview button to print without previewing. If you use this shortcut, you ...
- You can hold down SHIFT while you click the Sort Ascending button to sort in descending order. Then you can remove the Sort ...
- You can hold down SHIFT while you click the Sort Descending button to sort in ascending order. Then you can delete the Sort ...
- You can insert more than one worksheet at a time. Hold down SHIFT while you click the number of tabs you want to insert, ...
- You can make each marker a different color by clicking the individual marker two times to select it, clicking Selected Data ...
- You can move cells between workbooks just by dragging your selected cells right over to the window of the workbook you want, ...
- You can move cells between worksheets just by dragging your selection to the tabs at the bottom of your sheet, holding down ...
- You can not edit more than one query at a time from within Microsoft Excel.Task switch back to Microsoft Query and complete ...
- You can paint a range larger than the original selection. The format will repeat as many times as necessary to fill the larger ...
- You can perform case-sensitive sorts. Choose the Options button in the Sort dialog box (Data menu) and then select the Case ...
- You can place the chart on a worksheet, or on its own new chart sheet.Type a name for a new chart sheet, or choose an existing ...
- You can share files with users of older versions of Microsoft Excel by using the Save As command on the File menu to save ...
- You can sort data based on a custom sort order that you define. To define one, choose Preferences from the Edit menu, and ...
- You can specify how many sheets you want in each new workbook. Choose Preferences from the Edit menu, select the General ...
- You can specify rows or columns to be repeated on every printed page. Choose Page Setup from the File menu, and then specify ...
- You can store different values for the same worksheet cells without making multiple copies of the file. Choose Scenarios ...
- You can suppress the display of positive, negative or zero values by creating a custom number format in which the appropriate ...
- You can transpose rows and columns in a selected range. Copy the range, select a single cell, choose Paste Special from the ...
- You can type an asterisk (*) in the Find What box to match any number of characters or a question mark (?) to match any single ...
- You can use an ampersand (&) to concatenate text strings in a formula. For example, if A1 contains 'week' and A2 contains ...
- You can use custom graphics as markers in a bar, column, line, or radar chart. With the markers selected, paste a picture ...
- You can use page fields to view each range of data on a separate page, or to summarize all of the ranges on the same page.Microsoft ...