Public Service Commission
Dairy Development Corporation,
Administration, 4th Computer
Operator
2077/10/12
1. When a formatted number does
not fit within a cell, it displays
A. ####
B. #DIV/O
C. #DIV/@
D. None of the above
2. Each excel file is called a
workbook because.
A. It can contain text
and data
B. It can be modified
C. It can contain many sheets including worksheets and chart sheets
D. You have to work hard to create it
3. Which of the following is
concatenating operator..
A. Apostrophe (')
B. Exclamation(!)
C. Ampersand (&)
D. Hash (#)
4. Which of the following
formulas will excel not be able to calculate.
A. =sum(purchase)-a4
B. =sum (A1: A5) *6
C. sum (A1:A5) / ( 10-10 )
D. =sum (A1: A5)-10
5. You cannot link excel
worksheet data to a work document with.
A. The right drag method
B. The copy and paste special commands
C. A hyperlink
D. The copy and pastes buttons on the standard toolbar
6. What data changes in
multiple lists and all lists are not updated, this causes.
A. Data redundancy
B. Information overload
C. Duplicate data
D. Data inconsistency
7. The clause in SQL that
specifies that the query result should be sorted in ascending or descending
order based on the values of one more column is.
A. View
B. Order by
C. Group by
D. Having
8. Which query command does
not change any data in the database?
A. Select
B. Insert
C. Delete
D. Update
9. The...states that a foreign
key must either match a primary key value in another relation or it must be
null.
A. Entity integrity rule
B. Referential integrity constraint
C. Action assertion
D. Composite attribute
10. Relationship between
entities office to staff is
A. One to One
B. One to many
C. Many to one
D. Many to many
11. Which of the following
should you use if you want all the slide in the presentation to have same "look"?
A. The slide layout
option
C. Outline view
B. Add a slide option
D. A presentation design template
12. What power point feature
will you use to apply motion effects to different objects of a slide?
A. Animation scheme.
B. Motion
C. Slide design
D. Slide transition
13. Which command brings you
to the first slide in your presentation?
A. Next Slide Button
B. Page Up
C. Ctrl+Home
D. Ctrl+End
14. Objects on the slide that
hold text are called
A. Placeholders
B. Object holders
C. Auto layout
D. Text holders
15. Slides per page is not an
option when printing handouts.
A. Six
B. Five
C. Three
D. Two
16. An information in a disk
drive is accessed by address containing
A. Track number
B. Sector number
C. Surface number
D. All of the above
17. Time during which a job is
processed by the computer is
A. Delay time
B. Real time
C. Execution time
D. Down time
18. A network that connects 10
different banks (e.g. Nepal bank Itd, Nepal Rastra bank, agriculture development bank
etc.). For a specific function, can be classified as
A. Internet
B. Intranet
C. Extranet
D. LAN
19. The octal equivalent of 111010 is
A. 81
B.72
C. 71
D. None of the above
20. A computer program that
converts an entire program into machine language at a time is called a/an
A. Complier
B. Interpreter
C. Assembler
D. Translator
21. Which of the following is
not a video file extension?
A..avi
B. .flv
C. .mpeg
D. .jpeg
22. The number of bits that a
computer can process at a time in parallel is called
A. Word length
B. Speed
C. Accuracy
D. Diligence
23. Which of the following
memory has the shortest access times?
A. Cache memory
B. Magnetic bubble memory
C. Magnetic core memory
D. Ram
24. What is the minimum number
of wires needed to send data over a serial communication link layer?
A. 1
B. 2
C. 4
D. 6
25. Which of the following is
not function of operating system?
A. File management
B. Memory management
C. Email management
D. I/o management
26. In computing, what is the
process by which a running computer system is restarted without the need to interrupt the power?
A. Hibernate
B. Warm boot
C. Cold boot
D. Restart
27. Command line operation
used to list only directories is?
A. DIR /S
B. LS D
C. CD
D. DIR/A:B
28. An error is also known as
A. Bug
B. Debug
C. Cursor
D. Icon
29. In windows, add new
computer hardware option exists in
A. Main menu
B. Status bar
C. Task bar
D. Control panel
30. Which key can be pressed
quit without saving in DOS?
A. Ctrl+A
B. Ctrl+B
C. Ctrl+C
D. Ctrl+D
31. Which of the following
terms is used for the form in which the word will appear on the page?
A. Text formatting
B. Character formatting
C. Point size
D. Type size
32. Which of the following is
not a type of page margin?
A. Left
B. Right
C. Center
D. Top
33. Portrait and landscape are
A. Page orientation
B. Paper size
C. Page layout
D. All of the above
34. Sequence of steps in
inserting the table of content is
A. Insert object-- index
and tables-- table of content
B. Reference table of content
C. Insert reference- tables table of content
D. Reference content--- table
35. Which future is used for
monitoring all document changes?
A. Edit document
B. Monitor change
C. Track change
D. Track all
36. Shortcut key combination
Ctrl+Shift+C is for
A. Copy text with format
C. Copy text format
B. Copy paragraph format
D. Copy format
37. In Ms. Word, the key f12
opens a.... dialog box.
A. Save as
B. Open
C. Save
D. Close
38. Small squares, called
..... on the selection rectangle that surrounds a graphic can be used to change the dimensions of the
graphic.
A. Scroll boxes
B. Sizing handles
C. Status indicators
D. Move handles'
39. Which of the following is
not a font style?
A. Bold
B. Italics
C. Regular
D. Superscript
40. Which of the following is
not one of the three 'mail merge helper' steps?
A. Merge the two files
B. Create the main document
C. Set the mailing list parameters
D. Create the data source
41. Which of the following
options is not options in the print dialog box.
A. Print selected pages
B. Print selected text
C. Set the paper orientation
D. Collate copies
42.short cut key for manual
column break in MS word is.
A. Ctrl+Enter
B. Shift+Spacebar
C. Ctrl+Shift+Enter
D. Alt+Enter
43. Background color or
effects applied on a document is not visible in.
A. Web layout view
B. Print layout vie
C. Reading view
D. Print preview
44. In excel sheet...refers a
range from B1 through E5
A. B1-E4
B. B1:E5
C. B1 to B5
D. B1$E5
45.what does the VLOOKUP
function do.
A. Looks up text that
contain
B. Checks whether text is the same in one cell as in the text
C. Finds related records
D. All of the above
46.Which one is not function in
MS excel.
A. Sum
B. Avg
C. Max
D. Min
47. What is the short cut key
to replace a data with another in sheet.
A. Ctrl+R
B. Ctrl+Shift+R
D. Ctrl+F
C. Ctrl+H
48. Which of the following
formulas results 4.
A. If (10<1,5,4)
B. Power (2,2)
C. Both a and b
D. None of the above
49. Except for the ....
Function, a formula with a logical function shows the word "true" or "false" as a result
A. If
B. And
C. Or
D. Not
50. What is the result of
formula"-max (min (5,4,10)), max (3,2,2)"?
A. 5
B. 4
C. 10
D. 3
<< The
End >>