In Microsoft Excel 2016, which of the following keyboard shortcuts is used for the "Clear filter" command for Slicer in a Pivot table?

John inserts a PivotTable in Sheet 2, based on the data given in the image. He drags the 'Days' field from the list of columns to the Values section in the PivotTable Fields pane. Which of the following options will be the default selection under the Values section?

Correct procedure used for converting a table to a regular range?

By default, all cell references in Microsoft Excel 2016 are:

If a user specifies a print area from the backstage view, then it saves the setting with the workbook.

User can enable the Data Connections settings, in order to connect with external data?

In Excel 2013, the margin is set to which of the following values, by default, for each workbook?

Which statement is correct about Excel file protection?

In Microsoft Excel 2013, the New Comment option is available under which of the following tabs?

Given an Excel spreadsheet: A B C D E ----------------------------------------------------------------------------------- | ID Lastname First name Role Birth Date 1 | 101, Davis, Sara, Sales Rep, 12/08/1968 2 | 102, Fontana, Olivier, VP Sales, 12/19/1952 3 | 103, Leal, Karina, Sales Rep, 08/30/1963 You want to find the first name of the person with the lastname = 'Fontana'

When you have multiple sheets in an excel workbook and want to look at two of them at the same time,you should click: