Timelines are particularly designed for _______ fields that sort out data from a pivot table.

Which statements is 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?

ScreenTips are small pop-ups that provide help when you place the mouse pointer on a UI element. Which of the following will happen on setting the ScreenTip language in an Office program?

Microsoft Excel's custom theme can be applied to content in Word, PowerPoint, Outlook and Access.

Keyboard shortcut to insert a new worksheet?

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?