Microsoft Office Certification mcqs

•Microsoft Office Certification MCQs•

MS Word MS Excel MS Power Point Certification MCQs

Microsoft office certification mcqs

Q. What is the name of the first screen you see when Windows 8 is launched?

1. a) screen saver
2. b) desktop
3. c) Windows Start screen
4. d) Word screen

Answer: c

Q. Create a Microsoft account profile to gain access to __________ GB of free Cloud storage space.

1. a) 1
2. b) 3
3. c) 5
4. d) 7

Answer: d

Q. When you place your cursor over the insertion point, to what shape does it change?

1. a) dash
2. b) I-beam
3. c) box
4. d) underscore

Answer: b

Q. The Ribbon contains multiple __________ with common commands grouped on each.

1. a) icons
2. b) dialog boxes
3. c) buttons
4. d) tabs

Answer: d

Q. You cannot seem to locate a specific command while formatting text using commands in the Font group on the Home tab. Where can you find the dialog box launcher, which is necessary to display the dialog box with all commands?

1. a) upper left
2. b) lower left
3. c) upper right
4. d) lower right

Answer: d

Q.  You want to reduce clutter on the screen and hide the Ribbon. Which keyboard shortcut toggles between hide and unhide?

1. a) Ctrl + F1
2. b) Ctrl + F3
3. c) Alt + F1
4. d) Alt + F3

Answer: a

Q.  What displays when you point to selected text, allowing you access to popular commands?

1. a) drop-down menu
2. b) Mini toolbar
3. c) shortcut menu
4. d) dialog box

Answer: b

Q. What displays when you right-click on selected text?

1. a) drop-down menu
2. b) Mini toolbar
3. c) shortcut menu
4. d) dialog box

Answer: c

MS Word Tool Bar

Q. In order to save time searching for common commands, you can add tools to which toolbar located above the Ribbon?

1. a) Menu Toolbar
2. b) Word Toolbar
3. c) Shortcut Toolbar
4. d) Quick Access Toolbar

Answer: d

Q.  Which dialog box opens when you click the Save button on the Quick Access Toolbar with a new document displayed?

1. a) Save As
2. b) Save
3. c) New
4. d) Convert

Answer: a

Q. Which button on the Quick Access Toolbar can you use to cancel your last command or action?

1. a) Redo
2. b) Undo
3. c) Delete
4. d) Cancel

Answer: b

Q. Which button on the Quick Access Toolbar repeats your last action?

1. a) Redo
2. b) Undo
3. c) Delete
4. d) Cancel

Answer: a

Q. Which keyboard shortcut replaces the need for the Undo command on the Quick Access Toolbar?

1. a) Ctrl + A
2. b) Ctrl + U
3. c) Ctrl + W
4. d) Ctrl + Z

Answer: d

Q. Which tab displays Backstage view?

1. a) Home
2. b) File
3. c) View
4. d) Page Layout

Answer: b

Q. Which of the following options are available in the Print group on Backstage?

1. a) Choose number of copies
2. b) Choose default printer
3. c) Set printer properties
4. d) Preview document
5. e) Save as PDF

Answer: a,b,c,d

MS Word Help

Q. Where is the Word Help button located?

1. a) in the upper-left corner of the screen
2. b) in the upper-right corner of the screen
3. c) on the Ribbon
4. d) in the lower-right corner of the screen

Answer: b

Q. You are having trouble lining up columns of information. In order to troubleshoot hidden formatting commands, what do you display?

1. a) hidden characters
2. b) invisible characters
3. c) nonprinting characters
4. d) back characters

Answer: c

Q. What Word feature reduces the amount of time spent typing common content or phrases in a document?

1. a) AutoComplete
2. b) Auto Insert
3. c) Insert
4. d) AutoFill

Answer: a

Q. Which of the following best describes the Block Style letter format used in professional correspondence?

1. a) has open or mixed punctuation and is right-aligned
2. b) has open or mixed punctuation and is left-aligned
3. c) has no punctuation and is right-aligned
4. d) has punctuation after salutation and is left-aligned

Answer: b

Q. Auto Recover automatically saves your data at scheduled intervals. What is the default interval?

1. a) 2 minutes
2. b) 5 minutes
3. c) 10 minutes
4. d) 20 minutes

Answer: c

Q. Which of the following Word options are available when saving the document as a different file type?

1. a) Word template
2. b) web page
3. c) Rich Text Format
4. d) PDF
5. e) XLS

Answer: a,b,c,d

Microsoft Excel 

Q. Order to insert a table, what is the proper sequence?

1. a) Insert > Slides > New Slides
2. b) Insert > Tables > Table
3. c) Insert > Illustrations > Shapes
4. d) View > Show Ruler

Answer: b

Q. Which of the following actions allows you to resize the table without using the tabs?

1. a) Drag the corners of the table’s frame.
2. b) Right-click the table and select Split Cell from the shortcut menu.
3. c) Right-click the table and select Format Shape from the shortcut menu.
4. d) Right-click the slide and select Format Background from the shortcut menu.

Answer: a

Q. Which of the following choices is preferable when drawing a table instead of inserting a table from the Insert tab?

1. a) Create a table with a different number of columns or rows in a different location.
2. b) Create rows and columns of equal size.
3. c) Split rows and columns.
4. d) There is no difference between the two.

Answer: a

Q.  In order to insert or embed an Excel worksheet, which of the following is the proper sequence?

1. a) Design > Customize > Format Background
2. b) Insert > Illustrations > Chart
3. c) Insert > Links > Action
4. d) Insert > Tables > Table > Excel Spreadsheet

Answer: d

Q. When the worksheet is ready to edit in Excel, what type of border is displayed around the worksheet?

1. a) yellow-lined border
2. b) heavy hatched border
3. c) dashed lined border
4. d) single-lined border

Answer: b

Microsoft Office Word

Q. In which Word Options menu can you open the Customize Keyboard dialog box to set custom shortcut commands?

1. a) General
2. b) Proofing
3. c) Customize Ribbon
4. d) Quick Access Toolbar

Answer: c

Q. In order to change the number of Recent Documents from 25 to 15, you would access Backstage, Word Options, and then which of the following?

1. a) Advanced, Show this number of Recent Documents
2. b) Proofing, Show this number of Recent Documents
3. c) Save, Show this number of Recent Documents
4. d) General, Show this number of Recent Documents

Answer: a

Q. In order to have Word notify you before modifying the new document template, you would access Backstage, Word Options, and then which of the following?

1. a) General, Prompt before saving Normal template
2. b) Save, Prompt before saving Normal template
3. c) Advanced, Prompt before saving Normal template
4. d) Proofing, Prompt before saving Normal template

Answer: a

Q. Removing a check mark from the Auto Format As You Type options does which of the following?

1. a) turns the feature on
2. b) does not change the status
3. c) turns the feature off
4. d) duplicates the function

Answer: c

Q. Which category in Word Options allows you to add your name and initials automatically to all Word documents you create?

1. a) General
2. b) Display
3. c) Customize Ribbon
4. d) Add-Ins

Answer: a

Q. Which option provides an opportunity to print only specific pages or selections of the open document?

1. a) Settings
2. b) Printer
3. c) Copies
4. d) Zoom Slider

Answer: a

Read Also:

Microsoft New Top Browser