Excel for Macintosh 2016

  1. If you want a workbook to be opened whenever you start Microsoft Excel, put the workbook in the Microsoft Office X:Office:Startup:Excel ...
  2. If you want cells to always appear with a certain formatting even after they have been cut or cleared, change the Normal ...
  3. If you want the text box to automatically resize to fit the text, select the text box, click Text Box on the Format menu, ...
  4. If you want to be asked each time you open a workbook whether to open it as read-only, choose Save As from the File menu, ...
  5. If you want to define your own custom sort order, click Preferences on the Edit menu, and then click the Custom Lists tab. ...
  6. If you want to freeze a row at the top of the window, select the row below it, and then choose Freeze Panes from the Window ...
  7. If you want to permanently change the source file of a link, choose Links from the Edit menu, select the link in the list, ...
  8. If you want to place the PivotTable on an existing worksheet, type or select the cell reference for only for the upper-left ...
  9. If you want to print the worksheet with gridlines, choose Page Setup from the File menu and select the Gridlines check box ...
  10. If you want to print the worksheet without gridlines, choose Page Setup from the File menu and clear the Gridlines check ...
  11. If you want to reapply your number format when data is pivoted or refreshed, select the data field in the PivotTable, choose ...
  12. If you want to search only within a certain range of cells for a specific value, select the range before you choose Find. ...
  13. If you want to select an object that has a macro assigned to it without running the macro, hold down COMMAND while you click ...
  14. If you want to track reviewers' changes in this workbook, you need to make this workbook shared. Do you want to save a shared ...
  15. If you'd like all new workbooks to be based on the template you just opened, save the template with the name 'Workbook' in ...
  16. If you'd like to apply this same autoformat again, use the AutoFormat button. It remembers the last AutoFormat you applied. ...
  17. In languages that capitalize names of days, automatically capitalizes the first letter of the names when you enter them into ...
  18. In most charts, you can format an individual data marker. Click the marker until it is the only one selected, and then click ...
  19. In this step, you identify the ranges of data you want to combine in the PivotTable, and then assign the ranges to page field ...
  20. index_num,value1,value2,.!Chooses a value or action to perform from a list of values, based on an index number!specifies ...
  21. Indicates the earliest two-digit year that you want Excel to interpret as being in the twenty-first century. For example, ...
  22. Indicates where Excel will automatically put the decimal point in the numbers you enter as constants on a sheet. A positive ...
  23. info_type,reference!Returns information about the formatting, location, or contents of the first cell, according to the sheet's ...
  24. Initialization of the data source failed.Check the database server or contact your database administrator. Make sure the ...
  25. Inserts an icon that represents the contents of the file into your document. Changes to the source file will be reflected ...
  26. Inserts the contents of the file into your document and creates a link to the source file. Changes to the source file will ...
  27. Inserts the contents of the file into your document so that you can edit it later using the program which created the source ...
  28. Instead of hiding the horizontal scroll bar, you can make it smaller by dragging the handle at its left. To restore the scroll ...
  29. inumber!Returns the absolute value (modulus) of a complex number!is a complex number for which you want the absolute value! ...
  30. inumber!Returns the hyperbolic cosecant of a complex number!is a complex number for which you want the hyperbolic cosecant! ...
  31. inumber!Returns the imaginary coefficient of a complex number!is a complex number for which you want the imaginary coefficient! ...
  32. inumber,number!Returns a complex number raised to an integer power!is a complex number you want to raise to a power!is the ...
  33. inumber1,inumber2!Returns the difference of two complex numbers!is the complex number from which to subtract inumber2!is ...
  34. inumber1,inumber2!Returns the quotient of two complex numbers!is the complex numerator or dividend!is the complex denominator ...
  35. inumber1,inumber2,.!Returns the product of 1 to 255 complex numbers!Inumber1, Inumber2,. are from 1 to 255 complex numbers ...
  36. is a calculated column.Allow any values to appear in this column? If you choose Yes, the calculated formula will no longer ...
  37. is a calculated column.Use this new formula for all rows in the list? If you choose No, this formula will not propagate to ...
  38. is not recognized as a text file. Do you still want to open it?Excel can open this file as if it is a text file, but the ...
  39. is used to calculate other columns. Are you sure you want to delete it?If you delete |0, calculations will be adjusted in ...
  40. is used to calculate other columns. Are you sure you want to insert it?If you insert |0, calculations will be adjusted in ...
  41. issue,first_interest,settlement,rate,par,frequency,basis,calc_method!Returns the accrued interest for a security that pays ...
  42. issue,settlement,rate,par,basis!Returns the accrued interest for a security that pays interest at maturity!is the security's ...
  43. Keeps graphic objects, buttons, text boxes, drawn objects, and pictures with their associated cells when you cut, copy, filter, ...
  44. known_y's,known_x's!Calculates the point at which a line will intersect the y-axis by using a best-fit regression line plotted ...
  45. known_y's,known_x's!Returns the slope of the linear regression line through the given data points!is an array or cell range ...
  46. known_y's,known_x's!Returns the square of the Pearson product moment correlation coefficient through the given data points!is ...
  47. known_y's,known_x's!Returns the standard error of the predicted y-value for each x in a regression!is an array or range of ...
  48. known_y's,known_x's,const,stats!Returns statistics that describe a linear trend matching known data points, by fitting a ...
  49. known_y's,known_x's,const,stats!Returns statistics that describe an exponential curve matching known data points!is the set ...
  50. known_y's,known_x's,new_x's,const!Returns numbers in a linear trend matching known data points, using the least squares method!is ...
  51. known_y's,known_x's,new_x's,const!Returns numbers in an exponential growth trend matching known data points!is the set of ...
  52. Label references in this file will change to standard cell references.This version of Excel doesnâ t support label references. ...
  53. Limits iteration for goal seeking or for resolving circular references. Unless you specify otherwise, Excel stops after 100 ...
  54. link_location,friendly_name!Creates a shortcut or jump that opens a document stored on your hard drive, a network server, ...
  55. Locking objects has no effect unless the sheet is protected. To protect the sheet, choose Protection from the Tools menu, ...
  56. Locking objects has no effect unless the sheet is protected.To help protect the sheet, choose Format on the Home tab, and ...
  57. logical1,logical2,.!Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE!are 1 to 255 conditions ...
  58. logical1,logical2,.!Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments ...
  59. logical1,logical2,.!Returns a logical 'Exclusive Or' of all arguments!are 1 to 254 conditions you want to test that can be ...
  60. logical_test,value_if_true,value_if_false!logical_test!Checks whether a condition is met, and returns one value if TRUE, ...
  61. lookup_value,lookup_array,match_type!Returns the relative position of an item in an array that matches a specified value ...
  62. lookup_value,table_array,col_index_num,range_lookup!Looks for a value in the leftmost column of a table, and then returns ...
  63. lookup_value,table_array,row_index_num,range_lookup!Looks for a value in the top row of a table or array of values and returns ...
  64. lower_limit,upper_limit!Returns the error function!is the lower bound for integrating ERF!is the upper bound for integrating ...
  65. Make sure Visual Basic for Applications is installed on your computer. If Visual Basic for Applications is installed, make ...
  66. Makes an adjacent cell the next active cell after you press RETURN in the current active cell. On the Direction pop-up menu, ...
  67. Manage the lists that you create to automatically fill cells or sort data in unique ways. For example, a custom list can ...
  68. may contain features that are not compatible with |1. Do you want to keep the workbook in this format? To keep this format, ...
  69. Memory was used up attempting to convert and save PivotTable data from a different version.Data for the saved PivotTable(s) ...
  70. Microsoft Excel automatically assigned names to your page fields. To give them different names, click a page field and then ...
  71. Microsoft Excel can convert only one column at a time.The range can be many rows tall but no more than one column wide. Try ...
  72. Microsoft Excel cannot access the file '|'.There are several possible reasons: The file name or path name does not exist. ...
  73. Microsoft Excel cannot calculate a formula.Cell references in the formula refer to the formula's result, creating a circular ...
  74. Microsoft Excel cannot calculate a formula.There is a circular reference in an open workbook, but the references that caused ...
  75. Microsoft Excel cannot complete this operation because the ODBC Driver Manager is not installed. To install the ODBC Driver ...