PSC Computer Operator 2078/07/15

 

प्रदेश लोक सेवा आयोग, कोशी प्रदेश अन्र्तगत प्राविधिक तर्फ विविध सेवा, पाँचौ तह, कम्प्युटर अपरेटर पदको प्रतियोगितात्मक लिखित परिक्षा २०७८/०७/१५

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 cache 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 is 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 of the key to represent 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 is 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 used to mark a beginning of the cells in table?

a. <TD>

b. <BR>

c. <P>

d. <TR>

22. In video conference tools like Zoom, Team the place where participants is queued before permitting inside 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 envision 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 known as

a. Head

b. Spindle

c. Platters

d. Adulator

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. Mange 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 is 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