Nepal Police, IT/Computer Officer 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 cell 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 summarizing 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 form the___menu.

a. Insert

b. Format

c. Tools

d. Date

7. What function displays row data in column or column data in 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 Exel 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 object asks a question of information in database and then display the result?

a. Tables

b. Reports

c. Queries

d. Form

12. Related fields in a database are grouped form a

a. Data file

b. Data record

c. Menu

d. Bank

13. In MS Access rows and columns are technically called____respectively.

a. Record and fields

b. Tuples and attributes

c. Record and tuples

d. Attributes and field

14. The tables in relational database are linked according to

a. Hierarchy

b. Inheritance

b. Relationship

d. Dependency

15. Which of the following PowerPoint feature will be used to apply motion effect to different object of a slide?

a. Slide transition

b. Slide design

c. Motion effect

d. Animation scheme

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 section doesn't exist in a slide layout?

a. Lists

b. Titles

c. Animation

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 2^nd 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 example 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. Extend 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 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

b. .Exe

c. 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 update?

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. Addresses

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 website on the internet

c. A folder on your local computer

d. An application program

49. Macros are

a. Small program created in MS Word to automate repetitive task by using VBA

b. Small add-on programs that are installed afterward if you need them

c. Programming language 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 italic on them

c. You can apply font, border and pattern formats that meets the specified condition

d. You can delete condition from conditional formatting dialog box if it is not required