Final Examination In Computer Concepts And Fundamentals

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Rbastig
R
Rbastig
Community Contributor
Quizzes Created: 1 | Total Attempts: 938
Questions: 8 | Attempts: 938

SettingsSettingsSettings
Final Examination In Computer Concepts And Fundamentals - Quiz

Multiple choice final examination for Computer Concepts and Fundamentals Course under Mr. Remacha.


Questions and Answers
  • 1. 

       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.

    • A.

      Copyright

    • B.

      Hackers

    • C.

      Spyware

    • D.

      Phishing

    Correct Answer
    C. Spyware
    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.

    Rate this question:

  • 2. 

    Most motherboards have how many IDE connectors?

    • A.

      One

    • B.

      Two

    • C.

      Three

    • D.

      One of the above

    Correct Answer
    B. Two
    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.

    Rate this question:

  • 3. 

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

    • A.

      Memory

    • B.

      Modem

    • C.

      Drive bay

    • D.

      Microprocessor

    Correct Answer
    B. Modem
    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.

    Rate this question:

  • 4. 

    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?

    • A.

      45

    • B.

      5

    • C.

      -5

    • D.

      None of the above

    Correct Answer
    B. 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.

    Rate this question:

  • 5. 

    Which of the following is not a hardware device?

    • A.

      Storage Devices

    • B.

      Output Devices

    • C.

      MSDOS

    • D.

      CPU

    Correct Answer
    C. MSDOS
    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.

    Rate this question:

  • 6. 

    Input refers to?

    • A.

      Programs

    • B.

      Commands

    • C.

      User responses

    • D.

      All of the Above

    Correct Answer
    D. All of the Above
    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.

    Rate this question:

  • 7. 

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

    • A.

      There are too many numbers in the cell.

    • B.

      The formula is wrong.

    • C.

      The decimal point is wrong.

    • D.

      All of the above

    Correct Answer
    A. There are too many numbers in the cell.
    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.

    Rate this question:

  • 8. 

    The central processing unit is also called what?

    • A.

      Microprocessor

    • B.

      Motherboard

    • C.

      Power Supply

    • D.

      Control Unit

    Correct Answer
    A. Microprocessor
    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.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Mar 29, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Oct 04, 2010
    Quiz Created by
    Rbastig
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.