John inserts a PivotTable in a worksheet, as shown in figure 1 of the given image. There are three columns in the data source: Employee, Product and Sales. Now John wants to show the list of products under the employee names as shown in figure 2 of the given image. Where should he double-click on the PivotChart in figure 1, so that he should be able to select the Product column?

Which is NOT a command tab in Microsoft Excel 2016?

Default file extension(s) of a Microsoft Excel 2016 workbook?

Which option is NOT available under 'What-If Analysis'?

In order to treat a numerical value as a text value in Microsoft Excel 2016, it should precede with which of the following symbols?

Keyboard shortcut used for achieving the strikethrough effect as shown in the given image?

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:

Where on the Developer's tab is the VBA button located

When there is a big range of data (many sheets with at least 1000 rows in each),what is better regarding calculating process