Koshi Province 2080.02.20


Province Public Service Commission

Koshi Province, Biratnagar, Nepal

Date: 2080/02/20


1. To copy cell contents using drag-and-drop press the…….......

A. End key

B. Shift key

C. Ctrl key.

D. Esc key


2. The..... feature of MS Excel quickly completes a series of data.

A. Auto complete

B. Auto fill

C. File handle

D. Sorting


3 When applying conditional formatting we can check conditions against.....

A. Cell value

B. Formula

C. Formatting

D. All of the above


4. The cell references M$4 is a .....

A. Relative cell reference

B. Absolute cell reference

C. Mixed cell reference

D. Both (A) and (B)


5. Which would you choose to create a bar diagram?

A. Edit, Chart

B. Insert, Chart

C. Tools, Chart

D. Format, Chart


6. From the information below, find the output of=MIN(A2:C2)


























A. 2

B. 4

C. 6

D. 8


7. The task of arranging data in order is called.....

A. Searching

B. Sorting

C. Ordering

D. Shorting


8. What is the full form of DBMS?

A. Data of Binary Management System

B. Database Management Service

C. Database Management System

D. Data Backup Management System


9. A huge collection of information or data accumulated from different sources is known as.....

A. Data management

B. Data mining

C. Data warehouse

B. Both (B) and (C)


10. In which of the following formats data is stored in the DBMS?

A. Image

B. Text

C. Table

D. Graph


11. In a database table, the category of information is called.....

A. Tuple

B. Field

C. Record

D. All of the above


12. Primary key field of the table included in another table is called.....

A. Surrogate key

B. Compound key

C. Foreign key

D. Composite key


13. What PowerPoint feature will you use to apply motion effects to different objects of a slide?

A. Slide transition

B. Slide design

C. Animation objects

D. Animation scheme


14. What is the shortcut key for slide show?

A. Ctrl + S

B. F11

C. Ctrl + H

D. F5


15. In order to edit a chart, you can.....

A. Triple click the chart object

B. Click and drag the chart object

C. Double click the chart object-

D. Click the chart object


16. The handout master contains placeholders for all of the following except.....

A. Slide number

B. Title

C. Footer

D. Header


17. Zoom basic allows free meetings with more than two participant's with ..... time limit.

A. 20 mins

B. 30 mins

C. 40 mins

D. 50 mins


18. One of the goals of ICT policy of Nepal is.....

A. At least 70% of the population will have digital literacy skills by the end of 2020

B. At least 75% of the population will have digital literacy skills by the end of 2020

C. At least 80% of the population will have digital literacy skills by the end of 2020

D. At least 82% of the population will have digital literacy skills by the end of 2020


19. नेपालको संविधानको धारा १६ अनुसार प्रत्येक व्यक्तिलाई .. ....... बाँच्न पाउने हक हुनेछ ।

A. स्वतन्त्रतापूर्वक

B. सम्मानपूर्वक

C. बैयक्तिक स्वतन्त्रतापूर्वक

D. माथिका सबै


20. नेपालको संविधानको कुन अनुसूचीमा संघ र प्रदेशको साझा अधिकारको सूची उल्लेख गरिएको छ ?

A. अनुसूची ७

B. अनुसूची ८

C. अनुसूची ५

D. अनुसूची ९


21. Which computer memory is used for storing program and data currently being processed by the CPU?

A. Mass memory

B. Internal memory

C. Non-volatile memory



22. Where is Firmware stored?


B. Cache


D. Hard Disk


23. What is not the extension file of MS-Office?

A. .xls

B. .doc

C. .jpeg



24. A device which can be connected to a network without using cable is called.....

A. Distributed device

B. Centralized device

C. Open-source device

D. Wireless device


25. is used as a programming language in first generation computers.




D. Machine language

26. The second generation computer was based on.....

A. Vacuum tube

B. Silicon chips

C. Transistors

D. Integrated circuits


27. Which of the following is not an output device?

A. Speaker

B. Monitor

C. Digitizer

D. Plotter


28. Which of the following is the correct abbreviation of COMPUTER?

A. Commonly Occupied Machines Purposely Used in Technical and Educational Research

B. Common Operating Machined Purposely Used in Technical and Environmental Research

C. Commonly Oriented Machines Purposely Used in Technical and Educational Research

D. Common Operating Machine Purposely Used for Technological and Educational Research


29. Which of the following is designed to control the operations of a computer?

A. User

B. Application software

C. System software

D. Utility software


30. The technology used in optical disks is.....

A. Reflective

B. Laser beam

C. Refractive

D. Diffraction


31. Which of the following is not a type of virus?

A. Boot sector

B. Polymorphic

C. Multipartite

D. Trojans


32. Which is the connector of coaxial cable?

A. RJ45



D. None of the above


33. FAT stands for.....

A. File Accommodation Table

B. File Access Tape

C. File Allocation Table

D. File Activity Table


34. If you need to duplicate the entire disk, which command will you use?

A. Copy

B. Diskcopy

C. Chkdsk

D. Format


35. Which pair of command does not perform the same function?






36. Which of the following is not an executable file extension in windows operating system?






37. What is the shortcut key for manual line break?

A. Ctrl + Enter

B. Alt + Enter

C. Shift+Enter

D. Space + Enter


38. The shortcut key Ctrl+z is used for.....

A. Save the file with changes

B. Redo

C. Undo

D. Close word


39. Which of the following can change physical structure of the document.....

A. Print

B. Formatting

D. Debug

C. Approach


40. Which file is responsible to start MS Word?

A. Winword.exe

B. Win.exe

C. Word.exe

D. Wordwin.exe


41. What is the function of Ctrl+E?

A. Exit application

B. Align center

C. Select all

D. Clear all


42. In MS Word you can convert the document's file format by applying the command.....

A. Save

B. Save as-

C. Convert

D. Permission


43. Which enables us to send the same letter to different persons?

A. Macros

B. Template

C.. Mail merge

D. None of the above


44. Which feature helps you to insert the contents of the clipboard as text without any formatting?

A. Paste special

B. Format painter

C. Page setup

D. Styles


45. Ctrl+H shortcut-key is use for.....

A. Font

B. Page number

C. Replace

D. Hyperlink


46. The auto complete feature.....

A. Presents a tip box with contents you can insert by presenting the enter key

B. Checks the style of the documents

C. Checks the readability of the document

D. Checks the spelling in the document


47. A function inside another function is called a ..... function.

A. Nested

B. Round

C. Sum

D. Text


48. Which of the following is concatenating operator?

A. Apostrophe ()

B. Exclamation (!)

C. Ampersand (&)

D. Hash (#)


49. Which is an example of a function?

A. =Add(A1:A2)

B. =A1+A2

C. =Sum(A1:A2)

D. A1+A2


50. Which of the following is not the correct method of editing the cell content?

A. Press the Alt key

B. Press the F2 key

C. Click the formula bar

D. Double click the cell

<<The End>>

Post a Comment (0)
Previous Post Next Post