What are the Report categories in Excel?

Excel Services and Excel Web App all have a lot in common, but they are not exactly the same. These applications can differ in what workbook features are supported for viewing in a browser window. Which of the following feature is not supported in Excel Services?

In Excel 2016, the Forecast Sheet feature can turn a worksheet which contains historical financial data in a visual forecast worksheet. What type of chart is used by default if you do not use a chart of your own choice?

Microsoft does not support the automatic removal of hidden information for signed or protected documents, or for documents that use Information Rights Management (IRM). The Document Inspector has modules that help users inspect and fix specific elements of a given document. Which of the following is not Excel built-in document inspector module?

Which of the following is True when #NAME, error appears in Excel cell?

DGET Database Function in Excel extracts a single value from a record in the data list that matches the criteria you specify. DGET Function return error value if no record matches the specified criteria or the match criteria is greater than the specified criteria. Which of the following error values is returned if multiple records are matched?

If you save a workbook with the results of a Goal Seek calculation in place what will occur?

Which of the following is NOT a 'Solving Method' available in the Solver Add-in?

If you're drawing multiple shapes, how can you keep the Shapes drop-down panel visible, so you don't have to keep clicking the Shapes button?

Assuming Cell A1 is populated with 16.8942, which of the following formulas would result in 16?

Which of the following formulas contains the correct syntax for a calculated field within a PivotTable?