Computer Fundamentals Semester 2 Test 2
(53).webp "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. NumbersExplanation
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. TrueExplanation
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 theseExplanation
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 electricityExplanation
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. TrueExplanation
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 networkExplanation
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 networkExplanation
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:
- Investigate the problem
- Design the solution
- Produce the solution
- Evaluate the solution
- 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 photographerExplanation
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. WorksheetExplanation
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
CloudExplanation
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. PropertiesExplanation
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. CodeExplanation
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. FLNExplanation
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 informationExplanation
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
c6Explanation
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).
.jpg "This is a drawing of a")
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, 2023Quiz Edited by
ProProfs Editorial Team -
Nov 22, 2012Quiz Created by
Hbailie
Only a few can pass this basic computer science quiz
Only a few can pass this basic computer science quiz
Computer Quiz: Choose The Correct Word To Complete Sentences
Computer Quiz: Choose The Correct Word To Complete Sentences
Want A Computer Related Job? Start By Taking This Quiz!
Want A Computer Related Job? Start By Taking This Quiz!
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- HCI Quizzes
- Internet Quizzes
- IT SecurITy Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Programming Language Quizzes
- Server Quizzes
- Software Quizzes
Back to top