Which of the following commands in Microsoft Excel 2016 allows a user to automatically create groups and use common functions such as sum, count and average for helping in summarizing data?

In Microsoft Word 2016, which of the following is NOT a valid option for Macro Settings under the Trust Center in Word Options?

In order to show a timeline; a progression; sequential steps in a process, task or workflow; or to emphasize movement or direction, which of the following Process type SmartArt graphics will be the most suitable option?

In the New Slide option under the Insert tab, which option should you select if you want to import slides from another presentation in Microsoft PowerPoint 2016?

Suppose that you have typed a paragraph as shown in figure 1 of the given image. You have applied center alignment to the paragraph and the resultant paragraph is shown in figure 2 of the given image. Which of the following is the correct procedure to apply center alignment to the paragraph?

Which of the following types of watermark can be applied to a Microsoft Word 2016 document?

How can you remove duplicate emails present in a particular folder?

Dave receives a file named Theme1.thmx from his boss. Opening the file opens a blank PowerPoint document. On clarifying from his boss, he learns that the .thmx file contains a particular theme which needs to be applied to the annual report on which Dave is working. How can Dave achieve this?

Which of the following is not a category of transition?

Below are two statements regarding Breaks in Microsoft Word 2010. Statement X: Text Wrapping Page Break separates text around objects on web pages, such as caption text from body text. Statement Y: Continuous Section Break inserts a section break and starts the new section on the next page. Which of the following options is correct?

By default, when you paste a chart from Excel into PowerPoint 2007, is it linked or embedded?