Excel for Macintosh 2016

  1. 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 ...
  2. x,lambda,cumulative!Returns the exponential distribution!is the value of the function, a nonnegative number!is the parameter ...
  3. x,lambda,cumulative!This function is available for compatibility with Excel 2008 and earlier.Returns the exponential distribution!is ...
  4. x,mean,cumulative!Returns the Poisson distribution!is the number of events!is the expected numeric value, a positive number!is ...
  5. x,mean,cumulative!This function is available for compatibility with Excel 2008 and earlier.Returns the Poisson distribution!is ...
  6. x,mean,standard_dev!Returns a normalized value from a distribution characterized by a mean and standard deviation!is the ...
  7. x,mean,standard_dev!This function is available for compatibility with Excel 2008 and earlier.Returns the cumulative lognormal ...
  8. x,mean,standard_dev,cumulative!Returns the lognormal distribution of x, where ln(x) is normally distributed with parameters ...
  9. x,mean,standard_dev,cumulative!Returns the normal distribution for the specified mean and standard deviation!is the value ...
  10. x,mean,standard_dev,cumulative!This function is available for compatibility with Excel 2008 and earlier.Returns the normal ...
  11. x,n!Returns the Bessel function Jn(x)!is the value at which to evaluate the function!is the order of the Bessel function! ...
  12. x,n!Returns the modified Bessel function In(x)!is the value at which to evaluate the function!is the order of the Bessel ...
  13. x,n!Returns the modified Bessel function Kn(x)!is the value at which to evaluate the function!is the order of the function! ...
  14. 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 ...
  15. XML Data is not valid according to the XML Schema. The data was successfully exported.Click 'Details.' for more information. ...
  16. XML Data Tables are locked for editing while in design mode.Click on 'Finish' on the structured Document task pane, then ...
  17. x_num,y_num!Returns the arctangent of the specified x- and y- coordinates, in radians between -Pi and Pi, excluding -Pi!is ...
  18. x_range,prob_range,lower_limit,upper_limit!Returns the probability that values in a range are between two limits or equal ...
  19. y!Returns the inverse of the Fisher transformation: if y = FISHER(x), then FISHERINV(y) = x!is the value for which you want ...
  20. year,month,day!Returns the number that represents the date in Microsoft Excel date-time code!is a number from 1900 to 9999 ...
  21. You already have specified a custom chart type. To create a different type of chart, click another custom type, or click ...
  22. You are about to sort together columns from multiple external data ranges. If you continue, your column sorting, filtering ...
  23. You are attempting to put grouped items and property fields in the same dimension. This action is not supported. After clicking ...
  24. You are no longer connected to this file.Another user may have removed you from it, or saved over it.To preserve your unsaved ...
  25. You are pasting a new data series, which will affect the existing information along the category axis in your chart.You can ...
  26. 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 ...
  27. You can add buttons you use often to the Standard toolbar. Click the toolbar while holding down CONTROL, choose Customize, ...
  28. You can add gridlines to a chart by clicking Chart Options on the Chart menu, clicking the Gridlines tab, and selecting the ...
  29. You can add the chart template as a user-defined autoformat and use it later by choosing Autoformat from the Format menu. ...
  30. You can add words to a custom dictionary by using the Add Words To option in the Spelling dialog box. These words will be ...
  31. You can also select items in the chart by single-clicking them. In some cases you need to double-click the chart first to ...
  32. You can change the cells to which a picture is linked. Select the picture, and then type an equal sign (=) in the formula ...
  33. You can change the chart type for a series by selecting the series and clicking the Chart Type button on the Chart toolbar. ...
  34. You can change the formats and settings used for new workbooks. Customize a workbook, then save it as a template with the ...
  35. 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 ...
  36. 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 ...
  37. You can choose the AutoFormat command from the Format menu to format your subtotaled list so that it is easier to read and ...
  38. You can click the title bar of a workbook while holding down CONTROL to display a menu of commands that apply to workbooks. ...
  39. You can control the order in which your pages are printed. Choose Page Setup from the File menu, then select one of the Page ...
  40. You can convert a chart sheet into an embedded chart. Select the entire chart, copy it, and then paste it onto another sheet. ...
  41. You can copy a chart's data and formats to another chart. Select the chart, copy it, select the other chart, and then paste. ...
  42. You can create a chart on its own sheet so you can print it independently. Select the data to chart, click the Chart Wizard ...
  43. You can delete more than one sheet at a time. Hold down COMMAND while you click the sheet tabs, and then choose Delete Sheet ...
  44. 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 ...
  45. You can drag fields onto any PivotTable area. After you drag a field to the layout diagram, you can customize how it summarizes ...
  46. You can enter carriage returns in a cell to make the text easier to read. To enter a carriage return, press COMMAND+OPTION+RETURN. ...
  47. You can extend the selection from the active cell to another cell on the sheet by holding down SHIFT while clicking that ...
  48. You can filter your database to show a subset of the records. Point to Filter on the Data menu, then choose AutoFilter. Click ...
  49. 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 ...
  50. 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 ...
  51. You can help improve Excel by allowing your iPad to automatically send us information about your hardware configuration and ...
  52. You can hide more than one sheet at a time. First select the sheets by holding down COMMAND while you click the sheet tabs, ...
  53. You can hold down SHIFT while you click the Print button to preview before printing. If you use this shortcut, you can remove ...
  54. You can hold down SHIFT while you click the Print Preview button to print without previewing. If you use this shortcut, you ...
  55. You can hold down SHIFT while you click the Sort Ascending button to sort in descending order. Then you can remove the Sort ...
  56. You can hold down SHIFT while you click the Sort Descending button to sort in ascending order. Then you can delete the Sort ...
  57. You can insert more than one worksheet at a time. Hold down SHIFT while you click the number of tabs you want to insert, ...
  58. You can make each marker a different color by clicking the individual marker two times to select it, clicking Selected Data ...
  59. You can move cells between workbooks just by dragging your selected cells right over to the window of the workbook you want, ...
  60. You can move cells between worksheets just by dragging your selection to the tabs at the bottom of your sheet, holding down ...
  61. You can not edit more than one query at a time from within Microsoft Excel.Task switch back to Microsoft Query and complete ...
  62. You can paint a range larger than the original selection. The format will repeat as many times as necessary to fill the larger ...
  63. You can perform case-sensitive sorts. Choose the Options button in the Sort dialog box (Data menu) and then select the Case ...
  64. 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 ...
  65. You can share files with users of older versions of Microsoft Excel by using the Save As command on the File menu to save ...
  66. You can sort data based on a custom sort order that you define. To define one, choose Preferences from the Edit menu, and ...
  67. You can specify how many sheets you want in each new workbook. Choose Preferences from the Edit menu, select the General ...
  68. You can specify rows or columns to be repeated on every printed page. Choose Page Setup from the File menu, and then specify ...
  69. You can store different values for the same worksheet cells without making multiple copies of the file. Choose Scenarios ...
  70. You can suppress the display of positive, negative or zero values by creating a custom number format in which the appropriate ...
  71. You can transpose rows and columns in a selected range. Copy the range, select a single cell, choose Paste Special from the ...
  72. You can type an asterisk (*) in the Find What box to match any number of characters or a question mark (?) to match any single ...
  73. You can use an ampersand (&) to concatenate text strings in a formula. For example, if A1 contains 'week' and A2 contains ...
  74. You can use custom graphics as markers in a bar, column, line, or radar chart. With the markers selected, paste a picture ...
  75. 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 ...