Excel 2016

  1. To create a set, you must specify a set name and add at least one row to the set. Before you click OK, enter a set name and ...
  2. To create a table from an AutoFiltered range, turn off AutoFilter. Or, when inserting the table, enable the option: My table ...
  3. To create this stock chart, arrange the data on your sheet in this order: high price, low price, closing price. Use dates ...
  4. To create this stock chart, arrange the data on your sheet in this order: opening price, high price, low price, closing price. ...
  5. To create this stock chart, arrange the data on your sheet in this order: volume traded, high price, low price, closing price. ...
  6. To create this stock chart, arrange the data on your sheet in this order: volume traded, opening price, high price, low price, ...
  7. To create this stock chart, you must arrange the data on your worksheet in the following order: high price, low price, closing ...
  8. To create this stock chart, you must arrange the data on your worksheet in the following order: opening price, high price, ...
  9. To create this stock chart, you must arrange the data on your worksheet in the following order: volume traded, high price, ...
  10. To create this stock chart, you must arrange the data on your worksheet in the following order: volume traded, opening price, ...
  11. To display a workbook in this Web Part, you must first select the workbook.To select a workbook, open the tool pane, and ...
  12. To edit in the browser, a copy of the file will be created in a supported format.To edit this workbook without creating a ...
  13. To edit in the browser, a copy of the file will be created. Features that are not supported in the browser will be removed ...
  14. To edit this in your browser, we will create a copy that doesn't include unsupported features.To edit this workbook with ...
  15. To edit this workbook you first need to save it in a supported format. To do this, open the workbook for viewing and select ...
  16. To enable this option, you must install a High Performance Computing (HPC) Cluster Connector. A Cluster Connector enables ...
  17. To finish the query and retrieve the data, click Finish.If you want to add this query to the list of queries that are available ...
  18. To get data from a Web Page into (!idspnExcel_NV), you must open Excel as an independent application and then perform a Web ...
  19. To keep data in the order it's received from the data source, go on to the next step.To sort the data, choose a column in ...
  20. To prevent possible loss of data, Microsoft Graph cannot shift nonblank cells off the datasheet. Try to delete or clear the ...
  21. To prevent possible loss of data, you cannot shift nonblank cells off of the worksheet. Select another location in which ...
  22. To publish the entire workbook as an interactive web page, you must have at least one worksheet in this workbook. Chart sheets, ...
  23. To publish to a SharePoint list, Excel must force columns to use certain recognized data types. All cells with individual ...
  24. To refresh an external data range automatically when the parameter value changes, you must select a single cell to supply ...
  25. To refresh an external data range automatically when the parameter value changes, you must select the parameter cell from ...
  26. To remove blank rows from a PivotTable:1) Select the PivotTable.2) On the PivotTable Tools | Design tab, point to the Blank ...
  27. To resolve this conflict, you can discard your changes and keep the other changes, you can retry your changes, or you can ...
  28. To save a file with these features, click No, and then choose a macro-enabled file type in the File Type list.To continue ...
  29. To save as XML Spreadsheet, you must have at least one worksheet in this workbook. Chart sheets, MS Excel 4.0 Macro sheets, ...
  30. To save this web page to the current location, it needs to be saved using short file names, which requires organizing supporting ...
  31. To select a column, click the button to the right of the text box, select a column or cell within the column, and then click ...
  32. To simplify the spreadsheet structure:1) Select the merged cells.2) Split merged cells by selecting Unmerge Cells from the ...
  33. To sort a column, click the button to the right of the text box, select a column or cell within the column, and then click ...
  34. To sort a row, click the button to the right of the text box, select a row or cell within the row, and then click the button ...
  35. To specify a header row:1) Select the table and click on the Table Tools | Design tab.2) Check the Header Row table style ...
  36. To specify the data and labels for the chart now, click in the Data Range box, and then select the cells on your worksheet.To ...
  37. To use a chart template, you can choose it when you create a chart (Insert menu, All Chart Types Dialog Box Launcher, Templates ...
  38. To use an Office Data Connection (.odc) file, click Cancel, and then click Existing Connections in the Get External Data ...
  39. To use multiple chart types, choose the Chart Type command or the chart type group command (for example, Line Group) from ...
  40. To use this feature, you must first refresh the PivotTable. On the Analyze tab, in the Data group, click Refresh, and then ...
  41. To use this Web page interactively, you must have Microsoft Internet Explorer 5.01 Service Pack 2 (SP2) or later and the ...
  42. To view the columns for data in a table, click the + sign beside it the Available Tables And Columns box.To include an available ...
  43. trials,probability_s,alpha!Returns the smallest value for which the cumulative binomial distribution is greater than or equal ...
  44. trials,probability_s,alpha!This function is available for compatibility with (!idspnExcel_2007) and earlier.Returns the smallest ...
  45. trials,probability_s,number_s,number_s2!Returns the probability of a trial result using a binomial distribution!is the number ...
  46. type_text!Returns information about the current operating environment!is text specifying what type of information you want ...
  47. Unable to acquire a lock on your workbook. It is recommended that you select Open in {0:Excel} or try to save your changes ...
  48. Unable to get the required information about this cube. The cube might have been reorganized or changed on the server. The ...
  49. Unable to open Access database '{0}' due to failure of connection with the remote SQL Server database using cached authentication ...
  50. Unable to open Access database '{0}' due to failure of connection with the remote SQL Server database using integrated authentication. ...
  51. Unable to perform the operation. The operation refers to items that may not exist in the workbook, may not have been marked ...
  52. Unable to perform the requested action because of communication issues.Check that you are still connected to the Internet ...
  53. Unexpected file lock by |. Please try again, and then if necessary, use the Share Workbook command (Changes group on the ...
  54. Unexpected file lock by |. You can override this file lock, or continue without doing so. If you continue without overriding ...
  55. Unfortunately, the workbook needs to be closed or checked in before you can edit it. If everyone uses {0:ExcelWebApp}, you ...
  56. Uninitialized ActiveX controls cannot be transferred to the selected file format. The controls will be lost if you continue. ...
  57. Use the Data Analysis Expressions (DAX) Language to modify the results returned by the connection to the Workbook Data Model. ...
  58. 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 ...
  59. 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, ...
  60. value!Checks whether a value is a logical value (TRUE or FALSE), and returns TRUE or FALSE!is the value you want to test. ...
  61. 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, ...
  62. value!Checks whether a value is a reference, and returns TRUE or FALSE!is the value you want to test. Value can refer to ...
  63. value!Checks whether a value is an error (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!), and returns TRUE or FALSE!is ...
  64. value!Checks whether a value is an error (#VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!) excluding #N/A, and returns ...
  65. value!Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE!is the value you want tested: ...
  66. 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 ...
  67. 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, ...
  68. value!Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero)!is the value you ...
  69. value!Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; ...
  70. value!Returns the sheet number of the referenced sheet!is the name of a sheet or a reference that you want the sheet number ...
  71. value,format_text!Converts a value to text in a specific number format!is a number, a formula that evaluates to a numeric ...
  72. value,value_if_error!Returns value_if_error if expression is an error and the value of the expression itself otherwise!is ...
  73. value,value_if_na!Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression!is ...
  74. value1,value2,.!Calculates standard deviation based on an entire population, including logical values and text. Text and ...
  75. value1,value2,.!Calculates variance based on the entire population, including logical values and text. Text and the logical ...