Public Service Commission
Nepal Army, Technical, Internal / Open
Competitive Written Examination for Computer Post
1. The most common system
security method is
A) password
B) encryption
C) firewall
D) all of the above
2. The power specification
of USB is
A) 6 V
B) 5V
C) 9V
D) 12V
3. In MS-Word, the short
cut key to open a new document file is,
A) Alt + N
B) Ctrl + N
C) Shift + N
D) None of the above
4. Which of the following
is graphics solution for Word Processors?
A) Clipart
B) WordArt
C) Drop Cap
D) All of the above
5. When you want two
documents to view and edit simultaneously, how do you do?
A) View -> Side to
Side
B) Review > Side to
Side
C) View -> View
Side by Side
D) Review> View
Side by Side
6. What happens when we
click in the left margin beside a line in MS Word?
A) The entire line
gets left indented
B) The left margin is
adjusted
C) The entire
paragraph gets highlighted
D) The entire line
gets selected
7. Which feature is used
for monitoring all changes?
A) Edit Document
B) Monitor Changes
C) Track Changes
D) Track All
8. Text-styling feature of
MS Word is
A) Word Color
B) Word Font
C) Word Art
D) Word Fill
9. Which tool can the user
use to set indents or tabs?
A) Title bar
B) Insert
C) Toolbar
D) Ruler
10. If you need to change
the typeface of a document, which menu will you choose?
A) Edit
B) View
C) Format
D) Tools
11. How are footnotes,
endnotes and indexes inserted in a document?
A) As bookmarks
B) As cross-references
C) As hyperlinks
D) As word fields
12. Single spacing in MS
Word document causes..... point line spacing.
A) 10
B) 12
C) 14
D) 16
13. In MS Excel, the Fill
Handle is located at
A) bottom left corner
of a cell
B) bottom right corner
of a sheet
C) bottom right corner
of a cell
D) top right corner of
a cell
14. Which of the following
is not a valid data type in MS Excel?
A) Date
B) Time
C) Character
D) Fraction
15. How do you change
column width to fit the contents in MS Excel?
A) Single click the
boundary to the left of the column heading
B) Double click the
boundary to the right of the column heading
C) Press Alt and
single click anywhere in the column
D) All of the above
16. In goal seek, the 'by
changing cell' refers to the cell
A) containing the
outcome formula
B) containing the
constraints
C) that you are
attempting to calculate
D) containing the
target value
17. Macros are
"run" or executed from the....menu.
A) Insert
B) Format
C) Tools
D) Data
18. The short cut key to
display default chart for the selected range of data in excel sheet is
A) Ctrl + F1
B) Alt + F1
C) F11
D) Both B and C
19. When you link data
maintained in Excel workbook to a Word document, the Word document
A) cannot be edited
B) contains a
reference to the original source application
C) must contain a
hyperlink
D) contains a copy of
the actual data
20. Which function do you
use to return the remainder after a number is divided by a divisor?
A) ROUND ()
B) FACT ()
C) MOD ()
D) DIV ()
21.The correct syntax of
AND function in excel sheet is
A) =AND (Condition1,
Condition2)
B) = (Condition1 AND
Condition2)
C)= (Condition1
&& Condition2) E
D) None of the above
22. How can you insert
header or footer in MS Excel sheet?
A) Double clicking on
header or footer area and type
B) Using INSERT->
Header & Footer
C) Both A and B
D) None of the above
23. The slide that is used
to introduce a topic and set the tone for the presentation is called
the....slide.
A) Title
B) Bullet
C) Table
D) Graph
24. Which PowerPoint view
displays each slide of the presentation as a thumbnail and is useful for
rearranging slides?
A) Slide Master
B) Slide Show
C) Slide Sorter
D) Notes Page
25. The best way to insert
a new slide in a
A) Normal view
B) Special view
presentation is to use the
C) Slide show
view
D) Slide sorter view
26. If you want an
organization should include it on logo to be appeared on every slide in the
presentation, you
A) Slide Master
B) Design Template
C) Format Shape
D) None of the
above
27. Which of the following
file types can be added to any PowerPoint presentation slide?
A) Picture/Image
B) Audio/Video
C) Chart/Graph
D) All of the
above
28. In MS PowerPoint,
which of the following must be used with the mouse when you want to resize an image from the center and keep it
proportioned?
A) The space bar
B) The alt key
C) The ctrl key
D) The shift key
29. To start slide show of
a presentation
A) Hit F5 key
B) From Slide Show
menu choose View Show option
C) From Slide Show
menu choose Start
D) Both A and B
30. A special effect which
is used to introduce text or object serially using
mouse click or button in
PowerPoint slide is called
A) Animation
B) Transition
C) Design
D) None of above
31. Which of the following
tools enables you to add text to a slide without using the standard placeholders?
A) Text tool box
B) Line tool
C) Drawing tool
D) Auto shaped tool
32. To insert slide
numbers
A) Insert a text box
and select Insert -> Page Number
B) Insert a textbox
and select Insert Number-> Page Number
C) Choose Insert ->
Slide Number
D) Insert a new text
box and select Insert-> Slide Number
33. Database Management
System (DBMS) is
A) a collection of
data
B) a set of programs
to define database structure
C) a set of programs
to access and update those data
D) all of the above
34. Which of the following
database objects asks a question of information in a database and then displays the result?
A) Tables
B) Reports
C) Queries
D) Forms
35. In MS Access, table is
created using
A) Design view
B) Query
C) Datasheet view
D) All of the above
36. Referential integrity
means
A) Do not enter
a value in the foreign key field of a child table if that value does not exist
in the primary key of the parent table
B) Do not enter a
value in the primary key field of a child table if that value does not exist in
the primary key of the parent table
C) Do not enter a
value in the foreign key field of a parent table if that value does not exist
in the primary key of the child table
D) All of the
above
37. Which one of the
following commands is used for removing (or deleting) a relation from the SQL database?
A) Delete
B)Drop
C) Remove
D) All of the above
38. The following are
components of a database except
A) user data
B) meta data
C) reports
D) indexes
39. The correct syntax of
BETWEEN operator in MS Access is
A) BETWEEN (value1, value2)
B) BETWEEN (value] AND
value2)
C) BETWEEN value1 AND
value2
D) None of the above
40. What is the different
view to present a table?
A) Datasheet view
B) Design view
C) Pivot Table view
D) All of the above
41. What is a form in MS
Access?
A) It is a printed
page where users will write their data to fill it up
B) it is an input
screen designed to make viewing and entering data easier
C) This is an
important part of database used by analysts to draw conclusions
D) All of the above
42. Which is not one of
the sections of the form design window?
A) Form content
B) Form footer
C) Form header
D) Form detail
43. WAN stands for
A) WAP Area Network
B) Wide Area Network
C) Wide Array Net
D) Wireless Area
Network
44. Which of the following
is correct IPv4 address?
A)
124.201.3.1.52
B)
01.200.128.323
C) 300.142.210.54
D) 128.64.10.15
45. A secure computer
network which is setup for sharing information, operational systems and other computing services only within an
organization is called
A) E-mail
B) Internet
C) Intranet
D) Extranet
46. What is the default
subnet mask for a class C network?
A) 127.0.0.1
B) 255.0.0.0
C) 255.255.0.0
D) 255.255.255.0
47. In Computer network, nodes
are the computer that.... the data.
A) originates
B) routes
C) terminates
D) all of the above
48. What kind of
transmission medium is most appropriate to carry data in a computer network that is exposed to electrical
interferences?
A) Unshielded
twisted pair
B) Optical fiber
C) Coaxial cable
D) Microwave
49. Which of the following
statements is true in case of IP address?
A) IP address is an
internet path
B) Every computer must
have an IP address
C) IP is a unique
address of a computer connected to network
D) All of the above
50. Which of the following
devices is not a networking device?
A) Hub
B) Switch
C) Bridge
D) None of the above