लोक सेवा आयोगनेपाल प्रहरी, प्राविधिक, इञ्जिनियरिङ्ग, सूचना प्रविधि/कम्प्युटर प्राविधिक प्रहरी सहायक निरीक्षक (सूचना प्रविधिक/कम्प्युटर)पदको खुला प्रतियोगितात्मक लिखित परिक्षाामिति: २०८०/१२/१४
पत्र: प्रथम KEY (D)
समय: ४५ मिनेट पूर्णाङ्क: १००
विषय: Professional and Service Specific Test
Multiple Choice 50x2=100 Marks
1. 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 meets the specified
conditions
d) You can delete any condition from Conditional Formatting dialog box if it is
not required.
2. Which of
the following formulas is not valid in Excel?
a) =SUM (bonus)-A3
b) =SUM (A1:A8)
c) =A1:A8) *.05
d) =SUM (A1:A8)-10
3. An Excel
Workbook is a collection of
a) Charts
b) Workbooks
c) Worksheets
d) Workbooks and Charts
4. What is
the shortcut key to add a new slide in a presentation?
a) Ctrl + N
b) Ctrl + M
c) Ctrl + P
d) Ctrl + O
5. Color ___
changes the color of different objects without changing content.
a) Template
b) Master
c) Scheme
d) Pattern
6.
Features which allow us to view slides in a slide show without manually
advancing each slide is
a) Adding build effect
b) Setting animation
c) Adding transition
d) Adding bullet
7. How
can you create a uniform appearance by adding a background image to all slides?
a) Create a template
b) Edit the slide master
c) Use the autocorrect wizard
d) Use wide-screen layout
8. Which
of the following keys is used to view the slide show?
a) F2
b) F5
c) F8
d) F10
9. राष्ट्रिय सुरक्षा परिषद्मा देहायका
मध्ये को सदस्य रहँदैनन् ।
a) रक्षा मन्त्री
b) गृह मन्त्री
c) मुख्य सचिव
d) गृह सचिव
10. राष्ट्रिय जनगणना, २०७८ बमोजिम नेपालको लैगिक अनुपात कति
प्रतिशत रहेको छ ?
a) ९४१६
b) ९५५९
c) ९९५
d) ९९८
11. विष्णुको वाहनलाई के भनिन्छ ?
a) गरुड
b) मयूर
c) हाँस
d) गधा
12. मैले छिचोलेका कुइनेटा कृतिमा लेखक को
हुन् ?
a) विवेक ओझा
b) अमर न्यौपाने
c) कृष्ण धरावासी
d) मुकेशकुमार चालिसे
13. नेपालमा पहिलो कृषि गणना कहिले भएको
थियो ?
a) वि.स. १९६८
b) वि.स. २००८
c) वि.स. २०१८
d) वि.स. २०२८
14.
Which of the following is a method of gaining access to a computer program or
an entire computer system while circumventing all security measures?
a) Backdoor
b) Masquerading
c) Phishing
d) Trojan Horse
15.
Which of the following was used in Third Generation Computer?
a) Vacuum Tubes
b) Resistors
c) Integrated Circuits
d) Bio Chips
16.
Which part interprets program instruction and initiates control operations?
a) Input Unit
b) Storage Unit
c) Logic Unit
d) Control Unit
17.
Which of the following memories needs refreshing?
a) SRAM
b) DRAM
c) ROM
d) PROM
18. The
physical and logical arrangement of nodes and connection in a network is known
as
a) Media
b) Network Setup
c) Topology
d) Protocol
19. A
video consists of a sequence of
a) frames
b) packets
c) signals
d) pulses
20. A
microcode or program that is embedded into the memory of hardware devices to
help them to operate is known as
a) Floppy Memory
b) Cache Memory
c) Firmware
d) Control Unit
21.
Firmware is generally written in
a) RAM
b) ROM
c) Hard Disk
d) Cache
22.
Which of the following is a computer memory that can be programmed once, but
not reprogrammed?
a) ROM
b) RAM
c) PROM
d) EPROM
23.
Which of the following was the first computer made available for commercial use?
a) Mark-I
b) ENIAC
c) EDVAC
d) UNIVAC
24.
Which of the following is not an input device?
a) Keyboard
b) Mouse
c) Scanner
d) Printer
25. Hardware maintenance does not involve taking
care of
a) Keyboard
b) Application Programming
c) Defragmentation of hard disk
d) Hard disk drive
26. FAT stands for
a) File Attribute Table
b) File Allocation Table
c) Font Attribute Table
d) Format Allocation Table
27. GUI
based for
a) Geographical User Interest
b) Graphical Ultra Imagination
c) Graphical User Interface
d) Geometric Ultra Interfacing
28. The
primary job of the operating system is to manage
a) commands
b) users
c) programs
d) resources
29. Which
DOS command is used to fix the minor errors of the disk?
a) FDISK
b) FORMAT
c) CHKDSK/f
d) ATTRIB
30. What is
modified when changing the system start-up boot sequence?
a) BIOS/CMOS
b) CONFIG.SYS
c) COMMAND.COM
d) Autoexec.bat
31. In
Database Management System, what is used to establish an association between
related tables?
a) Line
b) Relationship
c) Primary key
d) Record
32. What
determines a table's sort order in DBMS?
a) AutoNumber Field
b) Field Order
c) Index Field
d) Primary Key
33. In E-R
Diagram, ______ are used to represent attributes.
a) Ellipses
b) Rectangles
c) Diamonds
d) Double Lines
34.
Which of the following is not a type of page margin?
a) Left
b) Right
c) Center
d) Top
35.
Which feature is used for monitoring all document change?
a) Edit Document
b) Monitor Change
c) Track Change
d) Track All
36.
Which shortcut key is used to view the thesaurus of a word?
a) Shift + F5
b) Shift + F7
c) Ctrl + Shift + F5
d) Ctrl + Shift + F7
37. How
can you access the font size tool on formatting toolbar?
a) Ctrl + S
b) Ctrl + Shift + S
c) Ctrl + P
d) Ctrl + Shift + P
38. Ctrl
+ Shift + D is used for ____ underline.
a) double
b) wave
c) dotted
d) dash
39. What
is the shortcut key to align text to center?
a) Ctrl + A
b) Ctrl + B
c) Ctrl + D
d) Ctrl + E
40. What
is the shortcut key for 'Save As' in Word Processing?
a) F2
b) F5
c) F10
d) F12
41.
Which is best suited definition about gutter margin?
a) Margin that is added to the left margin
b) Margin that is added to the right margin
c) Margin that is added to the binding side of page
d) Margin that is added to the outside of the page
42. To
update a formula in a table, press the____
a) F9 key
b) Alt + F9 key
c) F8 key
d) F6 key
43.
Which of the following keystroke is used to move the cursor to the end of the
document?
a) End
b) Shift + End
c) Ctrl + End
d) Alt + End
44. Each
cell in a Microsoft Office Excel document is referred to by its cell address
which is the cell's ____
a) column label
b) column label and worksheet tab name
c) row label
d) row and column labels
45. A
formula that either directly or indirectly depends on itself is called ____
software.
a) Iterative
b) Circular
c) Self
d) Auto
46.
Which of the following contains the name of each record on the chart?
a) Cell
b) Title
c) Axis
d) Legend
47.
Comments inserted for specific cell are called ____ Tips.
a) Smart
b) Cell
c) Tool
d) Remark
48.
Excel file cannot be exported to ____ format.
a) DOC
b) CSV
c) XML
d) HTML
49.
Feature to keep portion of sheet visible while scrolling a document is ____
Pane.
a) Lock
b) Stable
c) Freeze
d) Visible
50. Which chart would be best suited to track the
progress of the stock market on a daily basis?
a) Pie Chart
b) Row Chart
c) Line Chart
d) Column Chart
-The End-
Also Read