प्रदेश लोक सेवा आयोग
कोशी प्रदेश,अन्तर्गत प्राविधिक तर्फ विविध सेवा, पाँचौ तह, कम्प्युटर अपरेटर पदको प्रतियोगितात्मक लिखित परिक्षा
२०à¥à¥®/०à¥/१५
कोशी प्रदेश,
२०à¥à¥®/०à¥/१५
1. Document outline view is
a. A preview in a full screen
b. A preview with margin
c. A view with a margin and gutter
d. A view with a structure of heading at various levels
2. Which of the following is an absolute cell reference?
a. $C$1
b. $D1$
c. #B$1
d. #E1#
3. Comments can be added to cells using
a. Review->Comments
b. Insert->Comments
c. File->Comments
d. View->Comments
4. What is the maximum number of columns in worksheet?
a. 256
b. 255
c. 65,536
d. 131,72
5. Getting data from a cell located in different sheet is called___
a. Referencing
b. Updating
c. Functioning
d. Validating
6. Which function allows user to repeat certain rows and column on each page while printing
a. Print repeat
b. Print header
c. Print title
d. Print cells
7. The shortcut to shift active cell to one screen right
a. Alt + Page Up
b. Alt + Page Down
c. Ctrl + Page Up
d. Ctrl + Page Down
8. Which of the following conditional function?
a. Round
b. And
c. If
d. Sum
9. The shortcut to insert function is
a. F3
b. Alt + F3
c. Ctrl + F3
d. Shift + F3
10. What divides windows into two different panes that can scroll separately?
a. Mirror
b. Split
c. Slide
d. Pane Manager
11. Function in Excel allows you to adjust an input value in a formula to determine a desired outcome
a. Pivot table
b. Audit
c. Scenario
d. Goal seek
12. The candidate key that you choose to identify each row uniquely is
a. Alternate key
b. foreign key
c. Primary key
d. None of the above
13. Which of the following data types can be used to store unstructured data?
a. Raw
b. Char
c. Numeric
d. Varchar
14. Which of the following eliminates duplicate records?
a. No duplicate
b. Eliminate
c. Distinct
d. None of the above
15. Which of the command can be used to modify a column in a table?
a. Alter
b. Update
c. Set
d. Create
16. Which key represents relationship between tables?
a. Primary key
b. Secondary key
c. foreign key
d. Tertiary key
17. One of the advantages of the Database Management approach is
a. Data is dependent on programs
b. Data redundancy increases
c. Data is integrated and can be accessed by multiple programs
d. All of the above
18. What lets you create new presentation by selecting ready-made font color and graphics effects?
a. Presentation template
b. Master slide
c. Design template
d. Animation scheme
19. 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 auto correct wizard
d. All of the above
20. HTML stands for
a. Hyper Text Managing Links
b. Hyper Text Markup Language
c. Hyper Text Manipulating Language
d. Hyper Text Manipulating Links
21. Which of the following tag is used to mark the beginning of the cells in a table?
a. <TD>
b. <BR>
c. <P>
d. <TR>
22. In video conference tools like Zoom, Teams, the place where participants are queued before permitting inside the meeting is called
a. Holding room
b. Lobby room
c. Waiting room
d. Veranda
23. GIDC stands for
a. Government Information & Data Center
b. Government Information Data Company
c. Government Integrated Data Center
d. Government International
24. The IT Policy of Nepal 2072 envisions target for which year
a. 2020
b. 2030
c. 2040
d. 2050
25. The Electronic Transaction Act was passed as law in (B.S)
a. 2060
b. 2063
c. 2068
d. 2072
26. First Generation of Computer uses
a. Transistor
b. Diode
c. Vacuum tubes
d. Integrated circuits
27. RAM is following type of storage device
a. Non-volatile
b. Volatile
c. Read only
d. non-erasable
28. SSD stands for
a. Semiconductor Specified Device
b. Secure State Device
c. Solid State Device
d. Silicon State Device
29. ___is the memory between the CPU and the main memory.
a. Cache memory
b. Storage memory
c. Virtual memory
d. Register memory
30. BIOS stands for
a. Base Interface Operating System
b. Basic Input Output System
c. Basic Interaction for Output System
d. Basic Interface to Operating System
31. Low level programming language is also known as:
a. Object oriented language
b. Procedural oriented language
c. Machine level language
d. Processor level language
32. A device present on the arm of the hard drive that reads or writes data on the magnetic platters, mounted on the surface of the drive is known as:
a. Head
b. Spindle
c. Platters
d. Actuator
33. A topology that involves Token:
a. Star
b. Ring
c. Bus
d. Rocket
34. COM port in computer is used for:
a. Serial communication
b. Parallel communication
c. Power supply
d. Video out
35. POST stands for:
a. Password on self-test
b. Password off self-test
c. Power off self-test
d. Power on self-test
36. The Octal base 35 is equivalent to which number in decimal base:
a. 28
b. 29
c. 35
d. 43
37. NIC in network card stands for:
a. Network Interface Card
b. Network Information Card
c. Network Interface Communication
d. Network Interexchange Capability
38. The primary job of the operating system is to:
a. Manage commands
b. Manage users
c. Manage programs
d. Manage resources
39. When there is enough memory to fit a process in memory, but the space is not contiguous we need:
a. Internal Fragmentation
b. Virtual Fragmentation
c. External Fragmentation
d. None of the above
40. Each time you turn on your computer, which of the following control files are checked on?
a. Command.com, io.sys
b. Command.com, date.com, dir.com
c. Command.com, io.sys, msdos.sys
d. Chkdsk.exe
41. The operating system keeps the information of files in a table called:
a. File Folder Table (FFT)
b. File Allocation Table (FAT)
c. File Index Table (FIT)
d. Directory Index Table (DIT)
42. What is the smallest and largest font size available in font-size tool on formatting toolbar?
a. 8 and 72
b. 8 and 68
c. 6 and 72
d. 6 and 68
43. The space left between the margin and start of a paragraph is called:
a. Spacing
b. Gutter
c. Indentation
d. Alignment
44. Superscript, subscript, outline, emboss, engrave are known as:
a. Text effects
b. Word art
c. Font styles
d. Font effects
45. Pressing F8 key three times selects:
a. A word
b. A paragraph
c. A sentence
d. Entire document
46. In MS Word hyperlink is inserted by pressing:
a. Ctrl + Click
b. Ctrl + Shift + Click
c. Ctrl + C
d. Ctrl + Shift + C
47. Which of the following is not a type of TAB stop?
a. Bar
b. Decimal
c. Point
d. Left
48. Drop Cap is generally used for:
a. 1 Character
b. 1 Paragraph
c. 1 Line
d. 1 Word
49. To fit the width column as per content in a table we need to:
a. Double click at the right border of column
b. Double click at the left border of column
c. Double click at the column header
d. All of the above
50. The four types of mail merge main document in MS Word are:
a. Form letters, directories, catalogues and envelopes
b. Form letters, envelopes and mailing labels, directories and lists
c. Basic letters, envelopes, labels and list
d. Form letters, envelopes, mailing labels and directory
-The End-
Also Read