Bank Of Questions | Basic Computer Applications | CMT NTA 4

1. A device found in the computer system, that data can be stored temporarily:

A. Hard Disk Drive

B. RAM

C. CPU

D. ROM

E. PROM

DOWNLOAD HERE BANK OF QUESTIONS

2. Which of the following is correct about system unit:

A. All components connected to the motherboard

B. Case that houses most of the components that make the computer system

C. Circuit body of a computer system

D. Hold all peripheral devices

E. The unit that is supply electricity to the CPU

3. One of the following is keyboard shortcut for help

A. F5

B. F4

C. F3

D. F2

E. F1

4. Which of the following statements best defines Computer?

A. Electronic machine

B. Input device

C. Output device

D. Computerized machine

E. Digital Machine

5. Also called brain of the computer:

A. Chipset

B. Memory

C. Central Processing Unit

D. Hard Disk

E. Hardware

6. In a computer system 1024MB is equal to …..

A. 2GB

B. 1GB

C. 5GB

D. 0.5GB

E. 3GB

7. The devices that translate the processed information from the computer into a form that humans can understand:

A. Translators

B. Output device

C. Input/output

D. Input devices

E. Storage devices

8. One of the following is an example of Linux family Operating System:

A. DOS

B. Windows 10

C. Android

D. Red hat

E. Windows 7

9. One of the following is peripheral devices :

A. Scanner

B. Monitor

C. On screen Keyboard

D. Finger Print Device

E. On build web cam

10. Which type of application software is used for budgeting:

A. Page er

B. Spreadsheet software

C. Desktop publishing

D. Presentation software

E. Word processing software

11. WWW stands for?

A. World Whole Web

B. Wide World Web

C. Web World Wide

D. World Wide Web

E. World Web Wide

12. Which of the following are components of Central Processing Unit (CPU) ?

A. Arithmetic logic unit, Mouse

B. Arithmetic logic unit, Control unit

C. Arithmetic logic unit, Integrated Circuits

D. Control Unit, Monitor

E. Control Unit, Speaker

13. _______ are software which is used to do particular task.

A. Operating system

B. Program

C. Data

D. Software

E. System

14. Which among following first generation of computers had ?

A. Vaccum Tubes and Magnetic Drum

B. Integrated Circuits

C. Magnetic Tape and Transistors

D. Microcontroller

E. Microprocessor

15. Where is RAM located ?

A. Expansion Board

B. External Drive

C. Mother Board

D. External Hard disk

E. Board of the Computer.

16. Full form of URL is ?

A. Uniform Resource Locator

B. Uniform Resource Link

C. Uniform Registered Link

D. Unified Resource Link

E. Uniform Resource Location.

17. The most widely used computer device is.

A. Solid state disks

B. External hard disk

C. Internal hard disk

D. Mouse

E. Floppy Disk.

18. The brain of any computer system is

A. ALU

B. Memory

C. CPU

D. Control Unit

E. RAM/ROM

19. What difference does the 5th generation computer have from other generation computers?

A. Technology Advancement

B. Scientific Code

C. Object Oriented Programming

D. Industry

E. Modern Cars

20. Which part interprets program instructions and initiate control operations.

A. Input

B. Storage Unit

C. Control Unit

D. Logical Unit

E. Memory Unit

21. In which of the following form, data is stored in computer ?

A. Decimal

B. Binary

C. HexaDecimal

D. Octal

E. Numbers

22. Which of following is used in RAM ?

A. Conductor

B. Semi Conductor

C. Vaccum Tubes

D. Transistor

E. Electricity

23. What is full form of GUI in terms of computers ?

A. Graphical user Instrument

B. Graphical unified Interface

C. Graphical unified Instrument

D. Graphical user Interface

E. Graphical using Interface

24. What is full form of ALU ?

A. Arithmetic logic unit

B. Allowed logic unit

C. Ascii logic unit

D. Arithmetic least unit

E. Arithmetic login unit

25. Verification is process of ?

A. Access

B. Login

C. Logout

D. Authentication

E. Confidentiality.

26. What is LINUX ?

A. Malware

B. Operating System

C. Application Program

D. Firmware

E. System

27. MS-Word is an example of _____

A. An Operating System

B. A processing device

C. Application Software

D. An Input devices

E. A System Softwares

28. A computer cannot "boot" if it does not have the _____

A. Loader

B. Compiler

C. Assembler

D. Operating system

E. Application Software.

29. By default, your documents print in ________ mode

A. Landscape

B. Portrait

C. Page setup

D. Print preview

E. Print view

30. Which among following is secondary storage device ?

A. Hard Disk

B. RAM

C. Diode

D. Semi Conductor

E. Computer

31. USB is which type of storage device ?

A. Primay

B. Secondary

C. Tertiary

D. Quaternary

E. Preliminary

32. An electronic path, that sends signals from one part of computer to another is ?

A. Logic Gate

B. Modem

C. Bus

D. Serial Port

E. Slots

33. One of the following is used to align a text to both left and right margin, adding extra space:

A. Right Alignment

B. Left Alignment

C. Justify

D. Centre

E. Line Spacing

34. In Microsoft Excel is used to display the active cell address:

A. Formula Bar

B. Name box

C. Cell Address

D. Standard Toolbar

E. Formatting Toolbar

35. Which of the following is a keyboard shortcut used to insert an area of text or image in a document:

A. CTRL + U

B. CTRL + V

C. CTRL + I

D. CTRL + B

E. CTRL + K

36. The following is adapter card that is used to translate data from CPU into a format that screen can display

F. Video Card

G. Video Display Unit

H. Video Cards

I. Serial Ports

J. Parallel Ports

37. Which of the following is a type of Ant Virus

A. Trojan Horse

B. Norton

C. Safari

D. Mozilla Firefox

E. Nero

38. Which of the following statements best defines Internet

F. An interconnection of computers in a big company

G. A huge Interconnection of computers covering a wide area

H. A world wide connection of computers

I. An interconnection of computers within a small geographical area.

J. A multimedia interface for internet resources

39. Which of the following is originated from Centre for Disease Control:

A. Spread Sheet

B. Word

C. Epi Info

D. Epic

E. Access

40. Which of the following is a graphic representation for a program or function:

F. Pointer

G. Icon

H. Menus

I. Help

J. Dialog Boxes

41. One of the following refers to illegal programs which come into your computer usually while browsing the internet:

A. Virus

B. Ant Virus

C. Worm

D. Adware

E. Malware

42. Which of the following item will show who will get a copy of the message

F. BCC

G. CC

H. To

I. Subject

J. Signature

43. One of the following is an example of Linux family Operating System:

F. DOS

G. Windows 10

H. Android

I. Red hat

J. Windows 7

1. This data type allows alphanumeric characters and special symbols.

A. Text

B. Characters

C. Memo

D. Auto number

E. Character

2. Which of the following is not a database object?

A. Table

B. Queries

C. Forms

D. Relationship

E. Report

3. This key uniquely identifies each record

A. Primary key

B. Unique Key

C. Key records

D. Field name

E. File name

4. Which of the following creates a drop down list of values to choose from a list?

A. Hyperlinks

B. Attachments

C. OLE objects

D. Lookup wizard

E. Memo

5. Which field type can store photos?

A. Hyperlinks

B. Lookup wizard

C. Currency

D. OLE objects

E. Auto number

6. One of the following is used to align a text to both left and right margin, adding extra space:

F. Right Alignment

G. Left Alignment

H. Justify

I. Centre

J. Line Spacing

7. The following is adapter card that is used to translate data from CPU into a format that screen can display

K. Video Card

L. Video Display Unit

M. Video Cards

N. Serial Ports

O. Parallel Ports

8. Which of the following is a type of Ant Virus

F. Trojan Horse

G. Norton

H. Safari

I. Mozilla Firefox

J. Nero

9. Which of the following is a graphic representation for a program or function:

K. Pointer

L. Icon

M. Menus

N. Help

O. Dialog Boxes

10. The following is a type of browser

A. Eset node

B. Serengeti

C. Safari

D. Panda

E. Avast

11. The following is the computer application that is used for calculating the number of drugs in the shelf;

A. Microsoft Word

B. Microsoft Publisher

C. Microsoft Power Point

D. Microsoft Excel

E. Microsoft Outlook

12. _________is one of the Microsoft office suite used in report writing

A. Microsoft Word

B. Microsoft Publisher

C. Microsoft Power Point

D. Microsoft Excel

E. Microsoft Outlook

13. One of the following is the storage devices;

A. Printer

B. Scanner

C. Keyboard

D. Memory Card

E. Joystick

14. Which of the following is the type of Anti-virus;

A. Panda

B. Trojan House

C. Boot sector

D. Time bomb

E. Worm

15. The following is the type virus program that perform activity on the particular date;

A. Logical bomb

B. Time bomb

C. Worm virus

D. Boot sector virus

E. Macro virus

16. The following is a device used for facilitating the Internet connection on a computer system

A. Joystick

B. Modem

C. CD Drive

D. Keyboard

E. Mouse

17. The long form of WAN is

A. Wap Area Network

B. Wireless Area Network

C. Wide Array Net

D. Wide Area Network

E. Wide Areole Network

18. One of the following is an example of Email address

A. name@website@info

B. Kiccohas@ymail.uk

C. www.nameofwebsite.com

D. Name.website@com/http

E. name.com

19. The following is an example of a browser

A. Google

B. Yahoo

C. Alta Vista

D. Internet Explorer

E. Chacha.com

20. Which among the following is an example of Orientation on Microsoft office package

A. Top

B. Bottom

C. Right

D. Portrait

E. Portraits

21. The following are keyboard shortcuts for replace

A. Ctrl+ U

B. Ctrl+ R

C. Ctrl+ H

D. Ctrl+ F

E. Ctrl+ P

22. A workbook is a grid of cells , consisting of _________rows

A. 256

B. 265

C. 65,635

D. 63,565

E. 65,536

23. Used in creation of database

A. Microsoft Excel

B. Microsoft Publisher

C. Microsoft Access

D. Microsoft Power Point

E. Microsoft Word

24. A pharmacist used Google to locate a piece of information from the information super highway. How else can you refer to Google?

A. An internet vehicles engine

B. An engine used to search the internet

C. A search engine

D. A hardware facility used to locate information from the internet

E. A software used to instruct the engine of a vehicle

25. Which of the following statement best defines WEB

A. An interconnection of computer of a company

B. A huge Interconnection of computer covering a wide area

C. A word wide interconnection of computer

D. An internet

E. A multimedia interface for internet resources

26. The following is file extension of Microsoft Word 2007

A. .doc

B. .docx

C. doc

D. cod

E. docx

27. Part of the chart

A. Ruler

B. Alignment

C. Legend

D. View

E. Status

28. What is the example of a cell address?

A. 11 25

B. 911

C. 41A

D. A21

E. AA2

29. How do you tell one cell from another?

A. By numbers

B. By letters

C. By its address

D. By color

E. By its location

30. In order to arrange the countries from those with the highest population to those with the lowest, you need to sort on the population field in_________________________

A. Ascending order

B. Descending order

C. Alphabetical order

D. Random order

E. Vertical order

31. Where a row and a column meet, what do you call that?

A. A cell

B. A block

C. A box

D. A set

E. A node

32. You accidentally erased a record while using Microsoft package what command can be used to restore it immediately?

A. Insert

B. Copy

C. Undo

D. Replace

E. Delete

33. Workbook is associated with which of the following software;

A. Ms PowerPoint

B. Ms Publisher

C. Ms Access

D. Ms Excel

E. Ms Word

34. People who use computers directly and use the information malicious are called;

A. Users

B. Hackers

C. Operators

D. Technicians

E. Programmers

35. The shortcut Ctrl+V means;

A. Cut

B. Copy

C. Paste

D. Close

E. Verify

36. The shortcut Ctrl+C stands for;

A. Cut

B. Copy

C. Paste

D. Close

E. Verify

37. Any device connected to a computer to improve its performance is called

A. Software device

B. Digital device

C. Peripheral device

D. Connected device

E. Input device

38. Which type of application software is used for budgeting

A. Page er

B. Spreadsheet software

C. Desktop publishing

D. Presentation software

E. Word processing software

39. The transfer of data from one department to another it includes the presence of Internet Network. What is the medium for Networking

A. Modem

B. VGA

C. USB Cable

D. UPS

E. Flash

40. The following is the formula for Calculating total in Microsoft Excel

A. SUM(A3:B10)

B. = SUM(a1:a6)

C. SUM(3A:B10)

D. = SUM(A3:B10)

E. = SUM(3A:B10)

41. What is Apache?

A. Browser

B. Computer

C. Operating system

D. Web server

E. Computer virus

42. Unwanted and unsolicited emails is called

A. Instant messages

B. Messages

C. Trash

D. Spam

E. Virus

43. One of the following is a multimedia interface

A. Internet

B. Intranet

C. Web

D. Website

E. Web browser

44. Which of the following is not one of the four major data processing functions of a computer?

A. Gathering data

B. Processing data into information

C. Analyzing the data or information

D. Storing the data or information

E. Accept data and give out information

45. Special sequence of numbers or letters that limits access to information is known as

A. Software

B. Entry key

C. Digital signature

D. Passwords

E. Application control

46. Step by step instructions that tell the computer how to do its work

A. Switch on

B. Programs or software

C. Window button

D. CPU

E. Monitor

47. Peripheral devices are one which enhance the

A. Work functionality

B. Work functions

C. Work relax

D. Work Incompatibility

E. Work performance

48. Types of software used for creating slideshows is

A. Page maker slide

B. Presentation software

C. Web design software

D. Spreadsheet software

E. Word processing software

49. Which of the following component when removed from a computer cannot operate

A. Mouse

B. Diskette

C. Hard Disk

D. Keyboard

E. CD ROM drive

50. The output device that allow a user to see data or information on computer is

A. Mouse

B. Monitor

C. Printer

D. Speaker

E. Communication

51. Which of the following is the output devices

A. Mouse

B. Monitor

C. Printer

D. Speaker

E. Communication

52. Which type of software would you use to make the computer perform a specific task, such as writing a letter or drawing a picture?

A. Window XP

B. Application software

C. Utility software

D. System software

E. Operating system software

53. The device that translates data and programs that human can understand to a form that the computer can process

A. System unit

B. Output devices

C. Input devices

D. Primary memory

E. Secondary memory

54. Rules or guidelines to follow when using software are referred as

A. User

B. Procedures

C. Data

D. Software

E. Hardware

55. A person who repairs and install computer components and systems is known as

A. Web master

B. Computer technician

C. Technician writer

D. Computer trainer

E. Computer support specialist

56. A person who analyzes users needs and create application software is

A. Web master

B. Software engineer

C. Desk publisher

D. Computer Training

E. Network administrator

57. One of the following is an input devices used to identify a product and provide information like in superet

A. Scanner

B. Price checker

C. Bar code

D. Numeric digit

E. Lights sensitive detector

58. Small, relatively inexpensive computer designed for an individual user

A. Wearable computer

B. Cell phone

C. Personal computer pc

D. PDA

E. Laptop

59. Which type of application software Is used for budgeting

A. Page er

B. Spreadsheet software

C. Desktop publishing

D. Presentation software

E. Word processing software

60. Equipment that processes the data to create information and is controlled by software

A. Computer

B. Software

C. Hardware

D. Central processing Unit

E. System Unit

61. The following diagram shows

A. Status tool bar

B. Title bar

C. Menu bar

D. Formatting tool bar

E. Insertion port

SECTION B: TRUE / FALSE QUESTIONS: ANSWER ALL QUESTIONS: (10 )

Instructions:

ü This section consists of Four (4) questions with five (5) options each

ü Write in the space provided the word “TRUE” and NOT letter ‘T’ for a correct statement and the word “FALSE” NOT letter ‘F’ for incorrect statement

ü Half (1/2) a will be awarded for each correct response

1. Advantages of telecommunication in a health facility

A. ………..Networks enable information sharing

B. ………..Internet resources are mostly abused in health facilities workstations

C. ………..Internet enables sharing of valuable resources among health workers

D. ………..Remote data connections

E. ………..Telecommunication is a major demerit in the health facility

2. The following are the characteristics of a computer

A. ………………….. Speed

B. ………………… Accuracy.

C. ………………… Lazy

D. ……………………Versatility

E. …………………..Power of forgetting

3. Regarding Page setup on Ms Excel

A. …………. Margins

B. ……….. Number

C. ………. Data

D. ………. Analysis

E. ……… Orientation

4. The following are the types of Charts in Ms Excel

A. .............. Memo

B. .............. Signs.

C. ............. Surface

D. ............ Bubble

E. ............ Radar

5. Facts on mwanamvua@ydcp.co.tz

A. ………….It is a web page

B. ………….Mwanamvua is a domain name

C. ………….Ydcp is a user domain

D. ………….Co.tz is a domain code

E. ………….The provider is a company

6. About keyboard shortcuts.

A. ...............Shift+F11;Insert new worksheet

B. …………Shift+Delete;Delete item permanently

C. ………….CTRL+V;Cut

D. …………ALT+Tab;Switch to another running program

E. ………….CTRL+Z;Paste

7. Which of the following are examples of Operating system which belongs to Linux Family;

A. ………..Debi an

B. ………...DOS

C. …………Ubuntu

D. …………Window NT

E. …............Unix

8. Regarding CPU

A. ………………….. Has three parts

B. ………………….. Works to process data

C. ………………….. Saves data

D. ………………….. Is the primary memory

E. ……………….Is the permanent memory of computer

9. Uses of computers

A. ………………….. To save time

B. ………………….. Petroleum pumps

C. ……………… Automatic Teller Machine

D. ………………….. Weapon Guidance system

E. ………………….. Can be used to guide

10. The followings are computer input device

A. ………………….. Printer

B. ………………….. Monitor

C. ………………….. Keyboard

D. … ……………… Speaker

E. ………………….. UPS

Regards the kind of data types found in Access.

A. ___________Relationship

B. ___________Table

C. ___________Form

D. ___________Report

E. ___________Worksheet

10. Uses of computers

F. _____________ To save time

G. ______________ Petroleum pumps

H. ____________ Automatic Teller Machine

I. ______________ Weapon Guidance system

J. ______________ Can be used to guide

11. The followings are uses of spreadsheet

A. ___________Preparing Payroll

B. ___________Preparing Budget

C. ___________Calculate GPA

D. ___________Preparing Brochures

E. ___________Preparing Memos

12. The following statements are correct regarding the expression

A. ________(tz) Represent the country the organization is found

B. ________ (http:) Web protocol

C. ________(necta) Organization that owns the website

D. ________ (www) World Wide Web

E. ________ (go) Non-government organization

13. Regarding clearing of hard drive, the following steps are included

A. _________ Install new programs

B. _________ Clean out temporary files

C. _________ Shut down your computer

D. _________ Increase the size your recycle bin

E. _________ Scandisk and Defrag

14. About to modify a worksheet

A. ________ resize column

B. ________protect with password

C. ________rename

D. ________insert text

E. ________Use chart presentation

15. Computer operate with

A. _________Barcodes

B. _________ Scanner as input devices

C. _________Flash memory as transfer data device

D. _________Printer as input device

E. _________Modem as communication device

16. About word processing interface

A. _________Have the view ruler

B. _________Have the zoom

C. _________It contain drop menu formula

D. _________It contain spacing

E. _________It contains cell

17. Bellow is the machine cycle

A. ________fetch

B. ________Decode

C. ________Execute

D. ________Store

E. ________CPU

18. A pharmacist used Google to locate a piece of information from the information super highway. How else can you refer to Google?

A. _________An internet vehicles engine

B. _________An engine used to search the internet

C. _________A search engine

D. __________A hardware facility used to locate information from the internet

E. __________A software used to instruct the engine of a vehicle

19. The following are Examples of Websites that provide search services to help you find information

A. ___________Yahoo www. Yahoo.com

B. ___________Excite www. Excite.com

C. ___________Lycos www. Lycos.com

D. ___________Alta Vista www/alta-vista.com

E. ___________MSN Web search www.search.msn.com

20. About E-mail address

A. To _________ sumith.niit@esrilamnka.lk

B. Cc_________ assignments.trg@gmail.com

C. Bcc________barnabanicholaus23@esrilamnka.lk

D. ___________Time stamp

E. ___________Plain text

21. The Trash folder

A. __________Deleted messages go to the Trash folder

B. __________If you delete something by accident, you can retrieve it from Trash

C. __________If you delete a message in Trash its gone forever

D. __________You can delete everything in the Trash folder by clicking on Empty

E. __________lost data once tank rated by trash

11. Concerning Epi Info 7

F. _________Outbreak investigation software

G. _________Public health data collection

H. _________DOS Based Programs

I. _________Inventory management software

J. _________Example of a web browser

SECTION C: MATCHING ITEMS: (10 )

Instructions

ü This section consists of two (2) questions for matching with ( 5 ) five options each

ü Match the items in Column B with corresponding statements in Column A by writing a letter of correct response in the space provided.

ü Each correct response is awarded one (1)

ü Each item from Column B is used only once

PART ONE

Match the Terminologies in Column A with their respective definitions/meanings from Column B.

COLUMN A

COLUMN B

1. ……………..Motherboard

2. ……………..Hardware

3. ……………..Monitor

4. ……………..Modem

5. ……………..Peripheral Devices

A. Keyboard

B. Are equipment used with a computer to enhance its functionality.

C. A large printed circuit boards inside the system unit that has several microchips mounted on it.

D. CRT

E. Device that sends and receives data to and from computers over telephone lines.

F. Pointing

G. Arrangement of letters and Numbers

H. Right click

PART TWO

Match the Terminologies in Column A with their respective definitions/meanings from Column B.

S/N	COLUMN A	S/N	COLUMN B
1.	……………Screen	A.	Is a device which produce sound
2.	……………Keyboard	B.	Bring out a hardcopy
3.	……………Motherboard	C.	Display data into human understandable form
4.	…………….CENTRAL PROCESSING UNIT(CPU)	D.	Is a device with key 105 or 101
5.	……………HARD DISK DRIVE(HDD)	E.	Is a secondary storage device
		F.	Is a peripheral/device used to input file/document into a computer system
		G.	Is the base of modern computer
		H.	Loose data when power is cut off

PART A

Match the Terminologies in Column B with their respective definitions/meanings from Column A.

	COLUMN A	COLUMN B
1	______________ Correct grammar and spelling in word processing.	A) Line spacing
2	_________adjustment of text lines in the word processing.	B) Formatting toolbar
3	________ is at the top of the Microsoft excel window and it display files, edit, view etc.	C) Alignment text
4	_____________arrange text center ,middle, left side and right side in word processing.	D) menu bar
5	________used recall the information that was lost in word processing.	E) toolbar
		F) Spell checker
		G)Grammar correction
		H) Undo

PART B

Match the Terminologies in Column B with their respective definitions/meanings from Column A.

	COLUMN A	COLUMN B
1	______________ display the document name followed by the program name.	A) Status bar
2	_________contain shortcut buttons for the most popular commands.	B) Formatting toolbar
3	________ contains buttons used for formatting.	C) Standard tool bar
4	_____________used to views parts of the documents.	D) menu bar
5	________points the location where the next character appears.	E) Title bar
		F)Insertion point
		G)Scroll bars
		H) Status bar

PART 1

Match the definition of formula in Column B with the appropriate terms in Column A by writing the correct letter in the space provided (in column A).

COLUMN A

COLUMN B

1. .......................Count

2. .......................Average

3. .....................Depreciation Amount

4. ......................Time

5. ......................Hour

A. Returns the serial number of a particular time

B. Converts a serial number to an hour

C. Converts a serial number to a year

D. Counts the number of chosen data in a range of cells

E. Financial functions

F. Calculate the average range of cells

G. Calculate the range of columns

H. Accounting Package

PART A

Match the toolbar buttons in Column A with their corresponding answer in Column B

S/N	COLUMN A	ANSWERS	S/N	COLUMN B
1			A	Gives selected object a 3D effect.
2			B	Gives selected object some depth.
3			C	To select several objects hold down the Shift key and click on each object, or use the Select Objects tool
4			D	Changes the line style of a selected object.
5			E	Change the line color of a selected object.
			F	Fill color allow you to color all selected drawing objects. No fill is the color white.
			G	Changes the text color of a selected object.
			H	Fill color allow you to color all selected drawing objects. No fill is the color white.

PART B

Match the Terminologies in Column B with their respective definitions/meanings from Column A.

S/N	COLUMN A	ANSWERS	S/N	COLUMN B
1	Sentence case		A	All characters of the selected text will be converted to small letters
2	Lower case		B	All characters of the selected text will be converted to capital letters
3	Toggle case		C	The first character of every word of the selected text will be converted to upper case
4	Capitalize each word		D	First character of every sentence will be capitalized and remaining character will be unchanged
5	Upper case		E	All characters in lower case will be converted into upper case and all characters in upper case will be converted to lower case
			F	All character of the selected text will be converted to italic
			G	First character of every sentence will be converted into small and remaining character change to capital letter
			H	All characters of the selected text will be converted highlighted

PART I

Match the excel charts and graphs in Column A with corresponding Description in Column B by writing the correct letter in the space provided (in column A).

S/N	COLUMN A	ANSWERS	S/N	COLUMN B
1.	Pie Chart		A.	Input that identifies patterns, colour, or symbols associated with the ers of a chart data series
2.	Bar graph		B.	A symbol on the chart that represents a single value in the worksheet
3.	Line graph		C.	Everything within the chart window, including all parts of the worksheet.
4.	Histogram		D.	Compare discrete sets of data if one set of data doesn’t influence the other set of data.
5.	Chart area		E.	Represent the data that changes over a period of time
			F.	The circle graph that mostly represent in a demographics.
			G.	Represent the bins and the number of occurrence of a certain event.
			H.	A label or title that you add to the chart.

PART II

Match the Access data types in Column A with corresponding Description in Column B by writing the correct letter in the space provided (in column A).

S/N	COLUMN A	ANSWERS	S/N	COLUMN B
1.	OLE objects		A.	Used when inserting numbers in a table.
2.	Text		B.	Used when inserting numbers that follows order in ascending way.
3.	Lookup Wizard		C.	Used when snapping a picture in access.
4.	Auto number		D.	Used when inserting alphabetic in access.
5.	Memo		E.	Used when inserting pictures in access.
			F.	To create a drop down list.
			G.	To write comments in access
			H.	To keep memory in access

PART I

Match the definition of Excel issues in Column A with the appropriate outcome in Column B by writing the correct letter in the space provided (in column A)

S/N	COLUMN A	ANSWER	S/N	COLUMN B
1.	_____Cell reference		A	A
2.	_____Formula bar		B	N=k+1 sheet
3.	_____Row header		C	8.A
4.	_____Book 1		D	8
5.	_____Column header		E	F(x)
			F	A1
			G	1A

PART II

Match the definition of internet issues in Column A with the appropriate word in Column B by writing the correct letter in the space provided (in column A)

S/N	COLUMN A	ANSWER	S/N	COLUMN B
1.	_____Website		A	Are illegal programs that come onto computer through browsing from internet
2.	_____Authentication		B	The prevention of either the sender or the receiver denying a transmitted message
3.	_____Non-repudiation		C	Huge number of computer sharing resources
4.	_____Intranet		D	May be obtained by the prevision of a password or a scan of your retina
5.	_____Adware		E	Unauthorized writing or modification of information
			F	Information should be accessible and usable upon appropriate demand by an authorized user
			G	Is a page or collection of pages on the World Wide Web that contains specific information which was all provided by one person or entity and traces back to a common Uniform Resource Locator URL

PART I

Match the excel terminology in Column A with corresponding Description in Column B by writing the correct letter in the space provided (in column A).

S/N	COLUMN A	ANSWERS	S/N	COLUMN B
1.	Workbook		A.	Display information entered
2.	Worksheet		B.	Intersection of column and row
3.	Cell		C.	Show address of the current selected cell
4.	Formula Bar		D.	Spreadsheet
5.	Navigation Button		E.	Display the menu available
			F.	Shows in the workspace
			G.	Allow you to move to another worksheet
			H.	Display both name of application and name of spread sheet

PART II

Match the type of virus in Column A with their respective description from Column B.

S/N	COLUMN A	ANSWERS	S/N	COLUMN B
6.	Time bomb		I.	Clogging the system so that its operations are slowed down or stopped
7.	Trojan Horse		J.	Performs an activity when a certain action has occurred
8.	Logical Bomb		K.	Associated with application software
9.	Macros Virus		L.	Usually pretends as computer games
10.	Script Virus		M.	Virus program that performs an activity on a particular date
			N.	Virus program that performs an activity on a particular hour
			O.	Allow you to move to another worksheet
			P.	Written using the Visual Basic Scripting edition

SECTION D: SHORT ANSWER QUESTIONS (40 )

INSTRUCTIONS:

· This section consists of eight (8) questions.

· Write your answer on the Space provided

· Write a readable handwrite; DIRTY WORK IS DISCOURAGED

1. Outline five (5) functions of computer mouse (5)

2. Write the functions of the followings keyboard shortcut (5)

i. CTRL+X

ii. CTRL+H

iii. CTRL+Z

iv. CNTRL+P

v. CNTRL+I

3. Mention five (5) word processing cases (5)

4. List five (5) Microsoft power point presentation views features (5)

5. List five (5) Microsoft office power point illustration features (5)

5. List five (5) Microsoft office page setup features (5)

6. Write the long term of the followings computer terminology (5)

i. CD-R

ii. DVD-RW

iii. IBM

iv. USB

v. PC

7. Outline FIVE(5) program Keyboard shortcut (5 )

8. Outline FIVE(5) examples of Application Software (5 )

9. List FIVE(5) Microsoft office suit Package (5 )

10. Mention FIVE(5) examples of hardware parts of a computer system (5 )

11. List FIVE(5) Output Devices (5)

12. Numerate FIVE (5) basic operations of a mouse (5)

13. List FIVE(5) types of columns found in Microsoft Words (5 )

14. List FIVE(5) examples of electronic storage devices (5 )

1. Mention five types of internet connection. {5 }

a) ……………………………………………………….

b) ……………………………………………………….

c) ……………………………………………………….

d) ……………………………………………………….

e) ……………………………………………………….

2. Mention five(5) symptoms of Virus Attack {5 }

a) ……………………………………………………………………..

b) ……………………………………………………………………..

c) ……………………………………………………………………..

d) ……………………………………………………………………..

e) ……………………………………………………………………..

3. List Five (5) importance’s of Planned Preventive Maintenance {5 }

a) ………………………………………………………………………………………………..

b) ………………………………………………………………………………………………..

c) ………………………………………………………………………………………………..

d) ………………………………………………………………………………………………..

e) ………………………………………………………………………………………………..

4. Enumerate five (5) features that a computer security system provide {5 }

a) ………………………………………………………………..

b) ………………………………………………………………..

c) ………………………………………………………………..

d) ………………………………………………………………..

e) ………………………………………………………………..

5. List five (5) types of change case that are found in Microsoft word {5 }

a) ……………………………………………………………..

b) …………………………………………………………….

c) …………………………………………………………….

d) ………………………………………………………

e) ………………………………………………………

6. List five(5) importance’s of motherboard {5 }

a) ………………………………………………………………..

b) ……………………………………………………………….

c) ……………………………………………………………….

d) ……………………………………………………………….

e) ……………………………………………………………….

7. Mention five(5) input devices {5 }

a) ……………………………………………………………………………………………….

b) ………………………………………………………………………………………………

c) ………………………………………………………………………………………………

d) ………………………………………………………………………………………………

e) ……………………………………………………………………………………………..

8. Mention five(5) types of web browsers {5 }

a) …………………………………………………………………………………………….

b) ……………………………………………………………………………………………

c) …………………………………………………………………………………………….

d) …………………………………………………………………………………………….

e) …………………………………………………………………………………………….

9. Mentions 5 types of data type found in Microsoft Access.

a) ……………………………………………………………………….

b) ………………………………………………………………………..

c) ……………………………………………………………………….

d) …………………………………………………………………………

e) ………………………………………………………………………..

10. Mention 5 purpose of Microsoft Publisher.

a) ………………………………………………………………………………………………….

b) ……………………………………………………………………………………………………

c) ……………………………………………………………………………………………………

d) …………………………………………………………………………………………………..

e) …………………………………………………………………………………………………..

1. a. Define computer Bus (1 )

b. Mention four 4 types of a computer Buses (4 )

i. ………………………………………………..

ii. ………………………………………………..

iii. ………………………………………………..

iv. ………………………………………………..

2. (a) What is the computer Motherboard? (1 )

(b) State any four components found on the computer motherboard. (4 )

i. ………………………………………………

ii. ………………………………………………

iii. ………………………………………………

iv. ………………………………………………

v. ………………………………………………

3. Mention FIVE(5) devices that has the contribution of I/O functionality. (5 )

i. …………………………………………………….

ii. …………………………………………………….

iii. ……………………………………………………

iv. ……………………………………………………

v. ……………………………………………………

4. Briefly describe how each of the following I/O devices work.

i) Tracker ball. (0.5 )

ii) Touch screen. (0.5 )

iii) Light pen. (0.5 )

iv) Graphic (Digitizing) Tablet. (0.5 )

v) MICR. (0.5 )

vi) OCR. (0.5 )

vii) Speech (voice) recognition device. (1 )

viii) Speech (voice) Synthesizer. (1 )

5. Differentiate between:

i) Fixed and removable disks. (0.5 )

ii) Volatile memory and Non-volatile memory. (0.5 )

iii) Magnetic and Optical storage media. (0.5 )

iv) CD-ROM and Floppy disk. (0.5 )

v) Hardcopy and Softcopy. (0.5 )

6. (a) The diagram below represents the essential features of a computer system. Study the diagram and answer the questions that follow:

Name the components: (2 )

On the diagram above, indicate the direction of data flow-using arrows.

(b) Name the two types of buses in a computer system. (1 )

i. ..................................................................

ii. ………………………………………….

(c) Outline the CPU part thet may be used to carry out a basic calculation such as

2 + 7 = 9…………………………………. (1 )

(d) Name two computer output devices. (1 )

i. .................................................................

ii. ………………………………………….

7. (a)What is a computer keyboard? (1 )

(b) List four types of keys found on a computer keyboard. Give an example

of each. (4 )

i. …………………………………………………………….

ii. …………………………………………………………….

iii. …………………………………………………………….

iv. …………………………………………………………….

14. a)What is text wrap. (2 )

b) Explain three ways you can wrap-text an object. (3 )

i. ……………………………………………………….

ii. ……………………………………………………….

iii. ……………………………………………………….

15. The text in the box below was composed using a wordprocessor. The current cursor position is between the words “is” and “an”.

Computer security is an increasingly important

consideration. From authentication....

a. Describe what happens to the text in the box above when each of the following keyboard keys are pressed.

i. Tab (1 )

ii. Enter (1 )

iii. Home (1 )

b. Name two methods of paper orientation. (2 )

16. List five features of a word processor. (5 )

i. ……………………………………………..

ii. ……………………………………………..

iii. ……………………………………………..

iv. ……………………………………………..

v. ……………………………………………..

17. a. Explain the role/use of the following features in a word processor: (4 )

(a) Find and Replace.

(b) Undo and Redo.

(d) AutoCorrect.

b. Differentiate between bolding and highlighting text. (1 )

18. Define databackup (1 )

………………………………………………………………………………………………………

ii.Mention four (4) storage devices (4 )

i. ……………………………………………………….

ii. ……………………………………………………….

iii. ……………………………………………………….

iv. ………………………………………………………..

19. List FIVE(5) Microsoft office suit Package (5 )

i. ………………………………………………

ii. ………………………………………………

iii. ………………………………………………

iv. ………………………………………………

v. ………………………………………………

20. List five (5) skills of using the mouse(5 )

i. ……………………………………………………..

ii. ……………………………………………………..

iii. ……………………………………………………..

iv. ……………………………………………………..

v. ……………………………………………………..

21. The diagram below represents the role of operating system in a computer system. Use it to answer the questions that follow.

(a) Name the part labeled (1)

i) M- …………………………………………

ii) N………………………………………….

(b) Give TWO (2) example of label N (2 )

i. ………………………………………..

ii. ………………………………………..

(c) Classify TWO (2) types of program M (2 )

i. ……………………………………….

ii. ……………………………………….

22. Outline five (5) functions of computer mouse (5)

23. Write the functions of the followings keyboard shortcut (5)

vi. CTRL+X

vii. CTRL+H

viii. CTRL+Z

ix. CNTRL+P

x. CNTRL+I

27. Mention FIVE(5) examples of hardware parts of a computer system (5 )

i. ……………………………………………….

ii. ……………………………………………….

iii. ……………………………………………….

iv. ……………………………………………….

v. ………………………………………………..

28. List FIVE(5) Output Devices (5)

i. ………………………………………………….

ii. ………………………………………………….

iii. ………………………………………………….

iv. ………………………………………………….

v. ………………………………………………….

29. Numerate FIVE (5) basic operations of a mouse (5)

i. ……………………………………………………….

ii. ………………………………………………………..

iii. ………………………………………………………..

iv. ………………………………………………………..

v. ………………………………………………………..

30. List FIVE(5) types of columns found in Microsoft Words (5 )

i. ………………………………………………………

ii. ………………………………………………………

iii. ………………………………………………………

iv. ………………………………………………………

v. ……………………………………………………….

31. List FIVE(5) examples of electronic storage devices (5 )

i. ..................................................................................

ii. ……………………………………………………..

iii. ……………………………………………………..

iv. ……………………………………………………..

v. ……………………………………………………..

32. Mention five 5 input peripheral devices (5 )

i. ……………………………………………………..

ii. ………………………………………………………..

iii. ………………………………………………………...

iv. …………………………………………………………

v. …………………………………………………………

33. List five 5 examples of operating systems (5 )

i. …………………………………………………………

ii. …………………………………………………………

iii. ………………………………………………………….

iv. ………………………………………………………….

v. ………………………………………………………….

34. Mention five 5 types of a computer Hardware (5 )

i. ………………………………………………………..

ii. ………………………………………………………..

iii. ………………………………………………………...

iv. ………………………………………………………..

v. ………………………………………………………...

35. Mention five 5 elements of a word window (5 )

i. ………………………………………………………

ii. ………………………………………………………

iii. ………………………………………………………

iv. ………………………………………………………

v. ………………………………………………………

36. List five 5 tools used for storing software materials (5 )

i. ………………………………………………………

ii. ………………………………………………………

iii. ………………………………………………………

iv. ………………………………………………………

v. ………………………………………………………

37. Mention five 5 examples of a system software (5 )

i. ………………………………………………………

ii. ………………………………………………………

iii. ………………………………………………………

iv. ………………………………………………………

v. ………………………………………………………

38. Outline five 5 Title bars in Microsoft Office Word (5 )

i. ……………………………………………………

ii. ……………………………………………………

iii. …………………………………………………….

iv. …………………………………………………….

v. …………………………………………………….

39. a. Define Motherboard as used in computer terminology (1 )

b. List four 4 output peripheral devices connected to increase functionality performance (4 )

i. ………………………………………………………

ii. ………………………………………………………

iii. ………………………………………………………

iv. ………………………………………………………

40. Mention five 5 various computer application programs (5 )

i. ……………………………………………………….

ii. ………………………………………………………..

iii. ………………………………………………………..

iv. ………………………………………………………..

v. ………………………………………………………..

41. List five 5 parts of a CPU (5 )

i. ……………………………………………………….

ii. ……………………………………………………….

iii. ……………………………………………………….

iv. ……………………………………………………….

v. ………………………………………………………..

42. Mention five 5 types of text wrap in Microsoft Word (5 )

i. ………………………………………………………….

ii. ………………………………………………………….

iii. ………………………………………………………….

iv. ………………………………………………………….

v. ………………………………………………………….

43. Mention five 5 illustration in Microsoft Word (5 )

i. ………………………………………………………….

ii. …………………………………………………………

iii. …………………………………………………………

iv. …………………………………………………………

v. ………………………………………………………….

44. List five procedures on how to open and close computer machine (5 )

i. ………………………………………………………….

ii. ………………………………………………………….

iii. …………………………………………………………...

iv. …………………………………………………………….

v. ……………………………………………………………

45. Define the following concepts as used in Microsoft office (5 )

i. Font size

ii. Font style

iii. Line spacing

iv. Page Layout

v. Paragraph

vi. Font color

vii. Indenting

viii. Alignment

ix. Italicizing text

x. Bolding

46. Outline five 5 ways to manage folders and files (5 )

i. ……………………………………………………………

ii. ……………………………………………………………

iii. ……………………………………………………………

iv. ……………………………………………………………

v. ……………………………………………………………

47. a. Define term proofing as used in Microsoft Word (1 )

b. List four 4 work tools of proofing (4 )

i. ………………………………………………

ii. ………………………………………………

iii. ………………………………………………

iv. ………………………………………………

48. Outline five 5 uses of Microsoft Word (5 )

i. ……………………………………………………..

ii. ……………………………………………………..

iii. ……………………………………………………..

iv. ……………………………………………………..

v. ……………………………………………………..

49. Classify the following keyboard characters. (5 )

a) A, B, C ……..Z

b) 0, 1, 2 ………9

c) F1, F2 ……..F9

d) Del, Insert, Backspace

e) CTRL, SHIFT, ALT

50. Name following key symbols that are found in the keyboard. (5 )

i) …………………………………………..

ii) …………………………………………….

iii) ……………………………………

iv) ESC ………………………………………………………..

51. a. What is line spacing (1 )

b. Mention any four 4 line spacing in Word processing (4 )

i. ……………………………………………….

ii. ………………………………………………..

iii. ………………………………………………..

iv. ………………………………………………..

52. a. What is alignment as used in word processing (1 )

b. List four 4 paragraph formatting activities in word processing (4 )

i. …………………………………………………..

ii. …………………………………………………...

iii. …………………………………………………...

iv. ……………………………………………………

53. Distinguish between the following (5 )

a) Table in Word processing and Table in database

b) Mouse pointer and Insertion point

c) Subscript and Superscript

d) Bold and Highlighting

e) Copy text and Scrolling

54. Outline five 5 defference between RAM and ROM (5)

i. …………………………………………………………………………..

ii. …………………………………………………………………………..

iii. …………………………………………………………………………..

iv. …………………………………………………………………………..

v. …………………………………………………………………………..

11. Mention five(5) symptoms of Virus Attack {5 }

f) ……………………………………………………………………..

g) ……………………………………………………………………..

h) ……………………………………………………………………..

i) ……………………………………………………………………..

j) ……………………………………………………………………..

12. List five (5) types of change case that are found in Microsoft word {5 }

f) ……………………………………………………………..

g) …………………………………………………………….

h) …………………………………………………………….

i) ………………………………………………………

j) ………………………………………………………

13. Mentions 5 types of data type found in Microsoft Access. (5 )

f) ……………………………………………………………………….

g) ………………………………………………………………………..

h) ……………………………………………………………………….

i) …………………………………………………………………………

j) ………………………………………………………………………..

44. (i) What is a website? (1 )

(ii) Name three facilities that are needed to connect to the internet. (4 )

i. .........................................................................................

ii. ………………………………………………………….

iii. ………………………………………………………….

45. Describe the steps to follow in order to

i) Attach a file to an E-mail

(ii) Check an E-mail from internet.

46. (a) What is a Computer virus? (0.5 )

(b) Outline four symptoms of a virus infection in a computer system. (2 )

(b) State one damages which a computer virus may cause to a computer. (0.5 )

(c) Explain two control measures you would take to protect your computers from virus attacks. (2 )

47. State five possible ways of preventing data loss from a computer. (5 )

i. ………………………………………………………………

ii. ………………………………………………………………

iii. ……………………………………………………………….

iv. ……………………………………………………………….

v. ……………………………………………………………….

48. a. Define the term proofing as used in Word processing (1 )

b. List four 4 work tools of proofing (4 )

i. ………………………………………………………………….

ii. ………………………………………………………………….

iii. …………………………………………………………………..

iv. ……………………………………………………………………

49. Define the following terms (5 )

i. Internet

ii. Intranet

iii. Web page

iv. Website

v. Web browser

50. List five 5 types of internet connections (5 )

i. ……………………………………………………………………….

ii. ……………………………………………………………………….

iii. ……………………………………………………………………….

iv. ……………………………………………………………………….

v. ……………………………………………………………………….

51. Numerate five 5 impacts of computer virus (5 )

i. ………………………………………………………………………

ii. ………………………………………………………………………

iii. ………………………………………………………………………

iv. ………………………………………………………………………

v. ……………………………………………………………………..

52. Numerate five 5 symptoms of computer virus (5 )

i. ……………………………………………………………………..

ii. ……………………………………………………………………..

iii. ……………………………………………………………………..

iv. ……………………………………………………………………..

v. ………………………………………………………………………

53. Outline Internet communications tools (5 )

i. ……………………………………………………………………..

ii. ……………………………………………………………………..

iii. ……………………………………………………………………..

iv. ……………………………………………………………………..

v. ……………………………………………………………………..

54. Mention five data types found in Microsoft Excel (5 )

i. ……………………………………………………………………

ii. ……………………………………………………………………

iii. …………………………………………………………………..

iv. …………………………………………………………………..

v. …………………………………………………………………..

55. List five 5 types of virus and technical using to disturb computer system (5 )

i. ……………………………………………………………………………..

ii. ……………………………………………………………………………..

iii. ……………………………………………………………………………..

iv. ……………………………………………………………………………..

v. ……………………………………………………………………………..

56. Mention five 5 parts of E-mail (5 )

i. ………………………………………………………………

ii. ………………………………………………………………

iii. ………………………………………………………………

iv. ………………………………………………………………

v. ……………………………………………………………..

57. What do you understand by the following words (5 )

i. E-mail

ii. Video Conferencing

iii. Group Discussion

iv. Blind Carbon Copy

v. Carbon Copy

58. Outline ways to manage folders and file (5 )

i. …………………………………………………………………….

ii. …………………………………………………………………….

iii. …………………………………………………………………….

iv. …………………………………………………………………….

v. …………………………………………………………………….

59. Outline five 5 Menu bars of Microsoft Excel (5 )

i. ……………………………………………………………………………..

ii. ……………………………………………………………………………..

iii. ……………………………………………………………………………..

iv. ……………………………………………………………………………..

v. ……………………………………………………………………………..

60. Mention five 5 Menu bars in Access (5 )

i. ……………………………………………………………………………..

ii. ………………………………………………………………………………

iii. ………………………………………………………………………………

iv. ………………………………………………………………………………

v. ………………………………………………………………………………

61. Define the terminological terms used in Excel (5 )

i. ……………………………………………………………………………………………………………………………………………………..

ii. ……………………………………………………………………………………………………………………………………………………..

iii. ……………………………………………………………………………………………………………………………………………………..

iv. ……………………………………………………………………………………………………………………………………………………..

v. ……………………………………………………………………………………………………………………………………………………..

62. What do you understand about the following terminologies (5 )

i. Worksheet

ii. Workbook

iii. Active cell

iv. Function

v. Cell

63. a. Web (1 )

b. Mention three 3 advantages of Web (5 )

i. ………………………………………………………………………………………………………………………………………………..

ii. ………………………………………………………………………………………………………………………………………………..

iii. ……………………………………………………………………………………………………………………………………………….

64. Mention five kind of layout found in Microsoft Power point (5 )

i. ………………………………………………………………………….

ii. …………………………………………………………………………..

iii. …………………………………………………………………………..

iv. …………………………………………………………………………..

v. ……………………………………………………………………………

65. Mention five types of designs themes found in power point (5 )

i. …………………………………………………………………………

ii. …………………………………………………………………………

iii. …………………………………………………………………………

iv. …………………………………………………………………………

v. …………………………………………………………………………

66. Outline five kind of Transition found in Power point (5 )

i. ………………………………………………………………………..

ii. ………………………………………………………………………..

iii. ………………………………………………………………………..

iv. ………………………………………………………………………..

v. ………………………………………………………………………..

67. List out the steps to create a table in Access

i. ………………………………………………………………………..

ii. ………………………………………………………………………..

iii. ………………………………………………………………………..

iv. ………………………………………………………………………...

v. ………………………………………………………………………..

5. Worksheet cells are referenced using the column letter and row number e.g. D2 is cell in column D and row 2.

Use the sample worksheet provided to answer the questions below.

	A	B	C	D	E	F
1	Month	Jan.	Feb.	Mar.	April.	Total
2	Fees	460	460	460	460
3	Food	300	350	305	270
4	Electricity	100