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

 

Quiz

22:30

1. If you want to format an object such that you can see through object behind it, then you need to adjust

a. Brightness b. Color c. Contrast d. Transparency

2. What is Animation in PowerPoint?

a. A font style b. A background color c. Movement or visual effect applied to content on a slide d. A type of slide

3. In PowerPoint presentation, themes could be found in

a. Transition tab b. Design tab c. Insert tab d. Animation tab

4. Which feature in PowerPoint is used to apply a consistent design to all slides in presentation?

a. Slide Master b. Template c. Theme d. Layout

5. What is the size (aspect) ratio for widescreen slides?

a. 4:3 b. 16:9 c. 3:4 d. 9:16

6. Which feature in database is used to create a summary of data grouped by specific fields?

a. Grouped Report b. Summary Query c. Pivot Table d. Crosstab Query

7. What is the size of TRUE/FALSE field in MS Access?

a. One byte b. One character c. Two bits d. One bit

8. What is a Query in MS Access?

a. A table format b. A report style c. A tool to search and extract specified data d. A background design

9. Which of the following is not a type of relationship that can be applied in MS Access database?

a. One to one b. One to many c. Many to many d. None of the above

10. Which type of Query in a database is used to update existing records in a table?

a. Update Query b. Delete Query c. Select Query d. Append Query

11. Which object is used to create a form in MS Access?

a. Tables and queries b. Tables only c. Tables and reports d. Queries and reports

12. What is a Primary Key?

a. A field that can be left blank b. A field with duplicate values c. A unique identifier for each record d. A field used for formatting

13. Arranging of data in a logical sequence is called

a. Sorting b. Classifying c. Reproducing d. Summarizing

14. Which feature in a database is used to enforce rules that maintain the integrity of data?

a. Constraints b. Queries c. Forms d. Reports

15. In MS Database ‘Short Text’ data type size can be upto____ characters.

a. 125 b. 63 c. 511 d. 255

16. What does TCP/IP stand for

a. Telephone Control Protocol/Internet Protocol b. Transmission Control Protocol/Internet Protocol c. Transmission Control Protocol/International Protocol d. None of the above

17. Which of the following is not a type of computer network?

a. LAN b. MAN c. CAN d. RAM

18. If a network has subnet mask of 255.255.255.0, how many hosts can be connected to this network?

a. 253 b. 254 c. 255 d. 256

19. Which feature of a web browser allows you to save the address of a website for quick access later?

a. Bookmarks b. History c. Cache d. Cookies

20. What is the largest type of computer network?

a. PAN b. LAN c. MAN d. WAN

21. What is an Intranet?

a. Public network for global use b. A private network within an organization c. An entertainment website d. A search engine

22. A small text file that website store on your computer to remember information about your visit is known as

a. URL b. Cookie c. Link d. Session

23. Which protocol is used to resolve domain name to IP addresses in internet?

a. DNS b. DHCP c. FTP d. HTTP

24. What is required to access the internet?

a. MS Word b. Monitor c. Web Browser and Internet connection d. Scanner

25. Which protocol is used to send emails from a client to a server?

a. SMTP b. POP3 c. IMAP d. HTTP

26. Which HTML tag is used to define a table row?

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

27. If your are specifying color in RGB format for HTML page then each Red, Green and Blue color can have maximum value of___

a. 127 b. 255 c. 391 d. 512

28. Which attribute is used to add an image in an HTML page?

a. src b. href c. link d. alt

29. What is the basic language web pages are written in

a. html b. css c. hmtl d. javascript

30. Which HTML tag is used to insert a line break in a web page?

a. <br> b. <hr> c. <p> d. <div>

31. Which generation of computers introduced the use of Integrated Circuits (ICs)?

a. First Generation b. Second Generation c. Third Generation d. Fourth Generation

32. In which keys in keyboard, there are tactile makers to help typists find their row position without looking at the keyboard?

a. D and J b. F and J c. S and J d. F and K

33. In CPU, ‘Program counter’ is part of

a. Arithmetic and Logic Unit b. Control Unit c. Memory Unit d. Data Bus

34. Which of the following is the brain of the computer?

a. Central Processing Unit b. Memory c. Arithmetic and Logic Unit d. Control Unit

35. Which type of printer uses a laser beam to produce high-quality text and graphics?

a. Dot matrix printer b. Inkjet printer c. Laser printer d. Thermal printer

36. In scanner specification, what does DPI stands for?

a. Dots Pixels Inch b. Dark Pixels Inclusion c. Dots Per Inch d. Darkness Per Inch

37. What does SVGA stand for?

a. Standard Visual Graphics Array b. Super Visual Graphics Array c. Standard Video Graphics Array d. Super Video Graphics Array

38. Which type of software helps to interact with hardware?

a. Application software b. System software c. Utility Software d. Multimedia software

39. Which of the following is a type of malware that disguises itself as legitimate software?

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

40. What is the maximum encoding size for a character in UTF-8 Unicode?

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

41. Which of the following is not a basic function of an operating system?

a. Memory management b. File management c. Providing security d. Typing documents

42. Which command in DOS is used to list all files and directories in the current directory?

a. DIR b. LIST c. SHOW d. DISPLAY

43. The date and time display on

a. Taskbar b. Status bar c. System tray d. Launch pad

44. Which of the following shortcut key opens Run Dialog Box?

a. Ctrl + R b. Ctrl + D c. Window key + R d. Window key + D

45. Which part of a window contains the name of the currently open application or document?

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

46. What is the extension of MS paint file?

a. .mkv b. .ppt c. .psd d. .bmp

47. What is the default location of icons like My Computer and Recycle Bin?

a. Start Menu b. Taskbar c. Desktop d. Control Panel

48. Windows Explorer is a

a. File Explorer b. Windows Browser c. Disk Explorer d. Command Finder

49. Which Window feature allows you to view and manage all files and folders on your computer?

a. My Computer b. Control Panel c. Task Manager d. Recycle Bin

50. In control panel, option for managing storage spaces is found in____ category.

a. Hardware and sound b. Appearance and personalization c. Program d. System and security

51. In Word processing, to undo the last work, we use

a. Ctrl + U b. Ctrl + Y c. Ctrl + Z d. Ctrl + W

52. What does paragraph spacing mean?

a. Distance between characters b. Distance between margins c. Distance before and after a paragraph d. Line spacing only

53. Which shortcut is used to save a document quickly?

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

54. What does the Auto Correct feature do in a word processor?

a. Print the document b. Automatically fixes common spelling typing errors c. Changes font d. Saves the file

55. Which feature in Microsoft Word is used to insert a pre-designed document layout?

a. Template b. Style c. Theme d. Format Painter

56. Ctrl + N is used for

a. Save document b. Open document c. New document d. Close document

57. Which shortcut key is used to double underline text in windows word?

a. Ctrl + D b. Ctrl + Alt + D c. Ctrl + Shift + D d. Ctrl + Shift + U

58. If you are in ‘view side by side’ mode for two documents, then___ is possible for two documents.

a. Synchronous scrolling b. Synchronous editing c. Synchronous formatting d. Synchronous insert

59. Which feature in Microsoft Word is used to compare two documents and highlight the differences?

a. Compare b. Track Changes c. Combine d. Review

60. What is Mail merge used for?

a. Sending emails b. Merging files c. Creating personalized letters or labels from a data list d. Compressing documents

61. Which function is used to combine text from multiple cells in Excel?

a. CONCAENATE b. TEXT c. COMBINE d. COUNT

62. Which of the following is the correct syntax for cell references with absolute (fixed) column references?

a. @A@1 b. $A1 c. A$1 d. $A$1

63. Among operations percent, exponent, multiplication and addition, which comes first in the order of execution?

a. Percent b. Exponent c. Multiplication d. Addition

64. How do you display current date and time in Excel?

a. date() b. today() c. now() d. time()

65. Which function in Microsoft Excel is used to find the highest value in a range of cells?

a. MAX b. HIGHEST c. LARGE d. TOP

66. To keep specific rows and columns visible while scrolling through the rest of the worksheet,_____ feature is used.

a. split panes b. freeze panes c. divide panes d. fix page

67. Which option is used to create a chart in Excel?

a. Home tab b. Insert tab c. Page layout d. Data tab

68. Which function in excel checks whether a condition is true or not?

a. Sum b. Count c. If d. Average

69. What does pressing Alt + Enter do inside a cell?

a. Moves to the next cell b. Inserts a new row c. Creates a line break inside the cell d. Opens the Insert menu

70. What is the excel formula for multiplication?

a. =a1+b1 b. =a1*b1 c. =a1-b1 d. =a1/b1

71. Which feature in PowerPoint is used to create a non-linear presentation where slides can be accessed in any order?

a. Hyperlinks b. Action Buttons c. Slide Transition d. Animations

72. If you want to go to the end of slide show, you need to press

a. Ctrl + E b. Shift + E c. Alt + E d. Esc

73. What is the use of Notes Pane in PowerPoint?

a. Shows slide transition b. Shows speaker notes below the slide c. Displays slide number d. Shows chart data

74. Which of the following is not one of the PowerPoint’s view?

a. Slide sorter view b. Presentation view c. Outline view d. Normal view

75. Which feature in PowerPoint is used to create a custom sequence of slides for a specific audience?

a. Custom Slide Show b. Rehearse Timings c. Slide Transition d. Animation