Suppose that you conducted an aptitude test in a class room to check if the students are ready for competitive exams. Now you want to calculate the average of the total marks obtained by the students in the test. Which of the following formulas can be used to calculate the average of the "Marks Obtained" in the cell "I4"?

With respect to Protect Workbook in Microsoft Excel 2016, the Windows option can be used for preventing users from moving, resizing or closing the workbook window

Keyboard shortcut 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:

In Excel 2013, what happens if you select a row heading, right-click and select the option, Insert?

Difference between the .XLSX and .XLS file format?

A Pivot table enables fast and easy ... of inbuilt relationships in the data sources.

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?