Through which of the following options in Microsoft Excel 2016, a user can enable the Data Connections settings, in order to connect with external data?

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?

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

What happens when you use the combination Ctrl+Space

To build a PivotTable, how must your data be formatted?

The combination Ctrl+F1: