Nepal Police,Technical Police Deputy Inspector 2078/09/24


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


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

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>


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



C) Intranet


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?




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


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


B) cursors

D) buttons

36. The basic input-output system (BIOS) resides in




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

45. Which function key is used to view the thesaurus of a word in MS Word?
A) Shift+F7
B) Alt +F7
C) Ctrl +F7
D) F7

46.  In which of the following dialog box do you set certain indentation and spacing of Page setup
A) Page
B) Page setup
C) Paragraph
D) Section

47. F12' is shortcut key for
A) Save
B) Save As
C) Spell Check
D) Grammar Check

48. Hyperlinks cannot be created between a word document and
A) another web document folder on your local computer
B) a webpages on the internet 
C) a folder on your local computer
D) an application program

49 Macros are
A) small programs created in MS-Word to automate repetitive tasks by using VBA 
B) small add-on programs that are installed afterward if you need them
C) programming languages that you can use to customize MS-Word
D) large tools in Word such as mail-merge
50. Which of the following is not true regarding Conditional Formatting?
A) You can add more than one condition to check 
B) You can set condition to look for Bold and apply italics on them
C) You can apply Font, Border and Pattern formats that meet the specified conditions 
D) You can delete any condition from Conditional Formatting dialog box if it is not  required.

Post a Comment (0)
Previous Post Next Post