Monday, November 28, 2011

Computer Operator Examination 2011


Question Paper


Public Service Commission



Non-Gazetted First Class, Miscellaneous Service, Competitive  written Examination of Computer Operator/Data Entry Supervisor


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. W hich 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. W hich is an example of a formula in MS Excel?


1.     Sum(A1:A2)

2.     =A1+A2

3.     =add(A1:A2)

4.     A1+A2


7. It is possible to display pictures in HTML specification by using the key:


1.     <Gif src=picture file>

2.     <GR src=picture File>

3.     <PIC src=picture file>

4.     <IMG src=Picture file>

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. W hich of the following is a popular DOS based spreadsheet package?


1.     Lotus 1-2-3

2.     W ord

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. W hich 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.     W orksheets and charts

2.     W orkbook

3.     W orksheets

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. W hat 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 fi t

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. W here form you can insert shapes in your slide


1.     Animations menu

2.     Format menu

3.     Design menu

4.     All of the above


22. W hich 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. W hich of the following is a read only memory storage device?


1.     Magnetic tape

2.     Floppy disk

3.     Compact disk

4.     Hard disk


28. W hat do you call the translator which takes high level language program as input & produce machine language code as outpu t?


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. W hat 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.     W orkers

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. W hich of the following device is used only in LAN (local area network)?


1.     Router

2.     Gateway

3.     Modem

4.     NIC


37. W hich 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. W hen 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. W hich 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. W hich of the following operating system does not implement multitasking truly?


1.     MS DOS

2.     Windows 98

3.     Windows NT

4.     Windows XP


42. W hich 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.     W ord-processing software

2.     Communication

3.     Application

4.     System


45. W hich 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-W ord, 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


50. W hich page orientation you will select if you wish to print in wide format


1.     Vertical

2.     Landscape

3.     Portrait

4.     Horizontal


[Note: The options 1,2,3 & 4 are A, B, C & D respectively in question paper.]

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 are not on the options. So none of above is correct answer}
5 – C Column F row 5
6 – B - =A1+A2
7 – D <IMG src=Picture file>
8 – D - =NOW ()
9 C Cell B7 through B9
     10 B – An absolute cell address is created
11 A – A group of W orkbook
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 W indows 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
     50 – B Landscape


No comments:

Post a Comment

Dear Reader, if you like My Blog content, feel free to comment on our blog posts.