All Free Computer Science and IT MCQs with Answers

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

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

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

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

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

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

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

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

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

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