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 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

Which function checks to see that all conditions are true before returning a TRUE response?

Which worksheet function returns the slope of the linear regression line?