Font size
WorksheetsGr 7 - Chapter 1, 2, 3 and 4
Total questions: 80
Worksheet time: 8hrs 56mins
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
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.
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
Based on the picture given, determined whether the statement below is TRUE or FALSE
"The central 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 like a home or office and connects devices within a close range.
LAN
PAN
MAN
WAN
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
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 are able to direct data to the intended or specific device.
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
How does a client-server network work?
Data is stored only on client devices
Clients operate independently without a server
All devices in the network are servers
A client-server network works by clients requesting services from a centralized server, which processes requests and sends responses.
What is a peer-to-peer network?
A peer-to-peer network is a centralized system controlled by a single entity.
A peer-to-peer network only allows file sharing between two computers.
A peer-to-peer network is a decentralized network where each workstation can share resources directly with others.
A peer-to-peer network requires a dedicated server to function.
What is a network topology?
Network topology is the speed at which data is transferred across a network.
Network topology is the physical arrangement of cables, computers and peripheral devices.
Network topology is the type of operating system installed on each computer in the network.
Network topology is the method used to protect a network from hackers and viruses.
Describe a star topology.
A star topology connects nodes in a linear fashion.
A star topology is a decentralized network with equal peer nodes.
A star topology is a network layout where all nodes are connected to a central hub or switch.
A star topology has no central hub, only direct connections between nodes.
What are the differences between LAN and WAN?
LAN covers large areas with lower speed; WAN covers small areas with high speed.
LAN is slower than WAN and is used for global connections.
WAN is typically used for local networks with high bandwidth.
LAN is for small areas like same building WAN is for large areas like between countries.
A (a) is a computer intended for individual use in a
networking environment.
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
Where is the command Table located in Word? Tab, Group, Command
Insert Tab, Tables Group, Tables Command
Home Tab, Tables Group, Table Style Command
Page Layout Tab, Insert Group, Tables Command
Insert Tab, Graphics Group, Table Command
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
What is sorting in Excel?
Sorting in Excel is the arrangement of data in a specific order based on column values.
Sorting in Excel is the method of merging multiple sheets into one.
Sorting in Excel refers to the creation of charts and graphs.
Sorting in Excel is the process of deleting data from a spreadsheet.
What is filtering in Excel?
Sorting data in ascending order
Calculating averages of data
Creating charts from data
Filtering in Excel is a feature that enables users to display only the data that meets specific criteria.
How do you apply multilevel sorting in Excel?
Select data, go to Home tab, click Filter, choose colors, click Apply.
Select data, go to Data tab, click Sort, add levels, choose columns, click OK.
Select data, go to Insert tab, click Chart, choose type, click Create.
Select data, go to View tab, click Freeze Panes, adjust rows, click Save.
How can filtering help in data analysis?
Filtering reduces the amount of data available for analysis.
Filtering complicates the data analysis process.
Filtering helps in isolating relevant data for more accurate analysis.
Filtering is only useful for visualizing data trends.
What is the difference between sorting and filtering?
Sorting removes duplicates, filtering adds new data.
Sorting is used for data entry, filtering is for data deletion.
Sorting organizes data by order, filtering narrows down data by criteria.
Sorting changes data types, filtering changes data formats.
QBASIC is an example of ___ programming language.
1GL
2GL
3GL
4GL
5GL
Which Generation of Programming language uses AI?
2GL
3GL
4GL
5GL
Which generation of programming uses binary?
1GL
2GL
3GL
4GL
Which of the following is a characteristic of procedural programming?
It focuses on graphical interfaces
It is event-driven
It relies on a list of instructions
It uses objects to represent data
What is an event in event-driven programming?
A type of programming language
An action that takes place within a program
A method for debugging code
A procedure in procedural programming
Converts high-level programming language into machine language
Interpreter
Compiler
Assembler
Executor
Translates assembly language mnemonic into machine language
Assembler
Compiler
Interpreter
Program is translated line by line as the program is running
Assembler
Compiler
Interpreter
Which of the following is NOT a translator?
Assembler
Compiler
Interpreter
Executable
What generation of programming language is Machine Code/Machine language
1st Generation
2nd Generation
4th Generation
3rd Generation
