WorksheetsJune 2019
Total questions: 58
Worksheet time: 29mins
Which of the following items are considered computer hardware?
Data
Programs
Output devices
Operating systems
Scanning an item at a computerized checkout station in a supermarket is an example of data
input
output
storing
processing
Access time for magnetic disk is the time taken by the read/write head to find the
Buffer
Sector
Cluster
Cylinder
Intel Pentium V 64-bits 3.6 GHZ
The 64-bit in this specification means that the processor can
Process 4 Characters at one time
Access 4 Characters at one time
Process 8 Characters at one time
Access 8 Characters at one time
Which of the following devices is used to input data into the computer?
Mouse
Monitor
USB flash drive
External hard drive
Which of the following components is used by the CPU to temporarily store data?
Track
Sector
Buffer
Cylinder
In which of the following interface types is the user required to remember specific instructions and syntax
Menu-driven
Graphical User
Computer screen
Command -driven
The primary storage device that holds the data currently being processed by the computer is known as the
Read only memory (ROM)
Programmable ROM (PROM)
Random access memory (RAM)
Erasable and programmable ROM (EPROM)
Which of the following components is used by the CPU to temporarily store data?
Track
Sector
Buffer
Cylinder
In order to use a program stored on a flash drive, the program must be transferred into
ROM
RAM
PROM
EPROM
Which of the following systems provides transmission of data in both directions at the same time?
Simplex
Full duplex
Half duplex
Null duplex
Which of the following tasks is NOT a function of the control unit (CU)?
Performing arithmetic operations
Reading and interpreting machine instructions
Coordinating the operation of the internal registers
Controlling the sequencing of the machine instructions.
Which of the following functions is performed by a modem?
Analog and digital
Digital and upload
Analog and download
Download and upload
Which of the following devices is not required to successfully implement teleconferencing.
Sensor
Modem
Speaker
Microphone
Programs that duplicate the knowledge and diagnostic skills displayed by humans performing specialized tasks are referred to as
Virtual systems
Expert systems
Knowledge systems
Engineering Systems
Transferring data from a remote computer to your computer is referred to as
Browsing
Uploading
Data Mining
Downloading
A hard drive with on read/write head per disk is called a
SCSI
SATA
Fixed head
Moving head
Which of the following operations is considered a feature of a biometric system?
Matching fingerprints
Detecting irregular heartbeats
Diagnosing medical symptoms
Helping to lubricate skeletal joints.
The process of scrambling messages at the sending end and unscrambling them at the receiving end is called
Coding
Encryption
Espionage
Eavesdropping
Telecommuting can be BEST described as
Using the computer while commuting
Using the telephone while commutng
Working form home by connection home and office
Working from the office after establishing a connection at howm
There are many software restrictions used by computers protect data and maintain data integrity. Which of the following entities are software restriction media?
I. Viruses
II. Passwords
III. Encryption
I and II only
I and III only
II and III only
I, II and III
A webmaster is important to a company because he/she
Is responsible for the company's website
Assigns web addresses to all users in a company
monitors the shutting down of the competitors websites
Backs up files and stores the disks at another location
The data from the form shown is captured by
USB
OCR
OMR
MICR
The task of keeping a company's data files and software organized through the cataloguing and storing of tapes and disks is that of the
IT manager
File librarian
Systems analyst
Database administrator
Which of the following checks is NOT a validation technique?
Range
Inconsistency
Double entry
Reasonableness
Which of the following statements is true of accessing files sequentially?
Occurs in any order
Stats with the first record
Starts with the largest data field
Starts with the smallest data field.
The intersection of a row and a column in a spreadsheet is called a
Cell
Label
Range
Calue
A graph is stored and sent to another user. When the user opens the file he understands the graph he receives. This graph is a form of
Discussion
Facilitation
Calculation
Informationn
Which of the following would MOST likely be placed above a graph?
Title
Legend
Gridline
Data label
Which of the following activities is NOT an example of commercial data processing?
Budgeting
Invoice processing
Payroll processing
Forecasting hurricanes
In Microsoft PowerPoint a single page shown on a screen to display information is called a
Slide
Field
Table
Presentation
The following formulars is located in position B6 of a spreadsheet. What would be the resulting formular if it was copied to the position located immediately on the left?
=B3+ B4+ $B$5
C3 + C4 + C5
A3 + A4 + A5
A3 + A4 + $B$5
C3 + C4+$B$5
Which of the following is NOT a valid data type in Microsoft Access
Text
Character
Date/time
Auto number
Which of the following facilities is normally used for website to website connection?
Modem
Monitor
Hyperlink
Hypertext
Spreadsheet formulae use
Values or labels
Labels or cell addresses
Values, Labels or cell addresses
Values, ranges or cell addresses
If Column A is deleted the existing formulae would
Remain the same
Result in an error being reported
Be automatically corrected because of absolute addressing is used.
Be automatically corrected because of relative addressing is used.
Which of the following function 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.
I and II only
I and III only
II and III only
I, II and III
Information produced from queries and tables in a specific format that can be printed form a database is called
A file
A Report
A binary
An object
The slide sorter can be used to
Create a slide master
Modify custom animations
Add sound effects to a presentation
Show thumbnails of the entire slide show
In creating a query, a sturdent entered the following criteria for the data field.
>=05/11/2017 and <=05/14/2017
The output will show days
after 14 May 2017 only
from 11 to 14 May 2017
Before 11 May and after 14 May 2017
Between 14 May and 5 November 2017
Which of the following features can be used in a spreadsheet to copy the result across multiple rows in a single column?
Autofill
Label
Cursor
Function
In a spreadsheet, the column titles will always be visible when you scroll the spreadsheet if you first
Freese the top row
Lock the last column
Lock the spreadsheet
Freese the first column
What is the Value of X
3
8
9
14
Which of the following sequences of steps is correct for deleting a field in a database table?
Choose the delete row option
Select row to be deleted and right click.
Open table in design view.
Choose yes to confirm deletion
Open table in design view.
Select row to be deleted and right click.
Choose the delete row option
Choose yes to confirm deletion.
Select row to be deleted and right click.
Open table in design view.
Choose the delete row option.
Choose yes to confirm deletion.
Select row to be deleted and right click.
Choose the delete row option.
Open table in design view.
Choose yes to confirm deletion.
The integer variables a, b and c are given the values 6, 10 and 2 respectively. What is the result of the following expression
a Mult (b Div c)?
0
20
30
130
Which of the following Pascal statements reads data into a variable, N, and places the cursor on the next line.
Read (N)
Write (N)
Readln (N)
Writeln (N)
In representing algorithms, which of the following statements would be placed in the flow chart box shown below?
A>25
Read A
Output C
Count <-- Count + 1
In an algorithm, item_price is a variable used to store the price of grocery item. The MOST appropriate data type used for item_price is
Real
Integer
Boolean
Character
Read ( A, B)
If A<B Then
Print (A)
Which of the following tasks does the following algorithm perform?
Reads two numbers and prints the first number
Reads two numbers and prints the smaller number
Reads two numbers and prints the first number if it is lager than the second number
Reads two numbers and prints the first number if it is smaller than the second number
Which of the series of numbers represents the correct output when the number 3 is input?
2, 1, 0
2, 1, 0, -1
2, 1, 0, -2
3, 1, 0, -1
The Pascal code var x, y would generate and error the term used to describe this type of error is
Syntax
Logical
Run time
Execution
Which of the following terms is an invalid variable name?
Sum
2count
Vat15
Count
In preparing a computer program, the programmer should FIRST
Plan the solution
Code the progress
Define the problem
Prepare program documentation
The following commands are examples of computer programming instructions:
Sort customer by last name
Total income by department
To which generation of programming languages do these examples belong?
First
Second
Third
Fourth
Which of the following symbols is used to perform assignments in the programming language Pascal
=
:=
<--
==
I. users for length, width
II. Length, width
area <-- Length * width
III. "Area of rectangle is ". area
Which of the following options can be used to replace I, II, III in the algorithm?
Read, write, prompt
Write, read, prompt
Prompt, read, write
Read, prompt, write
Algorithm testing is BEST described as
Executing the program manually with input values to see the results
Running the program using sample data to identify errors in the program
Reading each line of code from beginning to end to search for errors
Checking that all documentation is included in the program
What is the MOST appropriate control structure to be used in calculating the total of ten numbers?
If - then - else
Repeat - until
While - do
For - do
