Free MS Office MCQs with Answers

1. In most applications, what does the keyboard shortcut Ctrl + V do?

• 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 clerical and data entry papers.

2. Which function allows to define names/text in formulas except the use of selection in MS Excel?

• 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. Name Manager manages existing names, while Create from Selection generates names from nearby labels.

3. What is a group of cells called in Excel?

• 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 workbook is the whole Excel file, not merely a group of cells.

4. In Excel, which is used to perform what if analysis?

• 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. Goal Seek changes one input, Solver handles constrained optimisation, and Scenario Manager compares sets of values.

5. The first page of document is ___________?

• 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. Strictly speaking, not every document has a cover page, but it is the intended answer among these options.

6. How are data organized in a spreadsheet ?

• 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. Lines and spaces do not describe its standard data structure.

7. Another name for a pre programmed formula in excel is ___________?

• 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 cell or range stores or identifies data, while a graph displays it.

8. Format painter in PowerPoint?

• 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. It does not create drawings or change a slide's background.

9. Letters in Excel denote: ______________?

• 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.

10. Short cut key ctrl + A use for __________?

• 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. Ctrl+C and Ctrl+V are the copy and paste shortcuts respectively.