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?

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

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

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?

Features available in Excel 2010?

Keyboard shortcut to insert a new worksheet?

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?

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

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?

VBA is used to automate tasks in Microsoft Excel 2010.

Which statements is correct about worksheet grouping?