The database tool that allows the user to select and filter data from multiple tables is referred to as
Answer
(C)
Query
2
The following statements are steps used in creating a new workbook in a Microsoft Excel application.
I. Click on New
II. Click on the Microsoft Office button
III. Choose blank document Which of the following arrangements shows the correct order of operation from the steps above?
Answer
(B)
II, I and III
3
Shared-memory is an architecture in
Answer
(A)
Parallel database
4
One example of web design package is
Answer
(A)
MS frontpage
5
Preventive maintenance measures in computer room do not include
Answer
(B)
The use of rugs
6
Corrective maintenance of software refers to
Answer
(C)
Modifications initiated due to defects in software
7
To search for information using the interface in Figure above, the keywords of the search subject is typed into part labelled
Answer
(B)
IV
8
To access a website, the URL of the website is typed into the part labelled
Answer
(A)
III
9
One of the major differences between WAN and MAN is that
Answer
(C)
WAN has no limited coverage while MAN has limited coverage
10
Which of the following malware does not replicate itself?
Answer
(A)
Trojan horse
11
One disadvantage of using computer for information processing is
Answer
(C)
The need for staff retraining
12
The part labelled III in the figure above is used to
Answer
(C)
Search for objects
13
Table 1 is a portion of a Microsoft Excel Worksheet which shows the marks obtained by some students in an examination.
A
B
C
D
E
F
1.NAME OF STUDENT
ENGLISH LANG
MATHEMATICS
DATA PROCESSING
COMP. STUDIES
CIVIC EDUCATION
2.ANENE LORRETA
65
90
70
85
65
3.BAKARE IMAM
60
65
75
80
75
4.ENEM GRACE
75
65
65
75
60
5.MOHAMMED DEJI
65
60
65
60
60
6.ONYEBUEKE DEBORAH
89
65
60
65
65
Which of the following formulas can be used to find the average score for ENEH GRACE?
Answer
(A)
=AVERAGE(B4:F4)
14
An application of ICT which allows a person to participate in a meeting from a remote location is called
Answer
(A)
Telepresence
15
The category of computers used for weather forecasting is known as
Answer
(C)
Super computers
16
When choosing a file organization method a system administrator will not consider
Answer
(C)
File medium
17
A suitable application software for creating Tables 1 and 2 is
Answer
(C)
MS access
18
Table 2 can be derived from table 1 by
Answer
(C)
Redundancy
19
The part labelled I in this figure is used in Microsoft Word to
Answer
(B)
Minimize current document
20
In Microsoft PowerPoint, the command: ctrl + m is used to create
Answer
(B)
New slide
21
The capacity of a communication channel is referred to as
Answer
(A)
Bandwidth
22
A desktop computer is switched on and the monitor displays an error message which reads: No input signal. The likely cause of this error is
Answer
(A)
Disconnected VGA
23
The concept of stored program for electronic devices was introduced by
Answer
(D)
John Von Neumann
24
At what stage in data processing does data manipulation take place?
Answer
(A)
Organization
25
One quality of a computer programmer
Answer
(D)
Excellent analytical thinking
26
A file organization method that has reference which identifies a record in relation to other records is called
Answer
(C)
Indexed file organization
27
One application of ICT in education is
Answer
(A)
Optical Mark Reader
28
The process of sending and receiving information from one place to another is called information
Answer
(C)
Transmission
29
Computer virus replicates itself into
Answer
(C)
Propagation phase
30
High level programming languages such as COBOL and FORTRAN were first used in the
Answer
(B)
Third generation computers
31
The subdivision of tracks in a hard disk is called
Answer
(C)
Sector
32
The standard way of arranging information is known as
Answer
(A)
Organization of information
33
Any meaningful fact and knowledge item that can be expressed in words and numbers is called
Answer
(B)
Information
34
The type of network which has a restricted coverage within an enterprise is called
Answer
(A)
Intranet
35
Arrange the following steps in the correct order for editing data type in data sheet view of a Microsoft Access database
I. Click the type of data that that will be entered into the fields
II. Click the data sheet tab on the ribbon
III. Click the field you wish to define
IV. Click the 'down' arrow next to the data type
