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"

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

Which statement is correct about Excel file protection?

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

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?

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?

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

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

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?

Keyboard shortcut used for the 'Clear filter' command for Slicer in a Pivot table?

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