Excel for Macintosh 2016

  1. database,field,criteria!Estimates variance based on a sample from selected database entries!is the range of cells that makes ...
  2. database,field,criteria!Extracts from a database a single record that matches the conditions you specify!is the range of ...
  3. database,field,criteria!Multiplies the values in the field (column) of records in the database that match the conditions ...
  4. database,field,criteria!Returns the largest number in the field (column) of records in the database that match the conditions ...
  5. database,field,criteria!Returns the smallest number in the field (column) of records in the database that match the conditions ...
  6. data_array,bins_array!Calculates how often values occur within a range of values and then returns a vertical array of numbers ...
  7. data_field,pivot_table,field,item,.!Extracts data stored in a PivotTable.!is the name of the data field to extract data from!is ...
  8. date!Returns number of the ISO week number of the year for a given date!is the date-time code used by Microsoft Excel for ...
  9. date_text!Converts a date in the form of text to a number that represents the date in Microsoft Excel date-time code!is text ...
  10. decimal_dollar,fraction!Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction!is ...
  11. Deletes all of your Microsoft email and password information the next time you quit and restart Excel. You'll be signed out ...
  12. destination_ref,data_type,text_delim,consecutive_delim,tab,semicolon,comma,space,other,other_char,field_info,decimal_separator,thousands_separator ...
  13. Determines the color palette that is used for elements such as backgrounds, text, gridlines, and comment indicators when ...
  14. Determines the font size used the next time you open Excel and create a new workbook. Enter a font size in the Size box to ...
  15. Determines the font used the next time you open Excel and create a new workbook. Click a font on the Standard Font pop-up ...
  16. dimension!Returns the unit matrix for the specified dimension!is an integer specifying the dimension of the unit matrix that ...
  17. Display banded columns, in which even columns are formatted differently from odd columns.This banding can make tables easier ...
  18. Display banded rows, in which even rows are formatted differently from odd rows.This banding can make tables easier to read. ...
  19. Displays a confirmation message if you attempt to create or open a file other than an Excel workbook from the Open dialog ...
  20. Displays a message when you open a workbook that contains links to information in other locations, such as other Office documents. ...
  21. Displays a small red triangle in the upper-right corner of a cell when there is a comment attached to the cell. Comments ...
  22. Displays a smart button that offers special options such as Formatting Same As Above, Clear Formatting, and Fill Without ...
  23. Displays cell gridlines. To print gridlines, make sure the Print Gridlines check box is checked on the Sheet tab of the Page ...
  24. Displays pictures and charts as gray rectangles. When you display object placeholders, you can scroll significantly faster ...
  25. Displays row numbers on the left side of the sheet and column letters at the top of the sheet. Affects: only the active sheets. ...
  26. Displays sheet movement and changes when you insert or delete cells, rows, or columns. Animation might slow video performance ...
  27. Displays sheet tabs so that you can move among and select sheets. Sheet tabs appear at the bottom of the document window. ...
  28. Displays the Color Picker dialog box. You can modify any of the original 40 colors on the color palette to create custom ...
  29. Displays the comment and comment indicator, a small red triangle in the upper-right corner of a cell, when there is a comment ...
  30. Displays the currently available colors. To change a color, click it, and then click modify. Affects: only the active workbook. ...
  31. Displays the first eight colors that Excel uses to fill charts. You can also apply these colors to other elements. To change ...
  32. Displays the first eight line colors that Excel uses for charts. You can also apply these colors to other elements. To change ...
  33. Displays the formula bar in all workbooks. To set different viewing options for individual workbooks, on the View menu, click ...
  34. Displays the status bar, which shows information about a selected command or option. The status bar appears at the bottom ...
  35. Do you want to save the changes you made to the Personal Macro Workbook?If you click Save, the macros will be available the ...
  36. Don't see what you need?Browse more functions from categories like statistical, engineering, web, or OLAP cube functions. ...
  37. Draw a text box anywhere.This is a great way to get the exact text box size you want, especially when adding text to shapes ...
  38. Due to limited developer and customer adoption of Publish and Subscribe, these features are no longer supported in the Mac ...
  39. Each chart type has two or more subtypes from which you can choose. To see what your data will look like when you use the ...
  40. Each custom type is based on a standard type. The custom chart type also includes display settings and custom formatting ...
  41. Earlier versions of Excel do not support color formatting in header and footer text. The color formatting information will ...
  42. Earlier versions of Excel only support line colors from the color palette. When the workbook is opened in an earlier version ...
  43. effect_rate,npery!Returns the annual nominal interest rate!is the effective interest rate!is the number of compounding periods ...
  44. end_date,start_date!Returns the number of days between the two dates.!start_date and end_date are the two dates between which ...
  45. Errors were detected in '|', but Microsoft Office Excel was able to save the file by removing or repairing the features listed ...
  46. error_val!Returns a number matching an error value.!is the error value for which you want the identifying number, and can ...
  47. Excel 3.x WorksheetExcel 4.x WorksheetExcel 5.x WorkbookExcel 97-2004 WorkbookExcel WorkbookExcel Binary WorkbookExcel for ...
  48. Excel can not open | at this time.A dialog or alert is currently open. Close the dialog or alert, and then open the file ...
  49. Excel can't shift nonblank cells off the worksheet. Try to delete or clear the cells to the right or below your data. Then ...
  50. Excel cannot calculate a formula.Cell references in the formula refer to the formula's result, creating a circular reference. ...
  51. Excel cannot connect to your database with the driver you specified in your data source. The driver does not support OLAP-provider ...
  52. Excel cannot convert this PivotTable report because conversion would result in a formula that is too long for Excel to handle. ...
  53. Excel cannot convert this PivotTable report because there are too many items selected in the report filter. Either reduce ...
  54. Excel cannot convert this PivotTable report, either because there is not enough memory or because the PivotTable report was ...
  55. Excel cannot convert to formulas because one or more filtered fields are not completely visible. To make the filtered fields ...
  56. Excel cannot display this PivotTable report. The row area has more than 65,536 items, or the column area has more than 16,384 ...
  57. Excel cannot find OLAP cube |. Either the OLAP database has been changed or you don't have permissions to connect to the ...
  58. Excel cannot find the text file to refresh this external data range.Check to make sure the text file has not been moved or ...
  59. Excel cannot group by numeric or date intervals in fields with blank or missing data. Grouping information for some fields ...
  60. Excel cannot insert additional columns because the last column (column XFD) contains data.Move or delete the data in the ...
  61. Excel cannot launch Microsoft Clip Gallery.Microsoft Clip Gallery may not be properly installed on your computer, or you ...
  62. Excel cannot load more than 65,500 cell formulas per sheet that have defined name or off-sheet references; additional formulas ...
  63. Excel cannot load the information used to connect to the server running Windows SharePoint Services. In order to edit this ...
  64. Excel cannot open this file.The file format or file extension is not valid. Verify that the file has not been corrupted and ...
  65. Excel cannot open this workbook.This workbook uses advanced encryption, which is not supported by Excel for the Mac. If this ...
  66. Excel cannot refresh the database query because the structure of the source data has changed.The query contains references ...
  67. Excel cannot save the file to this location. The file is checked out or locked for editing by another user. To save the file, ...
  68. Excel cannot save this workbook because it contains a query of a Filemaker Pro file that cannot be located.The Filemaker ...
  69. Excel cannot verify that unsynchronized changes are authorized. Synchronize your changes with the server and try saving again. ...
  70. Excel could not automatically insert the PivotTable because there is not enough data.At least two fields of data are required. ...
  71. Excel could not locate the client-server settings component for your OLAP provider. The OLAP provider may not support this ...
  72. Excel could not save all the data and formatting you recently added to |0. To return to your workbook without saving click ...
  73. Excel does not recognize this file format. This file may have been created in an application that is not compatible with ...
  74. Excel encountered an error and had to remove some formatting to avoid corrupting the workbook. Please re-check your formatting ...
  75. Excel for Mac cannot open this workbook because permission is restricted.The workbook can only be opened in a version of ...