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

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?

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

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

What is a known bug in Excel?

The formula =countif(a1,a1) typed in cell b1 will result in:

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?

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?

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?

What are the Report categories in Excel?

What you could do to stop the pivot table from loosing the column width upon refreshing?