Final Examination In Computer Concepts And Fundamentals

1. Which of the following is not a hardware device?

Storage Devices

Output Devices

MSDOS

CPU

MSDOS is not a hardware device. It stands for Microsoft Disk Operating System, which is an operating system software used to control and manage computer hardware. While storage devices, output devices, and CPU are all examples of hardware devices, MSDOS is a software program that runs on the hardware.

Explanation

MSDOS is not a hardware device. It stands for Microsoft Disk Operating System, which is an operating system software used to control and manage computer hardware. While storage devices, output devices, and CPU are all examples of hardware devices, MSDOS is a software program that runs on the hardware.

2. Formulas are instructions that you enter to perform calculations. For example, enter the number 350 in cell B1; enter the number 450 in cell B2; enter the formula =B1+B2 in cell B3. The value 800 is displayed in cell B3. If a value changes in cell B1 or B2, the formula will always add the two and show the correct sum in cell B3. If B1 is 25, B2 is 20, and B3 has the formula =B1-B2, what is the sum that will show in B3?

45

5

-5

None of the above

The formula in cell B3 is =B1-B2, which subtracts the value in cell B2 from the value in cell B1. Therefore, if B1 is 25 and B2 is 20, the sum that will show in B3 is 5.

Explanation

The formula in cell B3 is =B1-B2, which subtracts the value in cell B2 from the value in cell B1. Therefore, if B1 is 25 and B2 is 20, the sum that will show in B3 is 5.

3. Input refers to?

Programs

Commands

User responses

All of the Above

The correct answer is "All of the Above" because input refers to all of the mentioned options: programs, commands, and user responses. Input is any information or data that is entered or provided to a system, and in the context of this question, it can pertain to any of these options. Programs can take input from users or other programs, commands can be used as input to execute specific actions, and user responses can be considered as input for various purposes. Therefore, all of these options fall under the category of input.

Explanation

The correct answer is "All of the Above" because input refers to all of the mentioned options: programs, commands, and user responses. Input is any information or data that is entered or provided to a system, and in the context of this question, it can pertain to any of these options. Programs can take input from users or other programs, commands can be used as input to execute specific actions, and user responses can be considered as input for various purposes. Therefore, all of these options fall under the category of input.

4. When number signs (#####) are displayed in the cell, it means:

There are too many numbers in the cell.

The formula is wrong.

The decimal point is wrong.

All of the above

When number signs (#####) are displayed in the cell, it means that there are too many numbers in the cell. This occurs when the column width is not wide enough to display the entire number. Adjusting the column width or reducing the number of digits in the cell can help resolve this issue.

Explanation

When number signs (#####) are displayed in the cell, it means that there are too many numbers in the cell. This occurs when the column width is not wide enough to display the entire number. Adjusting the column width or reducing the number of digits in the cell can help resolve this issue.

5.
Most motherboards have how many IDE connectors?

One

Two

Three

One of the above

Most motherboards have two IDE connectors. IDE (Integrated Drive Electronics) is a standard interface used to connect storage devices such as hard drives and optical drives to the motherboard. Having two IDE connectors allows for the connection of multiple IDE devices simultaneously, providing more flexibility and expandability for storage options.

Explanation

Most motherboards have two IDE connectors. IDE (Integrated Drive Electronics) is a standard interface used to connect storage devices such as hard drives and optical drives to the motherboard. Having two IDE connectors allows for the connection of multiple IDE devices simultaneously, providing more flexibility and expandability for storage options.

6. The central processing unit is also called what?

Microprocessor

Motherboard

Power Supply

Control Unit

The correct answer is Microprocessor. The central processing unit (CPU) is often referred to as a microprocessor because it is responsible for executing instructions and performing calculations in a computer system. It is the brain of the computer and handles all the processing tasks. The other options, such as motherboard, power supply, and control unit, are important components of a computer system, but they are not synonymous with the CPU.

Explanation

The correct answer is Microprocessor. The central processing unit (CPU) is often referred to as a microprocessor because it is responsible for executing instructions and performing calculations in a computer system. It is the brain of the computer and handles all the processing tasks. The other options, such as motherboard, power supply, and control unit, are important components of a computer system, but they are not synonymous with the CPU.

7. Which part of the computer is rated by how many bits of information they can receive in one second?

Memory

Modem

Drive bay

Microprocessor

A modem is the correct answer because it is a device that allows computers to connect to the internet. Modems are rated by how many bits of information they can receive in one second, which is known as the data transfer rate. This determines the speed at which data can be transmitted over a network. Memory, drive bay, and microprocessor are not directly related to the data transfer rate of a computer.

Explanation

A modem is the correct answer because it is a device that allows computers to connect to the internet. Modems are rated by how many bits of information they can receive in one second, which is known as the data transfer rate. This determines the speed at which data can be transmitted over a network. Memory, drive bay, and microprocessor are not directly related to the data transfer rate of a computer.

8.

A criminal activity that is used by people to fraudulenty obtain personal information, such as usernames, passwords, cedit card details, and your social security information.

Copyright

Hackers

Spyware

Phishing

Spyware is a type of criminal activity that involves obtaining personal information fraudulently. It is a form of malicious software that is designed to collect sensitive data, such as usernames, passwords, credit card details, and social security information, without the user's knowledge or consent. This information is then used for various illegal purposes, such as identity theft or financial fraud. Spyware is typically distributed by hackers and can be installed on a computer or mobile device through deceptive means, such as phishing emails or infected websites.

Explanation

Spyware is a type of criminal activity that involves obtaining personal information fraudulently. It is a form of malicious software that is designed to collect sensitive data, such as usernames, passwords, credit card details, and social security information, without the user's knowledge or consent. This information is then used for various illegal purposes, such as identity theft or financial fraud. Spyware is typically distributed by hackers and can be installed on a computer or mobile device through deceptive means, such as phishing emails or infected websites.