PSC-Nepal
Computer Operator
Multiple Choice Questions
1. The shortcut key define name is..........
(A) Ctrl+F2
(B) Ctrl+F3
(C) Ctrl+F4
(D) Ctrl+F9
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. 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
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 maximum number of sheet within any workbook is..........
(A) 100
(B) 200
(C) 255
(D) Unlimited
20. The format dddd in date will display..........
(A) Sund
(B) Sun
(C) Sunday
(D) None of the above
21. The referencing styles used in Excel..........
(A) 1
(B) 2
(C) 3
(D) 4
22. To insert Auto sum function, one can press..........
(A) Alt++
(B) Alt+=
(C) Alt+Enter
(D) Alt+;
23. The category axis is also called a..........
(A) X-Axis
(B) Y-Axis
(C) Secondary Axis
(D) Value Axis
24. The shortcut key is used to create default chart is..........
(A) F11
(B) Alt+F1
(C) F10
(D) A & B
25. The file extension of workspace file is..........
(A) .xls
(B) .xlt
(C) .xlw
(D) .xls
26. The shortcut key is used to switch contents in to the edit mode..........
(A) F2
(B) F3
(C) F4
(D) F6
27. 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
28. A typical worksheet has .......... number of columns.
(A) 23
(B) 256
(C) 255
(D) 1024
29. Comments put in cells are called..........
(A) Smart Tip
(B) Cell Tip
(C) Web Tip
(D) Soft Tip
30. Which is text operator?
(A) Apostrophe (')
(B) Exclamation (!)
(C) Hash (#)
(D) Ampersand (&)
31. Which formula returns multiple results from single formula?
(A) Standard Formula
(B) Array Formula
(C) Mixed Formula
(D) Smart Formula
32. Which is not tool for what-if analysis?
(A) Table
(B) Goal Seek
(C) Pivot table
(D) Scenario
33. Data can be added from different sheet within a workbook using..........
(A) Data outline
(B) Data consolidate
(C) Data Subtotal
(D) Scenario
34. The Edit > Delete command will deletes..........
(A) Delete sheet
(B) Clear contents
(C) Delete cell
(D) All of the above
35. 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
36. 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
37. The mode of operations can be display at..........
(A) Formula bar
(B) Status bar
(C) Display bar
(D) Scroll bar
38. AutoSum button appears at the .......... toolbar.
(A) Standard
(B) Formula
(C) Formatting
(D) Border
39. You can enable auto save feature using..........
(A) Add-ins
(B) Attachment
(C) Option
(D) None of the above
40. The insert function appears at the..........
(A) Standard toolbar
(B) Formula palette
(C) Formatting toolbar
(D) None of the above
41. Which command will display the subset of data from list?
(A) Pivot Table
(B) Filter
(C) Goal Seek
(D) Scenario
42. Which one you can search by find command?
(A) Formula
(B) Value
(C) Comment
(D) All of the above
43. Which will affects the column width of entire worksheet?
(A) Column width
(B) Standard width
(C) Global width
(D) All of the above
44. Which symbol will display when your number is too larger than column width?
(A) $
(B) #
(C) @
(D) *
45. The .......... key press moves the cell pointer on pane of another pane in spited window.
(A) F5
(B) F6
(C) F9
(D) F11
46. Getting data from a cell located in a different sheet is called..........
(A) Accessing
(B) Referencing
(C) Updating
(D) Functioning
47. Which of the following is not a valid data type in Excel?
(A) Number
(B) Hyperlink
(C) Label
(D) Date/Time
48. Which elements of a worksheet can be protected from accidental modification?
(A) Contents
(B) Object
(C) Scenarios
(D) All of the above
49. A numeric value can be treated as a label value if it proceeded with..........
(A) '
(B) !
(C) "
(D) ~
50. Goal Seek appears at the.......... Menu
(A) File
(B) Data
(C) Tools
(D) Format
.jfif)
0 Comments