Saturday, June 8, 2013

Computer Operator 2013

Public Service Commission Examination
Computer Operator
2013

1. A small or intelligent device is so called because it contains within it a [Q. 525 set 27]

a. Computer
b. Microcomputer
c. Programmable
d. Sensor
Correct Answer: Sensor

2. Each IP packet must contain

a. Only source address
b. Only destination address
c. Source and destination address
d. Source or destination address
Correct Answer: Source and destination address

3. The two basic types of record access methods are [Q. 510 Set 26]

a. Sequential and random
b. Sequential and indexed
c. Direct and immediate
d. Online and realtime
Correct Answer: Sequential and random

4. Which of the following memories needs refresh [Q 385 Set 20]

a. SRAM
b. DRAM
c. ROM
d. All of above
Correct Answer: DRAM

5. First Generation computers used to have processing speed in [Q. 402 Set 21]

a. Microsecond
b. Millisecond
c. Nanosecond
d. Picosecond
Correct Answer: Millisecond

6. USB stands for

a. Unique serial bus
b. Unique save data
c. Universal serial bus
d. Ultra serial bus
Correct Answer: Universal serial bus

7. Which of the following is an example of operating system

a. DOS
b. OS/2
c. Unix
d. All of Above
Correct Answer: All of above

8. Which one is not an output device

a. Printer
b. Keyboard
c. Monitor
d. None of above
Correct Answer: Keyboard

9. Which of the following looses its contents when the computer is turned off

a. RAM
b. ROM
c. PROM
d. All of above
Correct Answer: RAM

10. CPU consists of

a. ALU
b. CU
c. MU
d. All of above
Correct Answer: All of above
(Ref.   Introduction to Computer Systems)

11. What is the main objective of IT Policy  2000

a. To increase employment
b. To build knowledge based society
c. To established knowledge based indistry
d. All of the above
Correct Answer: All of the above

12. Which of the following is network topology [Networking Set 3]

a. BUS
b. Star
c. Both of above
d. None of above
Correct Answer: Both of above

13. WAN stands for [Q. 205 set 11]

a. Widely accessible network
b. Wide area network
c. Wire & network
d. Wire Accessible Network
Correct Answer: Wide Area Network

14. FAT and NTFS in Windows is type  of

a. Disk tool
b. Storage format
c. Internal windows command
d. Utilities
Correct Answer: Storage format

15. The principle of locality of reference justifies the use of

a. Virtual memory
b. Interrupts
c. Main memory
d. Cache memory
Correct Answer: Cache memory

16. Multi-tasking and multi-threading is used in

a. Windows XP
b. Windows 2000
c. Linux
d. All of above
Correct Answer: All of above

17. An approach that permits the computer to work on several programs instead of one is  [Q 146 Set 8]

a. On-line thesaurus
b. Multi-programming
c. Over lapped processing
d. Outline Processor
Correct Answer: Over lapped processing

18. While booting how many types of system files will load into RAM?

a. 2
b. 3
c. 4
d. 1
Correct Answer: 2
Explanation: io.sys and dos.sys

19. Which menu you have to click if you want to print a document

a. Edit
b. Format
c. File
d. View
Correct Answer: File

20. Which one of the following is short-cut key of cut?

a. Ctrl+x
b. Ctrl+v
c. Alt+x
d. Ctrl+c
Correct Answer: Ctrl+x

21. Alignment can be found inside the

a. Font
b. Background
c. Paragraph
d. Pagesetup
Correct Answer: Paragraph

22. From where do you install font?

a. Font icon of control panel
b. Font option of format menu
c. Options submenu of Tools menu
d. None of the above
Correct Answer: Font icon of control panel

23. Which one is not found in Edit menu

a. Find
b. Copy
c. Replace
d. Print
Correct Answer: Print

24. To change case, which menu you have to click?

a. File
b. Edit
c. View
d. Format
Correct Answer: Format

25. What is the file extension of MS Word document? [Q.5 Samsad 11]

a. Dot
b. Doc
c. Dom
d. Txt
Correct Answer: Doc

26. What is the shortcut key for thesaurus [Q.22 Lok 2012]

a. F7
b. Shift+F7
c. Ctrl+t
d. Alt+t
Correct Answer: Shift+F7

27. Electronic spreadsheet is also known as

a. Data processor
b. Word processor
c. Presentation package
d. None of above
Correct Answer: Data processor

28. The contents of a cell may also be edited by pressing

a. F1
b. F2
c. F3
d. F4
Correct Answer: F2

29. Which one of the following is the extension of Excel

a. Exl
b. Xcl
c. Xls
d. Exe
Correct Answer: Xls

30.  In order to add comment in cell one can use following steps

a. Edit -> Comment
b. Comment -> Edit
c. Insert -> Comment
d. Comment -> Insert
Correct Answer: Insert à Comment

31. Type of data in a cell of a worksheet can be of [Forum Discussion]

a. Label
b. Value
c. Formula
d. All of above
Correct Answer: All of above

32. What do you use to create a chart

a. Chart Wizard on toolbar
b. Insert -> chart on menubar
c. Insert -> Diagram on menubar
d. Both A & B
Correct Answer: Both A & B

33. Multiple calculation can be made in a single formula by using

a. Complex formul
b. Array formula
c. Composite formula
d. All of the above
Correct Answer: Array formula

34. How do you protect your Excel sheet?

a. Tool -> Option -> Password
b. Tool -> Protection -> Protect Sheet -> Password
c. Both A & B
d. None of the above
Correct Answer: Tool -> Protection -> Protect Sheet -> Password

35. Which of the following is not a database application

a. Excel
b. Access
c. My SQL
d. Oracle
Correct Answer: Excel

36. A row in a table is also known as

a. A record
b. A field
c. A data type
d. None of the above
Correct Answer: A record

37. Which of the following best describes a query

a. A query enables people to enter or view data in your database easily
b. A query summarizes of prints data
c. A query retrieves data that satisfies conditions that you set
d. All of the above
Correct Answer: A query retrieves data that satisfies conditions that you set
Updated: Thank you Roshan for pointing it out. Because the question is about Access query and Access query will allow you to do all of those things, I guessed the answer is  ’All of above’ but according to  Microsoft Page, the Option C is confirmed answer.

38. The query “SELECT * FROM employee ” returns

a. All rows from table employee
b. All rows from table employee where ‘*’character is present
c. All rows from employee starting from ‘*’
d. None of the above
Correct Answer: All rows from table employee

39. Instructions and memory are

a. Character code
b. Binary codes
c. Binary word
d. All of these
Correct Answer: Binary codes

40. In MS Access … presents data in a way similar to an excel spreadsheet [Q 20 Ope 2011]

a. Datasheet view
b. Design view
c. Print preview
d. Layout preview
Correct Answer: Datasheet view

41. A field that uniquely identifies a record is called a [Q 29 Samsad 2011]

a. Main field
b. Header
c. Key field
d. None of above
Correct Answer: Key field

42. …. is used to speed up data retrieval

a. Indexing
b. Speeding
c. Referencing
d. Listing
Correct Answer: Indexing

43. A …. Is the readymade styles that can be used for presentation in MS PowerPoint [Q 16 Byapar]

a. Auto style
b. Wizard
c. Pre-format
d. Template
Correct Answer: Template

44. To enter speaker’s comments one has to be in which view

a. Normal
b. Slide sorter
c. Slide show
d. Note page view
Correct Answer: Note page view (updated)

45. To use the same fonts & bullet styles on all your text slides you can

a. Set them on the slide master
b. Set them on the title master
c. Set them in the auto-content wizard
d. Select all of the slides thumbnails & use the formatting toolbar to set the fonts & bullets
Correct Answer: Set them on the slide master

46. The effect that looks like the new slide is pushing the old one off the screen is an example of a

a. Slide animation
b. Slide transition
c. Slide presentation
d. All of the above
Correct Answer: Slide transition

47. The MS PowerPoint save PowerPoint file as following extension [Q 34 COP 04]

a. .ptt
b. .ppt
c. .ppp
d. .ptp
Correct Answer: .ppt

48. What is the full form of ‘www’ in ‘www.gmail.com’

a. World Wide Web
b. World Wide Writing
c. Whole World Web
d. Wild Wild West
Correct Answer: World Wide Web

49. What is the correct tag to add a hyperlink in html page?

a. < a href=’Target’ > link text < /a >
b. < link src=’Source’ > link text
c. < a scr=’Target’ > link text < /a >
d. < a name=’Target’ > link text < /a >
Correct Answer: < a href=’Target’ > link text < /a >

50. To draw a horizontal line in html we use

a. < +r >
b. < hr >
c. < HL >
d. < lh >
Correct Answer: < hr >

                                  Public Service Commission
                                         Computer Operator
                                                      2009

Time: 1 hourF.M.: 50
Attempt all of the following questions. Each question carries equal marks.

Fill in the circle against the correct option in your answer sheet. Do not mark or write anything in question paper.

1. Which is not function of excel?
a. Not
b. Or
c. True
d. Ok

2. To append data:
a. Add record to the start of active database file
b. Add record to the start of active database file & start full screen
data entry
c. Add record to the end of active database file
d. Add record to the end of active database file

3. Right align the selected text is:
a. CTRL + R
b. CTRL + E
c. CTRL + J

4. Which command is used to create the NTFS and FAT file system?
a. Format
b. Chkdsk
c. Both of above
d. None of above

5. You can create new presentation by completing all of the
following except
a. Clicking the new button on the standard toolbar
b. Clicking file/new
c. Pressing CTRL + New
d. Clicking File/Open

6. Which of the following is WAN?
a. Internet
b. Intranet
c. Both of the above
d. None of the above

7. Compiler programmed used to:
a. A program which translate a program written is a high level
language into machine language program that can be understood by
the computer
b. A program which translate the statement of a high level language
into machine codes.
c. Both of the above
d. None of above

8. Which of the following is multi functions?
a. *
b. /
c. ^
d. Both of the above

9. Which ofthe following is Condition Formula?
a. IF
b. AND
c. AVERAGE
d. All of above

10. Function of computer is:
a. Searching Internet
b. Creating document
c. Fasting work
d. All of above

11. DBMS is
a. Database Management Systems
b. Store data base data
c. Reporting data
d. All of above

12. Which short cut key is used to update the data?
a. F10
b. F9
c. F11
d. None of above

13. Material consisting of text and number is best presented as:
a. A table slide
a. A bullet slide
c. A title slide
d. All of the above

14. You can use a function to combine text from two cells into one
cell. You can use an operator to do the same thing
a. $
b. ^
c. /
d. @

15. Which command is used to make a directory?
a. dir
b. md
c. cd
d. None of above

16. Function of antivirus is
a. To protect document
b. To save the system files of computer
c. Both of the above
d. None of above

17. Which of the following is subscript?
a. a2b2
b. H2O
c. Both of the above
d. None of above

18. Which of the following is input output device?
a. Modem
b. Sound Box
c. Monitor
d. Mouse0102-01 [PS0102]

19. Heart of computer is:
a. RAM
b. CPU
c. Hard Disk
d. DVD Disk

20. Which of the following is an option in Print in Ms-Word?
a. Collate
b. Page per sheet
c. Scale to paper size
d. All of above

21. In Microsoft PowerPoint two kinds of sound effects files that can
be added to the presentation are:
a. .wav files and .mid files
b. .wav files and .gif files
c. .wav files and .jpg files
d. .jpg files and .gif files

22. Read/Write function of memory is
a. RAM
b. ROM
c. Both of the above
d. None of above

23. Which Program is written by manufacturer Companies is called?
a. RAM
b. ROM
c. CDROM
d. None of above

24. Which command is used to fix error of disk?
a. Scandisk
b. Chdksk
c. Disk Clean Up
d. Disk copy

25. Which attribute is used to bold the text of HTML?
a. <b> text </b>
b. <Bold>text</Bold>
c. Both of the above
d. None of above

26. Performance of OS is
a.Overall management of computer
b. Communication between computer and human
c. Both of the above
d. None of above

27. Board related to chip
a. Daughter Board
b. Grand Mother Board
c. Mother Board
d. None of above

28. Type of operating system is:
a. single user operating system
b. Multi user operating system
c. Both of the above
d. None of above

29. Two component of table is:
a. Relationship & database
b. Database and design report
c. Design report and design form
d. All of the above

30. To edit chart
a. Double click on chart
b. Click on chart wizard options form standard toolbar
c. Both of the above
d. None of above

31. To activate cell
a. Select cell
b. Pressing ctrl key
c. Both of the above
d. None of above

32. Analog and digital computer
a. Continuous scale and discontinuous scale
b. Speedometer and IBM PC.
c. Both of the above
d. None of above

33. The full form of RTF is
a. Relation Table format
b. Rich Text Format
c. Rich Table Format
d. ROM Time Format

34.Which shortcut key is used to search the entire files, folder?
a. Win key + F
b. F3
c. Start/Search/For files or folders
d. All of above

35. Microsoft Office Assistance is:
a. Animated
b. Close document
c. Both of the above
d. None of above

36. To add two cells (A1 and A2) together you use the following
formula?
a. =a1 + a2
b. Add(a1+a2)
c. =together(a1:a2)
d. a1+a2

37. To shutdown a computer we can use the following command is:
a. Start/Shutdown/Shutdown
b. Click on close
c. Both of the above
d. None of above

38. The multiplication arithmetic operator is represented by which if
the following symbols?
a. ^
b. *
c. &
d. /

39. To add a new record in database we use:
a. Append record from browse menu
b. Append record from file menu
c. Add record from edit menu
d. All of above

40. A database that contains table linked by common fields is called
a
a. Centralize database
b. Flat file database
c. Relational database
d. None of above

41. DBMS is
a. Collection of data
b. Set of programs to access those data
c. Set of program to update those data
d. All of above

42. The raw facts are called
a. data
b. programs
c. commands
d. responses

43. Except for the …..function a formula with a logical function shows
the result
a. IF
b. AND
c. OR
d. all of the above

44. You can print
a. A range of cell by range name
b. An entire worksheet
c. A single work sheet
d. All of above

45. Which picture file format can be added to a PowerPoint show?
a. jpg
b. gif
c. Both of the above
d. None of above

46. You can insert only a horizontal page break by first selecting
a. A row belowthe row where you want to the page break to occur
b. A cell in row 1
c. A cell in column A
d. both (a) and (c)

47. Which command is used to hide, read only etc of the file?
a. EDIT
b. ATTRIB
c. FC
d. None of above

48. Faster memory is:
a. Cache memory
b. Flash memory
c. Both of the above
d. None of above

                                                              Sample Answer Sheet
                                                            For Computer Operator
Following are the correct answers of the Question Paper PS0102-01. Trace against the answer sheet and verify if they matches. Correct
answers are awarded +1 mark each and wrong answers with -0.25

1. Ans: d
2. Ans : d
3. Ans : a
4. Ans : d
5. Ans : c
6. Ans : c
7. Ans : a
8. Ans : d
9. Ans : d
10. Ans : d
11. Ans : d
12. Ans : b
13. Ans : a
14. Ans : a
15. Ans : b
16. Ans : c
17. Ans : b
18. Ans : a
19. Ans : b
20. Ans : d
21. Ans : a
22. Ans : a
23. Ans : b
24. Ans : a
25. Ans : a
26. Ans : c
27. Ans : c
28. Ans : c
29. Ans : a
30. Ans : c
31. Ans : a
32. Ans : c
33. Ans : b
34. Ans : d
35. Ans : a
36. Ans : a
37. Ans : a
38. Ans : b
39. Ans : a
40. Ans : c
41. Ans : d
42. Ans : a
43. Ans : d
44. Ans : d
45. Ans : c
46. Ans : d
47. Ans : b
48. Ans : a
49. Ans :
50. Ans : 

Microsoft Word Multiple Choice Questions for Objective Exams

1. Which of the following command lets you set the vertical alignment?
1. Page Setup command from File menu
2. Page Setup command from Format menu
3. Paragraph command from Format menu
4. Font command from Format menu
Correct Answer: ans1
Explanation:
Layout tab of Page Setup dialog box contains options to set up vertical alignment.
Page setup Dialog Box with Layout Tab fronted
Page Setup Dialog Box Layout Tab
2. Minimum zoom percentage suppported by MS Word is
1. 10%
2. 15%
3. 25%
4. 4%
Correct Answer: ans1
Explanation:
Microsoft Word supports minimum 10% zoom.
Zoom List in MS Word
Zoom box in Microsoft Word
3. You can break the column by
1. Pressing Ctrl + Shift + Enter
2. Pressing Ctrl + Enter
3. Pressing Shift + Enter
4. Pressing Alt + Enter
Correct Answer: ans1
Explanation:
Column break can be inserted by pressing Ctrl+Shift+Enter. If you press Ctrl+Enter, it will insert page break and Shift+Enter will insert line break.
4. In MS Word you can insert hyperlink by
1. Pressing Ctrl+K or by choosing Hyperlink from Insert menu.
2. Pressing Ctrl+Shift+K or by choosing Hyperlink from Insert menu
3. Pressing Ctrl+K or by choosing Hyperlink from Format menu
4. Pressing Ctrl+Shift+K or by choosing Hyperlink from Format menu
Correct Answer: ans1
Explanation:
A hyperlink can be inserted by pressing Ctrl+K or choosing Insert >> Hyperlink.
5. The default lines to drop for drop cap is
1. 3 lines
2. 2 lines
3. 4 lines
4. 8 lines
Correct Answer: ans1
Explanation:
The default lines to drop for a drop cap is 3. Minimum lines to drop is 1 and maximum is 10 lines.

Drop Cap Dialog Box with Default Values

Drop Cap Dialog Box
6. The red wave underline in MS Word document indicates
1. Spelling errors
2. Grammar errors
3. Address block
4. None of these
Correct Answer: ans1
Explanation:
Spelling errors in a document is marked with red wave underline. Grammar errors are pointed out with green wave underline.
See the example below
Example of spelling error
7. In word-processing the task of changing the appearance of a document is
1. Formatting
2. Editing
3. Proofing
4. Inserting
Correct Answer: ans1
Explanation:
The task of changing appearance of a document is formatting
8. Which bar is usually located below the title bar that provides categorized options
1. Menu Bar
2. Tool Bar
3. Status Bar
4. Scroll Bar
Correct Answer: ans1
Explanation:
Menu Bar is usually located below the title bar. It contains the categorized options of an application.
MS Word Screen
MS Word Window Screen with Labels
Image Source: Exploring the Word Interface
9. Which of the following option is not in Insert menu?
1. Header and Footer
2. Footnote
3. Bookmark
4. Hyperlink
Correct Answer: ans1
Explanation:
Header and Footer is in View menu no in Insert.
Insert Menu in MS Word
Insert Menu
Image Source:The Insert Menu in Microsoft Word
10. Text boundary can be turned on and off from
1. Autotext from Insert menu
2. View tab on Options dialogue box
3. Text Boundary option from Tools menu
4. None of these
Correct Answer: ans2
Explanation:
Text boundary can be turned on and off from the View tab on Options dialogue box. Mark or clear the check box ‘Text Boundary’ under Print and Web Layout group in View tab of Options dialogue box.
View Tab of Options Dialogue Box
View Tab of Options Dialog Box
11. Which input device is not suitable to work with MS Word?
1. Keyboard
2. Mouse
3. Light Pen
4. Joystick
Correct Answer: ans4
Explanation:
Joystick is popularly used for gaming and is not suitable for word-processing tasks.
Joystick
Joystick
Image Source: Wikimedia
12. The insertion point in a table can be moved by using
1. Tab key
2. Shift + Tab key
3. Arrow keys
4. All of above
Correct Answer: ans4
Explanation:
All of the given keys Tab, Shift Tab, Arrow Keys can be used to move insertion point among cells in a table.
13. The four types of mail merge main document in MS Word are
1. Form letters, directories, catalogues and envelopes
2. Form letters, envelops and mailing labels, directories, and lists
3. Basic letters, envelopes, labels and lists
4. Form letters, envelopes, mailing labels, and directory.
Correct Answer: ans4
Explanation:
MS Word mail merge provides letters, envelopes, labels and directory as different types of main document.
Mail Merge Main Document Types
Mail Merge Main Document Types
Image Source: Mail Merge Labels in Microsoft Word
14. The word wrap features
1. automatically move text to the next line when necessary
2. appears at the bottom of the document
3. allows you to type over text
4. is the short horizontal line indicating the end of document
Correct Answer: ans1
Explanation:
The word wrap feature of wordprocessing applications moves text automatically to the next line when necessary.
Word wrap is the automatic breaking of text across lines. This feature is used to wrap text around a text box or a picture. Here, the text in a line automatically moves to the next line when its length exceeds the position of the right indent marker.
Read more about wordwrap Word Tutorial – Wordwrap in Word
15. Which page orientation you will select if you wish to print in wide format?
1. Landscape
2. Portrait
3. Horizontal
4. Vertical
Correct Answer: ans1
Explanation:
Landscape page orientation is suitable to print in wide format.
Page Setup Dialog Box to change page orientation
Page Setup Dialogbox to change page orientation
The default page orientation in Word is Portrait mode, and most of the time this is how you are going to want to set up your documents. Simply put, Portrait mode means the page is longer than it is wide. Sometimes, however, when you are working with charts or when you’re creating something like fliers, you’ll want to turn the page so the horizontal edge is longer than the vertical edge. Fortunately, Word makes it easy to switch to Landscape mode.
Continue Tutorial in About.com
16. You can use different page format within the same document by separating the differently formatted area with a
1. Section break
2. Document break
3. Line break
4. Format break
Correct Answer: ans1
Explanation:
Section Break lets you to apply different page format for different parts of a document.
When you start a document, there are no section breaks because the entire document consists of one section. A section break is the point at which you end one section and begin another because you want some aspect of page formatting to change.
You can divide a document into any number of sections and format each section the way that you want. Throughout this article, keep in mind that a section break acts as an embedded code that stores or maintains the properties of the section above it.
Follow this nice article about section break
17. To repeat the table heading in every page
1. From Table menu choose Row Height and Column Width
2. From Table menu choose Properties
3. From Table menu choose the Sort
4. From Table menu choose Heading Rows Repeat
Correct Answer: ans4
Explanation:
To repeat the table heading in every page From Table menu choose Repeat Row Heading.
Repeat Heading RowsSometimes, what seems to be a difficult problem has an easy built-in solution. I ran into that recently with a Word table that was several pages long. Of course, I wanted to repeat the table’s header row at the top of each page. That way, readers didn’t have to return to the table’s first page to learn what type of data was in a particular column. I had to stop and think for a minute, as I couldn’t remember ever doing this before.
Customized menus make it easy to miss built-in features. If you don’t use the item occasionally, Word doesn’t display the item on the menu! It’s less than intuitive, but I went back to the Table menu and clicked the double arrow to display all the menu items and there it was — Heading Rows Repeat.
To use this feature, simply click inside the header row and choose Heading Rows Repeat from the Table menu. It couldn’t be simpler. Word then displays the heading row at the top of every page as long as the table continues.
18. Which shortcut keys you will use to select all the text after current cursor position?
1. Shift + End
2. Ctrl + Shift + End
3. Ctrl + End
4. Ctrl + Shift + PageDown
Correct Answer: ans2
Explanation:
Ctrl + shift + End key selects all the text after current cursor position.
19. Which of the following is not a type of tab stop?
1. Bar
2. Decimal
3. Point
4. Left
Correct Answer: ans3
Explanation:
Point is not a type of tab stop. Please refer the image below:
20. To set equal width for columns we select
1. Equal Column Width from Table menu
2. Equal Width from Table menu
3. Columns from Format menu
4. Distribute Columns Evenly
Correct Answer: ans4
Explanation:
Distribute Columns Evenly option from Autofit option of Table menu can set equal width for columns. Please refer the image below:
Table Menu