1. There are red triangles in the upper-right corner of each cell under the column titled ‘Class'. What do they signify?
2. Which tab will you click for accessing the View Macros option in Microsoft Excel 2016. ?
3. In Microsoft PowerPoint 20i6, which of the following keys can be used to pause the slideshow delivery?
4. in Microsoft PowerPoint 20l6. which of the following view types should be used to show all the slides in a presentation on one screen?
5. Which is the correct syntax of the VLOOKUP command?
6. Consider the given Image for the following question. John inserts a PivotTa bie in Sheet 2, based on the data given in the image. He drags the 'Days' field from the list of columns to the Values Section in the PivotTabie Fields pane. Which of the followi
7. 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?
8. Which is incorrect about the Animations pane with respect to Microsoft PowerPoint 2016?
9. Which option is used for limiting or restricting the cell entries to a certain data type in Microsoft Excel 2016,?
10. In Microsoft Excel 2016, the =TODAY()command returns:
11.
Consider the Excel sheet given in the image. What will be the output if you type the formula, =COUNTA(A1:B8), in cell B9?
12.
Which of the following options can be used for checking the protection status of a file in Microsoft Excel 2016?
13. While working in Microsoft Excel 2016, for which of the following options, if included in a worksheet, we cannot use theTrack Changesoption?
14. 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?
15. In Microsoft Word 2016, which of the following is NOT a valid option for Macro Settings under the Trust Center in Word Options?
16. Which of the following statements regarding images in Microsoft Excel 2010 are true?
17. You are editing a shape using the Drawing Tools. Which among the following Shape Fill options in the Shape Styles group gives you control over the transparency for a shape?
18. Which of the following is NOT an option when inserting a Cross-reference?
19.
What are the benefits of digitally signing an e-mail in Microsoft Excel 2010?
20. Which among the following chart types do not have axes?
21. contents of the 'Name of User' column have been oriented at an angle. How is this done?
Microsoft Office MCQs | Topic-wise