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
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
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
A. Manage Data Model
B. Filter
C. Advanced
D. Data Validation
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
A. Outline view
B. Normal view
C. Slide Sorter view
D. Notes Page view
A. Color
B. Corrections
C. Shapes
D. Artistic Effects
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
A.
Max of Days
B.
Average of Days
C.
Sum of Days
D.
Count of Days
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.
A. F1
B. Ctrl+6
C. F4
D. Ctr|+2
A. Consolidation by position.
B. Consolidation by category.
C. Consolidation by data type
D. None of the above.
A. Ctrl + N
B. Ctrl + S
C. Ctrl + F
D. Ctrl + M
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.
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
A. Comment
B. Table
C. Chart
D. 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).
A. One
B. Two
C. Three
D. Five
A.
Surface char
B.
Histogram chart
C.
Area chart
D.
None of the above
A. Ctrl + N
B. Ctrl + S
C. Ctrl + F
D. Ctrl + M
A. Ctrl+Equal sign (=)
B. Ctrl+Shift+Plus sign (+)
C. Ctrl+Shift+Minus sign (-)
D. Ctrl+Minus sign (-)
A. Color
B. Corrections
C. Shapes
D. Artistic Effects
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
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.
A. relative
B. absolute
C. none of the above.
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.
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.
A. ALT + F6
B. ALT + F7
C. ALT + F8
D. ALT + F9
A. Animation pane
B. Notes pane
C. Comments pane
D. Selection pane
A. Manage Data Model
B. Filter
C. Advanced
D. Data Validation
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
A. Home
B. Insert
C. Review
D. View
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
A. Swivel
B. Bounce
C. Dissolve
D. Zoom
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.
A. Web layout view
B. Print layout view
C. Outline view
D. None of the above
A. Open the PDF file > Go to your PowerPoint presentation > Click on theHometab > Click on theScreenshotoption > Click on theScreen Clippingoption
B. Open the PDF file > Go to your PowerPoint presentation > Click on theInserttab > Click on theScreenshotoption > Click on theScreen Clippingoption
C. Open the PDF file > Go to your PowerPoint presentation > Click on theInserttab > Click on thePictureoption > Click on theScreen Clippingoption
D. Open the PDF file > Go to your PowerPoint presentation > Click on theTransitionstab > Click on theScreenshotoption > Click on theScreen Clippingoption
A. Select the paragraph > Click theInsert tab on the ribbon > Click on the Arrangeoption and select the option Three.
B. Select the paragraph > Click theInsert tab on the ribbon > Click on the Columnsoption and select the option Three.
C. Select the paragraph > Click theLayout tab on the ribbon > Click on the Arrangeoption and select the option Three.
D. Select the paragraph > Click theLayout tab on the ribbon > Click on the Columnsoption and select the option Three.
A. Perm
B. Permi
C. Permt
D. Permit
E. None of the above
A. DRAFT
B. RESTRICTED DOCUMENT
C. CONFIDENTIAL
D. DO NOT COPY
A. If a calculated item is contained by a field, then the subtotal summary function cannot be changed.
B. Sum, count and average functions can be used as a subtotal.
C. Var and Varp functions cannot be used as a subtotal.
D. None of the above.
A. Outermost circle
B. Innermost circle
C. Both a and b
D. Neither a nor b
A. F2
B. F5
C. F7
D. F9
A. Ctrl + Shift + S
B. Ctrl + Shift + T
C. Shift + S
D. None of the above
A. Scenario Manager
B. Goal Seek
C. Consolidate
D. Data Table
A. F1
B. Ctrl+6
C. F4
D. Ctrl+2
In Microsoft Excel 2016, when do we receive a "#Value!" error in the VLOOKUP function?
i) When the "lookup_value" argument is more than 255 characters.
ii) When the "col_index_num" argument contains text.
iii) When the "col_index_num" argument is equal to 0.
A.
Only option i) is correct.
B.
Only options i) and ii) are correct.
C.
Only options ii) and iii) are correct.
D.
All options i), ii) and iii) are correct.
A. Stock
B. Pie
C. Sunburst
D. Histogram
A. To edit font
B. To insert functions.
C. To copy and paste the formatting of one cell to another in a Worksheet.
D. To sort and filter data.
A. You can set your personal template as the default template so that it is ready to use every time you open PowerPoint.
B. You cannot set your personal template as the default template in PowerPoint
C. You can use every template included in PowerPoint.
D. You can personalize templates in PowerPoint.
A. Define
B. Grammar
C. Lookup
D. Explore
A. Go to theFiletab -> ClickInfo-> ClickExcel Options-> ClickSecurity-> Select Allow digitally signed macros only
B. Go to theFiletab -> ClickInfo-> ClickExcel Options-> ClickSecurity-> SelectDisable All macros except digitally signed macros
C. Go to theFiletab -> ClickOptions-> ClickTrust Centerunder theExcel Optionsdialog box-> ClickTrust Center Settings-> ClickMacro Settings-> SelectDisable All macros except digitally signed macros
D. Go to theFiletab -> ClickOptions-> ClickTrust Centerunder theExcel Optionsdialog box -> ClickMacros-> SelectDisable All macros except digitally signed macros
A. A
B. S
C. P
D. L
A. Print Layout
B. Web Layout
C. Outline
D. Draft
A. F9
B. F8
C. F7
D. F6
A. Set Up Slide Show
B. Slide Timing
C. Record Slide show
D. Rehearse Timings
A. Sunburst charts
B. Waterfall charts
C. Surface charts
D. Histogram charts
A. the current day name
B. the date when the Excel file was created.
C. the current day and date.
D. the current date.
Consider the Excel sheet given in the image. What will be the output if you type the formula, =COUNTA(A1:B8), in cell B9?
A.
5
B.
6
C.
8
D.
12
Which of the following options can be used for checking the protection status of a file in Microsoft Excel 2016?
A.
Click on theReviewtab > SelectNew> Click onProtect Workbook
B.
Click on theFiletab > SelectOptions> Click onProtect Workbook
C.
Click on theFiletab > SelectInfo> Click onProtect Workbook
D.
Click on theReviewtab > SelectAccount> Click onProtect Workbook
In Microsoft Excel 2016, which of the following options used for displaying or hiding formulas change(s) the state of a cell?
i) Prevent formulas from displaying in the formula bar by protecting the cells that contain them.
ii) Switch between displaying formulas and formula results on a worksheet.
iii) Show hidden formulas by removing the protection from cells.
A.
Only option i).
B.
Only options ii) and iii).
C.
Only options i) and iii).
D.
All options i), ii) and iii).
A. Developer
B. Review
C. View
D. Home
A. $Sheet5$B2
B. $Sheet5.B2
C. Sheet5!B2
D. $Sheet5!B2
A. Playback tab
B. PlayOn tab
C. Play Full Screen tab
D. Video tab
A. One
B. Two
C. Three
D. Five
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
A. Consolidation by position.
B. Consolidation by category.
C. Consolidation by data type.
D. None of the above.
John wants to use a SmartArt graphic to create a chart for his organization. He wants to show the reporting relationships of his organization, such as managers of the departments and non-management employees. Which of the following SmartArt graphic types will be the most suitable for him to use?
A.
Relationship
B.
Hierarchy
C.
Pyramid
D.
Matrix
A. Ctrl + U
B. Ctrl + R
C. Ctrl + Y
D. Ctrl + A
A. By providing Read Only access.
B. By password protecting a Workbook.
C. Restricting permissions by Information Rights Management (IRM).
D. All of the above.
A. Place the cursor inside any cell of the table and press the Delete key.
B. Right-click on the table move handle and select Delete Table.
C. Select the whole table by right-clicking on the table move handle and press Delete key.
D. Select the whole table by right-clicking on the table move handle and press Ctrl+Delete keys.
In Microsoft Excel 2016, what will happen when we click on the marked triangle as shown in the given image?
A.
It will select cell A1.
B.
It will select the complete Worksheet.
C.
It will select all the Worksheets available in a Workbook.
D.
It will add a Worksheet to the file.
A. Shape Fill
B. Text Effects
C. Text Outline
D. Text Fill
A. Ctrl+Alt+Space
B. Ctrl+Shift+Tab
C. Shift+Backspace
D. Ctrl+Alt+T
A. Outline view
B. Normal view
C. Slide Sorter view
D. Notes Page view
A. Alignment
B. Background color
C. Cell text
D. None of the above
A. They are used to add page numbers at the bottom of the pages.
B. They are used to add html links in a document, in order to link the document with a web page.
C. They are used to explain, comment on or provide references to the text mentioned in a document.
D. All of the above.
A. Comment
B. Table
C. Chart
D. Picture
A. 3
B. 4
C. 10
D. 12
E. 15
A. Shift+T
B. Alt+F2
C. Ctrl+F1
D. Shift+F3
A. Click anywhere on the table -> Click on theDesignoption underTable Tools-> Click on theConvert to Rangeoption under theToolsgroup.
B. Right-click on the table -> Click on theTableoption -> Select theConvert to Rangeoption.
C. Click anywhere on the table -> Click on theDeveloperoption underTable Tools-> Click on theConvert to Rangeoption under theToolsgroup.
D. Right-click on the table -> Click on theFilteroption -> Select theConvert to Rangeoption.
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. Insert
B. Review
C. Layout
D. View
Samantha is using SmartArt graphics to represent the performance of her team members. She wants to show the best performers on the top and narrowing down. Which of the following SmartArt types will be the most suitable option to do this?
A.
Matrix
B.
Relationship
C.
Pyramid
D.
Hierarchy
When you create a document in Microsoft Word 2016, certain personal information is added to the file, e.g. information about the author of the document. If you want to share the document with others but do not want to share that personal information, then which of the following options will you choose to remove that information from the file?
A.
Check Accessibility
B.
Check Compatibility
C.
Document Inspector
D.
None of the above
A. =VLOOKUP (value, table, col_index, [range_lookup])
B. =VLOOKUP (col_index, [range_lookup])
C. =VLOOKUP (table, [range_lookup]), value, col_index)
D. =VLKUP (value, col_index, table, [range_lookup])