General Technology and Computing Quiz

An Algorithm is a step-by-step sequential process that a computer follows to perform computations or solve problems. Logarithm is a mathematical function, Boolean Algebra deals with logical operations, and Syntax refers to language structure rules. Only Algorithm correctly describes a computational procedure.

Opening email attachments or messages from unknown sources is historically the most common way viruses infect computers. Email remains a primary vector for malware distribution. Installing games from CDs, uploading pictures from phones, or sending emails are not significant virus transmission methods compared to email-based attacks.

IBM's Deep Blue made history in 1997 when it defeated reigning world chess champion Garry Kasparov in a six-game match. This was the first time a computer defeated a world champion in a standard match. Colossus was a WWII code-breaking computer, Solaris is an operating system, and Samsung is an electronics company.

WYSIWYG is an acronym for 'What You See Is What You Get' - a principle where the display on screen accurately represents the final output. Options A, B, and C incorrectly use variations like 'Saw/Generated' which are not part of the standard acronym. This concept is fundamental in word processors and page layout software.

Hotmail was co-founded by Sabeer Bhatia and Jack Smith in 1996, then sold to Microsoft in 1997 for approximately $400 million. The options list three incorrect names (Genica Garvida, Hans Antolin, Alan Turing) with 'none of the above' marked correct, which is accurate since the actual founders are not listed.

UPS stands for Uninterruptible Power Supply (note: standard spelling is 'Uninterruptible', not 'Unitterrupted'). A UPS provides emergency power to connected equipment when main power fails, using batteries. The correct option A has a spelling error but is conceptually right. Option C 'unieke' appears to be a misspelling of 'unique'.

C is considered a middle-level language because it combines high-level language features (structured programming, abstractions) with low-level capabilities (direct memory manipulation, bit-level operations, pointer arithmetic). Java is purely high-level with extensive abstraction. Oracle is a database management system, not a language. .NET is a framework, not a language.

USB stands for Universal Serial Bus, a standard for connecting peripherals to computers. Options A and B incorrectly use 'Super' or 'Bit' instead of 'Serial'. USB supports both data transfer and power delivery, making it a versatile interface for devices like drives, keyboards, and cameras.

Volatile memory requires continuous power to maintain data. When power is lost, all data is erased. RAM (Random Access Memory) is the primary example of volatile memory used as main memory in computers. Hard disk, ROM, and Pendrive (flash storage) are all non-volatile - they retain data without power.

To activate the text to speech feature in Excel 2002 for English (U.S), Chinese, or Japanese, you need to follow these steps:

A. Point to Speech on the Tools menu, and then click Show Text To Speech Toolbar

Option A is correct. You need to point to Speech on the Tools menu, and then click Show Text To Speech Toolbar to activate the feature in Excel 2002. This toolbar contains the buttons you need to control the text-to-speech functionality.

Option B is incorrect. Clicking on Validation on the Data menu opens the Data Validation dialog box, which allows you to define validation rules for data entered into a cell.

Option C is incorrect. Speech Recognition is a different feature that converts spoken words into text. It does not activate the text-to-speech functionality.

Option D is incorrect. The correct option is A.

To paste only the value result of a formula (not the formula itself), use Paste Special > Values. In Excel 2002, you click the arrow on the Paste button to access special paste options, then select 'Values.' Option A performs a normal paste including the formula, Option B pastes formulas, and Option D is incorrect because the correct answer exists.

Auto-fitting column width in Excel is done by double-clicking the boundary to the right of the column heading. This automatically adjusts the width to fit the widest cell content. Single-clicking (Option A) allows manual dragging but doesn't auto-fit, and Option C describes incorrect keyboard behavior.

Microsoft Excel historically featured the Office Assistant (e.g., Clippy the paperclip) as an interactive help system that answered questions and provided tips. Options A, B, and C are nonsensical distractors; hitting your computer, using the power switch, or closing Excel are not help features.

CTRL+; is the Excel keyboard shortcut that inserts the current date into the active cell. This is a static date value that doesn't update automatically. CTRL+SHIFT+: inserts the current time, not the date.

Excel is Microsoft's spreadsheet application, designed specifically for creating and managing spreadsheets with calculations and data analysis. Word creates documents, Access manages databases, and PowerPoint creates presentations.