bla bla bla PDF Past Paper

1. Microso Word can be used to create a a. Leter b. Spreadsheet c. Database ﬁles d. Slideshow presenta on Answer: A 2. The larger and more complicated a system, the more diﬃcult it is to achieve goal. a. concession b. decision c. conﬂict d. congruence Answer: D 3. Which of the following is not a basic step in crea ng the worksheet? a. a. Save the work b. b. Modify the worksheet c. C. Enter text and data d. d. Copy the worksheet Answer: D 4. The undo command is useful for a. Restoring to disk the last ﬁle deleted b. Reversing the most recent ac on or command c. Clearing the contents of the d. Clears the document windows Answer: B 5. The …………… is a database model conceived as a ﬂexible way of represen ng objects and their rela onships. a. Hierarchical data b. Network model c. sta c model d. DATA model Answer: B 6. When you want to create an anima on eﬀect in MS PowerPoint that moves in a custom path deﬁned by you, you use a. Custom move b. Strategic move c. Custom path d. Mo on path Answer: D 7. What is a hash total? a. The number of documents processed b. The number of lines of data entered c. The grand total of all rows and columns processed d. None of the above Answer: D 1 8. To select one hyperlink a er another during a slide presenta on, what do you press? a. Tab b. CTRL + K c. CTRL + H d. All of above Answer: A 9. The selec on bar is a. Below the tle bar b. To the far le of your document c. Used to open other Oﬃce applica ons d. None of the above Answer: B 10. The characters word inserts into you document is called a. Removable characters b. Non-prin ng characters c. Prin ng characters d. Hidden characters Answer: B 11. Small code snippets writen into the Microso Visual Basic for Applica ons or automa cally, generated while recording macros are called a. Func ons b. Modules c. Controls d. Visual Answer: B 12. When the formula bar is ac vated, you can see a. The Edit Formula buton b. The Cancel buton c. The Enter buton d. All of above Answer: D 13. The default way for anima on to Start is a. On Click b. With Previous c. A er Previous d. Loop Answer: A 14. A link in a MS Word document may a. Refer to the external ﬁle b. Refer to a web address c. Refer to a posi on in the word document d. All of the above Answer: D 2 15. _____________is the familiar Microso Oﬃce now available on cloud as SaaS. a. a. Force.com b. B. Windows Azure Pla orm c. c. Dropbox d. d. Oﬃce 365 Answer: D 16. You can sort in a table using which of the following techniques? a. a. Click the Sort & Filter buton On the Home tab on the Ribbon b. b. Right-click the table and then to Sort on the shortcut menu c. c. Use the sort buton on the Data tab on the ribbon d. d. All Of the above Answer: D 17. A fraud perpetrated by tricking a person into disclosing conﬁden al informa on, such as a password, is called: a. A Trojan Horse b. Social Engineering c. Hacking d. Scavenging Answer: B 18. When you want to create an anima on eﬀect in MS PowerPoint that moves in a custom path deﬁned by you, you use a. Custom move b. Strategic move c. Custom path d. Mo on path Answer: C 19. Internet Financial Repor ng refers to: a. The use of company website to distribute ﬁnancial informa on b. The use of digital media to distribute the ﬁnancial informa on c. The use of XBRL to distribute the ﬁnancial informa on d. The use of XML to distribute the ﬁnancial informa on Answer: A 20. __________is the family of computer language used by computer programs. a. DML b. DDL c. DCL d. SSL Answer: A 21. The select Object Browser is located a. In the lower-le corner of the word screen b. Below the ver cal scroll bar c. On the menu bar d. On the forma ng toolbar Answer: B 3 22. When integra ng MS word and MS Excel, Word is usually the a. Server b. Source c. Client d. None Answer: C 23. A style is a format-enhancing tool that does not include a. Font Size b. Font Family c. File Name d. Line Height Answer: C 24. The ___________entry of the func on is made up of two expressions and a comparison operator. a. logical_test b. value_if_true c. value_if_false d. value_if_equal Answer: A 25. While more is o en considered beter, we reach a point at which our human minds cannot eﬀec vely absorb and process more informa on. This condi on is called: a. Neural Collapse b. Strategic Capacity c. Informa on Overload d. Decision Aid Deﬁcient Answer: C 26. A web applica on or _________ is any applica on so ware that runs in a web browser. a. Web App b. Computer c. Cloud d. Laptop Answer: A 27. To make your PowerPoint presenta on more impressive you can add a. Tables b. Video c. Sound d. All of the above Answer: D 28. The AIS plays an important role in maintaining a strategic posi on. a. TRUE b. FALSE Answer: A 4 29. In a MS Word document, the minimum line or with, you can set is a. 1/8 pt b. 1/4 pt c. 1/2 pt d. 1 pt Answer: B 30. It is desirable that your new so ware also supports expor ng and impor ng documents in ____________ formats, too. a. XML and XBRL b. auditable and printable c. receivable and payable d. word and excel Answer: A 31. TO run a macro in excel, when you are in VBA window, you press a. F5 b. ALT+F5 c. CTRL+F5 d. F4 Answer: A 32. ____________ separates the contents of one excel cell into separate columns. a. Text to Columns b. Concatenate c. Condi onal Forma ng d. Column Answer: A 33. The Rehearsal buton that clears the Slide Time box and resets the me to 0:00 is the _________ buton. a. Repeat b. Pause c. Elapsed Time d. Slide Time Answer: A 34. A communica on network which is used by large organiza on over regional, na onal, or global area is called a. LAN b. WAN c. MAN d. Intranet Answer: B 5 35. When you get more informa on than you can eﬀec vely assimilate, you suﬀer from informa on ___________ a. Overload b. Due c. Overdra d. Increase Answer: A 36. How can you create a uniform appearance by adding a background image to all slides? a. Create a template b. Edit the slide master c. Use the autocorrect wizard d. All of the above Answer: B 37. Formulas in Excel start with a. % b. = c. + d. - Answer: B 38. You create only a horizontal page break by ﬁrst selec ng can a. A row below the row where you want the page break to occur b. A cell in row 1 c. A cell in column A d. A and C Answer: D 39. An accoun ng informa on system adds value to an organiza on in many ways. Which of the following is not a way in Which the AIS adds value? a. Monitoring outputs for defects to increase product quality b. Providing more mely informa on c. Providing more accurate informa on d. Sharing exper se e. e. Monitoring outputs for defects to reduce the amount of waste f. All Of the above are ways in which an AIS adds value to the organiza on Answer: F 40. Reviewers o en use ______________ to communicate sugges ons, ps, and other messages to the author of a document. a. Pages b. Links c. Comments d. Notes Answer: C 6 41. Jovi and Associates operate a decora ve stone and brick wholesale opera on. Much of their inventory is stored outdoor. They have decided to put up a fence to safeguard their inventory. This would be considered a ______________ a. detec ve control b. prescrip ve control c. preventa ve control d. correc ve control Answer: C 42. OpenERP a. Tiny ERP b. Odoo c. Bodoo d. OpenERP Answer: B 43. An accoun ng informa on systems topics impact corporate strategy and ___________ a. Culture b. Heritage c. Gender d. Business plans Answer: A 44. IBM's ______________ was one of the ﬁrst DBMS's a. LMS b. CMS c. MMS d. IMS Answer: D 45. A denial-of-service atack occurs when perpetrator a. Sends e-mail bombs b. Installs a logic me bomb c. Eavesdrops d. Cracks a computer system Answer: A 46. Themes in word document can be saved and exported to be used by other people, a. True b. False Answer: A 47. Which of the following do you need to consider when you make a table in Database? a. Data types b. Primary keys c. Default values d. All of the above Answer: D 7 48. What are the banded rows in a table a. The rows that are collapsed when the size of the table rows or column are squeezed b. Hidden rows in a table c. Alterna vely, colored rows of the table d. Top row of the table also called header Answer: C 49. Which of the following statements is not true with respect to the characteris cs of the Master and the Transac on ﬁles? a. A transac on ﬁles contain records that hold the details of daily events aﬀec ng an atribute of the master ﬁle. b. A master ﬁle should only contain data that are of a permanent or nature. c. A transac on ﬁle is similar to a ledger in a manual accoun ng system. d. Records in a transac on ﬁle are used to update some data in the master ﬁle. Answer: C 50. Design templates that can be applied to an en re presenta on that allows for consistency throughout the presenta on. a. Layout b. Color c. Themes d. Standards Answer: C 51. Data ﬁelds a. Are indicated by column in a table b. May be le empty c. Separate data into many logical parts d. On the botom of ver cal scroll bar Answer: B 52. To drag a selected range of data to another worksheet in the same workbook, use the a. Tab Key b. Alt Key c. Shi Key d. Ctrl Key Answer: D 53. The __________ is a Short horizontal line indica ng the conclusion of a document. a. Intersec on point b. End mark c. Status indicator d. Scroll box Answer: B 54. Which one of the following is not RDBMS component? a. SQL engine b. Interface Driver c. Sub Language d. DDL Answer: C 8 55. In MS Excel, you can ac vate a cell a. Pressing the tab key b. Clicking the cell c. Pressing arrow key d. All of above Answer: D 56. A ______________ is a storage device connected to the server on a computer network a. Network drive b. Network memory port c. Server device d. Portable device Answer: A 57. Which font is name/logo? a. Bell MT b. Arista Light c. Dotum d. MeiryO Answer: B 58. Microso Access is a a. RDBMS b. OODBMS c. ORDBMS d. Network database model Answer: A 59. A fraud perpetrated by tricking a person into disclosing conﬁden al informa on, such as a password, is called a. Trojan house b. Social engineering c. Hacking d. Scavenging Answer: B 60. On an excel sheet the ac ve cell in indicated by, a. A dark side borders b. A doted border c. A blinking border d. None of the above Answer: A 61. The key F12 opens a a. Save as dialog box b. Open box c. Save box d. Close dialog box Answer: A 9 62. Odoo is available to install on LINUX and Windows system a. True b. False Answer: A 63. ______________ is an accoun ng framework for modelling an organiza ons cri cal resource, events, and agents (REA) and the rela onships them. a. REA b. PEA c. GLA d. TEA Answer: A 64. What types of threats confront a company? a. Strategic b. Opera onal c. Financial d. Informa on e. All of above Answer: E 65. An overlay network is, a. the connec on of two or more private networks. b. a kind of physical network connected by virtual or logical links. c. a computer network which is built on top of another. d. a gaming network developed for fast gaming performance for collaborate gaming experience. Answer: C 66. You can use a custom character a font as a bullet in a document list. a. True b. False Answer: A 67. You can prevent invalid data from being entered into a cell by using: a. Data valida on b. What if analysis c. Watch window d. Data manager Answer: A 68. The resul ng _________ can be used internally by management or externally by other interested par es including investors, creditors, and tax authori es. a. Financial b. Sta s cal c. Economical d. Mathema cs Answer: B 10 69. To update a formula in a table, press the a. F9 key b. ALT+F9 key c. Shi +F9 key d. F8 key Answer: A 70. The keyboard shortcut to align jus ﬁed to text as a. CTRL+L b. CTRL+R c. CTRL+E d. CTRL+J Answer: D 71. Informa on is the data that has been ________ and _______ to provide meaning to user a. Organized b. Processed c. Filtered d. Cleared Answer: AB 72. TO display hyperlink ﬁelds in a work document, you can press the. a. CTRL+SHlFT+F9 keys b. SHIFT+F9 keys c. CTRL + ALT keys d. None of the above Answer: D 73. The opera ng system of a computer serves as a so ware interface between the user and, a. Hardware b. Peripheral c. Memory d. Screen Answer: A 74. Which command brings you to the ﬁrst slide in your presenta on? a. Next slide buton b. Page up c. CTRL+ Home d. CTRL+ End Answer: C 75. Enterprise resource planning (ERP) is an informa on system model that enables an organiza on to __________ and ___________ it's key business processes. a. Automate b. Integrate c. Disperse d. Diverse Answer: AB 11 76. To determine the style of a par cular sec on of a word document, you can used a. Hyphena on b. Thesaurus c. Style inspector d. Style auto-correc on Answer: C 77. Which of the following doesn't inﬂuence the design Of an Accoun ng Informa on System (AIS)? a. Organiza on culture b. Informa on technology c. Business strategy d. Legal environment Answer: D 78. A __________ typed value that is self-deﬁning a. Literal b. Bilateral c. Interval d. Qualiﬁer Answer: A 79. A rela onal database materials data by using common ____________ found within the data set. a. Characteris cs b. Methods c. Features d. Syntax Answer: A 80. Borders can be applied to, a. Cells b. Paragraph c. Text d. All Of the above Answer: D 81. If you press SHIFT key when drawing a line in a document. a. The line will be forced to be ver cal b. The line will be forced to be straight c. The line will be automa cally draw with end arrow d. The line will be automa cally draw with start arrow Answer: AB 82. We use ______________ for condi onal selec on in SQL. a. WHEN b. WHERE c. IF d. WHERE IF Answer: B 12 83. Every company has the goal of making fraud less likely to occur. Which of the following are likely to help a company achieve this goal? a. Proper hiring and ﬁring prac ces b. Managing disgruntled employees c. Requiring signed conﬁden ality agreements d. All of the above Answer: D 84. The ____________is a database model conceived as a ﬂexible way of represen ng objects and their rela onships a. Hierarchical data b. Network model c. Sta c model d. Data model Answer: B 85. A _____________ model is a data model in which the data is organized into a tree-like structure a. Hierarchical data b. Network data c. RDBMS d. DBMS Answer: A 86. The produc on department (a subsystem) of a company might have to ______________ its goal of staying with its budget in order to meet the organiza on goal of delivering product on me. a. Forego b. Undergo c. API d. Deﬁne Answer: A 87. Where Can you ﬁnd the horizontal split bar on MS Word Screen? a. On the le of horizontal scroll bar. b. On the right of horizontal scroll bar. c. On the top of ver cal scroll bar. d. On the botom of ver cal scroll bar. Answer: C 88. A\An ____________ is a ques on presen ng in a way for access to process a. Query b. Inquiry c. FAQ d. None of the above Answer: A 13 89. In most of the desktop computers and laptops, there is a fan inside the box, the main purpose of the fan is a. To prevent bugs like mosquito to enter into the computer b. To distribute the air evenly inside the box of computer c. To reduce the heat generated inside the box d. To convert AC current into DC current because all the AC need to be converted into DC before it can be u lized by computer parts. Answer: C 90. The primary job of opera ng system of computer is to a. Command resources b. Manage resources c. Provide resources d. None of the above Answer: B 91. You can add a date to a document by a. Inser ng a text date b. Inser ng a date ﬁeld that will update automa cally c. Typing the date manually d. All of the above Answer: B 92. A _____________is an interac ve view of worksheet data that gives you the ability to summarize the data and then the tables row and column tles to show diﬀerent views. a. PivotChart b. Rotate Chart c. PivotTable d. Interac ve Table Answer: C 93. What is the term used when you press and hold the le mouse key and more move the mouse round slide? a. Highligh ng b. Dragging c. Selec ng d. Moving Answer: B 94. Which of the following should be used when you want to add a slide to an exis ng presenta on a. Insert Tab, Add a New Slide b. Insert, New Slide c. File, Open d. File, New Answer: B 14 95. Standards are derived from societal mores and deep-rooted social beliefs about issues of right and wrong that are not universally agreed upon. a. Ethical b. Business c. Modern d. Tradi onal Answer: A 96. When the formula bar is ac vated, you can see a. The Insert Func on Buton b. The Cancel Buton c. The Enter Buton d. All of the above Answer: D 97. What Is private cloud? a. A standard cloud service oﬀered via internet b. A cloud architecture maintained within an enterprise data center c. A cloud service inaccessible to anyone but the cultural elite. d. A cloud to maintain privacy Answer: B 98. Which of the following is not a font style? a. Bold b. Italics c. Regular d. Superscript Answer: D 99. The computer stores its program and data in its a. Arithme c Control Unit (ALU) b. Control unit (CU) c. Memory d. Cache memory Answer: C 100. The basic opera on performed by a computer is a. Arithme c opera ons b. Logic opera ons c. Storage and retrieval opera ons d. All Of the above Answer: D 101. What is guter margin? a. Margin that is added to the le margin when prin ng b. Margin that is added to right margin when prin ng c. Margin that is added to the binding side of page when prin ng d. Margin that is added to the outside of the page when prin ng Answer: C 15 102. A DBMS some mes called a. Database b. Database manager c. DB Management d. RDBMS Answer: B 103. Which of the following is used for modula on and demodula on? a. Modem b. Protocols c. Gateway d. Mul plexer Answer: A 104. Odoo was known as ___________ on the ﬁrst lunch. a. OpenERP b. TinyERP c. Odoo d. Bodoo Answer: B 105. The shortcut key combina on to show all the formulas in a work sheet is a. Ctrl + A b. Ctrl + ^ c. Ctrl + ` d. Ctrl + Shi + F Answer: C 106. The Func on Days360 a. Gives you how many days diﬀerence there are between two dates b. Tells you there may be 360 days in a par cular leap year c. There is no Days360 func on available in Excel d. Is used with Nepali Calendar date system Answer: A 107. Characteris cs of Accoun ng Informa on System. Choose all that are applicable. a. Relevance b. Reliability c. Popular d. Low Cost Answer: AB 108. Portrait and landscape are a. Page Orienta on b. Page size c. Page Layout d. All the above Answer: A 16 109. Listed below are the four characteris cs that make informa on useful and meaningful, Pick the characteris c that relates to informa on's ability to reduce uncertainty. a. Relevant b. Reliable c. Complete d. Timely Answer: A 110. The resul ng _________ can used internally by management or externally by other interested par es including investors, creditors, and tax authori es. a. Financial b. Sta s cal c. Economical d. Mathema cal Answer: B 111. IT ______________ a. is a collec on of data and processing procedures that creates needed informa on for its users b. is enterprise resources planning c. refers to the hardware, so ware, and related system components that organiza ons use to create computerized informa on system. d. conduct business over the internal or dedicated proprietary networks and e- commerce which refers mostly to buying and selling on the internet. Answer: C 112. Opera ng system is a. A collec on of hardware components b. A collec on of input/output devices c. A collec on of so ware rou nes d. None of the above Answer: C 113. ____________ is a very strong security password control feature in Tally a. Data Encryp on b. Tally Vault password c. Firewall d. Access Control Answer: B 114. By default, Track Changes is enabled in MS Word 2007 a. True b. False Answer: B 17 115. What type Of Cloud is a composi on of diﬀerent clouds? a. Private cloud b. Public cloud c. Hybrid cloud d. White cloud Answer: C 116. An e-business that allows consumer to name their own price for products and services is following which e-business model? a. B2B b. C2C c. C2B d. B2G Answer: C 117. When you work with large worksheets, you may need to a. Size the worksheet to ﬁt on the speciﬁc number of pages b. Add and remove page breaks c. Specify only certain print areas d. All of the above Answer: D 118. A DBMS is like ____________ a. Database b. File manager c. Store keeper d. Manager Answer: B 119. ____________ is when the computer is turned on and the opera ng system is loading. a. Boo ng b. Hashing c. Trapping d. Tracking Answer: A 120. Diﬀerent arithme c opera on (choose all that are applicable) a. Addi on b. Subtrac on c. Mul plica on d. Division Answer: ABCD 121. To calculate the Cosine of an angle, you can use a. COSINE (number) b. COS (number) c. DEGREE (number) d. COS (angle, degree) Answer: B 18 122. A ﬁle with the _______________ ﬁle extension is an Excel Macro-Enabled Workbook ﬁle. a. *.xlm b. *.xls c. *.xlsx d. *.xlsm Answer: D 123. The process of combining two or more text data items into a single expression is called a. Binding b. Concatena on c. Controlling d. posi oning Answer: B 124. Which of the following is a secondary memory device? a. Keyboard b. Disk c. Arithme c Logical Unit (ALU) d. All of the above Answer: B 125. SQL stands for _____________ a. Structure Queries Language b. Structured Queries Language c. Structure Query Language d. Structured Query Language Answer: C 126. RAM chips _____________ a. Allow the computer to store data electronically b. Store data indeﬁnitely unless you delete it c. Are always measured in thousands of bytes d. All of the above Answer: A 127. OpenERP is currently known as a. WebERP b. OﬃceERP c. Odoo d. Bodoo Answer: C 128. RDBMS stands form a. Redundant Database Management System b. Rela onal Database Management System c. Redundant Database Management Server d. Rela onal Database Management Server Answer: B 19 129. Which of the following is the fastest a. Central Processing Unit (CPU) b. Magne c Tapes and disks c. Video terminal d. Sensors, mechanical controllers Answer: A 130. DDL stands for a. Data Dic onary Language b. Data Deﬁni on Language c. Default Dic onary Language d. Dumb Dialogue Language Answer: B 131. DDL statements a. Create b. Alter c. Drop d. All of the above Answer: D 132. The main elements of the ___________ inser on point, end mark, mouse pointer, ruler, scrollbars, and status bar. a. Word toolbar b. Forma ng toolbar c. Word document window d. Graphics toolbar Answer: C 133. In Quick Access Toolbar a. Only the commands that are available in the ribbon can be added b. Some commands that are not available in the ribbon can also be added c. Only ﬁle opera on command can be added d. Only ﬁle forma ng command can be added Answer: B 134. ________ allow an image to be speciﬁed for use as a watermark behind the data in cells of a worksheet. a. Worksheet backgrounds b. Data cell merging c. Schema d. style Answer: A 135. The AIS is of three major subsystems a. The ﬁnancial management system b. The management informa on system c. The general ledger/ﬁnancial repor ng system d. The transac on processing system Answer: BCD 20 136. The func ons Of Accoun ng Informa on Systems are a. Collect and store data about agents. b. Transform that data into informa on that management can use to make decisions about events, resources, and agents. c. Provide adequate controls to ensure that the en ty's resources. d. All Of the above Answer: D 137. This key Uniquely Iden ﬁes Each Record a. Primary Key b. Key Record c. Unique Key d. Field Name Answer: A 138. You should use type when the ﬁeld contains text that is variable in length, and can poten ally be lengthy. a. Memo b. Text c. Atachment d. Hyperlink Answer: A 139. A er you create a document, you may need to a. A. Close it b. B. Preview it and Print it c. C. Save it d. D. All of the above Answer: D 140. Oﬃce automa on refers to a. Automa cally run the Microso Oﬃce 2007. b. The varied computer machinery and so ware. c. Automa c transmission of data. d. Oﬃce payroll. Answer: B 141. You can select all the pictures in a word or Excel by going to a. Home> Edi ng> Select> Select Objects b. Home> Edi ng> Select Objects c. Home>Edi ng> Select> Select All d. Home> Edi ng>Select All Answer: A 21 142. An AIS __________ a. is a collec on of data and procedures that creates needed informa on for its b. is enterprises planning c. refers to the hardware, so ware, and related system components that organiza ons use to create computerized informa on system. d. Conduct business over the internet or proprietary networks and e-commerce which refer mostly to buying and selling on the internet. Answer: A 143. Odoo (version1.0 was started in ___________ a. 2004 b. 2005 c. 2009 d. 2008 Answer: B 144. Accoun ng informa on systems were predominantly developed "in-house" as a. Legacy systems b. Larger system c. Sub system d. ERP Answer: A 145. The speed of computer is usually measure a. MB or GB b. MHz or GHz c. Mm or Cm d. Bit or Byte Answer: B 146. What does the VLOOKUP func on do? a. Looks up text that contain “V” b. Checks whether text is the same in one cell as in the next c. Finds related records d. Allof above Answer: C 147. What do you mean by one-to-many rela onship between student and class table? a. One class may have many student b. One student may have many classes c. Many classes may have many students d. Many students may have many classes Answer: B 148. The cell reference for cell range of 62 to M12 is a. G2.M12 b. G2,M12 c. G2:M12 d. G2-M12 Answer: C 22 149. Ctrl + V a. Paste text in the beginning of Document b. Paste images in the beginning of Document c. Paste tables at the middle of Document d. None of the above Answer: D 150. What is a mo on path? a. A type of anima on entrance eﬀect b. A method of advancing slides c. A method of moving items on a slide d. All of the above Answer: C 151. What method can you use to a new table to your database? a. Use Design View to create a table b. Enter data directly by using a datasheet c. By execu ng SQL command in Queries d. All of the above Answer: D 152. Thesaurus tool in MS Word is used for a. Spelling sugges ons b. Synonyms and Antonyms words c. Spelling Correc on d. Sentence Correc on and sugges ons Answer: B 153. SaaS refers to a. So ware as a Service b. System audit and accoun ng service c. System as a service d. So ware audit and accoun ng service Answer: A 154. What of the following is not a Database Object? a. Tables b. Queries c. Rela onships d. Reports Answer: C 155. The deﬁni on of fraud includes only acts of lies Bricks, and cunning a. FALSE b. TRUE Answer: A 23 156. An accoun ng informa on system is generally a ____________ ac vity in conjunc on with informa on technology resources. a. Computer-based b. System based c. Manual d. None of the Above Answer: A 157. Which of the following is not part of the merge process? a. Data ﬁeld b. Merge ﬁeld c. Data source d. Main document Answer: A 158. Which ﬁle format can be added to a PowerPoint show? a. *.jpg b. *.gif c. *.wav d. All of the above Answer: D 159. Accoun ng informa on system (AIS) ____________ and process data to produce informa on for decision makers. a. Collect b. Record c. Store d. Manipulate e. Process Answer: ABC 160. This is the stage in database design where one gathers and list all the necessary ﬁelds for the database project a. Data deﬁni on b. Data reﬁnement c. Establishing rela onship d. None of the above Answer: A 161. Using the F11 shortcut key to create a chart on sheet creates a. A default chart b. A 2-dimensional column chart c. A 2-dimensional bar chart d. A 3-dimensional line chart Answer: B 24 162. Which ﬁle starts MS Word? a. winword.exe b. word.exe c. msword.exe d. windword.exe Answer: A 163. What is data? a. All of the facts that are collected stored and processed by an informa on system b. All of the debit and credit informa on about each transac on c. series of Binary d. The same thing as informa on Answer: A 164. ODBMS stands for __________________________ a. Object Oriented Database Management System b. OO Database Management System c. Oodo Database Management System d. Occasional Object Database Management System Answer: A 165. Simply a tool to improve a system. a. Technology b. So ware c. Odoo d. Science Answer: A 166. HOW are the usage fee in the typical So ware-as-a-Service (SaaS) environment calculated? a. Base on the number or user b. The me in use c. Per-record-processed d. All of the above Answer: D 167. _____________ is a specialized or assembly of compa ble tools that enables teams to work for share more informa on, communicate more eﬀec vely, and do a beter job of comple ng tasks. a. Groupware b. Shareware c. Freeware d. Firmware Answer: A 168. _____________ is the shortcut key to start the slide show from beginning of slide a. Shi +F5 b. F5 c. Ctrl + F5 d. Alt + F5 Answer: B 25 169. Track change is available only in Excel a. Excel 2010 or later workbooks b. Workbook containing formulas c. Controlled workbooks d. Shared workbooks Answer: D 170. Which Of the following is a part of the CPU a. Printer b. Keyboard c. Mouse d. Arithme c Logic Unit Answer: D 171. A database scheme _______________ a. is a special purpose language used to data b. is a way to logically group objects such as tables, views stored procedures etc. c. a DBMS component that facilitates the Storage and retrieval of structured informa on on a computer's hard drive d. All of above Answer: B 172. The experimental smoothing analysis tool predicts a value based on the forecast for the prior a. Adjusted for the error in that prior forecast b. Added for the error in that prior forecast c. Subtracted for the error in that prior forecast d. Mul plied for the error in that prior forecast Answer: A 173. ___________ is a ﬁeld that is the primary ﬁeld in its own table, but that shows up in another table. a. Unique key b. Primary key c. Foreign key d. Candidate key Answer: C 174. IBM’s mainframe opera ng systems, the non-rela onal data managers were known a. DBMS b. RDBMS c. File manager d. Access methods Answer: D 175. Status indicators are located on the a. Ver cal scroll bar b. Horizontal scroll bar c. Formula bar d. Forma ng toolbar Answer: C 26 176. __________ is the conversion of data into a form that cannot easily understood by unauthorized people a. Valuing b. Authen ca on c. Encryp on d. Valida on Answer: C 177. Following is not a database model a. Network database model b. Rela onal database model c. Object oriented database model d. Personal Database Model Answer: D 178. ____________ recently gone public through an IPO in November, 2013 a. Microso b. Facebook c. Twiter d. Google Answer: C 179. The main circuit board of the system unit is the _____________ a. Computer program b. Control unit c. Motherboard d. SMPS Answer: C 180. What term refers to a speciﬁc set of values saved with the workbook? a. Range b. Scenario c. Trend line d. What If Analysis Answer: B 181. Characteris cs of Accoun ng Informa on System. Choose all that applicable. a. Relevance b. Reliability c. Popular d. Low cost Answer: AB 182. ____________ add patern and texture to a background. a. Fill eﬀects b. Transi ons c. Shared collec ons d. None of the above Answer: A 27 183. Odoo was known as __________ to a background. a. OpenERP b. TinyERP c. Odoo d. Bodoo Answer: B 184. USB stands for ____________________ a. Universal Serial Bus b. Uniﬁed Simple Bus c. Unique System Bay d. Ultra System Bus Answer: A 185. You Should use the _____________ data type when the ﬁeld contains text that is variable in length and can poten ally be lengthy. a. Memo b. Text c. Atachment d. Hyperlink Answer: A 186. Spelling and grammar checker (spelling and grammar buton), is located on the _____________tab, in the prooﬁng group. a. Home b. Paragraph c. View d. Review Answer: D 187. Cross-reference ____________________ a. creates a link in your document for quick access to web pages and ﬁles. b. refers to speciﬁc places in your document, such as headings, ﬁgures, and tables. c. works with hyperlinks to let you jump to a speciﬁc place in your document. d. All of the above Answer: B 188. Which of the following formula will give you the highest value among the value listed in cell A1 to A5. a. =HIGHEST (A1:A5) b. =MAXIMUM (A1:A5) c. =HIGH (A1:A5) d. =MAX (A1:A5) Answer: D 189. What do you need for an ink jet printer? a. Cartridge b. Drum c. Ribbon d. Toner Answer: A 28 190. LCD stands for ___________ a. Large clear display b. Liquid crystal display c. Limited crystal display d. Large computerized display Answer: B 191. Text format can be copied through a _________ tool available in the Home Tab a. Format Painter b. Format Copier c. Forma ng d. Format Entry Answer: A 192. An audit trial _____________________ a. is to make backup Copies b. recorded history of on a ﬁle c. can be used to restore lost informa on d. None of the above Answer: B 193. There are two types of cell reference methods in the MS Excel formula viz a. Rows and Columns b. Moving and Fixed c. Maximum and Minimum d. Absolute and Rela ve Answer: D 194. HTTPS stands for _____________________ a. Hypertext Transfer Protocol Secure b. Hypertext Transfer Protocol Simpliﬁed c. Hypertext Transfer Protocol Simple d. Hypertext Transfer Protocol Smart Answer: A 195. The Ribbon in Word 2007 consists of a series of a. Groups b. Commands c. Tabs d. Icons Answer: C 196. Rehearse ming helps you to ______________ a. record the amount of me you spend on each slide and save those mings to run the show automa cally in the future b. deﬁne how long an anima on eﬀect is run in a par cular object c. deﬁne how long a transi ons eﬀect last between slides d. be conﬁdent and smart while making a presenta on Answer: A 29 197. The correct func on of PMT func on in Excel a. PMT (rate, nper, pv, [fv]) b. PMT (rate, nper, pv, [type]) c. PMT (rate, nper, pv, [fv], [type]) d. INSTALLMENT (rate, nper, [fv], [type]) Answer: C 198. Every web page has a unique address called a(n) a. Digital address b. URL c. HTTP d. HTTPS Answer: B 199. ____________ is blank space between pages. a. Guter b. Whitespace c. Margin d. Tracking Answer: B 200. Which of the following is not an input device? a. Touch Screen b. Op cal Scanner c. Touch Pad d. Mouse Pad Answer: D 201. When the mouse pointer has a ____________ atached to it, you can drag the graphics to a desire loca on. a. Four-headed arrow b. Red dot c. Large arrow d. Small doted square Answer: A 202. ____________ displays only the slides we select. a. Set up Slide show b. Custom slide show c. From current slide d. Hide slide Answer: B 203. ___________ is the shortcut to Start the slide show from the current slide. a. Shi +F5 b. F5 c. Ctrl + F5 d. Alt + F5 Answer: A 30 204. =NOW () insert the _________ in the select cell in MS Excel. a. Current date b. Current me c. Current date and me d. None of the above Answer: C 205. To change the name "ram" to "raman", which SQL command is used? a. UPDATE b. DROP c. ALTER d. BETWEEN Answer: A 206. Kilobit is equivalent to __________ a. 1024 bytes b. 1024 bits c. 8 bits d. 8 bytes Answer: B 207. Accoun ng Informa on System (AIS) _________, ___________, __________ and process data to produce informa on for decision makers. a. Collect b. Record c. Store d. Manipulate e. Process Answer: ABC 208. The default page size in MS Word is ___________ a. A4 (8.27” x 11.69”) b. Leter (8.5” x 11”) c. Legal (8.5” x 14”) d. None of the above Answer: B 209. To insert new column while selec ng the column header you can press ___________ shortcut key. a. Ctrl + Shi + + b. Ctrl + Insert c. Ctrl + + d. Shi + Enter Answer: A 210. Header and footer are available in ___________ tab in oﬃce 2007. a. Home Tab b. Reference Layout Tab c. Insert Tab d. Page Layout Tab Answer: C 31 211. To insert characters that are not on the keyboard. a. Symbol b. Object c. Equa on d. Clipart Answer: A 212. Which is the default font used in MS word 2007 a. Times New Roman b. Arial c. Algerian d. Calibri Answer: D 213. Which is a view for displaying a report object in MS Access? a. Datasheet View b. Design View c. Print Preview d. Layout Preview Answer: A 214. MAC address is related to ____________________ a. Hard Disk Drive b. CD-ROM Drive c. Graphics Card d. Network Card Answer: D 215. _________ allows you to paste data into diﬀerent formats a. Paste diﬀerent b. Paste Append c. Paste transform d. Paste Special Answer: D 216. When arranging paragraph in alphabe cal, numerical or data based on the ﬁrst character of each paragraph, it is called _______________ a. Forma ng b. Dimensioning c. Ordering d. Sor ng Answer: D 217. Home Key a. Move the cursor beginning of the document b. Move the cursor beginning of the paragraph c. Move the cursor beginning of the screen d. Move the cursor beginning of the line Answer: D 32 218. The cell reference for a range of cells that starts in cell B1 and goes over the column G and down to row 10 is ____________ a. G1-G10 b. B1.C10 c. B1;G10 d. B1:G10 Answer: D 219. Hyperlink cannot be a. Special shapes like stars and banner b. Drawing objects like rectangles & ovals c. Pictures d. All Can be hyperlinks Answer: D 220. When all the numbers between 0 and 100 in a range should be displayed in red color, apply a. Use IF() func on to format the required numbers red b. Apply condi onal forma ng Command on format menu c. Select the cells that contain number between 0 and 100 then click red color on text color tool d. All of the above Answer: B 221. Which enables us to send the same leter to diﬀerent persons? a. Macros b. Template c. Mail Merge d. None Answer: C 222. NOT, AND, OR and XOR are a. Logical Operators b. Arithme c Operators c. Rela onal Operator d. Assignment Operator Answer: A 223. You can use the formula paletes to a. Format cells containing numbers b. Create and edit formula containing func ons c. Enter assump on data d. Copy a range of cells Answer: B 224. We can insert a page number at a. Header b. Footer c. Both A and B d. None Answer: C 33 225. How do you change column width to ﬁt the contents? a. Single-click the boundary to the le to the column heading b. Double click the boundary ta the right of the column heading c. Press ALT and Single click anywhere in the column heading d. All of the above Answer: B 226. Which of the following is not the Sec on Break Op on? a. Next Page b. Previous Page c. Odd Page d. Even Page Answer: B 227. The _________, or typeface, deﬁnes the appearance and shape of leters, numbers, and special characters a. Font b. Font size c. point d. Paragraph forma ng Answer: A 228. A word processor would most likely be used to do a. Keep an account of money spent b. Do a computer search in media center c. Maintain an inventory d. Type a biography Answer. D 229. “New comment” op on can be found under ________ tab a. Insert b. Data c. Review d. View Answer: C 230. Which is an example of a func on? a. ADD (A1:A2) b. ADD (A1, A2) c. SUM (A1:A2) d. SUM (A1, A2) Answer: C D 231. _________ is a data type that assigns values automa cally a. Automa c Number b. Auto Number c. Number d. Automa c Field Answer: B 34 232. The func on that is used to calculate the payment for speciﬁc loan term is a. SUMIF () b. PMT () c. COUNTIF () d. None Of the above Answer: B 233. Which of the following views is the best view to use when se ng transi on eﬀects for all slides in a presenta on? a. Slide Sorter View b. Notes Pages View c. Slide View d. Outline View Answer: A 234. Diﬀerent arithme c operators are (Choose that apply all) a. Addi on b. Subtrac on c. Mul plica on d. Division Answer. A B C D 235. To enter values into the table, __________ query type is used in MS Access. a. Alter b. Insert c. Add d. Append Answer: D 236. Which of the following is considered an absolute cell reference? a. B4 b. $B4 c. B$4 d. $B$4 Answer: D 237. Computer hardware can only understand only two basic concepts represented by a. On and Oﬀ b. 0 and 1 c. True and False d. All of the above Answer: D 238. Guter posi on Can be Set in the following a. Le & Right b. Le & Top c. Le And Botom d. Le Only Answer: B 35 239. Hardcopy is a term used to describe a. Wri ng on a hard board b. Printed output c. Storing informa on on the hard disk d. None of the above Answer: B 240. What term refers to a speciﬁc set of values saved with the workbook? a. Range b. Scenario c. Trend line d. What-if analysis Answer: A 241. Number of rows and columns in Microso excel 2007 is ________ and _______ respec vely. a. 65536,255 b. 65245, 16384 c. 1048576, 255 d. 1048576, 16384 Answer: D 242. Which tab do we ﬁnd Page Setup in PowerPoint a. Design b. Anima ons c. Slideshows d. Home Answer: A 243. ___________ is a workbook allowing mul ple users on a network to view and make Changes to the workbook. a. Distribu ng b. Sharing c. E-mailing d. Copying Answer: B 244. Which of the following op on is not available in a Paste Special dialog box? a. Add b. Subtract c. Divide d. SQRT Answer: D 245. Data valida on is added to Cells by using the _______ buton on the data tab on the ribbon. a. Trace precedent b. Valida on c. Remove precedent d. Data valida on Answer: D 36 246. Which Of the following line spacing is invalid? a. Single b. Double c. Triple d. Mul ple Answer: C 247. Which of the following is not an op on in the spelling dialog box? a. Edit b. Ignore c. Ignore all d. Change Answer: A 248. Which of the following is not a type of rela onship that can applied in access database? a. One to one b. One to many c. Many to many d. All of the above Answer: D 249. Which func on calculates your monthly mortgage payment? a. PMT (payments) b. NPER (number of periods) c. PV (present value) d. FV (future value) Answer: A 250. Which of the following is correct? a. =AVERAGE (4,5,6,7) b. =AVERAGE (A1, B1, C1, D1) c. =AVERAGE (A1:A9, B1:B9) d. All of the above Answer: D 251. Which of the following is not valid version Of MS Oﬃce? a. Oﬃce XP b. Oﬃce Vista c. Oﬃce 2007 d. Oﬃce 2003 Answer: B 252. Where can you set the shading color for a range of cells in Excel? a. Choose required color form Paterns tab of Format Cells dialog box b. Choose required color on Fill Color tool in Forma ng toolbar c. Choose required color on Fill Color tool in Drawing toolbar d. All of the above Answer: D 37 253. Which of the following statement is false? a. You can set diﬀerent header footer for even and odd pages b. You can set diﬀerent page number formats for diﬀerent sec ons pages c. You can set diﬀerent header footer for ﬁrst page of sec ons d. You can set diﬀerent header footer for last page of sec ons Answer: D 254. To insert three columns between column D and E you would a. Select column D b. Select column E c. Select column E, F and G d. Select column D, E and F Answer: C 255. What item contains detail informa on about something in text? a. Footer b. Footnotes c. Header d. Endnotes Answer: B 256. Which command will you choose to convert a column of data into row? a. Cut and Paste b. Copy and Paste c. Transpose d. Transfer Answer: C 257. = (D2:D26*E2:E26) is an example of MS Excel. a. Wrong formula b. Array formula c. Auto formula d. Protected formula Answer: B 258. Tables are related to one another through a. Foreign Key b. Main form and a Sub form c. Query and its associated dynast d. Report and its related query Answer: A 259. Which of the following storage is vola le? a. Semi-conductor Memory b. Floppy Disk c. CD-ROM d. Core Memory Answer: A 38 260. Which is correct form to retrieve data? a. SELECT …… FROM …… WHERE b. SELECT …… WHERE …… FROM c. SELECT …… INTO …… VALUES d. SELECT …… SET …… WHERE Answer: A 261. Basic hardware building blocks which interconnect network nodes are ___________ (Select all that apply) network interface cards. a. Repeaters b. Hubs c. Bridges d. Power sockets Answer: A B C 262. While saving a document of Microso word 2003 extension of the ﬁle be *.doc whereas in Microso Word 2007 extension of saved document is __________ a. *.doct b. *.docx c. *.dotx d. None Answer: B 263. The process of combining names and address with a leter format document to produce customized documents. a. Hyperlink b. Mail Merge c. Header d. None of the above Answer: B 264. Which of the following is the correct IF formula syntax? a. IF (logical_test, [value_if_false], [value_if_true]) b. IF (logical_test, value_if_false, value_if_true) c. IF (logical_test, [value_if_true], [value_if_false]) d. IF (logical_test, value_if_false, value_if_false) Answer: C 265. You can show or hide a _________ or change its loca on. (It contains a list of the variables appearing in the chart and an example of their appearance.) a. Title b. Legend c. Grid d. Labels Answer: B 39 266. PowerPoint presenta on is a collec on of _________ a. Slides and hand-outs b. Speaker's notes c. Outlines d. All of the above Answer: D 267. When you choose the _________ op on, the movie clip will not show un l you click the slide during slide show. a. Oﬀ click b. On click c. When clicked d. None of the above Answer: B 268. Excel doesn't recognize text in the formula or func on, such as the func on name is misspelled. The resul ng error message will be: a. #NUM! b. #VALUE! c. #NAME! d. #N/A Answer: C 269. To alert Excel that you are entering a formula and not text, type a(n) ________ preceding the formula. a. Ampersand (&) b. Equal sign (=) c. Number sign (#) d. Asterisk (*) Answer: B 270. __________ key is always unique. a. Foreign b. Primary c. Linked d. SN Answer: B 271. Samsung Galaxy S4 uses a a. Windows-based opera ng system b. Mobile-based system c. Android-based opera ng system d. Mac-based system Answer: C 40 272. If you use the mul ple ledger crea on feature in Tally a. You can create mul ple ledgers at once. b. You should take care of the account se ngs for each mul ple ledgers. c. Tally makes the task easier by saving the se ng of that ledger as default for the ledgers you create in mul ple mode. d. All of the above. Answer: C 273. Accoun ng on the internet refers to the accoun ng so ware that is hosted on _________ a. Remote servers b. Cloud c. WAN d. LAN Answer: B 274. You can open the sort dialog box by choosing from the __________ Tab a. View b. Home c. Format d. Data Answer: B D 275. The resul ng _______ reports can be used internally by management or externally by other interested par es including, creditors and tax authori es. a. Financial b. Sta s cal c. Economical d. Mathema cal Answer: B 276. A foreign key imposes a speciﬁc kind of integrity to related tables. What is the name of this integrity? a. Schemas b. Referen al c. Domain d. En ty Answer: B 277. The comparison operator __________ means not equal to or does not match text. a. >= b. c. >< d. Custom Transi on b. Slide Show > Slide Transi on c. Slide Show > Custom Anima on d. Slide Show > Slide Anima on Answer: C 343. The op on _________ allows you to change the appearance of the cell depending on certain condi ons a. Valida on b. Data Valida on c. Forma ng d. Condi onal Forma ng Answer: D 344. Which tab/s do we have Macros? a. Developer b. Review c. Insert d. View Answer: A D 345. XML stands for a. Extensible Markup Language b. Xtra Markup Language c. Example Markup Language d. X-Markup Language Answer: A 346. A ___________ is a special eﬀect as one slide replaces or changes to the next slide when we are in slide show view a. Anima on b. Design c. Themes d. Transi on Answer: D 51 347. How many bytes do 4 Kilobytes represent? a. 512 b. 1024 c. 4096 d. 8192 Answer: C 348. To get all columns of the table without typing all column names use a. SELECT column from TableName; b. SELECT * from TableName; c. SELECT # from TableName d. SELECT Like * from TableName Answer: B 349. ____________ allows word to break lines between the syllables of words. Books and magazines use this feature in order to have more uniform spacing between the words. a. Indenta on b. Jus ﬁca on c. Hyphena on d. Orienta on Answer: C 350. __________ runs on computer hardware and serves as pla orm for other so ware to run on e. Opera ng System a. Applica on So ware b. System So ware c. U li es So ware Answer: A 351. What are the individual dots which makes up a picture on the monitor screen called? a. Colored spots b. Pixels c. Dot Matrix d. Dots Answer: B 352. ___________ refers to the storing of the data in the database in an encoded format. a. Encryp ng b. Decryp ng c. Coding d. Decoding Answer: A 353. Internet can be deﬁned as _______________ a. Internal network b. External Network c. Network of Network d. Intermediate Network Answer: B 52 354. If we want our presenta on loops con nuously, which tab do we use? a. Design b. Anima ons c. Slide Show d. Slide Layout Answer: C 355. In MS Word 2007, op ons of First Line, Hanging, Le , Right comes under __________ a. Tables b. Line Number c. Indent Paragraph d. Break Answer: C 356. While anima ons are used in text and objects, transi ons are used in a. Pictures b. Drawings c. Slides d. Charts Answer: C 357. Switching of rows and columns of data is termed as a. Transpose b. Tracking c. Forma ng d. Querying Answer: A 358. VoIP stands for a. Voice Of Internet Protocol b. Voice Over Internet Protocol c. Voice Of Intranet Protocol d. Voice Over Intranet Protocol Answer: B 359. The best way to work with large document is: a. Use document style for text and paragraph style b. Work in MS Excel instead because it supports up to 1048576 rows c. Use Format Painter for document forma ng d. Divide the document in as many sec ons as possible Answer: A 53

bla bla bla PDF Past Paper

Document Details

Tags

Related

Summary

Full Transcript

Upgrade to continue