Computer Fundamentals Semester 2 Test 2

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 Hbailie
H
Hbailie
Community Contributor
Quizzes Created: 5 | Total Attempts: 752
Questions: 20 | Attempts: 60

SettingsSettingsSettings
Computer Fundamentals Semester 2 Test 2 - Quiz


Questions and Answers
  • 1. 

    What sort of information can be entered in a database? (You can select more than one)

    • A.

      Videos

    • B.

      Text

    • C.

      Images

    • D.

      Numbers

    Correct Answer(s)
    B. Text
    D. Numbers
    Explanation
    A database can store various types of information such as text and numbers. Text can include any form of written information, including names, descriptions, and other textual content. Numbers can be used to store quantitative data, such as measurements, quantities, or any other numerical values. While videos and images can be stored in a database as well, they are not included in the given correct answer.

    Rate this question:

  • 2. 

    Applying a FILTER in a database table reduces the number of records visible.

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    Applying a filter in a database table allows users to specify certain criteria or conditions that the data must meet in order to be displayed. This helps to narrow down the results and reduces the number of records visible, as only those that meet the specified conditions will be shown. Therefore, the statement that applying a filter in a database table reduces the number of records visible is true.

    Rate this question:

  • 3. 

    How can computers and devices be connected in a network?

    • A.

      By a modem

    • B.

      By a network cable

    • C.

      By wireless

    • D.

      All of these

    • E.

      None of these

    Correct Answer
    D. All of these
    Explanation
    Computers and devices can be connected in a network through various means. A modem can be used to establish a connection between devices using telephone lines or cable lines. A network cable, such as Ethernet cable, can be used to directly connect devices to a network switch or router. Wireless connectivity, such as Wi-Fi, allows devices to connect to a network without the need for physical cables. Therefore, all of these options are valid methods for connecting computers and devices in a network.

    Rate this question:

  • 4. 

    Which of these IS NOT an advantage of a computer network

    • A.

      Saving electricity

    • B.

      Sharing resources

    • C.

      Sharing programs

    • D.

      Communicating

    Correct Answer
    A. Saving electricity
    Explanation
    Saving electricity is not an advantage of a computer network because computer networks actually require electricity to function. The main advantages of a computer network include sharing resources, sharing programs, and communicating. These advantages allow for increased efficiency, collaboration, and data sharing among network users.

    Rate this question:

  • 5. 

    One advantage of a BUS network is that is uses less cabling

    • A.

      True

    • B.

      False

    Correct Answer
    A. True
    Explanation
    A BUS network is a type of computer network where all devices are connected to a single cable called a bus. In this network, the devices share the same communication channel, which means less cabling is required compared to other network topologies like a star or ring network. This reduces the cost and complexity of installation and maintenance, making it an advantage of a BUS network.

    Rate this question:

  • 6. 

    This is a drawing of a

    • A.

      Bus network

    • B.

      Star network

    • C.

      Peer-to-peer network

    • D.

      None of these

    Correct Answer
    B. Star network
    Explanation
    The drawing represents a star network because it shows a central node connected to multiple peripheral nodes. In a star network, all nodes are connected directly to the central node, which facilitates easy communication between the central node and the peripheral nodes. This type of network is commonly used in computer networks, where the central node can be a server or a switch, and the peripheral nodes can be client devices.

    Rate this question:

  • 7. 

    Which type of network is unaffected if one of the computers on it fails?

    • A.

      Bus network

    • B.

      Star network

    Correct Answer
    B. Star network
    Explanation
    In a star network, each computer is connected directly to a central hub. This means that if one computer fails, it does not affect the rest of the network. The other computers can continue to function normally and communicate with each other through the central hub. This is because the failure of one computer does not disrupt the connections of the other computers in the network.

    Rate this question:

  • 8. 

    The four stages of the design process are:
    1. Investigate the problem
    2. Design the solution
    3. Produce the solution
    4. Evaluate the solution
    Imagine you are a website developer and your next job is to set-up a website for Jim who runs a lawnmowing and gardening business.  What would you do at each stage of the design process in this job? You should write at least one full sentence for each of the four points above.

  • 9. 

    If you find an image online that has a Creative Commons Attribution licence what can you do with it?

    • A.

      Nothing

    • B.

      Only use it in a print document

    • C.

      Post it online

    • D.

      Use it online or in print with attribution to the photographer

    Correct Answer
    D. Use it online or in print with attribution to the pHotograpHer
    Explanation
    If you find an image online that has a Creative Commons Attribution license, you are allowed to use it both online and in print. However, you must provide attribution to the photographer. This means that you can use the image for various purposes, as long as you give credit to the original creator.

    Rate this question:

  • 10. 

    What is a single sheet in an Excel file called?

    • A.

      Worksheet

    • B.

      Workbook

    • C.

      Spreadsheet

    • D.

      Column

    Correct Answer
    A. Worksheet
    Explanation
    A single sheet in an Excel file is called a worksheet. It is a grid made up of rows and columns where data can be entered and manipulated. Worksheets are used to organize and analyze data, perform calculations, and create charts and graphs. Multiple worksheets can be created within a workbook, allowing for the organization of related data into separate sheets.

    Rate this question:

  • 11. 

    Software and storage located on the Internet and accessed via a web browser is called  _____ computing?

    Correct Answer
    cloud
    Cloud
    Explanation
    The correct answer is "cloud" or "Cloud". This refers to the concept of storing and accessing software and data over the internet instead of on a local computer or server. The term "cloud computing" is commonly used to describe this type of technology and service. It allows users to access their files and applications from anywhere with an internet connection, providing flexibility and scalability.

    Rate this question:

  • 12. 

    In Visual Basic Express the appearance of a button, label or textbox can be changed in the 

    • A.

      Controls

    • B.

      Properties

    • C.

      Form

    • D.

      Code

    Correct Answer
    B. Properties
    Explanation
    In Visual Basic Express, the appearance of a button, label, or textbox can be changed by accessing their properties. The properties of these controls allow the user to modify various attributes such as size, color, font, and alignment. By selecting the desired control and accessing its properties, the user can customize its appearance to meet their specific requirements.

    Rate this question:

  • 13. 

    In Visual Basic Express the function of a button or other control is edited in

    • A.

      Properties

    • B.

      Control

    • C.

      Code

    • D.

      Form

    Correct Answer
    C. Code
    Explanation
    The function of a button or other control in Visual Basic Express is edited in the "Code" section. This is where the programmer can write the necessary code to define what should happen when the button or control is clicked or interacted with. The "Properties" section is used to modify the visual appearance and behavior of the control, while the "Control" section is used for managing the control's properties and events. The "Form" section is used for designing and arranging the controls on the form.

    Rate this question:

  • 14. 

    In Excel what is the correct formula to calculate the total of cells B3 and B4?

    • A.

      Summary(b3+b4)

    • B.

      SUM B4+B3

    • C.

      SUMMARY(B3+B4)

    • D.

      SUM(B3+B4)

    • E.

      TOTAL(B3+B4)

    Correct Answer
    D. SUM(B3+B4)
    Explanation
    The correct formula to calculate the total of cells B3 and B4 in Excel is SUM(B3+B4). This formula adds the values in cells B3 and B4 and gives the total sum.

    Rate this question:

  • 15. 

    Which of these is NOT a type of image file?

    • A.

      JPG

    • B.

      PNG

    • C.

      FLN

    • D.

      JPEG

    Correct Answer
    C. FLN
    Explanation
    FLN is not a type of image file. The question asks for the option that is NOT a type of image file, and FLN is the only option that does not correspond to a commonly used image file format. JPG, PNG, and JPEG are all popular image file formats used to store and display images.

    Rate this question:

  • 16. 

    Which of these can be made/done using Excel? (You can select more than one)

    • A.

      Charts

    • B.

      Calculations

    • C.

      Drawings

    • D.

      Animations

    • E.

      Organise information

    Correct Answer(s)
    A. Charts
    B. Calculations
    E. Organise information
    Explanation
    Excel is a spreadsheet software that allows users to create charts, perform calculations, and organize information. With Excel, users can create various types of charts to visually represent data. It also provides a wide range of mathematical and statistical functions for performing calculations. Additionally, Excel provides tools for organizing and managing data, such as sorting, filtering, and creating tables. However, Excel does not support drawings or animations, so these cannot be made or done using Excel.

    Rate this question:

  • 17. 

    What is the address of this cell?

    Correct Answer(s)
    C6
    c6
    Explanation
    The correct answer is C6,c6. This answer indicates that the address of the cell is C6 and c6. The letter "C" represents the column and the number "6" represents the row. The answer also includes both uppercase and lowercase versions of the cell address, indicating that either format can be used to refer to the cell.

    Rate this question:

  • 18. 

    Hyperlinking is creating a link from one webpage or document to another. Explain how to insert a hyperlink (for example, in our Ultranet Collaborative Space).

Quiz Review Timeline +

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

  • Current Version
  • Jun 07, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 22, 2012
    Quiz Created by
    Hbailie
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.