Final Examination In Computer Concepts And Fundamentals

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Rbastig
R
Rbastig
Community Contributor
Quizzes Created: 1 | Total Attempts: 957
| Attempts: 957
SettingsSettings
Please wait...
  • 1/8 Questions

    Which of the following is not a hardware device?

    • Storage Devices
    • Output Devices
    • MSDOS
    • CPU
Please wait...
About This Quiz

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

Final Examination In Computer Concepts And Fundamentals - Quiz

Quiz Preview

  • 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

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

  • 3. 

    Input refers to?

    • Programs

    • Commands

    • User responses

    • All of the Above

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

  • 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

    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:

  • 5. 

    Most motherboards have how many IDE connectors?

    • One

    • Two

    • Three

    • One of the above

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

  • 6. 

    The central processing unit is also called what?

    • Microprocessor

    • Motherboard

    • Power Supply

    • 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:

  • 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

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

  • 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

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

Quiz Review Timeline (Updated): Mar 29, 2023 +

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
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.