Which of the given statements are correct about the slicers in Microsoft Excel 2016?

1. They can be used to filter data in a table.

2. They can be used to f‌ilter data in a PivotTable.

3. They can only be connected to PivotTables that share the same data source.

A valid certificate from a certificate authority is required to add a digital signature in Microsoft Excel 2016 workbook.

lf Sam wants to insert a pivot chart in his Excel worksheet, then which Of the following tabs should he use tO perform the same?

In order to protect your Excel data, which of the given f‌ile-level protections are available in Microsoft Excel 2016? 1. File encryption 2. Setting a password to open or modify a f‌ile 3. Digital signature

Correct function of the Wrap Text in Microsoft Excel 2016?

Can you perform a case sensitive data sorting in Microsoft Excel 2016?

The source range for a Pivot table may not contain:

Which worksheet function returns the parameters of an exponential trend?

The status bar does which of the following:

Which is true of Excel Macro-enabled templates and Excel Add-ins?

When creating a vertical page break without creating a horizontal page break as well, the active cell