By using Names, data can be understood and maintained in a much easier way. Which of the followings are the correct examples of using Names in Microsoft Excel 2010?

Which of the following options are true about a PivotTable calculated field?

Mark inserts an image into a current worksheet. His client demands that the image should be attached with a cell and should resize when the cell is resized. Which of the following options is the correct Format Picture property, which will fulfil this requirement?

Roger upgrades from Excel 2003 to 2010. He wants to run the PivotChart Wizard but has not installed the Classic menu for 2010. Which of the following is the correct way to add the PivotTable and PivotChart Wizard?

Daniel groups three sheets: Q1, Q2 and Q3, containing sales data. What will happen on deleting the data of cell B2 from sheet Q1?

For Workbook Links in Microsoft Excel 2010, which security setting is NOT recommended?

Data of a copied cell remains on the clipboard until a cell is not edited.

Slicers are typically associated with the PivotTable in which they are created.

Laura inserts an image into a shape. She needs to make this image transparent so that the text remains visible. Which of the followings is the correct way to make the image transparent?

If your Microsoft Excel workbook closes due to system error before you could save it, then which of the following is the correct way to recover it?

What is the maximum number of users that can open and share a shared workbook at the same time?