Computer Operator Questions and Answers SET-2 | MCQ | PSC - Nepal


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.

Computer Operator
Multiple Choice Questions
with Answers

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)
Previous Post Next Post