wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

Gr 7 Chp 1, 3, 4 and 5 Review

Total questions: 86

Worksheet time: 18hrs 13mins

Name
Class
Date
1.

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

a)

Star topology

b)

Bus topology

c)

Ring topology

d)

Peer-to-Peer

e)

Client-Server

2.

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.

a)

Star topology

b)

Bus topology

c)

Ring topology

d)

Peer-to-Peer

e)

Client-Server

3.

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.

a)

Network interface card

b)

Hub

c)

Workstation

d)

Server

4.

(Select more than one)

What do computer networks allow you to do?

a)

Transferring files between computers

b)

Using email to communicate with others

c)

Sharing peripheral devices such as printers and scanners

d)

Sharing an internet connection

e)

Sharing folders and files

5.

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.

a)

Star topology

b)

Bus topology

c)

Ring topology

d)

Client-Server

e)

Peer-to-Peer

6.

What does LAN stand for?

a)

Local Area Network

b)

Local Analogue Network

c)

Local Assisted Network

7.

What does WAN stand for?

a)

Wide Arena Network

b)

Wide Area Network

c)

World Area Network

8.

Every workstation has two neighbors for communication purposes. All messages travel through a ring in the same direction either clockwise or anticlockwise.

a)

Star topology

b)

Bus topology

c)

Ring topology

d)

Peer-to-Peer

e)

Client-Server

9.

It is a computer that manages network resources, software, and files. it is normally dedicated to an allocated task and performs no other task.

a)

Network interface card

b)

Hub

c)

Workstation

d)

Server

10.
What type of network is this?
a)
Star
b)
Bus
c)
LAN
d)
WAN
11.

A computer network is where two or more devices are connected together so they can share...

a)

information

b)

resources

c)

cables

d)

People

12.

Home networks are more likely to use a...

a)

router

b)

switch

c)

hub

13.
If the main cable on a bus fails what happens?
a)
Nothing
b)
Some of the computers will still work
c)
The whole network fails
d)
One computer fails
14.
If a cable fails on a star what happens?
a)
Network fails
b)
One computer fails
c)
Nothing
d)
Not sure
15.

What is a computer network?

a)

A type of computer game.

b)

Two or more electronic components connected together in an electrical circuit.

c)

A desktop publishing application.

d)

Two or more devices connected together allowing the sharing of information and resources.

16.

a huge collection of computers and networks that have been joined together.

a)

Internet

b)

Phishing

c)

Spam

d)

URL

17.
Which topology is this?
a)
Bus
b)
Star
c)
Ring
d)
Wave
18.
Which topology is this?
a)
Bus
b)
Star
c)
Ring
d)
Wave
19.
Which of these is an advantage of the bus topology?
a)
It is easy and cheap to set up
b)
It is useful for large companies
c)
You can pick people up
d)
Anyone can join
20.
Which of these is a disadvantage of the ring topology?
a)

If main cable is broken, the whole network can crash

b)
If the central hub crashes the whole network breaks
c)
Only four computers can be attached to the ring
d)
Everyone has to sit facing each other
21.
Which of these is an advantage of the star topology?
a)
Devices do not rely on each other to function
b)
It looks nice
c)

You need more cable

d)
Only one cable is needed to connect everything together
22.

Which of the following statements about a network is FALSE?

a)

Resources such as printers can be shared

b)

Viruses can spread to other computers throughout a computer network

c)

Files cannot be shared between users

23.

What is the minimum number of computers needed to create a network?

a)

1

b)

2

c)

3

d)

4

24.

What does the 'L' stand for in 'LAN'?

a)

Large

b)

Loop

c)

Local

d)

Lollypop

25.

Which of the following hardware devices is most likely to be shared on a network?

a)

Mouse

b)

Keyboard

c)

Monitor

d)

Printer

26.
What term describes the physical layout of a network?
a)
Topology
b)
topping
c)
topiology
d)
toppology
27.
Base on the picture given, determined whether the statement below is TRUE or FALSE

"The centeral communication device on this network must be a Server."
a)
FALSE
b)
TRUE
28.

Which one is a BUS topology

a)
b)
c)
29.

Which of the following options is not a component of a network?

a)

Workstation

b)

Server

c)

Keyboard

d)

Hub

e)

Switch

30.

A network which covers a small area and connects devices within a close range.

a)

LAN

b)

PAN

c)

MAN

d)

WAN

31.

What is a key benefit of centralized software management in a network?

a)

It reduces the need for network security

b)

It makes updating software easier across multiple devices

c)

It increases the risk of software incompatibility

d)

It decreases network speed

32.

What is a major disadvantage of using a bus topology?

a)

It is expensive to set up

b)

If the central cable fails, the whole network goes down

c)

Data transmission is very fast

d)

It is difficult to add new devices

33.

Which of the following is an example of a wired transmission channel?

a)

Infrared

b)

Radio waves

c)

Twisted Pair

d)

Microwave

34.

What is a primary advantage of using a switch instead of a hub in a network?

a)

Switches are cheaper than hubs

b)

Switches can handle more devices

c)

Switches require no power

d)

Switches reduce network collisions by directing traffic only to the intended device

35.

Which of the following is a type of wireless transmission channel?

a)

Twisted pair cable

b)

Coaxial cable

c)

Radio waves

d)

Fibre optics

36.

What is the primary function of a Network Interface Card (NIC)?

a)

Connects multiple networks together

b)

Provides wireless network access

c)

Allows a device to connect to a network

d)

Manages network traffic

37.

Given the highlighted area in the image, how many rows and columns would be in the resulting table?

a)

3 rows x 3 columns

b)

3 rows x 6 columns

c)

6 rows x 3 columns

d)

6 rows x 6 columns

38.

Where would you click to select the whole table?

a)

A

b)

B

c)

C

d)

D

39.

What are the vertical sections of a table known as?

a)

Headings

b)

Columns

c)

Rows

d)

Cells

40.
What are the horizontal elements of a table known as?
a)
Rows
b)
Columns
c)
Sections
d)
Headings
41.
Merging cells means to...
a)
To combine adjacent cells
b)
To make more of the current cell
c)
To create a new column from the cell
d)
To insert a border into the cell
42.
What does the term split cell refer to?
a)
Combining multiple cells 
b)
To create multiple cells from one cell
c)
To create a new column
d)
To create a new row
43.
Columns and/or rows can not be added to a table once it is created?
a)
True
b)
False
44.

What tab/menu would you use to add a chart?

a)

Home

b)

File

c)

Insert

d)

Page Layout

45.

An absolute reference is designated in a formula by the addition of a _______ sign before and after the cell reference letter.

a)

%

b)

$

c)

&

d)

#

46.
Which of the following is an mixed cell reference with a fixed column address?
a)
G$9
b)
$K356
c)
$F$8
47.

To remove conditional formatting, click ..................in the Condition Formatting drop-down menu.

a)

clear rules

b)

New rule

c)

Clear option

d)

None of These

48.

The Conditional Formatting button is present in the ____________ group on the Home Tab.

a)

Styles

b)

Cells

c)

Editing

d)

Alignment

49.

What are the numbers in spreadsheet called?

a)

Rows

b)

Alphabet

c)

Column

d)

Symbols

50.

Which type of chart values are arranged vertically?

a)

Bar Chart

b)

Line Chart

c)

Column Chart

d)

Area Chart

51.

True or False ? Is it line chart?

a)

True

b)

False

52.

A __________ is a graphical representation of data.

a)

Algorithm

b)

Steps

c)

Charts

d)

None of the above

53.

Observe the image and choose the correct type of Chart

a)

Line Chart

b)

Pie Chart

c)

Scatter Chart

d)

Area Chart

54.

Observe the given image and choose the correct answer.

a)

Scatter Chart

b)

Pie Chart

c)

Radar Chart

d)

Column Chart

55.
What formula is used in cell D3?
a)
B3*C3
b)
B3+C3
c)
=B3*C3
d)
11.50
56.
What formula is used in cell D8?
a)
=D3*D4*D5*D6
b)
SUM(D3:D6)
c)
=69.10
d)
=SUM(D3:D6)
57.

What symbol do all formula start with in Excel?

a)

+

b)

-

c)

=

d)

*

e)

/

58.
Columns are identified using _______?
a)
Numbers
b)
Letters
c)
Numbers & Letters
d)
Cells
59.

Which of the given cell reference can be included in relative reference?

a)

$D6

b)

A$1

c)

A3

d)

&D6

60.

A Formula always begin with an _____ sign.

a)

+

b)

-

c)

=

d)

!

61.

Formula are used to perform ______

a)

Manipulation

b)

Saturation

c)

Substraction

d)

Calculation

62.

The cell address in a Formula is also called_______

a)

Cell reference

b)

Relative reference

c)

Absolute reference

d)

Record reference

63.

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

a)

A1-C3

b)

A1-C3=

c)

=A1-C3

d)

=C3-A1

64.

What happens when you copy a cell with an absolute reference like $B$2 to another location in the worksheet?

a)

The reference changes based on the new location

b)

The reference remains $B$2

c)

The reference shifts one row down and one column to the right

d)

The reference is automatically adjusted

65.

In the formula =A$1 + B2, what kind of reference is A$1?

a)

Absolute reference

b)

Mixed reference (row fixed)

c)

Mixed reference (column fixed)

d)

Relative reference

66.

If you drag the formula =$A$1 + B2 down one row, what will the new formula be?

a)

=$A$1 + B2

b)

=$A$1 + B3

c)

=$A2 + B3

d)

=A$1 + B2

67.

In the formula =$A2 * B$3, which part of the formula is a mixed reference?

a)

$A2

b)

A2

c)

B$3

d)

Both $A2 and B$3

68.

What is the result of copying a formula with the reference C$5 to the cell below it?

a)

The reference changes to D$5

b)

The reference remains C$5

c)

The reference changes to C$6

d)

he reference changes to $C$5

69.

In the formula =A2 * $B$3, what happens to $B$3 if the formula is copied to another cell?

a)

$B$3 will change to a different reference

b)

$B$3 remains unchanged

c)

$B$3 will adjust based on the new location

d)

The reference will change to A2

70.

Which generation of programming uses binary?

a)

1GL

b)

2GL

c)

3GL

d)

4GL

71.

Which Generation of Programming language uses AI?

a)

2GL

b)

3GL

c)

4GL

d)

5GL

72.

QBASIC is an example of ___ programming language.

a)

1GL

b)

2GL

c)

3GL

d)

4GL

e)

5GL

73.

To get Pen block, I choose

a)
b)
74.

This block is used for

a)

set color

b)

change color

75.

The correct instruction to make sprite to draw a line is ____________

a)

"pen down"

b)

"set pen color to"

c)

"pen up"

d)

"change pen color by 10"

76.
How many times would this code need to repeat to make a full circle?
a)
90
b)
180
c)
360
d)
720
77.
Repeating a statement more than once is called a
a)
loop
b)
sequence
c)
repetition
d)
event
78.

What will happen when you run this code?

a)

Change color

b)

Grow and shrink

c)

Spin

d)

Bounce

79.
The "forever" block is found in which of the following block types?
a)
sound
b)
data
c)
events
d)
control
80.

What shape does the following code block produce?

a)

Square

b)

Circle

c)

Rectangle

d)

Triangle

81.

Create a program with the following algorithm?

a)
b)
c)
d)
82.

The Pen Down block tells ...

a)

The Sprite to start drawing

b)

The Sprite to erase a drawing

c)

The Sprite to stop drawing

d)

The Sprite to draw

83.

Which of the following blocks would repeat a code until a certain condition was met?

a)
b)
c)
d)
84.

Which of the following blocks are loops? Select all that apply

a)
b)
c)
d)
85.

What shape does the following code block produce?

(a)  

86.

What shape does the following code block produce?

(a)