1.
What sort of information can be entered in a database? (You can select more than one)
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.
2.
Applying a FILTER in a database table reduces the number of records visible.
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.
3.
How can computers and devices be connected in a network?
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.
4.
Which of these IS NOT an advantage of a computer network
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.
5.
One advantage of a BUS network is that is uses less cabling
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.
6.
This is a drawing of a
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.
7.
Which type of network is unaffected if one of the computers on it fails?
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.
8.
The four stages of the design process are:
-
Investigate the problem
-
Design the solution
-
Produce the solution
-
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?
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.
10.
What is a single sheet in an Excel file called?
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.
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.
12.
In Visual Basic Express the appearance of a button, label or textbox can be changed in the
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.
13.
In Visual Basic Express the function of a button or other control is edited in
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.
14.
In Excel what is the correct formula to calculate the total of cells B3 and 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.
15.
Which of these is NOT a type of image file?
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.
16.
Which of these can be made/done using Excel? (You can select more than one)
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.
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.
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).