WorksheetsFORM 4 INFORMATION TECHNOLOGY END OF TERM EXAMINATION
Total questions: 60
Worksheet time: 30mins
Name
Class
Date
1.
A bank needs an ATM with software that will display their logo after every transaction. Which type of software is best?
a)
custom-written
b)
integrated
c)
general purpose
d)
special purpose
2.
A business that writes programs to perform unique tasks for specific companies is engaged in the development of
a)
custom software
b)
specialised software
c)
off-the-shelf software
d)
general-purpose software
3.
All of the following are advantages of integrated software except
a)
Advanced features of some programs are not included
b)
They are cheaper than buying all of the programs separately
c)
The programs in a suite have similar toolbars and can easily share data
d)
They offer a variety of programs to fit the specific needs of the user
4.
All of the following are examples of cloud storage except
a)
Adobe Acrobat
b)
Dropbox
c)
Google Drive
d)
Microsoft One Drive
5.
An application has been well-tested and is available off-the-shelf for different uses. What type of software is this?
a)
general purpose
b)
custom-written
c)
specialized
d)
integrated
6.
At a news company, reporters use cloud storage to work on their stories. What may be a disadvantage of cloud storage?
a)
Someone may hack into the service and steal confidential files
b)
Reporters may not always have access to a desktop to edit their stories
c)
Reporters travelling to distant countries won't have access to their work
d)
Cloud storage is expensive and not widely available
7.
File compression, backup and antivirus software are examples of:
a)
utility
b)
application
c)
custom
d)
integrated
8.
In which of the following interface types is the user required to remember specific instructions and syntax?
a)
Menu-driven
b)
Graphical user
c)
Typeface
d)
Command-driven
9.
Microsoft Windows, Mac OS, Linux and DOS are all examples of
a)
operating systems
b)
computer manufacturers
c)
computer brands
d)
application software
10.
One DISADVANTAGE of software obtained "off-the-shelf" is
a)
it may not meet all of the user's requirements
b)
it has not been thoroughly tested
c)
it is not readily available
d)
it is less expensive than custom-written software
11.
The advantage of local storage over cloud storage is
a)
Data can be accessed without an internet connection
b)
Data is less secure
c)
Data can be accessed from multiple locations
d)
Data is automatically backed-up in many locations
12.
The appropriate method of processing for an airline reservation system would be
a)
real-time
b)
batch
c)
online
d)
time-sharing
13.
The processing mode that allows one CPU to run many applications at the same time is called
a)
real time processing
b)
multiprocessing
c)
batch processing
d)
time-sharing
14.
The type of processing mode used in a hotel reservation system is
a)
time sharing
b)
real time
c)
batch
d)
multiprocessing
15.
What type of processing is used by a telecommunications company's bill payment system?
a)
multiprocessing
b)
single user
c)
batch and inquiry (or interactive)
d)
real time
16.
When compared to a menu-driven interface, one advantage of a GUI is
a)
It uses up more of the system's resources
b)
It requires specific commands to be entered by the user
c)
It is simpler and easier to use
d)
Typically, only the keyboard is needed to input instructions
17.
Which of the following does NOT usually allow interactive processing?
a)
surfing the net
b)
ATMs
c)
alarm systems
d)
video games
18.
Which of the following is a disadvantage of cloud storage?
a)
Increased possibility for disaster recovery
b)
Reduction of storage cost to organization
c)
Not accessible when offline or without internet
d)
Efficient management of stored data
19.
Which of the following is a hardware user interface?
a)
Icon
b)
GUI
c)
Touchscreen
d)
Sensor
20.
Which of the following is NOT a type of user interface?
a)
Command Driven
b)
GUI
c)
SATA
d)
Menu Driven
21.
Which of the following is BEST suited to batch processing?
a)
Flight simulation
b)
Online gaming
c)
Salary preparation
d)
Theatre booking
22.
Which of the following is NOT an operating system?
a)
Windows
b)
Microsoft Office
c)
Mac OS
d)
Linux
23.
Which of the following is NOT application software?
a)
WhatsApp
b)
word processor
c)
spreadsheet
d)
Windows 11
24.
Which of the following processing modes is BEST suited for processing utility bills?
a)
Real time
b)
Multitasking
c)
Time sharing
d)
Batch processing
25.
Which of the following statements are true about writing custom software?
i. It takes a long time to produce
ii. It contains all of the features that are required
iii. Many other companies will have the same software
a)
ii and iii only
b)
i and ii only
c)
i and iii only
d)
i, ii and iii
26.
Which of the following user interfaces/devices is BEST suited for a visually impaired person?
a)
Touchscreen
b)
Voice interface
c)
Menu Driven
d)
Command Driven
27.
Which one of the following is a hardware user-interface?
a)
GUI
b)
Icon
c)
Sensor
d)
Touchscreen
28.
Which type of interface allows the user to communicate with the computer system by keying in instructions?
a)
Menu driven
b)
Graphical user
c)
Command driven
d)
Touch sensitive
29.
__________ is a database on the world wide web that helps us quickly and easily find the pages we want.
a)
A URL
b)
An ISP
c)
A search engine
d)
A dataset
30.
__________ is a unique name given to each website and web page on the internet.
a)
HTML
b)
HTTP
c)
A URL
d)
A search engine
31.
__________ is organized as millions of connected websites and web pages
a)
A hyperlink
b)
A URL
c)
The Internet
d)
A website
32.
A collection of webpages made up of text, images and other media is called __________.
a)
a browser
b)
multimedia
c)
a website
d)
a URL
33.
A company which provides access to the internet, usually for a fee is known as __________.
a)
a browser
b)
a search engine
c)
a modem
d)
an ISP
34.
A computer that hosts web sites is known as a __________.
a)
a mail server
b)
a web browser
c)
the World Wide Web
d)
a web server
35.
A program which allows you to view and interact with web pages on the internet is called
a)
a website
b)
a hyperlink
c)
HTML
d)
a browser
36.
Text or images that allow you to jump from one website or web page to another are known as __________.
a)
HTTP
b)
hyperlinks
c)
HTML
d)
a search engine
37.
One disadvantage of video conferencing is __________.
a)
Persons can’t utilize all their interpersonal skills
b)
Reception or connection may be poor
c)
May be costly to set up
d)
All of the above
38.
Telecommuting can BEST be described as
a)
communicating between two companies
b)
working from home by connecting home and office
c)
working from home by having employees visit each others' homes
d)
communicating between home and office
39.
Conducting a meeting electronically with participants in different geographical locations is called
a)
teleworking
b)
telemarketing
c)
teleprocessing
d)
teleconferencing
40.
Some DISADVANTAGES of videoconferencing include:
i. Both parties must have a device and a network connection
ii. Facial cues and body language may be missed
iii. One or both parties may be distracted
a)
i and ii only
b)
i and iii only
c)
ii and iii only
d)
all of the above
41.
All of the following are disadvantages of telecommuting EXCEPT:
a)
Persons may be easily distracted at home
b)
There is less security of company files at home
c)
It reduces socialization at the office
d)
Persons can work longer hours
42.
Which of the following is an example of a correctly formatted email address?
a)
lana@happy.net
b)
lana.happy@net
c)
@lana.happy.net
d)
lana@happy@net
43.
In an email program, the icon shown below is used to
a)
attach a file
b)
send a file
c)
forward a file
d)
create a file
44.
A formula = K5/40 gives a decimal answer. How do you change it to a percentage?
a)
Click the icon showing 100% in the tool bar or ribbon
b)
Click the cell then click the % icon in the toolbar or ribbon
c)
Type *100 at the end of the formula
d)
Type *100% at the end of the formula
45.
All of the following are numeric formatting features in spreadsheets except
a)
Comma
b)
Merge and Center
c)
$
d)
%
46.
In a spreadsheet, the term C12 is known as the
a)
record
b)
cell address
c)
name box
d)
cell value
47.
Richard wants to buy a piece of land. Which function will help him compare the monthly payment from different banks?
a)
IF
b)
Pivot Table
c)
PMT
d)
Advanced Filter
48.
Ryleigh has a table listing tourist arrivals from 6 Caribbean countries. For each country, she needs to find the total number of visitors and their combined fees. What spreadsheet feature would be MOST suitable for finding and displaying this information?
a)
VLOOKUP
b)
PMT
c)
Pivot Table
d)
Advanced Filter
49.
Spreadsheet formulae use
a)
values, mathematical operators and cell addresses
b)
functions and cell addresses
c)
cell ranges and addresses
d)
tabs, groups and buttons
50.
The cell that you would edit if you began typing is called the
a)
name box
b)
formula bar
c)
address
d)
active cell
51.
The default alignment for numbers in a spreadsheet is
a)
left
b)
right
c)
center
d)
justified
52.
To center the title row of a spreadsheet across the columns, one must
a)
center align the title columns
b)
merge and center the title rows
c)
merge and center the title columns
d)
center align the title rows
53.
To easily copy a formula from one cell to the other cells above it, you can use
a)
formula bar
b)
SHIFT + ENTER
c)
merge & center
d)
the fill handle
54.
What type of cell addressing must be used to keep the cell address in a formula the same when it is copied to another cell?
a)
Absolute
b)
Relative
c)
Fixed
d)
Direct
55.
Which of the following actions is required for creating a chart in a spreadsheet?
a)
Select the table
b)
Select the columns
c)
Select the data
d)
Select the rows
56.
Which of the following functions are performed by spreadsheets?
i. Performing automatic re-calculation when values have been updated
ii. Applying formulae to numerical data to determine values
iii. Capturing, displaying and manipulating text data
a)
i and ii only
b)
i and iii only
c)
ii and iii only
d)
i, ii and iii
57.
Which symbol MUST be placed in front of the column letter and row number to create an absolute reference?
a)
$
b)
*
c)
=
d)
%
58.
Which spreadsheet function finds and displays the largest value in a set of values?
a)
MAX
b)
HIGHEST
c)
COUNT
d)
BIGGEST
59.
In the spreadsheet below, any item with a total price of $250 or more has a status of "HIGH." Otherwise, the status is "NORMAL."
What function should be placed in Cell G4 to determine the status of the keyboard?
a)
= IF (E4 >= 250, "HIGH", "NORMAL")
b)
= IF (E4 < 250, "HIGH", "NORMAL")
c)
= IF (E4 > 250, "HIGH", "NORMAL")
d)
= IF (G4 > 250, "HIGH", "NORMAL")
60.
Consider the sample spreadsheet below.
To find the total of the values in the PRICE column, which function should be placed in cell C12?
a)
= SUM (C4:C10)
b)
= TOTAL (C4:C10)
c)
= SUM (C4 + C5 + C6 + C7 + C8 + C9 + C10)
d)
= ADD (C4:C10)
100 %
