Which of the following statements are correct about worksheet grouping?

VBA is used to automate tasks in Microsoft Excel 2010.

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?

Features available in Excel 2010?

The marketing team of XYZ Corp collects data of foods from multiple resources. If the marketing team wants to highlight the duplicate records of food, then which of the following sets of steps should be used?

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?