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.
| 1. |
In MS-word, the page is used to insert virtual text (ghost text) in the background of the odd content. |
| A. | Ghost |
| B. | Comment |
| C. | Water mark |
| D. | Hyperlink |
| Answer» D. Hyperlink | |
| 2. |
In MS PowerPoint, the shortcut Ctrl + M helps the user to_____. |
| A. | Open a new blank presentation |
| B. | Apply bold to the selected text |
| C. | Centre aligns the current selection |
| D. | To Insert a new slide |
| Answer» E. | |
| 3. |
In Execl sheet which of the following is the next column name after Z column? |
| A. | A1 |
| B. | A0 |
| C. | AA |
| D. | AZ |
| E. | Z1 |
| Answer» D. AZ | |
| 4. |
In an MS-Excel worksheet, the "zoom" bar appears at the ______ portion of the worksheet. |
| A. | top-right |
| B. | top-left |
| C. | bottom-right |
| D. | bottom-left |
| Answer» C. bottom-right | |
| 5. |
Borders and Shading option of Table Properties can be used to apply which of the following in MS-Word 2007? |
| A. | Mailings |
| B. | Margins |
| C. | Orientation |
| D. | Borders |
| Answer» E. | |
| 6. |
MS applications are examples of |
| A. | Platform software |
| B. | Hardware |
| C. | Operating System software |
| D. | Application Software |
| Answer» E. | |
| 7. |
________ is an animated character that gives help in MS Office? |
| A. | Office Worker |
| B. | Comic Assistant |
| C. | Office Assistant |
| D. | Plotter |
| E. | None of these |
| Answer» D. Plotter | |
| 8. |
How many “workbook views” are available in MS Excel 2007? |
| A. | 4 |
| B. | 3 |
| C. | 6 |
| D. | 5 |
| Answer» B. 3 | |
| 9. |
In MS Excel 2007, date format can be changed from: |
| A. | View tab |
| B. | Home tab |
| C. | Insert tab |
| D. | Review tab |
| Answer» C. Insert tab | |
| 10. |
A ______ is a pre-formatted container on a slide for content (text, graphics, or video) in MS PowerPoint. |
| A. | Cascade |
| B. | Watermark |
| C. | Placeholder |
| D. | Macros |
| Answer» D. Macros | |
| 11. |
In MS-PowerPoint, which feature will you use to apply motion effects in between a slide exits and another enters? |
| A. | Animation objects |
| B. | Animation scheme |
| C. | Slide design |
| D. | Slide transition |
| Answer» E. | |
| 12. |
Hyperlink can be in __________. |
| A. | Pictures. |
| B. | Documents. |
| C. | Text. |
| D. | Button. |
| E. | All of the above. |
| Answer» F. | |
| 13. |
In Microsoft Excel we cannot calculate _____ |
| A. | differentiation problems |
| B. | division problems |
| C. | arithmetic problems. |
| D. | multiplication problems |
| Answer» B. division problems | |
| 14. |
In MS-Word, which option divides a cell into several cells in a table? |
| A. | Merge cells |
| B. | Split cells |
| C. | Split table |
| D. | Autofit |
| Answer» C. Split table | |
| 15. |
How can we add a Chart to the presentation in MS PowerPoint? |
| A. | Insert > Illustration > Chart |
| B. | Design > Illustration > chart |
| C. | Insert > Macros > Chart |
| D. | Layout > object > chart |
| Answer» B. Design > Illustration > chart | |
| 16. |
______ and _______ are the smallest and largest font size available in Font Size tool on formatting toolbar in MS-Office. |
| A. | 8 and 72 |
| B. | 12 and 64 |
| C. | 12 and 72 |
| D. | 8 and 64 |
| Answer» B. 12 and 64 | |
| 17. |
In MS Excel 2010, what is the function of “Count Numbers” in AutoSum group? |
| A. | Find the total number of objects in a group |
| B. | None of the above |
| C. | Compute the sum of a group of numbers |
| D. | Compute the average of a group of numbers |
| Answer» C. Compute the sum of a group of numbers | |
| 18. |
In MS word, insert footnote appears on ________ tab. |
| A. | Insert |
| B. | Review |
| C. | References |
| D. | Layout |
| E. | None of the above |
| Answer» D. Layout | |
| 19. |
Assume the font size of a text in MS-Word 2016 document is 12. If you select the text and press CTRL+SHIFT+> once, then what will be the font size of the text? |
| A. | 11 |
| B. | 13 |
| C. | 10 |
| D. | 14 |
| Answer» E. | |
| 20. |
In MS Excel 2007, _________ will highlight cells that are greater than, less than, between or equal to values that you can specify in the Conditional Formatting. |
| A. | Icon Sets |
| B. | Colour Scales |
| C. | Highlight Cells Rules |
| D. | Data Bars |
| Answer» D. Data Bars | |
| 21. |
In MS-PowerPoint, the effect applied to display when slides changes in slide show view is _______. |
| A. | Custom transition |
| B. | Custom animation |
| C. | Slide transition |
| D. | Slide animation |
| Answer» D. Slide animation | |
| 22. |
Among the following which one operation is not performed by the Insert tab in MS Word 2010? |
| A. | Different way of viewing a document |
| B. | Adding a bookmark |
| C. | Adding page numbers |
| D. | Creating a link to a web page |
| Answer» B. Adding a bookmark | |
| 23. |
________ is an example range in MS Excel |
| A. | A1-B1 |
| B. | A1:A10 |
| C. | A1 to A10 |
| D. | A1-A10 |
| Answer» C. A1 to A10 | |
| 24. |
In MS Excel 2007, long text can be broken down into many lines within a cell through _________. |
| A. | Click Wrap Text in Home tab |
| B. | Click arrange all in View tab |
| C. | Click Align in Page Layout tab |
| D. | None of the above |
| Answer» B. Click arrange all in View tab | |
| 25. |
In Excel "Qtr 1, Qtr 2, and Qtr 3" is an example of: |
| A. | Formula |
| B. | Function |
| C. | Series |
| D. | Syntax |
| Answer» D. Syntax | |
| 26. |
In MS Word 2007, the space left between the margin and the start of a paragraph is called _________ |
| A. | spacing |
| B. | Indentation |
| C. | gutter |
| D. | alignment |
| Answer» C. gutter | |
| 27. |
Microsoft Excel comes under the category of ________. |
| A. | Table sheets |
| B. | Calculation sheets |
| C. | Spreadsheets |
| D. | Word sheets |
| Answer» D. Word sheets | |
| 28. |
In Microsoft word 2007, bulleted list is available in which dialog box? |
| A. | Font |
| B. | Styles |
| C. | Paragraph |
| D. | Editing |
| Answer» D. Editing | |
| 29. |
_______ Reference change when a formula is copied to another cell in MS EXCEL. |
| A. | Static reference |
| B. | Relative reference |
| C. | Absolute Reference |
| D. | Anonymous reference |
| Answer» C. Absolute Reference | |
| 30. |
In MS-Excel, a workbook must contain at least _______ worksheet(s). |
| A. | five |
| B. | two |
| C. | one |
| D. | three |
| Answer» D. three | |
| 31. |
In MS Excel, the intersection of a row and a column is called a _________. |
| A. | square |
| B. | row |
| C. | cell |
| D. | worksheet |
| Answer» D. worksheet | |
| 32. |
In MS Word, 'Ctrl+S' key is used for: |
| A. | Scenarios |
| B. | Save |
| C. | Size |
| D. | Spell Check |
| Answer» C. Size | |
| 33. |
Assigning names to text or to positions in an MS Word document is called ________. |
| A. | Word Count |
| B. | Bookmark |
| C. | Named word |
| D. | Cross-reference |
| Answer» C. Named word | |
| 34. |
In Excel 2007, to protect a worksheet, you can choose Protection and the Protect Sheet from the _________ menu. |
| A. | Data |
| B. | View |
| C. | Review |
| D. | Formulas |
| Answer» D. Formulas | |
| 35. |
In MS Excel 2010, to insert a comment option we have to click the ________. |
| A. | View tab |
| B. | Design tab |
| C. | Formula tab |
| D. | Review tab |
| Answer» E. | |
| 36. |
How can the slide show be repeated continuously in MS - PPT? |
| A. | loop continuously until ‘Esc’ |
| B. | repeat continuously |
| C. | loop more |
| D. | One by one |
| E. | None |
| Answer» B. repeat continuously | |
| 37. |
______ clicking on mouse selects the entire paragraph by default, while working with text document in MS Word. |
| A. | Alt + Single |
| B. | Triple |
| C. | Double |
| D. | Single |
| Answer» C. Double | |
| 38. |
In MS Excel 2010, electronic spreadsheet as a large piece of paper is divided into: |
| A. | Multiple boxes |
| B. | Rows and Columns |
| C. | Lines and Rows |
| D. | Lines and Columns |
| Answer» C. Lines and Rows | |
| 39. |
In MS Word 2010, ______ sheet has its length and breadth as 21cm x 29.7 cm. |
| A. | A6 |
| B. | A5 |
| C. | A4 |
| D. | A3 |
| Answer» D. A3 | |
| 40. |
In MS Word 2010, How many types of ‘Page Borders’ are present? |
| A. | 4 |
| B. | 3 |
| C. | 6 |
| D. | 5 |
| Answer» E. | |
| 41. |
In cut-paste operation of MS-Word |
| A. | A text can be cut, and paste exactly once |
| B. | A text can be cut, and paste multiple times |
| C. | A text can’t be cut if a background color is set |
| D. | A text can’t be cut if its length is more than 128 characters |
| E. | A text can’t be cut if its length is more than 256 characters |
| Answer» C. A text can’t be cut if a background color is set | |
| 42. |
In MS-Word, how many ways you can save a document? |
| A. | 3 |
| B. | 4 |
| C. | 6 |
| D. | 5 |
| Answer» B. 4 | |
| 43. |
MS Excel is used for: |
| A. | Documents |
| B. | Presentation |
| C. | Spreadsheets |
| D. | Sending message |
| Answer» D. Sending message | |
| 44. |
How many types of ‘Section Break’ are there in MS Word 2010? |
| A. | 4 |
| B. | 3 |
| C. | 6 |
| D. | 5 |
| Answer» B. 3 | |
| 45. |
In MS Excel 2007, “Term 1, Term 2, Term 3” is an example of a ______. |
| A. | Function |
| B. | Series |
| C. | Syntax |
| D. | Formula |
| Answer» C. Syntax | |
| 46. |
In MS Excel, a ________ is identified by the cell in the upper-left corner and the cell in the lower-right corner, separated by a colon. |
| A. | worksheet |
| B. | value |
| C. | cell reference |
| D. | range |
| Answer» E. | |
| 47. |
In MS Excel 2007, which of the cell pointer indicates you that you can make selection? |
| A. | Doctor's symbol (Big plus) |
| B. | Small thin plus icon |
| C. | Mouse Pointer with anchor at the tip |
| D. | None of above |
| Answer» B. Small thin plus icon | |
| 48. |
In MS 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 |
| D. | Changing the font size of your document |
| Answer» C. Using the Insert / Section Break | |
| 49. |
In MS-Word, which of the following options allows you to combine (or combine) two or more cells in a table? |
| A. | Distributed Rows |
| B. | Eraser |
| C. | Split Table |
| D. | Merge Cells |
| Answer» E. | |
| 50. |
Consider a formula "= A3 + B4" in cell A5. If cell A5 is copied and pasted into E9, then what will be the formula in cell E9? |
| A. | |
| B. | |
| C. | |
| D. | |
| Answer» D. | |