Excel for Macintosh 2016

  1. Unmistakably Office, Designed for MacModern Office design now fully optimized for the Mac, including Retina display and full ...
  2. value!Checks whether a reference is to an empty cell, and returns TRUE or FALSE!is the cell or a name that refers to the ...
  3. value!Checks whether a value is #N/A, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, ...
  4. value!Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE!is the value you want to test. ...
  5. value!Checks whether a value is a number, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, ...
  6. value!Checks whether a value is a reference, and returns TRUE or FALSE!is the value you want to test. Value can refer to ...
  7. value!Checks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSE!is ...
  8. value!Checks whether a value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns ...
  9. value!Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE!is the value you want tested: ...
  10. value!Checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not!is ...
  11. value!Checks whether a value is text, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, ...
  12. value!Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero)!is the value you ...
  13. value!Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; ...
  14. value!Returns the sheet number of the referenced sheet!is the name of a sheet or a reference that you want the sheet number ...
  15. value,format_text!Converts a value to text in a specific number format!is a number, a formula that evaluates to a numeric ...
  16. value,value_if_error!Returns value_if_error if expression is an error and the value of the expression itself otherwise!is ...
  17. value,value_if_na!Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression!is ...
  18. value1,value2,.!Calculates standard deviation based on an entire population, including logical values and text. Text and ...
  19. value1,value2,.!Calculates variance based on the entire population, including logical values and text. Text and the logical ...
  20. value1,value2,.!Counts the number of cells in a range that are not empty!are 1 to 255 arguments representing the values and ...
  21. value1,value2,.!Counts the number of cells in a range that contain numbers!are 1 to 255 arguments that can contain or refer ...
  22. value1,value2,.!Estimates standard deviation based on a sample, including logical values and text. Text and the logical value ...
  23. value1,value2,.!Estimates variance based on a sample, including logical values and text. Text and the logical value FALSE ...
  24. value1,value2,.!Returns the average (arithmetic mean) of its arguments, evaluating text and FALSE in arguments as 0; TRUE ...
  25. value1,value2,.!Returns the largest value in a set of values. Does not ignore logical values and text!are 1 to 255 numbers, ...
  26. value1,value2,.!Returns the smallest value in a set of values. Does not ignore logical values and text!are 1 to 255 numbers, ...
  27. Values cannot be changed when multiple items are selected in a Report Filter field. Select a single item for each field in ...
  28. Values cannot be changed when multiple items are selected in a slicer. Select a single item for each slicer before changing ...
  29. values,dates,guess!Returns the internal rate of return for a schedule of cash flows!is a series of cash flows that correspond ...
  30. values,finance_rate,reinvest_rate!Returns the internal rate of return for a series of periodic cash flows, considering both ...
  31. values,guess!Returns the internal rate of return for a series of cash flows!is an array or a reference to cells that contain ...
  32. VBA Converter is required to save the workbook in the selected file format.IThis workbook contains macros that cannot be ...
  33. Warning: This computer program is protected by copyright law and international treaties. Unauthorized reproduction or distribution ...
  34. was created in a previous version of Microsoft Excel.Do you want to update it to the new format? To update it, click Yes. ...
  35. When a formula is copied or filled to other cells, the absolute reference remains fixed while the relative reference changes ...
  36. When a formula is copied or filled to other cells, the absolute reference remains fixed while the relative reference changes ...
  37. When a formula is copied or filled to other cells, the formula's cell references change to the new location. For example, ...
  38. When you click Column on the Format menu and then click AutoFit Selection, the column width will be adjusted to fit the longest ...
  39. When you click the Go To command on the Edit menu, a reference to the current selection is added to the dialog box so you ...
  40. When you copy and paste between workbooks that use different date systems (1900 and 1904), converts the date system of the ...
  41. When you copy and paste formulas containing relative references, the references are adjusted. When you cut and paste formulas, ...
  42. When you create a formula that refers to other cells, it will have the same number format as the first cell it refers to. ...
  43. When you drag over tabs at the bottom of the sheet, use the COMMAND key to stop cells from scrolling and to switch to another ...
  44. When you drag the cell border while holding down CONTROL, a shortcut menu is displayed. From the shortcut menu, you can choose ...
  45. When you enter formulas, type function names in lowercase letters. When you press RETURN, valid function names are converted ...
  46. When you filter a column that contains dates, the Filter panel shows the dates grouped by year, month, and day. When this ...
  47. When you record a macro, click Personal Macro Workbook in the Store Macro In box on the Record Macro dialog box. Your macro ...
  48. When you see # in a cell, the number is too wide to be displayed. To widen the column to display the number, double-click ...
  49. When you select an option under 'Center on Page' (Margins tab, Page Setup command on the File menu), your data is centered ...
  50. with complete Microsoft Excel formatting. If the object is an OLE control, this includes all extended properties of the control. ...
  51. With the Customize dialog box displayed, you can click any toolbar button (not in the dialog box) while holding down CONTROL ...
  52. With the Customize dialog box displayed, you can click any toolbar button while holding down CONTROL to display a shortcut ...
  53. With this option selected, you can edit inside a cell by double-clicking the cell, rather than by editing the cell contents ...
  54. With this option selected, you can move and copy cells and data by dragging. You can also drag the fill handle to copy data ...
  55. Workbooks that contain structured references to tables cannot be shared. Do you want to continue? Structured references will ...
  56. x!Returns the Fisher transformation!is the value for which you want the transformation, a number between -1 and 1, excluding ...
  57. x!Returns the natural logarithm of the gamma function!is the value for which you want to calculate GAMMALN, a positive number! ...
  58. x!Returns the natural logarithm of the gamma function!is the value for which you want to calculate GAMMALN.PRECISE, a positive ...
  59. x!Returns the value of the density function for a standard normal distribution!is the number for which you want the density ...
  60. x,alpha,beta,A,B!This function is available for compatibility with Excel 2007 and earlier.Returns the cumulative beta probability ...
  61. x,alpha,beta,cumulative!Returns the gamma distribution!is the value at which you want to evaluate the distribution, a nonnegative ...
  62. x,alpha,beta,cumulative!Returns the Weibull distribution!is the value at which to evaluate the function, a nonnegative number!is ...
  63. x,alpha,beta,cumulative!This function is available for compatibility with Excel 2008 and earlier.Returns the gamma distribution!is ...
  64. x,alpha,beta,cumulative!This function is available for compatibility with Excel 2008 and earlier.Returns the Weibull distribution!is ...
  65. x,alpha,beta,cumulative,A,B!Returns the beta probability distribution function!is the value between A and B at which to evaluate ...
  66. x,deg_freedom!Returns the right-tailed probability of the chi-squared distribution!is the value at which you want to evaluate ...
  67. x,deg_freedom!Returns the right-tailed Student's t-distribution!is the numeric value at which to evaluate the distribution!is ...
  68. x,deg_freedom!Returns the two-tailed Student's t-distribution!is the numeric value at which to evaluate the distribution!is ...
  69. x,deg_freedom!This function is available for compatibility with Excel 2008 and earlier.Returns the right-tailed probability ...
  70. x,deg_freedom,cumulative!Returns the left-tailed probability of the chi-squared distribution!is the value at which you want ...
  71. x,deg_freedom,cumulative!Returns the left-tailed Student's t-distribution!is the numeric value at which to evaluate the distribution!is ...
  72. x,deg_freedom,tails!This function is available for compatibility with Excel 2008 and earlier.Returns the Student's t-distribution!is ...
  73. x,deg_freedom1,deg_freedom2!Returns the (right-tailed) F probability distribution (degree of diversity) for two data sets!is ...
  74. x,deg_freedom1,deg_freedom2!This function is available for compatibility with Excel 2008 and earlier.Returns the (right-tailed) ...
  75. x,deg_freedom1,deg_freedom2,cumulative!Returns the (left-tailed) F probability distribution (degree of diversity) for two ...