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?

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

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?

Which limitation is valid in Microsoft Excel 2010?

VBA is used to automate tasks in Microsoft Excel 2010.

Which statements is correct about worksheet grouping?

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

Which option is the miniature chart(s) that fit into a single cell and help(s) in analyzing and viewing trends in data without creating an entire chart?

Pivot tables are very useful for ___________ one set of data in your data list with another data set.