Translate

Search This Blog

Follow by Email

Chetan Thapa Magar. Powered by Blogger.

Technical Nepal Police Computer Exam Paper with Answer

Multiple Choice Competitive Written Test Computer Examination of Nepal Police, Technical, Information Technology 2074
Share it:

Nepal Police, Technical, Information Technology / Computer,

Technical Police Assistant Sub Inspector 

Competitive Written Test

Key: [B]                                                                                                                      Letter: First


Multiple Choice (50 x 1 = 50 marks)


1. Which function does one use to return the rest after variety is split by a divisor?

a. ROUND()
b. FACT()
c. MOD()
d. DIV()

2. .What is the shortcut key to insert current date during a cell?
a. Ctrl+ D
b. Ctrl + T
c. Ctrl + ;
d. Ctrl + /


3. The maximum number of rows in excel worksheet is

a. 65535
b. 32000
c. 1024
d. 256


4. In Excel, What is a Data Series?

a. a type of chart
b. a cell reference
c. collection of related data
d. a division of results




5. Which of the following is NOT a valid datatype in Excel?

a. Number
b. Character
c. Text
d. Currency




6. Which of the subsequent contains the name of every record on the chart?

a. Cell
b. Title
c. Axis
d. Legend




7. Getting data from a cell located during a different sheet is named

a. Accessing
b. Referencing
c. Updating
d. functioning




8. In Excel, which one denotes a range from B1 through E5?

a. B1-E5
b. B1 to E5
c. B1:E5
d. B1$E5




9. Which one is that the last column header in Excel 2007?

a. XFD
b. XFX
c. XFL
d. SFT



10. Database management systems are used to?

a. eliminate data redundancy
b. manage file access
c. establish relationship among records in different files
d. all of the above



11. Which of the subsequent isn't a logical database structure
a. Chain
b. Network
c. Tree
d. Relational




12. Primary key field of a table included in another table is named

a. surrogate key
b. compound key
c. foreign key
d. composite key



13. What would you select to make a pre-formatted style?

a. Slide sorter view
b. Slide layout
c. Slide Transition
d. Slide Design



14. what's a motion path in presentation slide?

a. a type of animation entrance effect
b. a method of advancing slide
c. a way of moving items on a slide
d. all of the above




15. The access method used for mag tape is?

a. Direct
b. Random
c. Sequential
d. None of the above




16. Which of the following memory is non-volatile?

a. SRAM
b. DRAM
c. ROM
d. All of above



17. Chip is that the common name for a (an)?

a. transistor
b. register
c. integrated circuit
d. semiconductor




18. A fault during a computer virus which prevents it from working correctly is understood as

a. boot
b. bug
c. biff
d. strap




19. Execution of two or more programs by one CPU is understood as?

a. Multiprocessing
b. Time sharing
c. Multiprogramming
d. None of the above



20. the amount of pin out for serial data port on a PC?

a. 5
b. 7
c. 9
d. 10




21. …. Are set of rules and procedures to regulate the info transmission over the internet?

a. IP Address
b. Domains
c. Protocol
d. Gateway




22. When a computer is first turned on or restarted, s special sort of absolute loader called … is executed?

a. Compile and Go loader
b. Boot loader
c. Bootstrap loader
d. Relating loader




23. With reference to a network interface card, the term 10/100 refers to

a. protocol speed
b. fiber speed
c. megabits per second
d. minimum and maximum server speed




24. The diagnostic testing sequence to work out if the pc keyboard, random access memory, disk drivers and other hardware are working correctly is?

a. safe mode
b. POST
c. NetBIOS
d. Power Up




25. Techniques used in ‘character recognition’ includes?

a. optical character recognition
b. magnetic ink character recognition
c. optical mark reading
d. Both a and b




26. A divide that forwards packets between networks by processing the routing information included in the packet is

a. Firewall
b. Bridge
c. Router
d. None of the above.




27. you think an epidemic has entered your computer what is going to not be suffering from virus?

a. CMOS
b. Boot Sector
c. Floppy Disks
d. Program files




28. IP address to be pinged to check proper installation of IP protocol stack on your local is

a. 127.0.0.0
b. 127. 0.0.255
c. 127.0.0.1
d. None of the above.




29. a tool that forwards packets between networks by processing the routing information included within the packet is

a. Firewall
b. Bridge
c. Router
d. None of the above.




29. Which statement is false?

a. you'll find deleted files in recycle bin
b. you'll restore any files in recycle bin if you ever need
c. you'll increase free space of disk by sending files in recycle bin
d. you'll right click and choose empty recycle bin to wash it directly .




30. CHKDSK command is used to

a. analyze the hard disk error
b. diagnose the hard disk error
c. report the status of files on disk
d. all of above




31. The … folder is that the default place that the majority applications want to store data files in

a. Start Menu
b. Recycle bin
c. Program files
d. My documents




32. alittle a part of taskbar has icons of background running application is

a. Start button
b. Quick launch
c. Task Bar
d. System Tray.



33. You can add or remove programs

a. delete the shortcut icon from desktop
b. add/remove program from control panel
c. both a and b
d. none of the above



34. You can’t close MS-Word application by

a. Choosing file menu then exit submenu
b. Press Alt+F4
c. Click the X button on the title bar
d. From file menu choose Close submenu




35. during which view Headers and Footers are visible in MS Word?

a. Normal View
b. Page Layout View
c. Print Layout View
d. Draft View.




36. what's the shortcut key to open the thesaurus in MS Word?

a. Ctrl+F7
b. F7
c. Alt + F7
d. Shift + F7




37. Which file starts MS Word?

a. winword.exe
b. word.exe
c. MS word.exe
d. word2002.exe




38. to use center alignment to a paragraph in MS Word, we will press

a. Ctrl + E
b. Ctrl + C
c. Ctrl + S
d. Ctrl + C + A




39. What does one call a faint image that you simply increase the background of a document report?


a. Watermark
b. Style
c. Background image
d. Gutter



40. the power to mix name and address with a typical document is?

a. Document formatting
b. Form letters
c. Database Management
d. Mail Merge




41. Which of the subsequent isn't available on the ruler of MS Word

a. Tab stop box
b. Left Indent
c. Right Indent
d. Center Indent





42. Which key's wont to recalculate the formula during a table in MS Word?

a. F3
b. F5
c. F7
d. F9




43. By default, on which page the header or the footer is printed?

a. on first page
b. on alternate page
c. on every page
d. on current page




44. Word wrap feature

a. Set text inside the fixed margin
b. appears at the top of the document
c. mark the paragraph center
d. none of above




46. What is gutter margin?

a. Margin that's added to the left margin when printing
b. Margin that's added to the proper margin when printing
c. Margin that's added to the binding side of page when printing
d. Margin that's added to the surface of the page when printing




47. Pressing Ctrl and clicking over the text selects?

a. Current Word
b. Current Sentence
c. Current paragraph
d. Current page




48. Which file starts MS Word?

a. winword.exe
b. word.exe
c. MS word.exe
d. word2002.exe




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




50. Which one isn't a function in Excel?

a. SUM
b. MIN
c. MAX
d. AVG
Share it:

Nepal Police

Nepal Police Paper

Post A Comment:

0 comments:

Thanks for visit. Hope you like it. Support us by Like, Comment, Share, Follow and Subscribe.