Nepal Police Assistant Sub Inspector (ASI) Computer Exam

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

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 a 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 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 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 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 programs by a single CPU is known as?
a. Multiprocessing
b. Time sharing
c. Multiprogramming
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, s 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/100 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 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 suspect a virus has entered your computer what will not be affected by virus?
a. CMOS
b. Boot Sector
c. Floppy Disks
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.0
b. 127. 0.0.255
c. 127.0.0.1
d. None of the above.

29. A device 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.

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

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 the default place that most applications want to store data files in
a. Start Menu
b. Recycle bin
c. Program files
d. My documents

32. A small 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 not 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. 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.

36. What is 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 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

39. What do you call a faint image that you add to the background of a document report?
a. Watermark
b. Style
c. Background image
d. Gutter

40. The ability to combine name and address with a standard document is?
a. Document formatting
b. Form letters
c. Database Management
d. Mail Merge

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

42. Which key is used to recalculate the formula in 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 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. 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 attemptint to calculate
d. Containing the target value

50. Which one is NOT a function in Excel?
a. SUM
b. MIN
c. MAX
d. AVG