Font size
WorksheetsGr 7 Chp 1, 3, 4 and 5 Review
Total questions: 86
Worksheet time: 18hrs 13mins
Is defined as a specific type of network which consists of a single powerful computer acting as a server, usually connected to multiple computers called clients
Star topology
Bus topology
Ring topology
Peer-to-Peer
Client-Server
Is a type of network in which each workstation has equivalent capabilities and responsibilities. The Workstations are connected to each other but do not have a server.
Star topology
Bus topology
Ring topology
Peer-to-Peer
Client-Server
Is a computer intended for individual use in a networking environment. It is like a personal computer except that it is also connected to the others computers and to the main computer.
Network interface card
Hub
Workstation
Server
(Select more than one)
What do computer networks allow you to do?
Transferring files between computers
Using email to communicate with others
Sharing peripheral devices such as printers and scanners
Sharing an internet connection
Sharing folders and files
is made up of a main single cable with terminators at both ends. It is a shared communication medium that makes the backbone of the system. computers and other devices including the server are connected to this linear cable for communication.
Star topology
Bus topology
Ring topology
Client-Server
Peer-to-Peer
What does LAN stand for?
Local Area Network
Local Analogue Network
Local Assisted Network
What does WAN stand for?
Wide Arena Network
Wide Area Network
World Area Network
Every workstation has two neighbors for communication purposes. All messages travel through a ring in the same direction either clockwise or anticlockwise.
Star topology
Bus topology
Ring topology
Peer-to-Peer
Client-Server
It is a computer that manages network resources, software, and files. it is normally dedicated to an allocated task and performs no other task.
Network interface card
Hub
Workstation
Server
A computer network is where two or more devices are connected together so they can share...
information
resources
cables
People
Home networks are more likely to use a...
router
switch
hub
What is a computer network?
A type of computer game.
Two or more electronic components connected together in an electrical circuit.
A desktop publishing application.
Two or more devices connected together allowing the sharing of information and resources.
a huge collection of computers and networks that have been joined together.
Internet
Phishing
Spam
URL
If main cable is broken, the whole network can crash
You need more cable
Which of the following statements about a network is FALSE?
Resources such as printers can be shared
Viruses can spread to other computers throughout a computer network
Files cannot be shared between users
What is the minimum number of computers needed to create a network?
1
2
3
4
What does the 'L' stand for in 'LAN'?
Large
Loop
Local
Lollypop
Which of the following hardware devices is most likely to be shared on a network?
Mouse
Keyboard
Monitor
Printer
"The centeral communication device on this network must be a Server."
Which one is a BUS topology
Which of the following options is not a component of a network?
Workstation
Server
Keyboard
Hub
Switch
A network which covers a small area and connects devices within a close range.
LAN
PAN
MAN
WAN
What is a key benefit of centralized software management in a network?
It reduces the need for network security
It makes updating software easier across multiple devices
It increases the risk of software incompatibility
It decreases network speed
What is a major disadvantage of using a bus topology?
It is expensive to set up
If the central cable fails, the whole network goes down
Data transmission is very fast
It is difficult to add new devices
Which of the following is an example of a wired transmission channel?
Infrared
Radio waves
Twisted Pair
Microwave
What is a primary advantage of using a switch instead of a hub in a network?
Switches are cheaper than hubs
Switches can handle more devices
Switches require no power
Switches reduce network collisions by directing traffic only to the intended device
Which of the following is a type of wireless transmission channel?
Twisted pair cable
Coaxial cable
Radio waves
Fibre optics
What is the primary function of a Network Interface Card (NIC)?
Connects multiple networks together
Provides wireless network access
Allows a device to connect to a network
Manages network traffic
Given the highlighted area in the image, how many rows and columns would be in the resulting table?
3 rows x 3 columns
3 rows x 6 columns
6 rows x 3 columns
6 rows x 6 columns
Where would you click to select the whole table?
A
B
C
D
What are the vertical sections of a table known as?
Headings
Columns
Rows
Cells
What tab/menu would you use to add a chart?
Home
File
Insert
Page Layout
An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.
%
$
&
#
To remove conditional formatting, click ..................in the Condition Formatting drop-down menu.
clear rules
New rule
Clear option
None of These
The Conditional Formatting button is present in the ____________ group on the Home Tab.
Styles
Cells
Editing
Alignment
What are the numbers in spreadsheet called?
Rows
Alphabet
Column
Symbols
Which type of chart values are arranged vertically?
Bar Chart
Line Chart
Column Chart
Area Chart
True or False ? Is it line chart?
True
False
A __________ is a graphical representation of data.
Algorithm
Steps
Charts
None of the above
Observe the image and choose the correct type of Chart
Line Chart
Pie Chart
Scatter Chart
Area Chart
Observe the given image and choose the correct answer.
Scatter Chart
Pie Chart
Radar Chart
Column Chart
What symbol do all formula start with in Excel?
+
-
=
*
/
Which of the given cell reference can be included in relative reference?
$D6
A$1
A3
&D6
A Formula always begin with an _____ sign.
+
-
=
!
Formula are used to perform ______
Manipulation
Saturation
Substraction
Calculation
The cell address in a Formula is also called_______
Cell reference
Relative reference
Absolute reference
Record reference
How would you write a cell reference formula for cell A1 subtracted by Cell C3?
A1-C3
A1-C3=
=A1-C3
=C3-A1
What happens when you copy a cell with an absolute reference like $B$2 to another location in the worksheet?
The reference changes based on the new location
The reference remains $B$2
The reference shifts one row down and one column to the right
The reference is automatically adjusted
In the formula =A$1 + B2, what kind of reference is A$1?
Absolute reference
Mixed reference (row fixed)
Mixed reference (column fixed)
Relative reference
If you drag the formula =$A$1 + B2 down one row, what will the new formula be?
=$A$1 + B2
=$A$1 + B3
=$A2 + B3
=A$1 + B2
In the formula =$A2 * B$3, which part of the formula is a mixed reference?
$A2
A2
B$3
Both $A2 and B$3
What is the result of copying a formula with the reference C$5 to the cell below it?
The reference changes to D$5
The reference remains C$5
The reference changes to C$6
he reference changes to $C$5
In the formula =A2 * $B$3, what happens to $B$3 if the formula is copied to another cell?
$B$3 will change to a different reference
$B$3 remains unchanged
$B$3 will adjust based on the new location
The reference will change to A2
Which generation of programming uses binary?
1GL
2GL
3GL
4GL
Which Generation of Programming language uses AI?
2GL
3GL
4GL
5GL
QBASIC is an example of ___ programming language.
1GL
2GL
3GL
4GL
5GL
To get Pen block, I choose
This block is used for
set color
change color
The correct instruction to make sprite to draw a line is ____________
"pen down"
"set pen color to"
"pen up"
"change pen color by 10"
What will happen when you run this code?
Change color
Grow and shrink
Spin
Bounce
What shape does the following code block produce?
Square
Circle
Rectangle
Triangle
Create a program with the following algorithm?
The Pen Down block tells ...
The Sprite to start drawing
The Sprite to erase a drawing
The Sprite to stop drawing
The Sprite to draw
Which of the following blocks would repeat a code until a certain condition was met?
Which of the following blocks are loops? Select all that apply
What shape does the following code block produce?
(a)
What shape does the following code block produce?
(a)
