Computer Basics

Java is a programming language that was specifically designed with applets in mind - small programs that run within web browsers. The 'write once, run anywhere' philosophy of Java made it ideal for creating downloadable applets that could execute on any platform with a Java Virtual Machine. While applets are now deprecated, Java was historically the primary language for applet development. Options like Cable, Domain name, Net, and COBOL are not programming languages used for creating applets.

In Microsoft Excel, a cell is the basic unit of the spreadsheet worksheet where data is entered. Each cell can be identified by its column letter and row number (like A1, B2, etc.). Worksheets consist of rows and columns that form these cells. Options like 'tab' (which refers to worksheet tabs), 'box' (not a standard Excel term), and 'range' (which refers to a group of cells) are incorrect.

The system unit (also called the computer case or tower) is the container or enclosure that houses the main electronic components of a computer, including the motherboard, processor, memory, and power supply. It coordinates and connects all the internal hardware but doesn't directly control input/output devices, manipulate data (that's the CPU's job), or perform arithmetic operations (also the CPU). Note: There's a typo in option B where 'contain' should read 'container.'

To reload or refresh a web page in a browser, you click the Refresh button (or press F5). This causes the browser to fetch the current page from the server again, updating any content that may have changed. Options like Redo (for undoing an undo action), Reload (the action, not the button name), Restore (for windows or minimized applications), and Ctrl (a modifier key used in keyboard shortcuts) are incorrect.

Ctrl+Enter is the standard keyboard shortcut to force a page break at the cursor position in Microsoft Word. The F1 key opens help documentation, Insert/Section Break creates section boundaries rather than simple page breaks, and changing font size has no effect on page breaks.

The processor (CPU) is the component that actually executes program instructions by fetching, decoding, and running them. The scanner is an input device, main storage holds data temporarily, secondary storage stores data long-term, and the printer is an output device.

The Home key moves the insertion point to the first cell of the current row in Excel. Page Up and Page Down scroll through the worksheet by pages, Tab moves to the next cell to the right, and None of these is incorrect.

The booting process performs the Power-On Self-Test (POST) which checks hardware components when the computer starts up. An integrity test is not a standard boot process term, correct functioning test is vague, reliability test is not part of booting, and shut down test happens when turning off.

In Microsoft Excel, individual files created and saved are known as workbooks, which can contain multiple worksheets.

High-level languages are designed to be similar to human languages and easy for humans to read and write. Source code is code written in any language, Machine Language is binary (0s and 1s), Object Code is compiled machine code, and Assembly Language is low-level but still uses mnemonics.

A page has four margins: top, bottom, left, and right. Headers and footers are areas within the top/bottom margins, not margins themselves. Landscape and portrait are page orientations, not margins, and there are definitely more than two margins.

To create vertical column data in Word, you should use the Tab key or the Table menu to create a table structure. Pressing Tab alone just moves the cursor, Excel is a different application, and Spacebar creates horizontal spacing, not vertical columns.

Cut and Paste is the correct method to move a paragraph from one place to another. Copy and Paste leaves the original in place, Delete and Retype is inefficient, and Find and Replace is for changing text content, not moving it.

A cookie is a small text file that stores information about a user's web activity and preferences. Cookies do not store software developed by users, passwords (that would be a security risk), or commands used by the user.

A computer programmer does the logical thinking and problem-solving for computers by writing instructions. Entering input data quickly is data entry, operating equipment is technical support, drawing flowcharts is just one part of programming, and programmers are very useful.

Memory (RAM) is volatile and loses its contents when the computer turns off. Storage (hard drive, SSD) retains data, Input is data entering the system, Output is results leaving the system, and None of these is incorrect.

Double-clicking a word selects it in most text editing and word processing software. A single click places the cursor, while triple-clicking typically selects the entire line or sentence.

A website is a collection of related web pages that are grouped together under a domain name. Graphics, programs, and charts may be components of web pages, but they don't define what a website is.

Functions in Excel are pre-built formulas that simplify complex calculations. For example, SUM() adds values and AVERAGE() calculates the mean without requiring you to write the mathematical formulas manually.

Booting is the process of loading and initializing the operating system when a computer is powered on. Without an operating system, the computer cannot start up properly or run any programs.

The CPU (Central Processing Unit) is a physical hardware component that processes instructions. Excel, printer driver, operating system, and PowerPoint are all software programs that run on hardware.

E-commerce refers to buying and selling goods over the internet. The term combines electronic and commerce, describing commercial transactions conducted online through websites and applications.

An assembler is specifically designed to translate assembly language instructions into machine code. It cannot translate C programs, which require a C compiler. This statement correctly identifies what an assembler cannot do.

Indenting a paragraph shifts the text inward from the left margin without changing the actual margin settings. It creates space between the margin and where the text begins, commonly used to emphasize quotations or create hierarchical structure.

The ALU (Arithmetic Logic Unit) is the component within the CPU that performs mathematical calculations and logical operations. While the CPU contains the ALU, the ALU is specifically responsible for arithmetic computations.

Option (2) is correct. 

Downloading refers to receiving data from a remote server, typically from the internet, to your local computer. Uploading is the opposite (sending data), while gathering and inputting are generic terms not specific to internet data transfer.

Option (2) is correct. 

Justify alignment adjusts text spacing so both left and right edges are aligned evenly with the margins. This creates clean, professional-looking blocks of text commonly used in newspapers and formal documents.

The machine cycle (or instruction cycle) consists of the fetch phase (retrieving the instruction) followed by the execution phase (performing the instruction). This cycle repeats continuously as the computer processes programs.

To delete a sentence, you first select it by highlighting, then use the delete command. 'Cut and paste' moves content elsewhere, while 'copy and paste' duplicates it.

A monitor is an output device that displays information visually, not a storage medium. Hard disks, flash drives, DVDs, and CDs all store data permanently or temporarily.

To format text with bold, italics, or other styling in email, you need Rich Text format (note: option likely has typo 'Reach' for 'Rich'). Plain text cannot display formatting.

The motherboard is also called the System Board because it contains the primary circuitry and connects all components. 'Computer Board', 'Central Board', and 'Mouse' are not standard alternate names.

Formulas and Functions in Excel automatically recalculate when input data changes, creating dynamic results. Charts, tables, and diagrams display data but don't compute dynamically.

Email addresses follow the format [email protected], meaning the user's name comes first, followed by the domain name. Postal and street addresses are not part of email addressing.

Spelling and Grammar tools in word processors help identify and correct errors. Find and Replace locates specific text, while Print Preview shows how documents will look when printed.

COBOL stands for Common Business-Oriented Language, so CO stands for 'Common'. The name reflects its design for business data processing applications.

Correct option is (3).

Option (3) is correct.