Nepal Police IT/Computer ASI 2074/07/30

 

लोक सेवा आयोग

नेपाल प्रहरी, प्राविधिक, सूचना प्रविधि/कम्प्युटर प्रहरी सहायक  निरिक्षक(ASI) पदको प्रतियोगितात्मक लिखित परिक्षा २०७४/०७/३०

1. Which function do you use to return the remainder after a number is divided by a divisor?

a. Round( )

b. Fact( )

c. Mod( )

d. Div( )

2. What is the shortcut key to insert current date in cell?

a. Ctrl + D

b. Ctrl + T

c. Ctrl +;

d. Ctrl + /

3. The maximum number of rows in excel worksheet is

a. 65536

b. 32000

c. 1024

d. 256

4. In Excel, what is the data series?

a. A type of chart

b. A cell reference

c. Collection of related data

d. A division of result

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

a. Number

b. Character

c. Text

d. Currency

6. Which of the following contains the name of each record on the chart?

a. Cell

b. Title

c. Axis

d. Legend

7. Getting data from a cell located in different sheet is called

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 the last column header in Excel 2007?

a. XFD

b. XFX

c. XFL

d. SFT

10. Database management system are used to?

a. Eliminate data redundancy

b. Manage files access

c. Establish relationship among records in different files

d. All of the above

11. Which of the following is not a logical database structure?

a. Chain

b. Network

c. Tree

d. Relational

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

a. Surrogate key

b. Compound key

c. Foreign key

d. Composite key

13. What would you choose to create a pre-formatted style?

a. Slide sorter view

b. Slide layout

c. Slide transition

d. Slide design

14. What is a motion path in presentation slide?

a. A type of animation entrance effect

b. A method of advancing slide

c. A method of moving items on a slide

d. All of the above

15. The access method used for magnetic 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 the above

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

a. Transistor

b. Register

c. Integrated circuit

d. Semiconductor

18. A fault in a computer program which prevents it from working correctly is known as

a. Boot

b. Bug

c. Biff

d. Strap

19. Execution of two or more program by a single CPU is known as?

a. Multiprocessing

b. Time sharing

c. Multi programming

d. None of the above

20. The number 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 control the data transmission over the internet?

a. IP Address

b. Domains

c. Protocol

d. Gateway

22. When a computer is first turned on or restarted, a special type of absolute loader called___is executed?

a. Compile and Go loader

b. Boot loader

c. Bootstrap loader

d. Relating loader

23. With respect to a network interface card, the term 10/1000 refers to

a. Protocol speed

b. Fiber speed

c. Megabits per seconds

d. Minimum and maximum server speed

24. The diagnostic testing sequence to determine if the computer keyboard, random determine if the computer keyboard, random access disk drivers and other hardware are working correctly is?

a. Safe mode

b. POST

c. NetBIOS

d. Power Up

25. Technique 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 packet 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 suspect a virus has entered your computer will not be affected by virus?

a. CMOS

b. Boot sector

c. Floppy disk

d. Program files

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

a. 127.0.0.1

b. 127.0.0.255

c. 127.0.0.1

d. None of the above

29. A device that forwards a packets between networks by processing the routing information included in the packet is

a. Firewall

b. Bridge 

c. Router

d. None of the above

30. Which statement is false?

a. You can find deleted files in recycle bin

b. You can restore any files in recycle bin if you ever need

c. You can increase free space of disk by sending files in recycle bin

d. You can right click and choose empty recycle bin to clean it at once

31. 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 the above

32. The___folder is the default place that most application want to store data files in

a. Start menu

b. Recycle bin

c. Program files

d. My document

33. A small part of taskbar has icons of background running application is

a. Start button

b. Quick launch

c. Test bar

d. System tray

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

35. You cannot close MS Word application by

a. Choosing file menu then exist submenu

b. Press the Alt + F4

c. Click the X button on the title bar

d. From file menu choose close submenu

36. In which view headers and footers are visible in MS Word?

a. Normal view

b. Page layout view

c. Print layout view

d. Draft view

37. What is the shortcut key to open the thesaurus in MS Word?

a. Ctrl + F7

b. F7

c. Alt + F7

d. Shift + F7

38. Which file starts MS Word?

a. winword.exe

b. word.exe

c. msword.exe

d. word2003.exe 

39. To apply center alignment to a paragraph in MS Word, we can press

a. Ctrl + E

b. Ctrl + C

c. Ctrl + S

d. Ctrl + C + A

40. What do you call a faint image that you and to the background of a document report?

a. Watermark

b. Style

c. Background image

d. Gutter

41. The ability to combine name and address with a standard document is?

a. Document formatting

b. Form letters

c. Database management

d. Mail merge

42. Which of the following is NOT available on the ruler of MS Word?

a. Tab stop box

b. Left indent

c. Right indent

d. Center indent

43. Which key is used to recalculate the formula in table in MS Word?

a. F3

b. F5

c. F7

d. F9

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

45. 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 the above

46. What is gutter margin?

a. Margin that is added to the left margin when printing

b. Margin that is added to the right margin when printing

c. Margin that is added to the binding side of page when printing

d. Margin that is added to the outside of the page when printing

47. Press 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. msword.exe

d. word2003.exe

49. In a 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 is NOT a function in Excel?

a. SUM

b. MIN

c. MAX

d. AVG