Public Service Commission
Nepal Police, Engineering
(Information
Technology / Computer),
Open Competitive Written Examination for the post of
Technical Police Deputy Inspector 2078/09/24
1. Comments can be added to cells using
A) Edit -Comments
B) File -Comments
C)Insert -Comments
D) View -Comments
2. What is the correct syntax to make a number in any cell 13% more than the number in cell A1?
A) =A1*1.13
B) =A1+A1%13
C)=A1+A1*0.87
D) Both A and B
3. A tool button used for summing large range of data in MS Excel
A) Auto Sum
B) Auto Fill
C) Auto Format
D) Auto Correct
4. The cell reference for cell range of G2 to M12 is
A) G2:M12
B) G2;M12
C) G2'M12
D) G2,M12
5. The 'IF' function in Excel check a
A) which number is greater
B) Two numbers are equal or not
C) whether a condition is true or not
D) none of the above
6. Macros are "run" or executed from the ........menu
A) Insert
B) Format
C) Tools
D) Date
7. What function displays row data in column or column data in a row?
A) Hyperlink
B) Index
C) Transpose
D) Rows
8. Which of the following tools will you use in Excel to see what must be the value of a cell to get required result?
A) Formula Auditing
B) Research
C) Track Change
D) Goal Seek
9. When you insert an Excel file into a Word document, the data are
A) Hyperlinked
B) Placed in word table
C) Linked
D) Embedded
10. Which of the following is not the data type in MS-Access?
A) Number
B) Date
C) Text
D) Identifier
11. Which of the following database objects asks a question of information in database and then displays the result?
A) Tables
B) Reports
C) Queries
D) Form
12. Related fields in a database are grouped to form a
A) Data file
B) Data record
C) Menu
D) Bank
13. In MS Access rows and columns are technically called .......respectively.
A) Records and Fields
B) Tuples and Attributes
C) Records and Tuples
D) Attribute and Field
14. The tables in relational database are linked according to
A) Hierarchy
B) Inheritance
C) Relationship
D) Dependency
15. Which of the following powerpoint features will be used to apply motion effect to different objects of a slide?
A) Slide Transition
B) Slide Design
C) Motion Effect
D) Animation schema
16. What lets you create new presentation by selecting ready-made font color and graphics effects?
A) Presentation template
B) Master slide
C) Design template
D) Animation Scheme
17. Which of the following sections does not exist in a slide layout?
A) Lists
B) Titles
C) Animations
D) Chart
18. Which of the following HTML code is valid?
A) <font colour="red">
B)<font color="red">
C) <red><font>
D) all of the above
19. How will you create an ordered list (a list with the list items in numbers) in HTML?
A) <ul>
B)<ol>
C) <i>
D) <u>
20. The correct HTML for inserting an image is
A) <IMG SRC="Image.gif">
B) <IMAGE SRC="image.gif">
C) <IMG SOURCE = "Image.gif">
D) <IMG HREF="Image.gif">
21. What is the name of the application program that gathers user information and sends it to someone through the Internet?
A) A virus
B) Spybot
C) Logic bomb
D) Security patch
22. Which of the following technology is used in 2nd generation computer?
A) Magnetic Tape
B) Integrated Circuit
C) Transistors
D) Vacuum Tube
23. If there is a page you visit frequently, you can access it more quickly by
A) saving it as a favorite/bookmark
B) typing the URL into the search bar
C) searching for it on Google
D) going to another page that links to it
24. All of the following are examples of real security and privacy risks except
A) hackers
B) spam
C) viruses
D) identity theft
25. Maximum distance in a network is 500 meters. The network is closely classified as
A) LAN
B) WAN
C) Intranet
D) MAN
26. Which of the following programming language uses mnemonics?
A) Machine language
B) Assembly language
C) High level language
D) Natural Language
27. RISC stands for
A) Reduced Image Set Computer
B) Reset Information Source Code
C) Reduced Instruction Set Computer
D) Redo Image Scan Code
28. Which of the following term is used to specify the resolution of a laser printer?
A) DPI
B) LPM
C) CPM
D) PPM
29. A hard disk is divided into tracks, which are further subdivided into
A) clusters
B) sectors
C) vectors
D) heads
30. EBCDIC stands for
A) Extended Binary Coded Decimal Interchange Code
B) Extended Bit Code Decimal Interchange Code
C) Extended Bit Case Decimal Interchange Code
D) Extended Binary Case Decimal Interchange Code
31. Which term is used for number of pixels stored in the frame buffer of a graphics system?
A) Resolution
B) DPI
C) Frame
D) Megapixels
32. There are 10 computers connected to a hub, this network topology is closely related to
A) Bus topology
B) Star topology
C) Ring topology
D) None of the above
33. In internet, FTP stands for
A) File Translate Protocol
B) File Translate Path Protocol
C) File Transfer Path
D) File Transfer Protocol
34. Second Generation computers were developed during
A) 1965 to 1970
B) 1970 to 1990
C) 1949 to 1955
D) 1956 to 1965
35. Which of the following is not a part of GUI?
A) icons
C).exe
B) cursors
D) buttons
36. The basic input-output system (BIOS) resides in
A) RAM
B) ROM
C) CPU
D) Memory Cache
37. Which of the following is the most important reason for installing Windows updates?
A) They may include security patches
B) They can improve the performance of your PC
C) They may fix bugs in the operating system
D) They slow down the start-up time for your computer
38. Which of the following mode do you opt for if you want your PC to not consume power but remember the current state of your desktop?
A) Shutdown
B) Restart
C) Sleep
D) Hibernate
39. In other word, computer administrative tools is called
A) start button
B) device and printer
C) control panel d) recycle bin
40. Ctrl + K is a shortcut key for
A) animation
B) end of page
C) jump to page K
D) hyperlink
41. What is the shortcut key to open font dialog box?
A) Ctrl + F
B) Ctrl + D
C) Ctrl + Shift + D
D) Alt +Ctrl + F
42. Autocorrect was originally designed to replace.... words as you type.
A) short, repetitive
B) grammatically incorrect
C) misspelled
D) none of the above
43. Which of the following is not available in Font Spacing?
A) Normal
B) Loosely
C) Condensed
D) Expanded
44. The list of addresses in the Mail merge is also known as
A) Invitee
B) Recipient
C) Addressee
D) Meta tag