Computer Fundamentals Semester 2 Test 2

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 Hbailie
H
Hbailie
Community Contributor
Quizzes Created: 5 | Total Attempts: 764
| Attempts: 61 | Questions: 18
Please wait...
Question 1 / 18
0 %
0/100
Score 0/100
1. Software and storage located on the Internet and accessed via a web browser is called  _____ computing?

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.

Submit
Please wait...
About This Quiz
Computer Fundamentals Semester 2 Test 2 - Quiz

The 'Computer Fundamentals Semester 2 Test 2' assesses knowledge in database management, network configurations, and benefits of different network types. It evaluates understanding of data entry, filtering, network connectivity, and network advantages, crucial for students in IT and computer science.

Personalize your quiz and earn a certificate with your name on it!
2. What is the address of this cell?

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.

Submit
3. Which of these is NOT a type of image file?

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.

Submit
4. Which of these IS NOT an advantage of a computer network

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.

Submit
5. One advantage of a BUS network is that is uses less cabling

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.

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

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.

Submit
7. In Excel what is the correct formula to calculate the total of cells B3 and 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.

Submit
8. How can computers and devices be connected in a network?

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.

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

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.

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

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.

Submit
11. This is a drawing of a

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.

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

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.

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

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.

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

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.

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

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.

Submit
16. What is a single sheet in an Excel file called?

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.

Submit
17. Match the program with the file extension (the file extension is the letters after the fullstop in a filename).
Submit
18. Match the program with the type of document or item it is used for:
Submit
View My Results

Quiz Review Timeline (Updated): Jun 7, 2023 +

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
Cancel
  • All
    All (18)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
Software and storage located on the Internet and accessed via a web...
What is the address of this cell?
Which of these is NOT a type of image file?
Which of these IS NOT an advantage of a computer network
One advantage of a BUS network is that is uses less cabling
In Visual Basic Express the appearance of a button, label or textbox...
In Excel what is the correct formula to calculate the total of cells...
How can computers and devices be connected in a network?
Applying a FILTER in a database table reduces the number of records...
Which of these can be made/done using Excel? (You can select more than...
This is a drawing of a
If you find an image online that has a Creative Commons...
In Visual Basic Express the function of a button or other control is...
Which type of network is unaffected if one of the computers on it...
What sort of information can be entered in a database? (You can select...
What is a single sheet in an Excel file called?
Match the program with the file extension (the file extension is the...
Match the program with the type of document or item it is used for:
Alert!

Advertisement