Koshi Province, Computer Operator 2080/01/12

E-Learn 0

 

State Public Service Commission
Koshi Province, Biratnagar, Nepal
Various services under local government services,
Assistant Level 5th Level, Open Competitive Written Examination for The Post of Computer Operator

KEY: [D]                                      Date: 2080/01/12
Time: 45 Minute                            Full Mark: 100
Subject: Service Related

The KEY of the question paper must be mentioned in the answer sheet. If the KEY is not mentioned, the answer sheet will be canceled. Electronic devices including mobile phones and calculators will not be allowed in the examination.

Multiple Choice Questions (50x2=100 Marks)
1. Which function allows user to repeat certain rows and columns on each page while printing__
a. Print Repeat
b. Print Header
c. Print Title
d. Print Cells

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

3. Which of the following is conditional function?
a. Round
b. And
c. If
d. Sum

4. The shortcut to insert function is__
a. F3
b. Alt + F3
c. Ctrl + F3
d. Shift + F3

5. What divides window into two different panes that cache scroll separately?
a. Mirror
b. Split
c. Slide
d. Pane Manager

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

7. Which of the following is the correct order of keyword for SQL, SELECT statements?
a. SELECT, WHERE, FROM
b. FROM, WHERE SELECT
c. WHERE, FROM, SELECT
d. SELECT, FROM, WHERE

8. The technique which defines a set of value acceptable for the field is known as__
a. Authentication
b. Acceptance
c. Verification
d. Validation

9. DML stands for__
a. Data Manipulation Language
b. Data Multiplication Language
c. Data Matching Language
d. Data Making Language

10. What are the main building blocks of a database?
a. List
b. Queries
c. Tables
d. Forms

11. Which of the following is the property of primary key?
a. Unique
b. Image
c. Repeated
d. Single bit

12. Which keyword is used to find the number of values in a column?
a. Value
b. Total
c. Find
d. Cout

13. Which is not a slide transition type?
a. Blinds
b. Swivel
c. Wind
d. Flash

14. Master slide is used for__
a. Header and Footer
b. Table Slide Design
c. Auto layout
d. Text Holders

15. <IMG SRC=File name>__is used to
a. Insert image file
b. Source file
c. Hyperlink
d. None of the above

16. <A HREF=File Name>___</A> is used for
a. Hyperlink
b. Insert image file
c. Alignment
d. Paragraph formatting

17. Which of the following is not true about video conferencing tools-Zoom or Team?
a. Participant's open window can be shared
b. Host can restrict participation from sharing screen
c. Entering a meeting can be password protected
d. Host can access participant's computer via Zoom or Team

18. The Electronic Transaction Act was passed as law in B.S.___
a. 2060
b. 2063
c. 2068
d. 2072

19. Which is not the E-Governance Pillar?
a. E-Administration
b. E-Democracy
c. E-Services
d. Virtual Reality

20. The Disaster Recovery (DR) site of the Government Integrated Data Center (GIDC) is established in__
a. Biratnagar
b. Butwal
c Hetauda
d. Nepalgunj

21. Which of the following is soft output device?
a. Printer
b. Monitor
c. Plotter
d. Keyboard

22. Fifth generation computer uses__
a. Vacuum Tube
b. ULSI
c. VLSI
d. Transistor

23. VGA stands for__
a. Visual Graphics Array
b. Visual Graphics Adapter
c. Video Graphics Array
d. Video Graphics Adapter

24. SSD stands for__
a. Semiconductor Specified Device
b. Solid State Device
c. Secure State Device
d. Silicon State Device

25. A computer program that converts entire program into machine language is called__
a. Interpreter
b. Compiler
c. Simulator
d. None of the above

26. A step-by-step procedure to solve a problem is called__
a. Algorithm
b. Syntax
c. Program 
d. Error

27. Which of the following memories has the shortest access time?
a. Cache memory
b. Magnetic bubble memory
c. Magnetic core memory
d. RAM

28. Which protocol is used to address the webpage in Internet?
a. HTTP
b. TELNET
c. SMTP
d. FTP

29. CMOS stands for__
a. Complements Main Oxide Semiconductor
b. Complementary Main Oxide Semiconductor
c. Complementary Metal-Oxide Semiconductor
d. Configuration Management & Option Semiconductor

30. Faster data communication is possible when using
a. Twisted pair
b. Co-axial cable
c. Optical fiber
d. Normal view

31. SMTP stand for
a. Simple Mail Transfer Protocol
b. Simple Machine Transfer Protocol
c. Simple Merge Transfer Protocol
d. Simple Mail Travel Protocol

32. LPT port in computer is used for
a. Serial communication
b. Parallel communication
c. Power Supply
d. Video out

33. The primary job of the operating system is to__
a. Mange Commands
b. Manage Users
c. Manage Programs
d. Manage Resources

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

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

36. The operating system keeps the information of files in a table is called__
a. File Folder Table (FFT)
b. File Index Table (FIT)
c. File Allocation Table (FAT)
d. Directory Index Table (DIT)

37. Which menu in MS-Word can be used to change page size & typeface?
a. View
b. Tools
c. Data
d. Format

38. Maximum font size in word is__
a. 48
b. 54
c. 72
d. 78

39. Shortcut to insert the page break in word is__
a. Alt + Enter
b. Shift + Enter
c. Ctrl + Enter
d. Tab + Enter

40. Key combination used for thesaurus is__
a. Shift + T
b. Shift + F3
c. Shift + F7
d. Shift + F9

41. The list of addresses in the mail merge is also known as__
a. Invitee
b. Recipient
c. Addressee
d. Meta tag

42. What is portion of a document in which you set certain page formatting option as default?
a. Page 
b. Document
c. Section
d. Page Setup

43. __is tool to apply same format different character/paragraph?
a. Format painter
b. Format generator
c. Format applier
d. Format manager

44. What is the shortcut to align text to center?
a. Ctrl + S
b. Ctrl + L
c. Ctrl + C
d. Ctrl + E

45. The ghost text that appears behind the text is known as__
a. Ghost Mark
b. Water Mark
c. Paper Mark
d. Background Mark

46. __is note at the bottom of the page providing more info about something in the document
a. Citation
b. Table of content
c. Footnote
d. Footer

47. Which of the following is an absolute cell reference?
a. $C$1
b. $D1$
c. #B$1
d. #E1#

48. Comments can be added to cells using__
a. Review->Comments
b. Insert->Comments
c. File->Comments
d. View->Comments

49. What is the maximum number of columns in worksheet?
a. 256
b. 255
c. 65,536
d. 131,072

50. Getting data from cell located in different sheet is called__
a. Referencing
b. Updating
c. Functioning
d. Validating

- The End -

Also Read

Tags

Post a Comment

Post a Comment

Previous Post Next Post