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

 

Quiz

22:30

1. What is a computer network?

a. A collection of software programs b. A single computer system c. A group of connected computers sharing resources d. A type of printer

2. Data from one LAN can be transmitted to another LAN via

a. Router b. Bridge c. Repeater d. Modem

3. CAT6 Ethernet cable can be up to ___ length for quality network connection.

a. 10 m b. 100 m c. 150 m d. 200 m

4. A network device that has multiple ports to connect multiple computers is

a. Switch/hub b. Router c. Repeater d. Gateway

5. Which type of network topology connects all devices in a circular chain?

a. Bus b. Star c. Ring d. Mesh

6. What is an Extranet?

a. A gaming server b. A local database c. A private network extended to outside users d. A music sharing platform

7. How many pins are there in RJ-45 connector?

a. 4 b. 6 c. 8 d. 12

8. Which type of network topology connects all devices to a central hub or switch?

a. Star b. Bus c. Ring d. Mesh

9. Which device is used to connect to the internet using telephone line?

a. Modem b. Switch c. Router d. Hub

10. Which protocol is used for sending emails?

a. SMTP b. FTP c. ICMP d. HTTP

11. Which HTML tag is used to create an ordered list?

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

12. Which command is used to separate content by drawing horizontal line on the page?

a. <line> b. <shape> c. <hr> d. <space>

13. What is the purpose of the <br> tag in HTML?

a. Makes text bold b. Inserts a line break c. Changes text color d. Creates hyperlink

14. What is the number of heading sizes in HTML?

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

15. HTML is a ___ language?

a. Procedural b. Markup c. Object oriented d. Object based

16. Which of the following is an example of input device?

a. Printer b. Monitor c. Keyboard d. Speaker

17. What does the CPU consist of?

a. ALU and control unit b. Monitor and mouse c. Printer and keyboard d. Hard disk and RAM

18. Which of the following is the smallest unit of data in a computer?

a. Bit b. KB c. Nibble d. Byte

19. Which of the following is not an output device?

a. Monitor b. Speaker c. Mouse d. Printer

20. Standard display resolution ‘1920x1080’ is known as

a. HD [1280x720] b. Full HD (FHD) c. Quad HD [2560x1440] d. Ultra HD [3840x2160]

21. Which of the following is a characteristic of primary memory?

a. Non-volatile b. Slower access speed compared to secondary memory c. Directly accessible by the CPU d. Used for long-term storage

22. Which of the following is not a characteristic of a computer?

a. Versatility b. Accuracy c. Diligence d. I.Q.

23. Which of the following is not a peripheral device?

a. Keyboard b. CPU c. Printer d. Scanner

24. Operating system is best classified as

a. General purpose software b. Utility software c. Device software d. System software

25. What is the binary equivalent of the decimal number 25?

a. 11001 b. 10101 [21] c. 10011 [19] d. 11100 [28]

26. What is the main function of an operating system?

a. Word processing b. Manage hardware and software c. Internet browsing d. Typing letters

27. Which of these is an example of a GUI-based operating system?

a. Linux CLI b. MS-DOS c. Windows 11 d. Command prompt

28. Date and Time are available on the desktop of computer at

a. Keyboard b. My computer c. Recycle bin d. Task bar

29. Which feature in Windows allows you to quickly access frequently used programs?

a. Taskbar b. Start menu c. Desktop d. Control panel

30. What is a file extension used for?

a. To decorate the icon b. To determine file type c. To compress files d. To create folders

31. Which Windows feature is used to recover deleted files?

a. Recycle bin b. My computer c. Control panel d. Task manager

32. Which Windows application is used to create and edit text files?

a. Notepad b. Paint c. Calculator d. Character map

33. You can keep your personal files or folders in

a. My folder b. Documents c. My files d. My text

34. Which of the following command permanently deletes a file?

a. Cut delete b. Alt + Delete c. Tabs Delete d. Shift + Delete

35. Which of the accounts is a ‘Single Sign On (SSO)’ account used in Windows?

a. Administrator account b. Standard account c. Guest account d. Microsoft account

36. Which feature in Microsoft Word is used to copy formatting from one text to another?

a. Format painter b. Copy and paste c. Find and replace d. Styles

37. If you create hyperlink in a text, then

a. Color of text will be changed b. Color of text will be changed with underline in text c. Text is underlined d. Text will be bold

38. Which of the following tab is used to enable ‘ruler’ option in MS Word?

a. Review b. Design c. Page layout d. View

39. Which key should be pressed to start a new paragraph in MS Word document?

a. Down cursor key b. Enter key c. Shift + Enter d. Ctrl + Enter

40. Which command is used to make a selected text bold?

a. Ctrl + U b. Ctrl + I c. Ctrl + B d. Ctrl + P

41. In MS Word, ‘Word Art’ option is available in ___ Menu.

a. Home b. File c. Design d. Insert

42. Which feature in Microsoft Word is used to automatically generate a table of content based on heading?

a. Table of contents b. Index c. Bibliography d. Captions

43. Which of the following is not a font style?

a. Bold b. Italics c. Regular d. Superscript

44. What does the drop Cap feature do?

a. Adds capital letters at the end of paragraphs b. Makes the first letter of a paragraph large and decorative c. Remove capital letters d. Highlights all capital letters

45. In newspaper style multi-column view, which statement is true?

a. All columns are equal width b. Spacing both column are fixed c. There could not be line both columns d. Column size spacing could be specified by user

46. What is a pivot table used of in Excel?

a. To create dynamic summaries of data b. To protect the worksheet c. To apply conditional formatting d. To draw graphs and charts

47. What does COUNT() function do in Excel?

a. Adds numbers b. Counts only text c. Counts numeric values in a range d. Finds average

48. What is the use of the IF function in Excel?

a. To perform logical tests b. To find and replace text c. To import data d. To create pivot tables

49. What type of chart is useful for comparing parts of a whole?

a. Pie chart b. Column chart c. Line chart d. Dot graph

50. What is the correct sequence of input parameters for DATE function?

a. Day, month, year b. Month, day, year c. Year, day, month d. Year, month, day

51. An Excel file is generally called a/an

a. e-spreadsheet b. workbook c. worksheet d. sheet

52. Which file format supports macros in Excel?

a. .xlsx b. .csv c. .xlsm d. .txt

53. Cell reference to cell ‘J12’ of sheet 1 from sheet 2 is written as

a. Sheet1!J12 b. @Sheet1, J12 c. Sheet1@J12 d. !Sheet1, J12

54. In Excel, rows are identified by

a. Numbers (1,2,3..) b. Letters (A, B, C) c. Symbols d. Colors

55. Which of the following is not a function in MS Excel?

a. Sum b. Min c. Subtract d. Max

56. What is Microsoft PowerPoint used for?

a. Writing code b. Creating spreadsheets c. Making presentations d. Editing videos

57. What is a transition in PowerPoint?

a. A way to print the slides b. A background color c. A visual effect between slides d. A type of font style

58. Which animation effect in PowerPoint is used to make an object appear on the slide?

a. Entrance b. Exit c. Emphasis d. Motion path

59. What is the shortcut key to insert link to other documents or object in a slide?

a. Ctrl + K b. Ctrl + O c. Ctrl + D d. Ctrl + L

60. How can you start a slide show from the first slide?

a. Press F1 b. Press F5 c. Press Ctrl + S d. Press Shift + Enter

61. Which feature in PowerPoint is used to add notes to a slide that are visible only to the presenter?

a. Notes page b. Slide master c. Handout master d. Slide sorter

62. Which feature in PowerPoint is used to link one slide to another slide or external resources?

a. Hyperlink b. Action button c. Slide transition d. Animation

63. What is the short-cut key for adding a slide in current presentation?

a. Ctrl + N b. Ctrl + P c. Ctrl + S d. Ctrl + M

64. What is a placeholder in PowerPoint?

a. A font style b. A type of transition c. A box where you can type text or insert content d. A color background

65. Which file that consists of readymade style that we can use for our presentation?

a. Pre-formatting b. Template c. Wizard d. Auto style

66. Which of the following part can consist of only one type of data?

a. Table b. Report c. Field d. Record

67. Which of the following is an example of RDBMS?

a. MS Word b. MS PowerPoint c. MS Access d. Adobe Photoshop

68. Which of the following is not type of query in MS Access?

a. Select query b. Update query c. Delete query d. Text query

69. Which feature in a database is used to create a user-friendly interface for data entry?

a. Form b. Query c. Report d. Table

70. Which of the following is not a valid data type in MS Access?

a. Memo b. Picture c. Currency d. Auto number

71. What is a relationship in MS Access?

a. A format style b. A background design c. A connection between tables d. A type of record

72. In MS Access, to switch to ‘Form View’ from ‘Design View’ we can press

a. F2 b. F3 c. F4 d. F5

73. Which type of relationship in a database allows one record in a table to relate to multiple records in another table?

a. One to many b. One to one c. Many to many d. Many to one

74. Which is not a database?

a. Phone diary b. Mark ledger c. Attendance registers d. Report card

75. What does a join do in a query?

a. Splits records b. Hides data c. Combines data from multiple tables d. Delete rows