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

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


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

ADS 1

ADS 2