In this Computer Operator Questions and Answers SET-2, you will find the 50 most important Multiple Choice Questions (MCQ) which can be asked in any competitive exams of Computer Operator or Assistant Computer Operator conducted by the Public Service Commission of Nepal.
First, try to answer all these questions by yourself, then confirm whether your answer is right or wrong by matching it with the Answer Sheet given below.
PSC-Nepal
Computer Operator
Multiple Choice Questions
with Answers
SET-2
1. Which one is true for password?
(A) Passwords are case sensitive
(B) Has fixed length
(C) Can contain letters, numbers and symbols
(D) All of the above
2. Which is not an operator?
(A) ;
(B) %
(C) /
(D) ,
3. The orientation of the page in which the printed lines run the width (81/2") of the page is called.........
(A) Landscape
(B) Inverted
(C) Normal
(D) Portrait
4. The labels defining in a worksheet structure
(A) Contain letters, numbers and symbols
(B) Are comprised of numbers and the equals sign
(C) Include function
(D) Begin with and equals sign
5. To move to the last column in a worksheet, press..........
(A) Ctrl+Home
(B) Ctrl+End
(C) Alt+Right Arrow
(D) Alt+Down Arrow
6. What will be happen when you click the border between two columns?
(A) Widen the column width as contents
(B) Widen the row height as contents
(C) Hide the row
(D) Both (A) and (C)
7. A worksheet contains approximately how many rows?
(A) 256
(B) 65535
(C) 65635
(D) 65536
8. To select multiple, non-adjacent worksheets in a workbook.
(A) Press Ctrl and click another tab
(B) Press Alt and click another tab
(C) Press Shift and click another tab
(D) Drag the mouse pointer through the tabs
9. By default, how is text horizontal aligned inside a cell in Excel?
(A) Left aligned
(B) Center
(C) Right aligned
(D) Justified
10. Which option restrict the values that can be entered into a
(A) Data > Validation
(B) Data > Filter > Advanced Filter
(C) Format > Cells
(D) Format > Conditional Formatting
11. To display the heading as slanted text to save space..........
(A) Select slanted Text on the font tab
(B) Select Text Orientation on the Alignement tab
(C) Superscript on the font tab
(D) Center Across selection on the Alignment tab
12. What will be the correct answer, if user enters the 3 P into a cell?
(A) 3.00
(B) 3:00 PM
(C) 3 P
(D) Non of above
13. The formula uses its own reference is called..........
(A) Absolute reference
(B) Mixed reference
(C) External reference
(D) Circular reference
14. What is the function of text to column?
(A) Allows you to separate delimited text across the columns automatically.
(B) Converts the selected text to table.
(C) It automatically resizes the cell size whenever a large text is added in the cell
(D) None of the above
15. The maximum number of characters can be stored in a cell is..........
(A) 256
(B) 32000
(C) 65000
(D) None of the above
16. Goal Seek appears at the.......... Menu
(A) File
(B) Data
(C) Tools
(D) Format
17. Which shortcut key is used to hide column?
(A) Alt+9
(B) Ctrl+9
(C) Alt+0
(D) Ctrl+0
18. The maximum length of formula is..........
(A) 1024 characters
(B) 255 characters
(C) 2000 characters
(D) Depends upon internal memory
19. The shortcut key define name is..........
(A) Ctrl+F2
(B) Ctrl+F3
(C) Ctrl+F4
(D) Ctrl+F9
20. The maximum number of sheet within any workbook is..........
(A) 100
(B) 200
(C) 255
(D) Unlimited
21. The format dddd in date will display..........
(A) Sund
(B) Sun
(C) Sunday
(D) None of the above
22. The .......... key press moves the cell pointer on pane of another pane in spited window.
(A) F5
(B) F6
(C) F9
(D) F11
23. The referencing styles used in Excel..........
(A) 1
(B) 2
(C) 3
(D) 4
24. To insert Auto sum function, one can press..........
(A) Alt++
(B) Alt+=
(C) Alt+Enter
(D) Alt+;
25. The category axis is also called a..........
(A) X-Axis
(B) Y-Axis
(C) Secondary Axis
(D) Value Axis
26. The shortcut key is used to create default chart is..........
(A) F11
(B) Alt+F1
(C) F10
(D) A & B
27. The file extension of workspace file is..........
(A) .xls
(B) .xlt
(C) .xlw
(D) .xls
28. The shortcut key is used to switch contents in to the edit mode..........
(A) F2
(B) F3
(C) F4
(D) F6
29. Which one of Excel window allows you to enter values in worksheet?
(A) Title Bar
(B) Menu Bar
(C) Formula Bar
(D) Standard Tool Bar
30. A typical worksheet has .......... number of columns.
(A) 23
(B) 256
(C) 255
(D) 1024
31. Comments put in cells are called..........
(A) Smart Tip
(B) Cell Tip
(C) Web Tip
(D) Soft Tip
32. Getting data from a cell located in a different sheet is called..........
(A) Accessing
(B) Referencing
(C) Updating
(D) Functioning
33. Which of the following is not a valid data type in Excel?
(A) Number
(B) Hyperlink
(C) Label
(D) Date/Time
34. Which elements of a worksheet can be protected from accidental modification?
(A) Contents
(B) Object
(C) Scenarios
(D) All of the above
35. A numeric value can be treated as a label value if it proceeded with..........
(A) '
(B) !
(C) "
(D) ~
36. Which is text operator?
(A) Apostrophe (')
(B) Exclamation (!)
(C) Hash (#)
(D) Ampersand (&)
37. Which formula returns multiple results from single formula?
(A) Standard Formula
(B) Array Formula
(C) Mixed Formula
(D) Smart Formula
38. Which is not tool for what-if analysis?
(A) Table
(B) Goal Seek
(C) Pivot table
(D) Scenario
39. Data can be added from different sheet within a workbook using..........
(A) Data outline
(B) Data consolidate
(C) Data Subtotal
(D) Scenario
40. The Edit > Delete command will deletes..........
(A) Delete sheet
(B) Clear contents
(C) Delete cell
(D) All of the above
41. Data of sheet can be printed on center of page using..........
(A) Page setup / Margin
(B) Print / Center
(C) Page setup / Layout
(D) Page setup / Sheet
42. To import data for database in excel using..........
(A) Data / Import external data
(B) Tools / Get external data
(C) Tools / Import external data
(D) None of the above
43. The mode of operations can be display at..........
(A) Formula bar
(B) Status bar
(C) Display bar
(D) Scroll bar
44. AutoSum button appears at the .......... toolbar.
(A) Standard
(B) Formula
(C) Formatting
(D) Border
45. You can enable auto save feature using..........
(A) Add-ins
(B) Attachment
(C) Option
(D) None of the above
46. The insert function appears at the..........
(A) Standard toolbar
(B) Formula palette
(C) Formatting toolbar
(D) None of the above
47. Which command will display the subset of data from list?
(A) Pivot Table
(B) Filter
(C) Goal Seek
(D) Scenario
48. Which one you can search by find command?
(A) Formula
(B) Value
(C) Comment
(D) All of the above
49. Which will affects the column width of entire worksheet?
(A) Column width
(B) Standard width
(C) Global width
(D) All of the above
50. Which symbol will display when your number is too larger than column width?
(A) $
(B) #
(C) @
(D) *
Answer Sheet
1. (D) 2. (A) 3. (B) 4. (D) 5. (B) 6. (A) 7. (D) 8. (A) 9. (A) 10. (A) 11. (B) 12. (B) 13. (D) 14. (A) 15. (B) 16. (C) 17. (D) 18. (A) 19. (B) 20. (D) 21. (C) 22. (B) 23. (B) 24. (B) 25. (A) 26. (D) 27. (C) 28. (A) 29. (C) 30. (B) 31. (B) 32. (B) 33. (B) 34. (D) 35. (A) 36. (D) 37. (B) 38. (C) 39. (B) 40. (B) 41. (A) 42. (A) 43. (B) 44. (A) 45. (C) 46. (B) 47. (B) 48. (D) 49. (B) 50. (B)