SPSC 2004 ASI (Computer) Sindh Police — Aptitude Test (2004) Paper

ASI (Computer) Sindh Police — Aptitude Test (2004). Aptitude test for recruitment to the post of A.S.I. (Computer) in Sindh Police · Thursday 25 March 2004, 11:00 am to 12:30 pm · Maximum marks 100. 100 questions of 1 mark each. Half mark deducted for incorrect answers in Part I only. Part I Computers (1–45), Part II English (46–60), Part III Pakistan Knowledge (61–70), Part IV Current Affairs (71–80, as of March 2004), Part V General Knowledge & Everyday Science (81–90), Part VI Islamiat (91–100)

1. 1Identify the correct format of the "IF" function.

   • A)=IF(condition, result if true, result if false)
   • B)=IF(condition, result if true, result if true)
   • C)=IF(condition, result if false, result if true)
   • D)=IF(condition, result if false, result if false)

2. 2Which character(s) can't be used in a condition of IF function?

   • A)<=
   • B)>=
   • C)<>
   • D)!=

   Explanation: Excel uses <> for "not equal"; != is not an Excel operator.

3. 3Which operator(s) can't be used for defining a mathematical formula?

   • A)/
   • B)*
   • C)^
   • D)!=

4. 4Which equation will correctly return the cumulative total of all values in a column of data?

   • A)=ADD(B1:B100)
   • B)=TOTAL(B1:B100)
   • C)=SUM(B1:B100)
   • D)=CUMULATIVE(B1:B100)

5. 5What do you need to access the Websites?

   • A)Computer
   • B)Email client software
   • C)Browser Software
   • D)Connection with an Internet Service Provider

   Explanation: A browser is the software used to open websites (a computer and an internet connection are also needed).

6. 6A floating point number represented in hardware does not have one of the following components:

   • A)Decimal point
   • B)Mantissa
   • C)Characteristics
   • D)Sign

   Explanation: The decimal point is implied, not stored.

7. 7A utility that connects the components of a program together is called a(n)

   • A)Editor
   • B)Loader
   • C)Linker
   • D)Assembler

8. 8______ are pre-written formulas that perform calculation automatically.

   • A)Macros
   • B)Function
   • C)Formula
   • D)Equation

9. 9______ is an example of Primary Storage.

   • A)RAM/ROM
   • B)Hard Disk
   • C)Cache
   • D)Diskette

10. 10______ is a rectangular area containing docs, programs and messages.

    • A)Window
    • B)Pages
    • C)Monitor
    • D)Web Page

11. 11______ dialogue box also contains "Template" in its "Type List".

    • A)Save As
    • B)Open
    • C)Close
    • D)Exit

12. 12______ will be reached if the "Home" key is pressed (in a worksheet).

    • A)Left most cell
    • B)Last cell of work sheet
    • C)Right most cell
    • D)First cell of work sheet

    Explanation: Home moves to the first cell of the current row; Ctrl+Home goes to the first cell of the sheet.

13. 13To copy the contents of a cell type ______ key.

    • A)Ctrl+C
    • B)Alt+C
    • C)Ctrl+O
    • D)Alt+O

14. 14To paste the copied contents of a cell type ______ key.

    • A)Ctrl+V
    • B)Alt+V
    • C)Ctrl+P
    • D)Alt+P

15. 15File extension for an Excel Workbook is

    • A).XLS
    • B).EXL
    • C).XEL
    • D)None of the above

    Explanation: In 2004; newer versions use .XLSX.

16. 16Microsoft Excel is a ______ type of software.

    • A)Accounting
    • B)Spreadsheet
    • C)Graphical
    • D)None of the above

17. 17In MS Excel graphic representation of numbers is known as ______.

    • A)Charts
    • B)Graphs
    • C)Pictorial
    • D)None of the above

18. 18A ______ refers to the file you create with Microsoft Excel.

    • A)Workbook
    • B)Document
    • C)Sheet
    • D)None of the above

19. 19The combined cell column and row headings are known as the cell's ______.

    • A)Cell
    • B)Cell address
    • C)Cell Number
    • D)None of the above

20. 20The abbreviation URL refers to ______.

    • A)Universal Resource Locator
    • B)Unique Resource Locator
    • C)Universal Resource Location
    • D)None of the above

    Explanation: URL stands for Uniform Resource Locator.

21. 21The type of software that is used to access the websites is called ______.

    • A)Internet Browser
    • B)MSN
    • C)Website Browser
    • D)None of the above

22. 22The range B4:D11 refers to ______ (number of) cells.

    • A)24
    • B)36
    • C)18
    • D)22

    Explanation: 3 columns × 8 rows = 24.

23. 23The WWW refers to ______.

    • A)Word Wide Web
    • B)World Wide Wait
    • C)Wide World Web
    • D)None of the above

    Explanation: WWW stands for World Wide Web, which is not among the options.

24. 24The Correlation can be calculated in Excel using a ______ function.

    • A)Correl
    • B)Correlation
    • C)Cor
    • D)None of the above

25. 25Two different Boolean expressions are said to be ______ if they have the same truth table.

    • A)Equivalent
    • B)Equal
    • C)Compatible
    • D)None of the above

26. 26The ongoing phase of the software life cycle is ______.

    • A)Maintenance
    • B)Development
    • C)Testing
    • D)Study

27. 27Final testing is done in ______ phase.

    • A)Testing
    • B)Implementation
    • C)Development
    • D)Maintenance

    Explanation: Acceptance (final) testing happens at implementation.

28. 28The storage unit which is larger than Gigabyte is ______.

    • A)Megabyte
    • B)Petabyte
    • C)Gigabyte
    • D)None of the Above

    Explanation: The next unit is the terabyte; of the options only the petabyte is larger than a gigabyte.

29. 29A Gigabyte is exactly equal to ______ MB.

    • A)1024
    • B)256
    • C)64
    • D)8

    Explanation: The printed wording is garbled ("the storage unit which is larger than Gigabyte"); 1 GB = 1024 MB.

30. 30The speed (access time) of RAM is of the order of ______ seconds.

    • A)Nano
    • B)Mega
    • C)Micro
    • D)None of the Above

31. 31The convention that a byte consists of 8 bits means that 1 byte can achieve as many as ______ states.

    • A)512
    • B)128
    • C)64
    • D)256

    Explanation: 2⁸ = 256.

32. 32The ______ are high speed temporary storage areas of the micro processor.

    • A)Cache
    • B)RAM
    • C)ROM
    • D)Hard Disk

    Explanation: Strictly these are registers; of the options, cache is the closest.

33. 33______ is the physical component of the computer.

    • A)Hardware
    • B)CPU
    • C)Hard Disk
    • D)Micro Processor

34. 34A pictorial representation of a command or task that is used in a GUI is called ______.

    • A)Icon
    • B)Button
    • C)Graphics
    • D)None of the Above

35. 35First high level language was ______ designed in 1954 at IBM under the direction of John Backus.

    • A)Fortran
    • B)BASIC
    • C)PASCAL
    • D)Visual Basic

36. 36High Level Languages generally characterize the ______ generation of computers.

    • A)First
    • B)Second
    • C)Third
    • D)Fourth

37. 37A(n) ______ software is used by the computer to manage its internal resources.

    • A)Operating System
    • B)Application
    • C)Packages
    • D)Microsoft Windows

38. 38______ is the shortcut to select (extend) text in MS Word.

    • A)Ctrl+Shift+F8
    • B)Alt+Shift+F9
    • C)Ctrl+Alt+F8
    • D)Ctrl+Alt+F9

    Explanation: Ctrl+Shift+F8 turns on column (block) selection.

39. 39MS Word document can be protected by using ______.

    • A)Protect Document
    • B)Antivirus
    • C)Save As
    • D)Option

40. 40______ file type can not be edited in MS Word.

    • A)TXT
    • B)INI
    • C)EXE
    • D)BAK

41. 41Web pages can be saved in MS ______.

    • A)Word
    • B)Excel
    • C)Access
    • D)PowerPoint

    Explanation: Word, Excel and PowerPoint can all save as a web page; Word is the usual answer.

42. 42MS ______ is used for presentations.

    • A)Word
    • B)Excel
    • C)Access
    • D)PowerPoint

43. 43In MS Word a new shortcut button can be added by using ______.

    • A)Customize
    • B)Option
    • C)Tools
    • D)Format

44. 44______ key(s) is/are used for spell check in MS Word.

    • A)F3
    • B)F4
    • C)Alt+F7
    • D)F7

45. 45______ data type is not supported in MS Access.

    • A)Date
    • B)Number
    • C)Character
    • D)Memo

    Explanation: Access uses Text, not Character.

46. 46Give the PLURALS of: (A) Axis (B) Radius (C) Crisis (D) Criterion

    Answer: Axes, radii, crises, criteria.

47. 47Write the wrong word in these sentences: (A) Who did you meet? (B) A wonderful prospect lays before the youth of today.

    Answer: (A) "Who" should be "Whom". (B) "lays" should be "lies".

48. 48Identify the words of opposite meaning: (A) Abuse (B) Short (C) Censure (D) Tainted — I. Protracted II. Praise III. Pure IV. Praise

    Answer: Abuse – Praise; Short – Protracted; Censure – Praise; Tainted – Pure.

49. 49Match the word that has the same meaning: (A) Tremble (B) Taste (C) Calm (D) Candid — I. Serene II. Sincere III. Savour IV. Shudder

    Answer: Tremble – Shudder; Taste – Savour; Calm – Serene; Candid – Sincere.

50. 50Write the PAST TENSE: (A) Wake (B) Give (C) Commit (D) Bid

    Answer: Woke, gave, committed, bid (or bade).

51. 51Identify the correct spelling: (A) Assessment / Assesment / Asessment (B) Relief / Releif / Releef (C) Recieve / Receive / Receve (D) Laisure / Liesure / leisure

    Answer: Assessment, Relief, Receive, Leisure.

52. 52Find the word ending with the suffix "-ship" (e.g. a ship propelled by steam is a steamship): (A) An agreement that exists between persons engaged in business (B) Skill of an expert worker

    Answer: (A) Partnership (B) Craftsmanship (or workmanship).

53. 53Write the female gender: (A) Sheep (B) Waiter (C) Dog (D) Host

    Answer: Ewe, waitress, bitch, hostess.

54. 54One who keeps books or is skilled in monetary matters.

    • A)Treasurer
    • B)Accountant
    • C)Banker
    • D)Cashier

55. 55A dealer in cloth or cloth goods

    • A)Draper
    • B)Tailor
    • C)Outfitter
    • D)None of them

56. 56Garment that is not well-fitted

    • A)Loose
    • B)Lose

57. 57A part or character in a film or drama

    • A)Roll
    • B)Role
    • C)Roal

58. 58A profession or occupation chosen as one's life work

    • A)Carrier
    • B)Carreer
    • C)Career
    • D)Carier

59. 59Fill in the blanks: (A) Ways and ______ (B) Ready and ______

    Answer: Ways and means; ready and willing.

60. 60Pakistan became ISLAMIC REPUBLIC OF PAKISTAN on

    • A)23 March 1956
    • B)14 August 1947
    • C)23 March 1940
    • D)24 August 1955

61. 61Poet who wrote Pakistan's national anthem

    • A)Faiz Ahmad Faiz
    • B)Allama Iqbal
    • C)Hafeez Jalandhari
    • D)Ahmad Faraz

62. 62Sindh's first Governor after 14 August 1947

    • A)Mian Ameenuddin
    • B)Sir Shahnawaz Bhutto
    • C)Ayub Khuro
    • D)Ghulam H. Hidayatullah

63. 63Mangla Dam is located in

    • A)AJ & K
    • B)Northern Areas
    • C)Punjab
    • D)NWFP

64. 64Pakistan's total area in Sq Km

    • A)796,095
    • B)796,905
    • C)796,950
    • D)796,590

65. 65First Martial Law was proclaimed in

    • A)July 1977
    • B)Oct 1958
    • C)Oct 1956
    • D)Jul 1957

66. 66Who started the Reshmi Roomal Movement?

    • A)Ubaidullah Sindhi
    • B)Maulana Mahmoodul Hasan
    • C)Sir Syed Ahmad Khan
    • D)Khan A. Ghaffar Khan

    Explanation: Led by Maulana Ubaidullah Sindhi under Shaikh-ul-Hind Mahmood-ul-Hasan.

67. 67Quaid-e-Azam presented 14 points in

    • A)1929
    • B)1916
    • C)1931
    • D)1940

68. 68Actual name of Sukkur Barrage

    • A)Lloyd Barrage
    • B)Ghulam Mohammad Barrage
    • C)Guddu Barrage
    • D)Taunsa Barrage

69. 69Pakistan's Shortest and Longest Rivers

    • A)Chenab & Indus
    • B)Ravi & Indus
    • C)Sutlej & Indus
    • D)Beas & Indus

    Explanation: As expected by the paper.

70. 70Country that recently banned the use of head scarves by Muslim female students

    • A)Germany
    • B)Spain
    • C)USA
    • D)France

    Explanation: France, March 2004.

71. 71India recently signed an agreement for purchase of a state-of-the-art Radar system with

    • A)USA
    • B)Israel
    • C)UK
    • D)Russia

    Explanation: The Phalcon AWACS deal (2004).

72. 72On-going uprising in Kashmir started in

    • A)1989
    • B)1990
    • C)1988
    • D)1991

73. 73Early elections in India are due from

    • A)20 May
    • B)15 May
    • C)20 Apr
    • D)15 Apr

    Explanation: The 2004 general election began on 20 April.

74. 74Who will challenge George Bush in elections later this year?

    • A)Al Gore
    • B)George Tenet
    • C)Colin Powell
    • D)John Kerry

75. 75Pakistan's current Finance Minister

    • A)Mahmood Ali Kasuri
    • B)Liaqat Jatoi
    • C)Shaukat Aziz
    • D)Hafeezullah Shaikh

76. 76Olympic 2004 will be held in

    • A)Athens
    • B)Beijing
    • C)Munich
    • D)London

77. 77SAARC games are due to start in Islamabad on

    • A)29 April 2004
    • B)15 April 2004
    • C)27 March 2004
    • D)29 March 2004

78. 78Malaysia's sitting Prime Minister

    • A)Dr Mahathir Mohammad
    • B)Abdullah Badawi
    • C)Dr Saleh Al-Sadlan
    • D)None of the above

79. 79Latest train bombing took place in

    • A)France
    • B)Germany
    • C)Spain
    • D)Italy

    Explanation: Madrid, 11 March 2004.

80. 80Airplane was invented by Wright Brothers in:

    • A)1905
    • B)1900
    • C)1909
    • D)1903

81. 81Longest and Shortest solar days in Northern Hemisphere fall on, respectively

    • A)21 June & 22 December
    • B)22 June & 22 December
    • C)23 June & 21 December
    • D)21 June & 21 December

82. 82Earth rotates round its axis

    • A)Once in 24 hours from EAST to WEST
    • B)Once in 24 hours from WEST to EAST
    • C)Once in 365 days from WEST to EAST
    • D)Once in 365 days from EAST to WEST

83. 83Which of the following denotes ONE BILLION

    • A)1,000,000
    • B)1,000,000,000
    • C)10,000,000
    • D)1,00,00,000

84. 84SAARC stands for

    • A)South Asian Association for Regional Conference
    • B)South Asian Association for Regional Collaboration
    • C)South Asian Association for Regional Countries
    • D)South Asian Association for Regional Co-operation

85. 85UN Headquarters are located in

    • A)Washington
    • B)New York
    • C)Geneva
    • D)London

86. 86WMD stands for

    • A)Women for Mass Demonstration
    • B)World Maritime Day
    • C)Weapons of Mass Destruction
    • D)World Muslim Day

87. 87Pakistan defeated India in Olympic Hockey Finals for the first time in

    • A)Montreal in 1976
    • B)Munich in 1972
    • C)Rome in 1960
    • D)Tokyo in 1964

88. 88Identify Pakistan's national game

    • A)Cricket
    • B)Hockey
    • C)Kabaddi
    • D)Squash

89. 89Who suggested the word PAKISTAN as name of our country

    • A)Allama Mohammad Iqbal
    • B)CH Rehmat Ali
    • C)Ch Khaliquz Zaman
    • D)Maulvi Fazlul Haq

    Explanation: The paper prints "Rehmat Ilahi"; it was Choudhry Rahmat Ali (1933).

90. 90SURAH-E-TAUBA starts without Bismillah

    • A)TRUE
    • B)FALSE

91. 91Name of Father of Holy Prophet Muhammad (PBUH)

    • A)Hazrat Abu Talib
    • B)Hazrat Abdullah
    • C)Hazrat Abdul Muttalib
    • D)None of the Above

92. 92Identify the shortest & longest surah respectively as laid down in QURAN-e-PAK

    • A)Surah-e-KAUSAR and Surah-e-BAQARAH
    • B)Surah-e-KAUSAR and Surah-e-AAL-e-IMRAAN
    • C)Surah-e-AN'NAS and Surah-e-BAQARAH
    • D)Surah-e-KAUSAR and Surah-e-RAHMAN

93. 93Who compiled the Quran Shareef in its present form

    • A)Hazrat ALI (AS)
    • B)Hazrat USMAN (RA)
    • C)Hazrat UMER (RA)
    • D)Hazrat ABU BAKR (RA)

94. 94Longest duration of Khilafat was that of

    • A)Hazrat USMAN (RA)
    • B)Hazrat ABU BAKR
    • C)Hazrat UMER (RA)
    • D)Hazrat ALI (AS)

    Explanation: About 12 years.

95. 95Hajj became compulsory in the Year

    • A)9 AH
    • B)5 AH
    • C)2 AH
    • D)7 AH

96. 96Identify the SEVENTH month of the Lunar calendar

    • A)Jamadi-ul-Awwal
    • B)Shawwal
    • C)Rajab-ul-Murajjab
    • D)Shabaan

97. 97The First Mosque on earth was (A) Masjid-e-Nabawi (B) Masjid-e-Aqsa (C) Masjid-e-Qiblatain (D) Masjid-e-Nimra

    Answer: None of the printed options: the first mosque on earth is Masjid al-Haram (the Kaaba), and the first mosque built by the Holy Prophet (PBUH) is Masjid-e-Quba.

98. 98Hazrat Ali embraced shahadat on

    • A)19 Ramazan
    • B)17 Ramazan
    • C)13 Rajab
    • D)21 Ramazan

    Explanation: He was struck on 19 Ramazan and passed away on 21 Ramazan 40 AH.

99. 99First woman to accept Islam

    • A)Hazrat Khadija
    • B)Hazrat Aisha
    • C)Hazrat Amna
    • D)None of the Above