Font size
WorksheetsDATA PROCESSING THIRD TERM EXAM
Total questions: 85
Worksheet time: 3600secs
The first stage in computer data processing is __________.
collection of data
communication of information
conversion of data
manipulation of data
One reason for using Computer Aided Design in manufacturing is that __________.
it uses few system resources
manufacturing time is reduced
designers do not need training to use it
3D designs are easily produced with it
The process of inspecting, transforming and modeling data to get useful information is known as ________.
collation
interpretation
execution
analysis
A user working on a computer that is running on Windows 7 issued the command "Ctrl + Alt + Del" while typing a document. What interface is expected to be displayed on the screen?
restart windows
shut down windows
windows security
windows task manager
Header and Footer are added to a document in MS Word by just clicking on the __________.
edit menu
format menu
insert menu
view menu
A typist positioned the insertion point at the beginning of a line of text in a word processor and then pressed down the SHIFT key and clicked at the opposite end of the text. What would be the result of this action? The text will be ___________.
copied into the clipboard
cut into the clipboard
deleted from the storage
highlighted on the screen
Which one of the following practices is considered ethical?
gaining access into the school's database to change one's grades
gaining access to government's database to alter personal details
logging into a friend's social media account to read their inbox messages
signing into the school's e-library to read e-books
The aim of administering questionnaire is to collect ________.
data
information
statistics
specimen
A digital platform for the delivery of public sector information and seminar to citizens is called ______.
e-library
e-government
e-commerce
e-learning
One application of ICT in medicine is __________.
global positioning system
seismic software
computerized axial tomography
optical character recognition
The process of drawing inference from a piece of information is called ________.
analysis
collation
interpretation
organization
The information processing stage that produces detailed evaluation of data is __________.
analysis
collection
interpretation
organization
The allocation and de-allocation of computing resources in a computer is the function of ________.
application software
browsers
memory unit
operating system
Computer ethical practices include the following except ________.
Exposure of vulnerability in websites
respect for intellectual property
use of polite words on other users
use of other people's computer without due permission
To add a new column to the right of the IGR column on the interface in the figure above, the user would __________.
right-click on cell C1 and then click on insert
right-click on cell D1 and then click on insert
right-click on column C and then click on insert
right-click on column D and then click on insert
The equipment shown here is used for ________.
audio transmission
Ethernet transmission
infrared transmission
radio transmission
Which of the following devices is not a micro computer?
Note book
Laptop
EDVAC
Desktop
In a computer, the sets of instruction that direct it in performing a particular task are called ________.
information
program
data
file
The powering down of a computer while retaining its state of operation is ________.
shut down
safe mode
hibernation
restart
The placement of texts at the left, right, or center of a cell is _______.
positioning
formatting
alignment
alteration
The act of using a computer to create, edit, and print documents is word ________.
application
processing
editing
documentation
Which of the following is not produced using a spreadsheet?
statistical calculations
simple invoice
journals
data analysis
Which of the following computer applications is not an example of a word processor?
WordPad
Google Docs
Corel Word
Amaya
First generation computers used _______ and magnetic drums for circuitry and memory respectively.
vacuum tubes
transistors
integrated circuits
artificial intelligence
The most common way to look at a table in Access is ________.
datasheet view
design view
table view
print view
Napier bone and abacus are examples of _______ devices.
communicating
computing
memory
processing
The verification of a login name and password is __.
accessibility
activation
authentication
certification
The benefits of ICT in the society include ________.
borderless communication
effective information phishing
financial fraud
identity theft
A single page in a spreadsheet is called _________.
book
page
paper
sheet
One disadvantage of using computer for information processing is _____
Reduced running cost in the long term
Low productivity
The need for staff retraining
The increase in processing speed
The category of computers used for weather forecasting is known as ______.
Special purpose computers
Microcomputers
Super computers
General purpose computers
The part labelled I in this figure is used in Microsoft Excel to _____
Enlarge current document
Minimize current document
Highlight current document
Close current document
Which of the following statements is true?
Data leads to information and information leads to knowledge
Data leads to knowledge and knowledge leads to information
Information leads to data and data leads to knowledge
Knowledge leads to information and information leads to data
The following software are web browsers except ________.
Firefox
Google Chrome
Linux
Opera
An operating system that enables more than one user to access the same data is called _________.
multi-tasking OS
multi-user OS
single user OS
virtual memory OS
The use of the internet to perform illegal activities is generally called ______.
cyber crime
packet sniffing
phishing
spamming
All the following are the media of storing personal information except______.
Computer System
Diaries
E-mails
Television
Which one of the following is word Processing application package?
Word Perfect
Adobe Photoshop
Google Chrome
Dreamweaver
The characteristic of computer that allows it to perform multiple tasks simultaneously with equal ease is __________.
accuracy
reliability
security
versatility
A feature of Word Processing that identifies grammatical errors by reference to an incorporated dictionary is _________.
citation
spell check
thesaurus
word count
The combination of Ctrl + _______ keys previews a page before printing worksheet in MS Excel.
F2
F5
F6
P
E-mails sent in bulk which provide no purpose and obstructing the entire system is __________.
fraud
phishing
plagiarism
spamming
Which of the following is a non-electronic means of information transmission?
computer system
fax
road signs
radio
The arrangement of data items in a desired sequence is ___________.
manipulating
sorting
storing
summarizing
Linux is example of a/an ___________.
high level language
interpreter
low level language
operating system
The combination of Ctrl + ______ keys move cursor to the beginning of the document.
down
end
home
up
The addition of 11012 and 11012 is _________.
110102
111002
101102
110112
The formula "= sum (A2: A7, A9)" will ___________.
multiply the summation of cell range A2 to A7 with cell A9
sum values from cell range A2 to A7, skip A8 and add A9
sum values from cell range A2 to A7
sum values from cell range A2 to A9
A data element that uniquely identifies one record from the other in a table is (a) key.
A data element that uniquely identifies one record from the other in a table is ___________ key.
alternate
attribute
determinant
primary
Which of the following is an example of database management system?
CorelDraw
Lotus 1-2-3
FoxPro
VisiCalc
Write the formula to calculate the total score in Mathematics.
What spreadsheet function can be used to determine the highest score in English?
What field is most suitable to be used as Primary Key?
State four benefits of Internet in Education.
What is a function in MS Excel?
State three ways of classifying computers.
Give two types of information transmission medium.
Table 2 can be derived from table 1 by _______.
Segmentation
Replication
Redundancy
Fragmentation
In Microsoft PowerPoint, the command: ctrl + m is used to create _______.
An animation
New slide
New presentation
New PowerPoint document
The capacity of a communication channel is referred to as _______.
Bandwidth
Baud rate
Bit flow
Data flow
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 _______.
Disconnected VGA
Power failure
Low memory
Defective monitor
At what stage in data processing does data manipulation take place?
Organization
Collation
Analysis
Interpretation
One application of ICT in education is _______.
Optical Mark Reader
Electronic Fund Transfer
Automated Teller Machine
Magnetic Ink Character Recognition
The process of sending and receiving information from one place to another is called information ________.
Synchronization
Transfer
Transmission
Technology
A device used for broadcasting information for simultaneous transmission and reception of human voice is _______.
television
radio
printer
telephone
The series of steps and procedures involved in the production of information from its raw form is data ___________.
validation
processing
manipulation
comparison
Which of the following is not a benefit of digitalization?
plagiarism and copyright
orderly archiving of documents
long term preservation of documents
easy information dissemination through images, texts, internets, extranets, etc.
A common method of sorting data by creating keywords is _________.
stocking
stacking
searching
indexing
Which of the following is not a cleaning tip for the computer system?
use compressed air from a blower to remove dust from the inner compartments
unplug the peripherals from the system unit
turn the keyboard upside down and shake off the crumbs
turn off and unplug the computer before cleaning
In fourth generation computers, ________ is used as a switching device.
valve
transistor
integrated circuit
microprocessor
The powering down of a computer while retaining its state of operation is __________.
shut down
safe mode
hibernation
restart
The placement of texts at the left, right, or center of a cell is _______.
positioning
formatting
alignment
alteration
The act of using a computer to create, edit, and print documents is word ________.
application
processing
editing
documentation
Which of the following is not produced using a spreadsheet?
statistical calculations
simple invoice
journals
data analysis
The subdivision of tracks in a hard disk is called ________.
Record
Row
Sector
Cluster
Any meaningful fact and knowledge item that can be expressed in words and numbers is called _________.
Knowledge base
Information
Database
Data
A user working on a computer that is running on Windows 7 issued the command: Ctrl +Alt +Del while typing a document. What interface is expected to be displayed on the screen?
Windows hibernate
Shutdown windows
Windows task manager
Restart windows
The following computer files will open on a computer that has only Microsoft office 1997 - 2003 installed except ________.
exam.rft
exam.doc
exam.ppt
exam.docx
The use of Visual Display Unit was a major breakthrough in the _______.
first generation computers
second generation computers
third generation computers
fifth generation computers
In hexadecimal system, D is equivalent to _____.
15
14
13
10
The sum of 1102 and 1012 is
11012
11102
11002
10112
Which of the options A to D is not a medium of information transmission?
Cable
Satellite
Television set
Wireless transmission
The following programming tools are employed by a web developer except _______.
COBOL
CSS
HTML
PHP
One responsible way of using the computer is _______.
software piracy
phishing
pharming
ethical hacking
