Free MS Office MCQs with Answers

211. How we can view a cell comment ?

• A. position the mouse pointer over the cell
• B. click the comment command on the view menu
• C. click the edit comment commands on the Insert menu
• D. click the Display comment command on the window menu

Explanation: In classic Excel, placing the mouse pointer over a cell with a comment displays its comment indicator or note. The other choices refer to commands that are not the standard way to view it.

212. Which of these will not select all the cells in a document ?

• A. Using the Edit - Select All menu
• B. Pressing Ctrl + A on the keyboard
• C. Clicking three times with the right mouse button in the spreadsheet
• D. None of These

Explanation: Edit > Select All and Ctrl+A are recognised selection commands, whereas clicking three times with the right mouse button does not select every spreadsheet cell. Right-clicking normally opens a shortcut menu.

213. When you insert a comment in a document, the comment appears in a___________?

• A. New window
• B. Sidebar
• C. sticky note icon bar
• D. Balloon

Explanation: In word-processing applications such as Microsoft Word, comments are commonly displayed in balloons in the document margin. A comment is therefore not normally inserted into a separate window.

214. In a computer spreadsheet rows are labeled ________ ?

• A. by letters
• B. by numbers
• C. by cell references
• D. by symbols

Explanation: Spreadsheet rows are labeled with numbers, while columns are labeled with letters. A cell reference identifies the intersection of a row and a column.

215. Basic unit of a computer worksheet in which you enter text and numbers is known as __________ ?

• A. workbook
• B. column
• C. row
• D. cell

Explanation: A cell is the basic worksheet unit formed by the intersection of a row and a column, and it is where text or numbers are entered. A workbook contains one or more worksheets.

216. In microsoft Window 7, __________ can give you information about weather?

• A. File
• B. Gadgets
• C. Window explorer
• D. Both A and B

Explanation: Windows 7 Gadgets could display small information panels such as weather, news, and clocks on the desktop. File and Windows Explorer do not provide this gadget function.

217. Computer spreadsheet cell that is highlighted with a heavy border is a _________ ?

• A. Active cell
• B. Cell containing a formula
• C. Locked cell
• D. Cell

Explanation: The active cell is the currently selected cell, usually shown by a heavy border. A formula, locked status, or ordinary cell content does not determine that border.

218. In a computer spreadsheet, which is true if current or active cell is B4 and you pressed Enter key?

• A. you will be in the cell A1
• B. you will be in the cell B5
• C. you will be in the cell B3
• D. you will be in the cell B6Science

Explanation: In a spreadsheet, pressing Enter normally moves the selection one cell downward in the same column. From B4, the next active cell is B5.

219. Following combination of keys is used to maximize or restore a selected window:

• A. CTRL+F1
• B. CTRL+F5
• C. CTRL+F10
• D. CTRL+F12

Explanation: Ctrl+F10 toggles the active Microsoft Office document window between maximized and restored states. The other listed Ctrl+F keys do not perform this window command.

220. Which of the following format you can decide to apply or not in AutoFormat dialog box?

• A. Number format
• B. Border format
• C. Font format
• D. All of above

Explanation: AutoFormat can apply or omit several formatting categories, including number, border, and font formats. Therefore, all three listed formats can be selected.