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 |
B |
C |
D |
|
1 |
5 |
5 |
7 |
8 |
|
2 |
8 |
7 |
4 |
7 |
|
3 |
5 |
5 |
8 |
7 |
|
4 |
1 |
8 |
5 |
2 |
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
D.
PROM
22. Where is Firmware
stored?
A.
RAM
B.
Cache
C.
ROM
D.
Hard Disk
23. What is not the extension
file of MS-Office?
A.
.xls
B.
.doc
C.
.jpeg
D..pptx
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.
A.
FORTRAN
B.
COBOL
C.
BASIC
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
B.
DIX
C.
BNC
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?
A.
FOR, FORMAT
B.
DEL, ERASE
C.
CH, CHDIR
D.
REN, RENAME
36. Which of the following
is not an executable file extension in windows operating system?
A..exe
B..bat
C..apk
D..msi
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>>