Data Entry Operator In The Punjab Police Department – 2016 May 6, 2021 – by Sufyan Ansari 0 We have developed this website for all the ASPIRANTS who are seeking an online system for preparing the PPSC Exams. The online testing system is based on the past papers held by PPSC. You can access the online test Data Entry Operator In The Punjab Police Department - 2016 after putting your name in the field below. NOTE: Math's Questions included please must hold a notebook with you for rough work. Questions related to Current Affairs are also included. Negative Marking: 0.25 marks will be deducted in case of each wrong answer. Put your whats app number so we can send you the link to the next online test on your whats app. You can leave it blank if you already submitted. Thank You Your Name: Whats App Number 1. Find the odd man out. Coaxial Cable Microwaves Opitacal fiber Twisted pair wire 2. To have your macro available to all new documents you create, store it in: My Documents Quick Access The Normal Template The Macro Gallery 3. To move to the previous cell in a table inserted in a document, press: The Tabk key Alt + Tab Shift + Tab Backspace 4. To get step-by-step instructions as you go through the Word mail merge process, use: A Template The Mail Merge Wizard The Mailing Table A macro 5. A _______ is a major database object used to display information in a printable page format. Form Query Report Table 6. The percentage increase in the area of a rectangle, if each of its sides is increased by 20% is: 40% 42% 44% 46% 7. When inserting a graphic into a worksheet you could go to cell A1 by pressing Shift + Home Ctrl + Home Enter + Home Alt + Home 8. To be conpatible with previous versions of Microsoft Word, a Word 2013 document should be saved with this extension. .docx .doc .txt .rft 9. Which option displays fill color in alternate rows in an Excel table? Banded Rows First Row Last Row Filled Row 10. What function displays row data in a column or column data in a row? Hyperlink Index Transpose Rows 11. When typing character search criteria, Excel matches fields based on? Alphabetical order Capitalization Spelling Primary recodrs 12. When you insert a picture into a document, the default text wrapping option is: Line with Text None Tight Square 13. What is the sum of this series 1, 2, 3, 4, ......99 1500 4950 2500 3000 14. The most common types of storage devices are? Magnetic Optical Flash Persistent 15. What category of functions is sued in this formula? = PMT(C10/12, C8, C9, 1) Logical Financial Payment Statistical 16. Which is the largest fraction? 3/4 4/5 7/8 7/9 17. Each sector on a hard drive stores ______ bytes of data. 64 512 1024 1 Glga 18. What does an I-beam facilitate? Locating text Highlighting text Dragging and selecting text Fomattig text 19. An unauthorized user is a network _______ issue. Performance Reliability Security All of these 20. A car left Lahore at 7.12 am and arrived at certain place 180 miles distant at 10.57 am. What was its average speed in miles per hour? 42 44 46 48 21. Which of the following, is not a major reason for an email bounce? Bad user account name Bad domain name Stale file handle Domain server is down 22. When you insert a comment in a document, the comment appears in a: New window Sidebar Balloon Sticky note icon 23. Which function automatically totals a column per row of values? Total ADD SUM AVG 24. The information inside your table needs to be sorted alphabetically. to do this, you go to: Table tools design Page Layout Home tab>Paragraph group. Table Tools Layout 25. What is the missing number? 1 4 9 ? 25 15 16 17 18 26. Why might you hide worksheets in a workbook? The file is smaller The file is larger Some data is private Some data is formatted 27. User developed instructions for Excel are called: Programe Macros Procedures All of these 28. What term describes a picture that has been resized by a percentage? Cropped Flipped Stretched Scaled 29. How can words be separated in a range name? With a space With a comma With a period With a colon 30. A word template stores common document: Content Structure Style Theme 31. In which view does a page break appear as a black dashed line on the screen? Normal Page Break Preview Page Layout Custom 32. The Synonym of "Commence" is: To End To Begin Nearing Finish To Run 33. A man is 24 years older than his son. In two years, his age will be twice the age of his son The present age of his son is: 14 years 18 years 20 years 22 years 34. Find the odd man out: Carret Cucumber Onion Ginger 35. If the code for JAVA is LCXC what is the code for BASIC? CBJTD DCUKE EDVLF FEWMG 36. For what can you use Outlook Tasks? Manage client data Send and receive email Schedule appointments and meetings Manage to-do items 37. What do-while is an _____ loop. Entry control Exit control Entry enrolled None of these 38. What should follow the sheet name in a 3-D formula? Colon Parentheses Period Exclamation point 39. Excel would evaluate the formula, = 20 X 10/5 X 8, and return this answer. 5 6.25 320 232 40. What do you see if you hover the mouse over a chart object? Key Tip Screen Tip Chart Tip Chart Key 41. Afzal mixed 40% kerosene solution to 25% kerosene solution hence obtaining 30% kerosence solution. In what ratio were the both solutions mixed. 3:1 2:3 1:2 3:2 42. Protecting a worksheet means: No cell in a worksheet can be changed Saving the workbook in a hidden folder No additional changes can be made to a woksheet To lock cells in the worksheet so that a user cannot inadvertently change them. 43. A driver drives 8 km South then 6 km W. and 2 km S. again. She then drives 3 km E to avoid a traffic jam before driving 6 km N. How many kilometers is she from her starting point? 4 5 6 7 44. Which of the following is reliable communication? TCP IP UDP None of these 45. What term describes shaped text? Text Art Text Word Word Art Word Text 46. If ADD = 9, BAD = 7, CAD = 8 what is the value of ADA? 3 4 5 6 47. A drive that can be removed or inserted while the computer is running is said to be _____. Robust Dynamic Hot swappable SCSI 48. Before you create labels such as name tags, specify the size by selecting? Label Options Layout Format Templates 49. A man buys an item for Rs. 1400 and sells it at a loss of 15%. What is the selling price of the item? 1090 1160 1190 1202 50. In a rich text content control field, the text: Can be formatted Cannot be formatted Is limited to lower case Cannot contain space 51. In the formula, = 10 + 5 + 15 + 25/5, Excel computes this first. 10+5 5+15 25/5 15+25 52. Where is the address of the active cell displayed? Row heading Status bar Name Box Formula bar 53. Find odd man out Japan China London Canada 54. You can evenly adjust spacing in columns and rows by using the table tool called: Equalize Distribute Mirror Snap to Grid 55. This describes the size, weight, and spacing of a character in a word document. Font Typeface Points Typography 56. When you want to combine cells in any given table row, you: Merge Simpliy Join Link 57. There are two different ways to insert content from one application into another embedding and: Importing Integrating Linking Bookmarking 58. What term escribes a feature that gives Excel enhanced capability? Trend lining Enhancement bit Thumbnail Add-in 59. A cube has a volume of 8 cubic meters. If each side is doubled in length what will its new volume be in cubic meters? 16 32 48 64 60. The best tool to use to create a hierarchical flow chart in Word is: Word Art Shapes Smart Art Tables 61. Insert the missing number. 3, 7, 6, 5, 9, 3, 12, 1, 15, (....) 18 13 -1 3 62. What, is the least number by which 294 should be multiplied to make it perfect square. 2 3 6 12 63. The average weight of A, B and C is 45 kg. if the average weight of A and B be 40 kg and that of B and C be 43 kg, then weight of B is: 17 Kg 20 Kg 26 Kg 31 Kg 64. A vessel is filled to its capacity with pure milk. Ten liters milk is withdrawn from it and replaced by water. The procedure is repeated agai. The vessels now have 32 liters of milk. Find the capacity of The vessels (in liters) 40 45 50 55 65. A combination of instructions and keystrokes that are stored and used in documents is called: A shortcut A macro A keystroke A function 66. What is the name for a webpage address? Directory Domain URL Protocol 67. To what does the term "page orientation" refer? An application that displays Web pages. Combining two versions of the same document Code where data will be inserted Whether a page is laid out vertically of horizontally 68. A ______ is a data communication system within a building, plant, or campus, or between nearby buildings. MAN LAN WAN None of these 69. Which is NOT a method of creating a table in MS Access? Datasheet View Design View Layout View Template 70. When you are working on a document, Word automatically saves your document: Every 10 minutes Every 10 seconds When you close the document When you close the application. 71. The price of certain item increased by X% per week over two successive weeks. If at the beginning, 2 kg was available for Rs. 80 and after two weeks they were available for Rs. 80 and after two weeks they were available for Rs. 105.80, what is value of X. 1.5 15 115 11.5 72. Which alignment choice spreads the data across the width of the cell? Center Distibuted Justify Indent 73. Where does Word insert a table of contents? On the first page of the report After the cover page At the insertion point Before the document title 74. When the Reviewing pane is open, the title of that pane is: Comments Revisions Edits Changes 75. If a - b = 3 and a^2 + b^2 = 29 find the value of ab: 10 12 15 18 76. Connetions to the Internet using a phone line and a modem are called _______ connections. Broadband Dish Digital Dial-up 77. Your _________ files store various versions of running programs. Cache memory temp static 78. The rules that dictate how the various parts of a formula are written in a table and elsewhere are called: Structure Functions Exponents Syntax 79. A sum of money at simple interest amounts to Rs. 815 in 3 years and Rs. 854 in 4 years. The sum is? 650 690 698 700 80. Which one of the following is not a prime number? 11 61 91 31 81. Which number will come next? 5, 7, 10, 12, 14, 24, 26 52 30 28 48 82. _____ is a technique that is used to send more than one call over a single line? Digitizing Duplexing Multiplexing Streaming 83. What is the background for a chart called? Chart area Chart grid Legend area Plot grid 84. What dialog box allows you to change a field name'in a Pivot Table? Field Options Field Pane Field Settings Field Structure 85. What is synonym for Contradict? Predict To Support External To oppose by words 86. If the hour hand of a clock is turned anticlockwise from 2 pm to 9 am, through how many degrees will it have turned? 120 degree 150 degree 165 degree 180 degree 87. A man has some hens and cows, if the number of heads be 48 and the number of feet equals 140, then the number of hens will be: 22 23 24 26 88. 89. The sort command of the Data menu provides this capability. Multiple-row Multiple-column Multiple-field Multiple-table 90. You want create a built-in cover page for your report. You go to the: Page Layout tab Insert tab References tab Themes menu 91. Which view shows margins and the rulers? Normal Page Layout Page Setup Review 92. Data that is copied from an application is stored in the _____ Driver Clipboard Ternimal Prompt 93. Akram thought of a number, add 7, multiplied by 3, took away 5 and divided by 4 to give an answer of 7. What was the starting number? 2 3 4 5 94. Data communication requires Sender Receiver Transmission medium All of these 95. From what location are the 1st computer instructions available on boot up? ROM BIOS CPU Boot.ini CONFIG.SYS 96. If Excel disables and notifies you about a macro, how can you enable the macro? Click the option on the View tab Click the Macros button on the Developer tab Click the option in the security message panel Close and reopen the workbook 97. What is the binary value of 2020? 10010110 11010110 10110110 11001000 98. To open a template in Word, first goto file and: Click New. Click Display Click Open Click Search 99. A social security number or a telephone number is considered to be this type of entry in a worksheet. Numeric Text Value Formula 100. Which of the following functions is a database function: DSUM DGLAZE DPART DGROUP Time is Up!