1. The insertion point in a table can be moved by using:

1.     Arrows keys

2.     Tab key

3.     Shift+tab key

4.     All of the above

2. Which bar is usually located below the title bar that provides categorized options?

1.     Scroll bar

2.     Menu bar

3.     Tool bar

4.     Status bar

3. Mail merge is concerned with:

1.     To split main document

2.     Combining main document with data file

3.     Sending a typed letter to share holder of a company

4.     None of the above

4. The thesaurus tool

1.     Corrects two initial capitalized letters in a word

2.     Find repeated words in the document

3.     Adds new words to the custom dictionary

4.     None of the above

5. The cell level F5 refers to:

1.     Function key F5

2.     Row F column 5

3.     Column F rows 5

4.     Function available in cell

6. Which is an example of a formula in MS Excel?

1.     Sum(A1:A2)

2.     =A1+A2

3.     =add(A1:A2)

4.     A1+A2

7. Which page orientation you will select if you wish to print in wide format

1.     Vertical

2.     Landscape

3.     Portrait

4.     Horizontal

8. How do you display current date and time in MS Excel?

1.     Time()

2.     Date()

3.     Today()

4.     Now()

9. In MS-Excel B7:B9 indicates:

1.     Cell B8 only

2.     Cell B7 and B9 only

3.     Cell B7 through B9

4.     None of the above

10. In MS Excel, what happens when dollar sign ($) are entered in a cell address? (ex: $B$2 : $B$10)

1.     The status bar does not display the cell address

2.     An absolute cell address in created

3.     Cell address will change when it is copied to another cell

4.     The sheet tab is changed

11. In Ms Excel, what do you mean by a workspace?

1.     Group of workbook

2.     Group of columns

3.     Group of worksheets

4.     Group of rows

 

12. Which of the following is a popular DOS based spreadsheet package?

1.     Lotus 1-2-3

2.     Word

3.     Smart cell

4.     Excel

13. The intersection of a row and column is called:

1.     An equation

2.     Data

3.     A field

4.     A cell

14. Which operator will combine text from two cells into one cell?

1.     Space

2.     & (ampersand)

3.     = (equal)

4.     None of the above

15. An excel workbook is a collection of:

1.     Worksheets and charts

2.     Workbook

3.     Worksheets

4.     Charts

16. Database that contains table linked by common field is called a

1.     Relational database

2.     Centralized database

3.     Flat file database

4.     None of above

17. DBMS is:

1.     Set of programs to update those data

2.     Collection of data

3.     Set of programs to access those data

4.     All of the above

18. What term refers to a collection of related information?

1.     Record

2.     Database

3.     List

4.     Outline

19. A DBMS allows you to create and maintain a database, create reports, and develop application programs, select the best fit answer:

1.     Query language

2.     Database management approach

3.     DBBMS uses

4.     Database administrator

20. …………………. Presents data in a way similar to an excel spreadsheet.

1.     Layout preview

2.     Datasheet view

3.     Design view

4.     Print preview

21. Where form you can insert shapes in your slide

1.     Animations menu

2.     Format menu

3.     Design menu

4.     All of the above

22. Which key used for slide show from beginning

1.     F9

2.     F1

3.     F2

4.     F5

 

23. Page setup for slides is available on:

1.     View menu

2.     Home menu

3.     Design menu

4.     Insert menu

24. A world wide web contains web pages:

1.     Residing In many computers linked together using HTML

2.     Residing in many computers

3.     Created using HTML

4.     With links to other web pages

25. A web page is located using a

1.     Uniformly reachable links

2.     Universal record linking

3.     Uniform resource locater

4.     Universal record locater

26. FORTRAN programming language is more suitable for…..

1.     Data base application

2.     Business application

3.     Marketing applications

4.     Scientific applications

27. Which of the following is a read only memory storage device?

1.     Magnetic tape

2.     Floppy disk

3.     Compact disk

4.     Hard disk

28. What do you call the translator which takes high level language program as input & produce machine language code as output?

1.     Assembler

2.     Compiler

3.     Interpreter

4.     Debugger

29. The program which is as permanent as hardware & stored in ROM is known as:

1.     Live ware

2.     Hardware

3.     Software

4.     Firmware

30. What is the first stage in software development?

1.     Writing program codes

2.     Specification and design

3.     Testing

4.     System analysis

31. MIS is designed for ….

1.     Managers

2.     Consumers

3.     Workers

4.     End users

32. How many pair cables does RJ45 UTP cable have?

1.     5 pair

2.     2 pair

3.     3 pair

4.     4 pair

33. How was the generation of computer classified?

1.     By the model of the computer

2.     By the device used in memory & processor

3.     By the time period

4.     None of the above

34. Through which device do the main components of the computer communicate with each other?

1.     Memory

2.     Keyboard

3.     System bus

4.     Monitor

35. The digital signals can be represented by

1.     High and low

2.     Binary codes

3.     0 and 1

4.     All of the above

36. Which of the following device is used only in LAN (local area network)?

1.     Router

2.     Gateway

3.     Modem

4.     NIC

37. Which of the following cables can transmit data at high speed?

1.     UTP cable

2.     Coaxial cable

3.     Optic fiber cable

4.     Twisted pair cable

38. When a computer is first turned on or restarted, a special type of absolute loader called is executed?

1.     Relating loader

2.     Compile loader

3.     Boot loader

4.     Bootstrap loader

39. Which among the following are the best tool for fixing errors on disks?

1.     FIXDSK

2.     FDISK

3.     SCANDISK

4.     CHKDSK

40. ……. Runs on a computer hardware and serve as platform for other software to run on.

1.     System software

2.     Operating system

3.     Application software

4.     All of the above

41. Which of the following operating system does not implement multitasking truly?

1.     MS DOS

2.     Windows 98

3.     Windows NT

4.     Windows XP

42. Which of the following operating system do you choose to implement a client-server network?

1.     Windows 2000

2.     MS DOS

3.     Windows 95

4.     Windows 98

43. The operating system manages:

1.     Disk and I/O devices

2.     Memory

3.     Processes

4.     All of the above

44. The operating system is the most common type of ……. Software

1.     Word-processing software

2.     Communication

3.     Application

4.     System

45. Which of the following do you use to change margins?

1.     Paragraph dialog box

2.     Formatting toolbar

3.     Page setup dialog box

4.     Standard toolbar

46. In word-processing the task of changing the appearance of a document is:

1.     Inserting

2.     Formatting

3.     Editing

4.     Proofing

47. In MS-Word, you can insert the hyperlink:

1.     Pressing ctrl+k or by choosing hyperlink from format menu

2.     Pressing ctrl+k or by choosing hyperlink form insert menu

3.     Pressing ctrl+shift+k or by choosing hyperlink insert menu

4.     Pressing ctrl+k or choosing hyperlink from format menu

48. You can break the column by:

1.     Pressing alt+enter

2.     Pressing ctrl+shift+enter

3.     Pressing ctrl+enter

4.     Pressing shift+enter

49. In MS-word, you can convert the documents file format by applying the command:

1.     Convert

2.     Save

3.     Permission

4.     Save as

Correct Answers

1 – D – All of above

2 – B – Menu bar

3 – B – Combining main document with data file

4 – D – None of the above { Thesaurus does not find repeated words nor the other two options. It displays the synonyms or antonyms which is not on the options. So none of above is correct answer}

5 – C – Column F row 5

6 – B – =A1+A2

7 – B – Landscape

8 – D – =NOW()

9 – C – Cell B7 through B9

10 – B – An absolute cell address is created

11 – A – A group of Workbook

12 – A – Lotus 1-2-3

13 – D – A cell

14 – B – & (Ampersand)

15 – A – worksheets and charts

16 – A – Relational database

17 – D – All of above {DBMS is the integration of databases and applications to manipulate that database}

18 – B – Database

19 – D – Database Administrator

20 – B – Datasheet View

21 – No correct answer. Insert Shapes is available in Insert menu or Home menu (Ribbons). There is no format ribbon and in Animations or Design, there is not Insert Shapes command available.

22 – D – F5

23 – C – Design menu

24 – A – Residing In many computers linked together using HTML

25 – C – Uniform Resource Locator

26 – D – Scientific Applications

27 – C – Compact Disk

28 – B – Compiler

29 – D – Firmware

30 – D – System analysis

31 – A – Managers

32 – D – 4 pair

33 – B – By the device used in memory & processor

34 – C – System Bus

35 – D – All of above {high/low, binary codes, 0/1 are all same thing}

36 – D – NIC

37 – C – Optical fiber cables

38 – D – Bootstrap loader

39 – C – Scandisk

40 – B – Operating System

41 – A – MS DOS

42 – A – Windows 2000

43 – D – All of above

44 – D – System software

45 – C – Page Setup Dialog Box

46 – B – Formatting

47 – A – Pressing Ctrl+K or by choosing hyperlink from format menu

48 – B – Ctrl+Shift+Enter

49 – D – Save As