MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 115 Mcqs, each offering curated multiple-choice questions to sharpen your Microsoft Certification knowledge and support exam preparation. Choose a topic below to get started.
| 51. |
_______ contains multiple tabs, each with several groups of command. |
| A. | Ribbon |
| B. | Active Cell |
| C. | Formula Bar |
| D. | Title Bar |
| Answer» B. Active Cell | |
| 52. |
In an Excel spreadsheet, the contents of cells are as follows:a) A1 contains the value 3b) A2 contains the value 5c) A3 contains the formula: = A$1+A2Contents of cell A3 are copied to Cell A4. The value displayed in Cell A4 will be: |
| A. | 11 |
| B. | 5 |
| C. | 8 |
| D. | 13 |
| Answer» B. 5 | |
| 53. |
Calisto M T, Arial and Century are various types of ______. |
| A. | Word Art |
| B. | Font sizes |
| C. | Styles |
| D. | Fonts |
| Answer» E. | |
| 54. |
In Excel, Weight refers to: |
| A. | The print density of characters |
| B. | The design and appearance of characters |
| C. | The height of the printed character |
| D. | Upright or slanted shape |
| Answer» B. The design and appearance of characters | |
| 55. |
In MS-Excel 2016, 'margin' and 'orientation' options can be selected from which of the following menus? |
| A. | Home |
| B. | Review |
| C. | Insert |
| D. | Page Layout |
| Answer» E. | |
| 56. |
How can you print three copies of a worksheet? |
| A. | Click print from the menu and select the print pages from 1 to 3 |
| B. | Click print from the menu and type 3 in the number of copies text box |
| C. | Press Ctrl+P+3 |
| D. | All of the above |
| Answer» C. Press Ctrl+P+3 | |
| 57. |
In which bar of the MS Word 2010 will the total number of pages, word count and language used will appear? |
| A. | Scroll bar |
| B. | Menu bar |
| C. | Quick Access Tool bar |
| D. | Status bar |
| Answer» E. | |
| 58. |
An alpha numeric combination like 'D2 in Excel would mean a : |
| A. | Workbook address |
| B. | Worksheet address |
| C. | Cell address |
| D. | File name |
| Answer» D. File name | |
| 59. |
In MS Excel, the result value of either 'TRUE' or 'FALSE' is available in which one of the following functions? |
| A. | Logical |
| B. | Arthimetic |
| C. | Algorithm |
| D. | Logarithm |
| Answer» B. Arthimetic | |
| 60. |
MS-Office is a: |
| A. | Software |
| B. | Hardware |
| C. | Firmware |
| D. | Malware |
| Answer» B. Hardware | |
| 61. |
In MS-Excel, a formula starts with the _____ symbol. |
| A. | & |
| B. | # |
| C. | 0 |
| D. | $ |
| Answer» D. $ | |
| 62. |
In MS Word, the dimensions of the Letter page size are |
| A. | 8.5” × 11” |
| B. | 11” × 17” |
| C. | 8.5” × 14” |
| D. | 7.25” × 10.5” |
| E. | None of these |
| Answer» B. 11” × 17” | |
| 63. |
_________ is a tool to create and format spreadsheets. |
| A. | Adobe Photoshop CS |
| B. | Microsoft Power Point |
| C. | Microsoft Excel |
| D. | Internet Explorer |
| Answer» D. Internet Explorer | |
| 64. |
In MS word 2010, shortcut key to print preview is: |
| A. | Ctrl+Alt+I |
| B. | Ctrl+Alt+L |
| C. | Ctrl+Shift+I |
| D. | Ctrl+F2 |
| Answer» E. | |
| 65. |
In MS-Word, the term ‘portrait’ is used to represent: |
| A. | Page size |
| B. | Page orientation |
| C. | Page margin |
| D. | Font style |
| Answer» C. Page margin | |
| 66. |
Among the following which of the bar is NOT present in the MS Word 2010? |
| A. | Scroll bar |
| B. | Menu bar |
| C. | Tool bar |
| D. | Page bar |
| Answer» E. | |
| 67. |
How many different positions can you set for drop cap in MS Word 2007 (Exclude "None position")? |
| A. | 1 |
| B. | 2 |
| C. | 4 |
| D. | 6 |
| Answer» C. 4 | |
| 68. |
In MS Excel, press ________ key to select all rows and columns in the worksheet. |
| A. | Ctrl + A |
| B. | Ctrl + B |
| C. | Ctrl + C |
| D. | Ctrl + D |
| Answer» B. Ctrl + B | |
| 69. |
An excel document that are stored as files is called _____ |
| A. | workforce |
| B. | worksheet |
| C. | worktable |
| D. | workgroup |
| Answer» C. worktable | |
| 70. |
MS Word is an example of : |
| A. | Application Software |
| B. | Complier |
| C. | Operating System |
| D. | System Software |
| Answer» B. Complier | |
| 71. |
In MS Excel 2010, the shortcut key to apply or remove underlining is: |
| A. | Ctrl+4 |
| B. | Ctrl+3 |
| C. | Ctrl+2 |
| D. | Ctrl+5 |
| Answer» B. Ctrl+3 | |
| 72. |
In Excel, what feature enables you to adjust or back solve the value in a cell to reach a desired outcome in a formula? |
| A. | Goal Seek |
| B. | Forecasting |
| C. | Trend line |
| D. | Scenario Summary report |
| Answer» D. Scenario Summary report | |
| 73. |
Mail-merge is a component of |
| A. | MS-Word |
| B. | WordPress |
| C. | MS-Excel |
| D. | MS-Access |
| Answer» B. WordPress | |
| 74. |
In MS Excel 2007, which among the following is called upon to help you solve the problems? |
| A. | Mathematical Library |
| B. | Logical Library |
| C. | Function Library |
| D. | Scientific Library |
| Answer» D. Scientific Library | |
| 75. |
In MS Excel 2007, __________ is an Excel feature that lets you filter out rows from a data table. |
| A. | AutoFilter |
| B. | SystemFilter |
| C. | ManualFilter |
| D. | DataFilter |
| Answer» B. SystemFilter | |
| 76. |
By default how many worksheets are there in an MS-Excel workbook2007? |
| A. | 1 |
| B. | 4 |
| C. | 2 |
| D. | 3 |
| Answer» E. | |
| 77. |
_________ is an example of a math function in MS Excel. |
| A. | IF |
| B. | AND |
| C. | COUNT |
| D. | SQRT |
| Answer» E. | |
| 78. |
Name the feature that commands the word processor to align all the text to fit within the defined margins. |
| A. | Auto correct |
| B. | Auto text |
| C. | Auto format |
| D. | Word wrap |
| Answer» E. | |
| 79. |
In which of the following tab in the illustrations group available in MS Excel 2007 ? |
| A. | Insert |
| B. | Page Layout |
| C. | Data |
| D. | View |
| Answer» B. Page Layout | |
| 80. |
In MS-PowerPoint, slide show options available to the presenter include all of the following, except for: |
| A. | Transitions command |
| B. | Meeting minder command |
| C. | Navigation commands |
| D. | Speaker notes command |
| Answer» B. Meeting minder command | |
| 81. |
In MS-Excel, to hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the _________. |
| A. | freeze panes command on the window menu |
| B. | hold titles command on the edit menu |
| C. | split command on the window menu |
| D. | unfreeze panes command on the window menu |
| Answer» B. hold titles command on the edit menu | |
| 82. |
________________ is the ghosted text behind the content on page in Microsoft word. |
| A. | Watermark |
| B. | Stamp |
| C. | Logo |
| D. | Ghost text |
| Answer» B. Stamp | |
| 83. |
From the given formula, X2 + Y2 what does 2 appear to be in MS Word 2007? |
| A. | Topscript |
| B. | Subscript |
| C. | Upscript |
| D. | Superscript |
| Answer» E. | |
| 84. |
In MS-Word 2007, what is the function of Widow/Orphan control? |
| A. | It will allow you to keep your paragraphs together. |
| B. | It will allow you to form a sentence. |
| C. | It will not allow you to keep your paragraphs together. |
| D. | It will not allow you to form a sentence |
| Answer» B. It will allow you to form a sentence. | |
| 85. |
Cell address $A4 in a formula in MS Excel means:- |
| A. | Absolute cell reference |
| B. | Mixed cell reference |
| C. | Relative cell reference |
| D. | None of the above |
| Answer» C. Relative cell reference | |
| 86. |
In MS-PowerPoint, which key on the keyboard can be used to view slide show? |
| A. | F1 |
| B. | F2 |
| C. | F5 |
| D. | F10 |
| Answer» D. F10 | |
| 87. |
Consider a formula "= $D$3 + $C$5" in cell B4. If cell B4 is copied and pasted into F10, then what will be the formula in cell F10? |
| A. | |
| B. | |
| C. | |
| D. | |
| Answer» C. | |
| 88. |
An alphanumeric combination like "J6" in Excel would mean a: |
| A. | Workbook address |
| B. | Worksheet address |
| C. | Cell address |
| D. | File name |
| Answer» D. File name | |
| 89. |
______ is a feature of the Microsoft word 2010 which helps us to correct mistakes in a document without reading it. |
| A. | Review |
| B. | Drop Cap |
| C. | Thesaurus |
| D. | Spelling and Grammar |
| Answer» E. | |
| 90. |
How many types of default bullets are present in MS Word 2010 (Except None)? |
| A. | 8 |
| B. | 7 |
| C. | 6 |
| D. | 5 |
| Answer» C. 6 | |
| 91. |
In Word, you can force a page break by: |
| A. | Positioning your cursor at the appropriate place and pressing the F1 key |
| B. | Positioning your cursor at the appropriate place and pressing Ctrl+Enter |
| C. | Using the Insert/Section break on the Insert tab |
| D. | Changing the font size of your document |
| Answer» C. Using the Insert/Section break on the Insert tab | |
| 92. |
Press ________ key to open the help window in MS Word 2007 document. |
| A. | F1 |
| B. | F2 |
| C. | F9 |
| D. | F11 |
| Answer» B. F2 | |
| 93. |
In MS-Word 2007, which of the following option is NOT available in Insert? |
| A. | Chart |
| B. | Clip Art |
| C. | Picture |
| D. | Graph |
| Answer» E. | |
| 94. |
In MS Word, RTF stands for ____________ |
| A. | Real Time Formatting |
| B. | Rich Text Format |
| C. | Real Time Fonts |
| D. | Really Text Files |
| Answer» C. Real Time Fonts | |
| 95. |
In MS-Word, Thesaurus tool is used for: |
| A. | Finding words with similar meaning |
| B. | Finding words with opposite meaning |
| C. | Copying of the word |
| D. | Both 1 and 2 |
| Answer» E. | |
| 96. |
In MS - PPT, you can show the shortcut menu during the slide show by: _____. |
| A. | Clicking the shortcut button on the formatting toolbar |
| B. | Right-clicking the current slide |
| C. | Clicking an icon on the current slide |
| D. | None of the above |
| E. | All of the above |
| Answer» C. Clicking an icon on the current slide | |
| 97. |
An alphanumeric combination like "B5" in Excel would mean a: |
| A. | Workbook address |
| B. | Worksheet address |
| C. | Cell address |
| D. | File name |
| Answer» D. File name | |
| 98. |
Choose the well-known DOS based spreadsheet package from the list. |
| A. | Word |
| B. | Smart cell |
| C. | Excel |
| D. | Lotus 1-2-3 |
| E. | None of these |
| Answer» E. None of these | |
| 99. |
In MS-Word, "Ctrl + Delete" is used to: |
| A. | Delete the single letter just after the cursor |
| B. | Delete the single letter just before the cursor |
| C. | Delete the word just before the cursor |
| D. | Delete the word just after the cursor |
| Answer» E. | |
| 100. |
In Microsoft Excel, we use ____________ Tool to copy format from one place and apply it to others. |
| A. | Paint format |
| B. | Paint bucket |
| C. | Format painter |
| D. | Copy format |
| Answer» D. Copy format | |