Computer Science MCQS

Correct answer: Word Wrap. Word wrap automatically continues text on the next line at the margin.

• Line Break: A line break is inserted manually.
• Justify: Justify spaces text to align both margins.
• Align: Align positions text left, right, or centre.

Correct answer: Count cells containing numbers. COUNT counts the cells in a range that contain numbers.

• Sum cells: SUM adds the values.
• Find average: AVERAGE finds the mean.
• Find maximum: MAX finds the maximum.

Correct answer: LAN. A LAN (Local Area Network) covers a small area such as a room, building, or campus.

• WAN: A WAN covers large areas such as countries.
• MAN: A MAN covers a city.
• PAN: A PAN covers a person’s immediate surroundings (a few metres).

Correct answer: COUNT. COUNT counts only cells that contain numbers.

• COUNTA: COUNTA counts all non-empty cells, including text.
• COUNTBLANK: COUNTBLANK counts empty cells.
• COUNTIF: COUNTIF counts cells that meet a condition.

Correct answer: F5. F5 starts the slideshow from the first slide.

• F4: F4 repeats the last action.
• F7: F7 starts the spelling check.
• Ctrl+F5: Ctrl + F5 is not the standard key to start the slideshow from the beginning.

Correct answer: NOW(). NOW() returns the current date and time.

• DATE(): DATE() builds a date from year, month, and day values.
• TIME(): TIME() builds a time from hour, minute, and second values.
• TODAY(): TODAY() returns only the current date.

Correct answer: Print Preview. Print Preview shows how the document will look on paper before printing.

• Save: Save stores the file and does not show print output.
• Page Setup: Page Setup sets margins and size but does not show the final result.
• Print Properties: Print Properties are printer-specific settings.

Correct answer: Over the internet. Cloud computing provides data and services over the internet.

• On hard disk: A hard disk is local storage.
• On pen drive: A pen drive is local, portable storage.
• On CD: A CD is local, physical storage.

Correct answer: Mesh. In a full mesh every computer connects to every other, which requires n(n − 1)/2 = 300 links for 25 computers.

• Star: A star needs one link per computer (25) to a central hub.
• Bus: A bus uses one shared backbone cable.
• Ring: A ring needs about one link per computer (25).

Correct answer: To summarize and analyze data. A pivot table summarizes and analyzes large amounts of data interactively.

• Print data: Printing is done with the Print command.
• Sort data: Sorting is done with the Sort command.
• Filter data: Filtering is done with the Filter command.

Correct answer: Application Software. Application software is designed to help users perform specific tasks such as writing, calculating, or browsing.

• System Software: System software runs and manages the hardware.
• Utility Software: Utility software maintains and optimises the computer.
• Programming Software: Programming software is used by programmers to write programs.

Correct answer: Vint Cerf. Vint Cerf and Bob Kahn designed the TCP/IP protocols in the 1970s.

• Bill Gates: Bill Gates co-founded Microsoft.
• Charles Babbage: Charles Babbage designed the Difference Engine.
• Steve Jobs: Steve Jobs co-founded Apple.

Correct answer: Computer Hardware. The operating system controls and manages computer hardware and provides services for applications.

• Applications Software: It supports applications, but its core job is managing hardware.
• Personal Software: “Personal software” is not a standard term in this context.
• None of these: “None of these” is incorrect because computer hardware is correct.

Correct answer: Being able to work for hours without fatigue. Diligence means a computer can work for long hours without tiredness or loss of accuracy.

• Ability to do multiple things at once: Doing multiple things at once is multitasking.
• Works fast: Working fast is speed.
• None of these: “None of these” is incorrect because working without fatigue is correct.

Correct answer: To open Task Manager. Ctrl + Shift + Esc opens Task Manager directly in Windows.

• Shutdown: Shutdown is done from the Start menu or power options.
• Restart: Restart is done from the Start menu or power options.
• Log Off: Log Off is done from the Start menu or Ctrl + Alt + Delete screen.

Correct answer: Multiprocessor. A multiprocessor system uses two or more processors.

• Multitasking: Multitasking is running several tasks at the same time.
• Multiprogramming: Multiprogramming keeps several programs in memory so the CPU stays busy.
• Multiusers: Multiusers means several people using the system.

Correct answer: Multitasking. Multitasking is when an operating system runs more than one task at the same time.

• Multiprocessing: Multiprocessing means using more than one processor.
• Batch Processing: Batch processing runs a group of jobs without user interaction.
• Time Sharing: Time sharing lets several users share the CPU in turns.

Correct answer: CPU. The CPU fetches, decodes, and executes instructions.

• ALU: The ALU only performs arithmetic and logic operations inside the CPU.
• Hard Disk: A hard disk stores data.
• Software: Software is a set of instructions, not the part that executes them.

Correct answer: Machine & Assembly. Machine language and assembly language are low-level languages.

• C++, Java: C++ and Java are high-level languages.
• Python: Python is a high-level language.
• BASIC: BASIC is a high-level language.

Correct answer: Facebook. Facebook is a social media platform.

• MS Word: MS Word is word-processing software.
• Chrome: Chrome is a web browser.
• Excel: Excel is spreadsheet software.

Correct answer: Machine language. Machine language, made up of binary code, is the only language a computer executes directly.

• Assembly language: Assembly language must be translated by an assembler.
• High Level language: High-level languages must be translated by a compiler or interpreter.
• Binary language: “Binary language” is not the standard term; the standard term is machine language.

Correct answer: GUI. A GUI (Graphical User Interface) lets users interact using windows, icons, menus, and buttons.

• OS: An operating system manages the computer and may offer a graphical or a command-line interface.
• MacOS: MacOS is a specific operating system that uses a GUI, not the type of interface itself.
• All of the above: “All of the above” is incorrect because GUI is the only option that names a type of interface.

Correct answer: Spelling error correction. AutoCorrect automatically fixes common spelling and typing errors as you type.

• Format text: Formatting is done with the formatting tools.
• To create a table: Tables are inserted from the Insert tab.
• To print a document: Printing is done with the Print command.

Correct answer: 4.7 GB. A standard single-layer DVD-ROM holds 4.7 GB.

• 700 MB: 700 MB is the capacity of a CD-ROM.
• 1.44 MB: 1.44 MB is the capacity of a floppy disk.
• 25 GB: 25 GB is the capacity of a single-layer Blu-ray disc.

Correct answer: $. The dollar sign ($) fixes the row or column of a cell reference, such as $A$1.

• #: # appears in error values such as #REF!.
• @: @ is used in e-mail addresses and some references, but not absolute references.
• &: & joins text in a formula.