Free MS Office MCQs with Answers

• A. Copy
• B. Cut
• C. Paste
• D. Undo

Explanation: Ctrl + V pastes the clipboard contents. Ctrl + C copies, Ctrl + X cuts and Ctrl + Z undoes — this cluster of four shortcuts is standard in…

• A. Defined Names
• B. Create from Selection
• C. Formulas Bar
• D. Name Manager

Explanation: Defined Names let users assign meaningful names to cells or ranges and use those names in formulas instead of cell references.

• A. Cell Range
• B. Workbook
• C. Margin
• D. None of these

Explanation: A range is a group of one or more cells identified by references such as A1:C5.

• A. Goal seek
• B. Solver
• C. Scenario Manager
• D. All of above

Explanation: Goal Seek, Solver and Scenario Manager are all Excel What-If Analysis tools.

• A. First page
• B. Document
• C. Cover Page
• D. None of these

Explanation: A cover page is designed to appear as the opening page of a document and commonly contains its title and author details.

• A. Lines and spaces
• B. Layers and planes
• C. Rows and columns
• D. Height and width

Explanation: A spreadsheet arranges data in horizontal rows and vertical columns, with each intersection forming a cell.

• A. Cell
• B. Graph
• C. Function
• D. Range

Explanation: A function is a predefined formula, such as SUM, AVERAGE or IF, that performs a particular calculation.

• A. To paint pretty pictures on your slides
• B. To copy formatting from one object or piece of text and then apply it elsewhere
• C. To change the background color of your slides
• D. To paint pretty pictures on background of slides

Explanation: Format Painter copies formatting such as font, colour, size and effects from one object or text selection to another.

• A. Columns
• B. rows
• C. numbers
• D. reference

Explanation: Excel labels columns with letters such as A, B and C, while rows are labelled with numbers. A cell reference combines both, such as B4.

• A. To Select All Text
• B. To copy
• C. To paste
• D. None

Explanation: Ctrl+A selects all content in the active context, such as all text in a document or all cells in a worksheet region.

• A. CTRL + T
• B. CTRL + U
• C. CTRL + Z
• D. CTRL + B

Explanation: Ctrl+U applies or removes underlining in common word-processing applications. Ctrl+B applies bold, while Ctrl+Z undoes the last action.

• A. F1
• B. F2
• C. F5
• D. F7

Explanation: F7 opens the spelling and grammar check in Microsoft Word. F1 opens Help, F2 is used for editing or renaming in several contexts, and F5…

• A. Go to the Ribbon > Insert tab
• B. Go to the Bar > Insert tab
• C. Both
• D. None

Explanation: In Word, Drop Cap is accessed from the Insert tab, usually through the Text group.

• A. Ctrl+M
• B. Ctrl+N
• C. Ctrl+P
• D. None of these

Explanation: Ctrl+P opens the Print command in most document and office applications.

• A. Margin that is added to the left margin when printing
• B. Margin that is added to right margin when printing
• C. Margin that is added to the binding side of page when printing
• D. Margin that is added to the outside of the page when printing

Explanation: A gutter is extra space added on the binding side of a printed page so that binding does not cover the text.

• A. Date()
• B. Year()
• C. Now()
• D. Time()

Explanation: NOW() returns both the current date and current time in Excel. DATE() constructs a date, while TIME() constructs a time without the…

• A. F10
• B. F12
• C. F11
• D. None

Explanation: In classic desktop Excel, F11 creates a chart on a separate chart sheet, while Alt+F1 creates a chart within the current worksheet.

• A. UNIX
• B. DOS
• C. WINDOWS
• D. OS/2

Explanation: Microsoft Excel is a Windows application in the context of this traditional classification, although modern Excel also runs on macOS…

• A. Winword.exe
• B. Word.exe
• C. Word2003.exe
• D. Msword.exe

Explanation: Winword.exe is the executable program used to launch Microsoft Word in traditional Windows installations.

• A. Ctrl + Shift + <
• B. Ctrl + Shift + v
• C. Ctrl + Alt + >
• D. CTRL + [

Explanation: Ctrl+[ decreases the selected font size by one point in Microsoft Word.