All Free Computer Science and IT MCQs with Answers

451. The capacity of 3.5 inch floppy disk was__________?

• A. 1.40 MB
• B. 1.44 GB
• C. 1.40 GB
• D. 1.44 MB

Explanation: The common 3.5-inch high-density floppy disk stored 1.44 MB, not GB. The GB choices are far too large for floppy-disk capacity.

452. What is a light pen?

• A. A Mechanical Input device
• B. Optical input device
• C. Electronic input device
• D. Optical output device

Explanation: A light pen detects light from a screen and sends position information to the computer, making it an optical input device. It is not an output device because it does not display or produce information.

453. Which of the following controls the process of interaction between the user and the operating system?

• A. User interface
• B. Language translator
• C. Platform
• D. Screen saver

Explanation: The user interface controls how a person gives commands to and receives responses from the operating system. A language translator converts programs, a platform provides the operating environment, and a screen saver is only a display utility.

454. A CPU contains___________?

• A. a card reader and a printing device
• B. an analytical engine and a control unit
• C. a control unit and an arithmetic logic unit
• D. an arithmetic logic unit and a card reader

Explanation: The basic functional CPU contains the Control Unit, which directs operations, and the Arithmetic Logic Unit, which performs calculations and comparisons. Card readers and printing devices are input or output peripherals.

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

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

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

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

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

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