Free MS Office MCQs with Answers

221. Main window in a computer spreadsheet is called ___________ ?

• A. Work book
• B. Work
• C. Account book
• D. Work sheet

Explanation: An Excel workbook is the main spreadsheet file and can contain one or more worksheets. A worksheet is only an individual sheet within that workbook.

222. Which of the following will not enter data in a cell?

• A. Pressing the Esc key
• B. Pressing the Tab Key
• C. Both of these
• D. None of above

Explanation: Esc cancels the current cell entry, so it does not enter the typed data. Tab confirms the entry and moves to the next cell.

223. In a computer spreadsheet, cell range A3 through G3 should be keyed in as _________ ?

• A. A3-G3
• B. A3:G3
• C. A3?.G3
• D. A3 to G3Word Processing Software

Explanation: A colon denotes a continuous cell range in spreadsheet notation. Thus, A3:G3 includes every cell from A3 through G3.

224. In a computer spreadsheet, each cell contain a __________ ?

• A. label
• B. Value
• C. Formula
• D. All of these

Explanation: A spreadsheet cell may contain text such as a label, a constant value, or a formula that calculates a result. Hence all the listed contents are possible.

225. Actual working area of Computer's Microsoft Excel is ________ ?

• A. Workbook
• B. Worksheet
• C. Notesheet
• D. Notebook

Explanation: The worksheet is Excel's actual grid-based working area where data is entered and manipulated. A workbook is the file that contains one or more worksheets.

226. In a computer spreadsheet, first part of number format describes __________ ?

• A. Positive number
• B. Negative number
• C. Zero values
• D. Text values

Explanation: In Excel's four-section number format, the sections normally describe positive numbers, negative numbers, zero values, and text in that order. The first section therefore controls positive numbers.

227. In a computer, element which is not a part of chart is ___________ ?

• A. Plot area
• B. Fill handler
• C. Series
• D. Chart area

Explanation: Plot area, data series, and chart area are standard chart components. A fill handle is a spreadsheet feature used for copying or extending cell data, not a chart element.

228. A "Ctrl + Enter" command will __________ ?

• A. Open a new document
• B. Create a new page
• C. Create a new Paragraph
• D. Create a new line

Explanation: In Microsoft Word, Ctrl+Enter inserts a page break and moves the following content to a new page. It does not merely create a paragraph or ordinary line break.

229. The protect document option can be found in the _______ tab of the Ribbon ?

• A. Review
• B. Insert
• C. References
• D. Edit

Explanation: In Word 2007, document protection controls are found on the Review tab, under Protect Document. Insert and References contain tools for adding content and citations instead.

230. Which function you will use to add names and addresses of different recipient for each copy of the letter?

• A. Envelopes
• B. Labels
• C. Mail Merge
• D. Drop Cap

Explanation: Mail Merge combines a standard letter with a recipient data source so each copy can receive a different name and address. Envelopes and Labels format outputs, but do not perform this personalized-document process by themselves.