PSC Computer Operator Written Exam Question Paper 2079/11/29

 

Quiz

22:30

1. What are the home keys alphabets on keyboard for the right hand?

a. FDSA b. JKL; c. UIOP d. REWQ

2. Which program runs first after booting the computer and loading the GUI?

a. Desktop Manager b. Authentication c. File Manager d. Windows Explorer

3. From which menu can you insert Header and Footer in MS-Word?

a. Tools Menu b. Format Menu c. View Menu d. Insert Menu

4. Which bar provides a quick access to the commonly used command and tools?

a. Tool Bar b. Status Bar c. Menu Bar d. Title Bar

5. Which key should be pressed to start a new paragraph?

a. Down Cursor key b. Enter key c. Shift + Enter d. Control + Enter

6. What is a Gutter margin?

a. Margin added to the left margin when printing b. Margin added to the right margin of page when printing c. Margin added to the opposite side of binding side when printing d. Margin added to the binding side of page when printing

7. What is Ctrl + Right Arrow command used for in MS Word?

a. To move the cursor one word right b. To move the cursor to the end of line c. To move the cursor to the end of document d. To move the cursor one paragraph down

8. What is the maximum number of columns that can be inserted in MS-Word table?

a. 15 b. 35 c. 63 d. 65

9. Which operation allows to send same letter to multiple persons?

a. Letter Merge b. Letter Repeater c. Mail Merge d. Mail Repeater

10. Which of the following allows to move directly to specific location of a document?

a. Sub-line b. Bookmark c. Index d. Pointer

11. Which bar in MS-Word shows the current positions as far as the text goes?

a. Title Bar b. Menu Bar c. Scroll Bar d. Status Bar

12. Which of the following opens when you press the key F12?

a. Save As dialog box b. Save dialog box c. Close dialog box d. Open dialog box

13. What can you specify while formatting a cell in currency?

a. Currency symbol b. Decimal place c. Both A and B d. None of the above

14. In Excel, how are rows labeled as?

a. A, B, C etc b. A1, A2, A3 etc c. 1, 2, 3 etc d. A1, B1, C1 etc

15. Absolute reference for the range F1:F6 is____

a. =$F%1:$F%6 b. =$F1:$F6 c. =$F1%:$F6% d. =$F$1:$F$6

16. How do you change the chart type of an existing chart?

a. Click the chart, then go to the 'Design' tab and click 'Change Chart Type' b. Right-click the chart and select 'Change Chart Type' c. Double-click the chart to select a new type d. Both A and B are correct

17. Which of the MS-Excel function returns TRUE or FALSE based on two or more conditions?

a. AVERAGE b. CONCAT c. COUNTA d. AND

18. Except for the ____ function, formula with a logical function shows the word "TRUE" or "FALSE" as a result.

a. OR b. AND c. IF d. NOT

19. The cell B5 in Excel worksheet contains formula =A4+C3. This is copied to cell D8. What will be the formula in cell D8?

a. =C7+E6 b. =C6+E7 c. =E7+C5 d. =A4+C3

20. Which of the following will lock the first column or the top row in place while you scroll?

a. Lock Pane b. Lock Scroll c. Freeze Pane d. Freeze Scroll

21. How can you apply conditional formatting to highlight duplicate value in range?

a. Use 'Highlight Cells Rules' and select 'Duplicate Value' b. Use 'Data Bars' and adjust the duplicate value c. Use 'Color Scales' and adjust the colors to select duplicate value d. Use 'Icons Sets' and set the icons to indicate duplicate value

22. Which menu option in MS Excel is used to split windows into two?

a. Review>Window b. View>Window>Split c. Window>Split d. View>Split

23. The Handout Master contains placeholders for all of the following except___

a. Title b. Slide Number c. Header d. Footer

24. It is possible to move a placeholder on a slide?

a. No, it's fixed b. Yes, only after 'Layout' change c. No, we have to delete it first and recreate it d. Yes, by dragging it

25. What is the shortcut key to insert a new slide in the current presentation of MS PowerPoint?

a. Ctrl + F b. Ctrl + O c. Ctrl + M d. Ctrl + N

26. Which type of slide provides the most control over content and allows you to customize it by adding your own text boxes, picture chart and more?

a. Blank slide b. Title and content slide c. Title slide d. Title only

27. Which of the following items does not exist in a slide layout?

a. List b. Animations c. Tiles d. Chart

28. What is Microsoft PowerPoint?

a. Database program b. Document processor c. Spreadsheet program d. Presentation program

29. What is the purpose of the 'Speaker Notes' in PowerPoint?

a. Add comment to slide b. Insert audio file c. Customize slide transition d. Change slide background

30. Ctrl + D is used in MS PowerPoint to

a. Duplicate all slides b. Delete all slides c. Duplicate selected slides d. Delete selected slides

31. What is a shortcut key to switch to Presentation view?

a. F5 b. Ctrl + F5 c. Alt + F5 d. Shift + F5

32. Which of the following will not advance the slides in a slideshow view?

a. The Esc key b. The Spacebar c. The Mouse button d. The Enter key

33. Which of the following is Microsoft Access?

a. Network Database Model b. OODBMS c. ORDBMS d. RDBMS

34. Which of the following is user friendly interface for data entry?

a. Datasheet view b. Form view c. Design view d. Layout view

35. Another name for columns in MS-Access table is_

a. Records b. Fields c. Rows d. Tuple

36. Which key is used to link two tables together?

a. Composite key b. Primary key c. Unique key d. Foreign key

37. Which key declares that an index in one table is related to that in another?

a. Primary key b. Secondary key c. Foreign key d. Super key

38. Which option allows you to build a new table by entering data directly into the datasheet?

a. Datasheet view b. Design view c. Link table d. Worksheet view

39. In database management system____, combines rows from two or more tables, based on a related column.

a. REFER b. CASCADE c. COMBINE d. JOIN

40. Which query prompts users for input data by displaying dialog boxes?

a. Update b. Parameter c. Delete d. Append

41. What property determines how data is displayed in text box control?

a. Format b. Default value c. Input d. Control source

42. What does an RDBMS consist of?

a. Collection of Records b. Collection of Tables c. Collection of Keys d. Collection of Fields

43. Which of the following refer to a set of rules that govern data communication?

a. Servers b. Standards c. RFCS d. Protocols

44. In a peer-to-peer network, how is control and decision making distributed?

a. Centralized on a single servers b. Equally among all connected devices c. Through designated peer devices d. Randomly assigned to devices

45. What kind of transmission medium is most appropriate to carry data in a computer network that is exposed to electrical interference?

a. Microwave b. Coaxial cable c. Optical fiber d. Unshieled twisted pair

46. What does TCP stands for?

a. Transaction Control Protocol b. Trans Control Protocol c. Transmission Control Protocol d. Terabyte Control Protocol

47. Which type of topology is best suited for large business which must carefully control and coordinate operation of distributed branch outlets?

a. Ring b. Hierarchical c. Local Loop d. Star

48. Which of the following is the control device in a star topology network?

a. STP Server b. DNS Server c. Router d. Hub/Switch

49. A company wants to communicate internally with its employees and share information securely then it should use

a. Internet b. Intranet c. Extranet d. SafeNet

50. Which of the following is a network layer protocol for internet?

a. Internet protocol b. Ethernet protocol c. File transfer protocol d. Hypertext transfer protocol

51. Which of the following is correct IPv4 address?

a. 124.201.3.1.52 b. 01.200.128.123 c. 300.142.210.64 d. 128.64.10.15

52. Which of the following is a valid email address?

a. example@example.com b. gmail.com c. example@.com d. example@com

53. Which HTML tag is used to include an image in a webpage?

a. <jpeg> b. <image> c. <img> d. <include>

54. What does CSS stand for?

a. Computer Style Sheet b. Creative Style Sheet c. Cascading Style Sheet d. Centralized Style Sheet

55. Which HTML tag adds a row in a table?

a. <tr> b. <td> c. <th> d. <tt>

56. Which of the following elements are all <table> elements?

a. <table><head><tc> b. <head><body><tr> c. <table><tr><tt> d. <table><tr><td>

57. How can you make a numbered list?

a. <list> b. <ul> c. <ol> d. <dl>

58. Which of the following is the chief component of First Generation of computer?

a. Vacuum tube b. Transistor c. Integrated circuit d. Microprocessor

59. Which of the following devices is used to connect to internet using traditional telephone line?

a. Printer b. Modem c. Auxiliary d. Trojan

60. One nibble is equivalent to ____ bits.

a. 1 b. 2 c. 4 d. 8

61. ____ computer is one that processes both analog and digital.

a. Analog b. Digital c. Super d. Hybrid

62. _____ is a circuitry that responds and processes the basic instructions in computer.

a. Processor b. Memory c. ALU d. CU

63. What is the common name for a board in personal computer that mounts a number of chips?

a. Breadboard b. Main circuit board c. Motherboard d. Auxiliary board

64. Unsolicited or undesired electronic messages are also known as___

a. Trojan b. Worm c. Virus d. Spam

65. Viruses are

a. Micro-program b. Application software c. Utility software d. Operating system

66. Which of the following is an example of hexadecimal number?

a. (35)8 b. (54)10 c. (81)16 d. (24)24

67. What is the decimal value for the octal value 1?

a. 1 b. 8 c. 10 d. 100

68. What is the primary job of operating system?

a. Manage users b. Manage programs c. Manage commands d. Manage resources

69. Best way to have correct and same system date and time in multiple computer is to

a. Set date and time in all computer at once b. Refer same clock to set date and time c. Sync date and time with a time server d. Set date and time exactly at 12:00

70. Desktop shortcuts are___

a. Executable files b. Link to a file or folder c. Applications d. Folders

71. What combination of key is used to switch user on a Windows computer?

a. Ctrl + Shift + Esc b. Ctrl + Alt + Del c. Alt + Tab d. Ctrl + Shift + Del

72. What is the full form of BIOS?

a. Basic Inter Operating System b. Basic Input Operating System c. Basic Input Of System d. Basic Input Output System

73. In what sense are COPY and XCOPY commands same?

a. Both are DOS internal commands b. Both are DOS external commands c. Both are used to copy file or group of files d. Both commands are exactly the same

74. Which of the following is not the primary function of operating system?

a. Networking b. File management c. Processor management d. Resource management

75. GUI in an operating system stands for___

a. General User Interface b. Generic User Interface c. Graphical User Interface d. Geo-User Interface