PSCNepal Police, Technical, Information Technology/Computer Police Assistant Inspector (ASI) Post Competitive Written Examination 2074/07/30
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 nonvolatile?
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 pins
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 packet 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
chooses 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
-The End-
Also Read
- Nepal Bar Council IT Officer 2082/06/26
- TU Technical Assistant Written Exam Question Paper 2082/05/14
- PSC Computer Operator 2075
- PSC Computer Operator Written Exam Question Paper 2082/02/03
- Nepal Rastra Bank, IT Assistant Written Exam Question Paper 2081/01/19