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?

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?

Keyboard shortcut for accessing the Spelling option in Microsoft Excel 2013?

Peter created an Excel sheet containing the name and price of articles sold at a jewellery store; however, when he viewed the document again, he noticed that some of the cells contained pound signs as shown in the given image. What should be done to resolve this issue?

Suppose you made some changes in Sheet1 in cell 'B13' and you want to change the same cell in Sheet2. Which of the following functions will help you for this task?

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?