Microsoft Office MCQs
Microsoft Office MCQs
Answer these 200+ Microsoft Office MCQs and assess your grip on the subject of Microsoft Office.
Scroll below and get started!
A.
General
B.
Proofing
C.
Save
D.
Advanced
A.
They represent that the cells are containing formatted data.
B.
They represent that some data validation is associated with the cells.
C.
They represent that the comments are associated with the cells
D.
They represent that the cells cannot be edited.
The IT security depanmc-ltt of Mark''s organization has (loaded that only digitally signed macros will he allowed in micorosoft’s Excel 2016. Which of the following is the correct way to restrict the unsigned macros?
A.
Go to the File tab -> Click Info -> Click Excel Options -> Click Security-> Select Allow digitally signed macros only
B.
Go to the File tab -> Click info ~> Click Excel Options -> Click Security-> Select Disable All macros accept digitally signed macros
C.
Go to the File tab -> Click Options -> Click Trust Center under the Excel Options dialog box-> Click Trust Center Settings --> Click Macro Settings-> Select Disable All macros except digitally signed macros
D.
Go to the File tab ~> Click Options -> Click Trust Center under the Excel Options dialog box -> Click Macros -> Select Disable All macros except digitally signed macros
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 SmatArt graphics will be the most suitable option?
A.
Arrow Ribbon
B.
Basic Chevron Process
C.
Continuous Picture List
D.
Ascending Picture Accent Process
A.
Check Accessibility
B.
Check Compatibility
C.
Document inspector
D.
None of the above
A.
4
B.
6
C.
10
D.
16
7: In Microsoft Word 2016. which of the following types of circle represents the top of the hierarchy in a Sunburst chart?
A. Outermost circle
B. innermost circle
C. Both a and b
D. Neither a nor b)
A.
Select all the text and press Ctrl + U keys.
B.
Select all the text and press Shift + U keys.
C.
Select all the text and press Ctrl + Shift + W keys.
D.
Select all the text and press Ctrl + Shift + T keys.
Suppose that you have inserted a few images into a Microsoft Word 2016 document. From which of the following views under the View tab, you will NOT be able to edit these images?
1. Print Layout
2. Web Layout
3. Outline
4. Draft
A.
All 1. 2. 3. and 4
B.
Only 2 and 3
C.
Only 3 and 4
D.
Only 2 and 4
10: In Microsoft Excel 2016. which of the following tabs will you click for accessing the View Macros option?
A. Developer
B. Review
C. View
D. Home
Maria inserts a table with three rows and three columns into a Microsoft Word 2016 document. Now she wants to delete that table from the document- Which of the following isr’are the correct procedure[s] to do this?
1. Place the cursor Inside any cell of the table and press the Delete key.
2. Right-click on the table move handle and select Delete Table.
3. Select the whole table by right-clicking on the table move handle and press Delete
key.
4. Select the whole table by right-clicking on the table move handle and press Ctrl + Delete
A.
Only 1 and 2
B.
Only 2 and 4
C.
Only 2 and 3
D.
Only 1. 3. and 4
12: In Microsoft Excel 2016. which of the following options is used for limiting or restricting the cell entries to a certain data type?
A. Manage Data Model
B. Filter
C. Advanced
D. Data Validation
13: In Microsoft PowerPoint 20i6, which of the following keys can be used to pause the slideshow delivery?
A. A
B. S
C. P
D. L
The coach of the national cricket team wants to analyze the strengths and weaknesses of the team players. He has selected 4 major areas to analyze: fitness. flexibility. attitude and punctuality. Which of the following chart types will be most suitable in this situation?
A.
Line chart
B.
Surface chart
C.
Radar chart
D.
Waterfall chart
15: in Microsoft PowerPoint 20l6. which of the following view types should be used to show all the slides in a presentation on one screen?
A. Outline view
B. Normal view
C. Slide Sorter view
D. Notes Page view
16: While changing the resolution of a picture in Microsoft PowerPoint 2016. which of the following is NOT included in the Adjust group under the Format tab?
A. Color
B. Corrections
C. Shapes
D. Artistic Effects
17: In Microsoft Excel 2016. which of the following is the correct syntax of the VLOOKUP command?
A. =VLOOKUP (value. table. coi_lndex. [range_lookup})
B. =VLOOKUP (col_ index. [range_lookup})
C. :VLOOKUP (table. Irange_lookup]),value, col_index)
D. =VLKUP (value, col_index. table. [range_lookup]i
Consider the given Image for the following question.A.
Max of Days
B.
Average of Days
C.
Sum of Days
D.
Count of Days
19: Which of the following statements is correct about subtotal and total fields in a Microsoft Excel 2016 PivotTable report?
A. lfa calculated item is contained by a field, then the subtotal summary function cannot be Changed.
B. Average function cannot be used as a subtotal.
C. Var and Varp functions cannot be used as a subtotal.
D. None of the above.
20: in Microsoft Excel 20l6. which of the following keyboard shortcuts should be pressed to switch between relative and absolute cell references while writing a formula in a worksheet?
A. F1
B. Ctrl+6
C. F4
D. Ctr|+2
21: Which of the following options is NOT a correct method for consolidating data in Microsoft Excel 2016?
A. Consolidation by position.
B. Consolidation by category.
C. Consolidation by data type
D. None of the above.
22: In Microsoft PowerPoint 2016, which of the following keyboard shortcuts is used to add a new slide to a presentation?
A. Ctrl + N
B. Ctrl + S
C. Ctrl + F
D. Ctrl + M
23: in a Microsoft Word 2016 document. which of the following is the correct procedure to divide a paragraph into three columns?
A. Select the paragraph > Click the insert tab on the ribbon > Click on the Arrange option and select the option Three.
B. Select the paragraph > Click the insert tab on the ribbon > Click on the Columns option and select the option Three.
C. Select the paragraph > Click the Layout tab on the ribbon > Click on the Arrange option and select the option Three.
D. Select the paragraph > Click the Layout tab on the ribbon > Click on the Columns option and select the option Three.
24: in Microsoft Word 2016. which of the following options is NOT a default watermark in the Watermark gallery?
A. DRAFT
B. RESTRICTED DOCUMENT
C. CONFIDENTIAL
D. Do Not COPY
A.
Select the paragraph and press Ctrl + C.
B.
Select the paragraph and press Shift + C.
C.
Selectthe paragraph and press Shift + L.
D.
Select the paragraph and press Ctrl + E
26: While working in Microsoft Excel 2016. for which of the following options. if included in a worksheet. we cannot use the Track Changes option?
A. Comment
B. Table
C. Chart
D. Picture
27: In Microsoft PowerPoint 2016. which of the following statements is incorrect about deleting cropped areas of a picture?
A. After you crop parts of a picture. the cropped parts will no longer be a part of the picture file.
B. After you delete cropped parts. your changes cannot be undone if you have saved and closed the file.
C. If you delete cropped parts and change your mind. you can click the Undo button to restore the cropped parts.
D. Even after you crop parts of a picture. the cropped parts remain a part of the picture file.
A.
Only option i).
B.
Only options ii) and iii].
C.
Only options i) and iii).
D.
All options i) .ii) and iii).
29: By default. how many worksheets are there in a new Microsoft Excel 2016 workbook?
A. One
B. Two
C. Three
D. Five
A.
Surface char
B.
Histogram chart
C.
Area chart
D.
None of the above
31: In Microsoft PowerPoint 2016, whicxh of the following keyboard shortcuts is used to add a new slide to a presentation?
A. Ctrl + N
B. Ctrl + S
C. Ctrl + F
D. Ctrl + M
32: Which of the following keyboard shortcuts is used to apply subscript formatting?
A. Ctrl+Equal sign (=)
B. Ctrl+Shift+Plus sign (+)
C. Ctrl+Shift+Minus sign (-)
D. Ctrl+Minus sign (-)
33: While changing the resolution of a picture in Microsoft PowerPoint 2016, which of the following is NOT included in the Adjust group under the Format tab?
A. Color
B. Corrections
C. Shapes
D. Artistic Effects
34: In Microsoft PowerPoint 2016, if you want to remove a picture watermark that was applied as a background, then which of the following sets of steps will you choose?
A. Slide Master > Background Styles > Format Background
B. Slide Master > Master Layout > Format Background
C. Slide Master > Background Styles > Delete
D. Slide Master > Background Styles > Remove Watermarks
35: With respect to Microsoft PowerPoint 2016, which of the following statements is incorrect about the Animations pane?
A. In the Animations pane, you can rearrange or remove animations in the Play From option.
B. In the Animations pane, you can add speaker notes to a slide.
C. In the Animations pane, you can modify how the animation works, or include a sound in Effect Options.
D. In the Animations pane, you can modify how the animation starts and how long it lasts in Timing.
36: By default, all cell references in Microsoft Excel 2016 are:
A. relative
B. absolute
C. none of the above.
37: How can we define a name to a cell in a Microsoft Excel 2016 Worksheet?
A. Right-click on the cell and click on "Define Name".
B. Click on the "Formulas" tab and click on "Define Name" under the "Define Names" group.
C. Click on the "Home" tab and click on "Format" under the "Cells" group.
D. Click on the "Home" tab and click on "Define Name" under the "Define Names" group.
38: Which of the following statements is/are correct about working with slides in a Microsoft PowerPoint 2016 presentation?
A. You can add, rearrange and delete slides.
B. You can organize slides into sections.
C. You can change the size of slides.
D. All of the above.
39: Which of the following keyboard shortcuts is used to open the Macros dialog box in Microsoft Word 2016?
A. ALT + F6
B. ALT + F7
C. ALT + F8
D. ALT + F9
40: In Microsoft PowerPoint 2016, when you are applying animations to objects, in which of the following panes can you give each object a distinct name to make it easier to work with them?
A. Animation pane
B. Notes pane
C. Comments pane
D. Selection pane
41: In Microsoft Excel 2016, which of the following options is used for limiting or restricting the cell entries to a certain data type?
A. Manage Data Model
B. Filter
C. Advanced
D. Data Validation
42: In Microsoft Word 2016, which of the following options is NOT a valid setting for Page Border?
A. Shadow
B. Line
C. 3-D
D. Box
Suppose that you have copied data from an Excel worksheet and want to paste it in your PowerPoint 2016 presentation. While pasting data to your presentation from thePasteoption under theHometab, which of the following options will you choose in order to copy the data as information that can be edited in Excel later?
A.
Picture
B.
Keep Text Only
C.
Embed
D.
Keep Source Formatting
44: While working in a Microsoft Word 2016 document, which of the following tabs on the ribbon is used to display the Navigationpane?
A. Home
B. Insert
C. Review
D. View
45: In Microsoft PowerPoint 2016, which of the following is NOT a part of Emphasis Animations under the Animations tab?
A. Lighten
B. Pulse
C. Bounce
D. Teeter
Suppose that you have downloaded a new font from the web for your Microsoft Word 2016 document. If you want to open this document on another computer that doesn
A.
General
B.
Proofing
C.
Save
D.
Advanced
47: Which of the following is NOT an animation effect?
A. Swivel
B. Bounce
C. Dissolve
D. Zoom
48: With respect to PowerPoint 2016, which of the following statements is correct?
A. You can only apply one animation to a single object.
B. You cannot apply animations to an object.
C. You can apply more than one animation to a single object.
D. You can only apply animations if it is more than a single object.
A.
Go to theHometab > Click on theTrack Changesoption under theEditinggroup > Click on theSet Passwordoption.
B.
Go to theFiletab > Click onOptions> Click on theAdvancedoption in theWord Optionsdialog box > Click onTrack Changes> Click onLock Tracking.
C.
Go to theReview tab> Click on theTrack Changesoption > Click onLock Tracking.
D.
Go to theReviewtab > Click onSecurity> Click on theTrack Changesoption > Click on theLock Track Changesoption.
E.
Password to Track Changes cannot be set in Microsoft Word 2016.
50: While working with a Microsoft Word 2016 document, in which of the following views, gridlines in the background of the document can be seen?
A. Web layout view
B. Print layout view
C. Outline view
D. None of the above
List of Microsoft Office MCQs ...
Available in:
Microsoft Office MCQs
Вопросы с выбором ответа по Microsoft Office (MCQs)
Preguntas de opción múltiple sobre Microsoft Office (MCQs)
Microsoft Officeの選択肢式問題 (MCQs)
Domande a Risposta Multipla su Microsoft Office (MCQs)
Questions à choix multiple sur Microsoft Office (MCQs)
Perguntas de Múltipla Escolha sobre o Microsoft Office (MCQs)
Fragen mit Mehrfachauswahl zu Microsoft Office (MCQs)
Microsoft Office 多项选择题 (MCQs)
أسئلة اختيار متعدد حول Microsoft Office (MCQs)
Pertanyaan Pilihan Ganda Microsoft Office (MCQs)
Microsoft Office Çoktan Seçmeli Sorular (MCQs)
