ITT Final Questions.pdf

q_id q_desc op1 op2 op3 op4 ans Analytical reports in Tally.ERP 9 includes Cash Flow Ratio All of AC1 _____________. Statement Analysis BRS Abo...

q_id q_desc op1 op2 op3 op4 ans Analytical reports in Tally.ERP 9 includes Cash Flow Ratio All of AC1 _____________. Statement Analysis BRS Above D _______________ is a summary of all ledger Trail Balance AC10 balances to check whether the figures are P&L Balance Sheet Ledger B Tally.ERP 9 allows us to maintain and Credit generate all primary books of accounts and Purchase Note All of AC11 registers like_______________. Cash Book Register Register Above D Gateway Gateway of Tally > of Tally > Display > Gateway Display > Account of Tally > Account Books > Display > Books > Register > Register > Sales Sales Sales AC12 Path of Sales Register is ____________. Register Register Register None A AC13 Is Debit Note Register Available in Tally ERP Yes No A Accounts Credit Accounts ____________ refer to amounts to be Payables, Payables,Receivabl Debit received from the sundry debtors while Accounts Debit es,Accoun Receivabl ________________ are the amounts to be Receivabl Receivablts es,Credit AC14 paid to sundry creditors. es es Payables Payables C Both A Nither A AC15 F8 used for ___________ Sales Purchase and B Nor B A ____________Analysis reports for Movemen All of AC16 Outstandings which specify 0 to 30 days, 30 t Ageing Variance Above B Sales Predefined Vouchers in Tally.ERP 9 includes Movemen Voucher/I Ageing AC17 ______________ t Voucher nvoice Voucher None B In Tally.ERP 9, we can record any money Receipt Payment Journal AC18 received from debtors against sales Invoices Voucher Voucher Voucher None A AC19 Is Receipt Voucher available in Single Entry TRUE FALSE Can't Say None A ___________ Analysis report providing Movemen AC2 information on critical ratios (viz., operating Ratio Data t Variance A AC20 _________voucher adjustments with Contra Journal General None B Credit Debit Purchase Sales Note Note AC21 Ctrl+F9 is used for ______________ Voucher Voucher Voucher Voucher D Credit Debit Purchase Sales Note Note AC22 Ctrl+F8 is used for ______________ Voucher Voucher Voucher Voucher C _______ voucher is use for all types of Stock Adjustments viz., Inter-Godown Transfer, Stock Physical Stock All of AC23 Manufacturing Process etc. Journals Stock Summery Above A  Physical Stock Journal Voucher shortcut key Both A Nither A AC24 is _____________. Alt+F10 F10 and B Nor B C Accountin Timely Minimum g activity delivery of accuracy consumes Financial Accounting activity was one of the most level lot of time Statement important activities which desperately required and s and All of AC25 needed automation for which reasons? is 100% energy. Reports Above D Understan ding the Journal / Accounting process includes transactio Voucher Ledger All of AC26 ______________. n Entry Posting Above D Understan ding the Which activity is performed by software Transactio Voucher AC27 automatically? ns Balancing Entry None B Multiple Major advantages of accounting software Arithmetic reports on over manual accounting includes al Time timely All of AC28 _____________. accuracy saving basis Above D Accounts Accounts having having Accounting software are only two types of debit credit Both A Nither A AC29 ledger accounts includes ___________. balance balances and B Nor B C __________ Analysis Report provides Movemen AC3 information on the difference between the Ratio Variance Data t B AC30 Zero balance ledgers are not considered in TRUE FALSE A Income Expense ledger or If a ledger is having a credit balance, it can ledger or a liability Both A Nither A AC31 be an ____________. an Asset ledger and B Nor B B Income Expense ledger or If a ledger is having debit balance, it can be ledger or a liability Both A Nither A AC32 an ______________. an Asset ledger and B Nor B A Profi t & All income and expense ledger balances are Loss Balance Both A Nither A AC33 taken to __________. Account Sheet and B Nor B A Profi t & All Asset and Liability ledger balances are Loss Balance Both A Nither A AC34 taken to __________. Account Sheet and B Nor B B  ___________ is the end point in accounting Profi t & a mirror showing true and fair position of a Loss Balance AC35 concern Ledger Voucher Account Sheet D Non Accounting software stored (stores) data in Master Master Both A Nither A AC36 ___________ Data Data and B Nor B C Accounting Master Data includes Both A AC37 _____________. Ledgers Categories Scenarios and C D Payroll Master Data includes Employee Employee Unit All of AC38 _____________. s Groups (Work) Above D Inventory Master Data includes Service Salary Both A Nither A AC39 _____________. Categories Details and B Nor B D Budget Ratio Data Movemen AC4 Alt + B is a shortcut key of ____________ Variance Variance Variance t Variance A Income Tax Statutory Master Data includes Service Classifi Both A Nither A AC40 _____________. Categories cations and B Nor B C Emp Which voucher is use for recording of Attendanc Attendanc Both A Nither A AC41 employee attendance? e e and B Nor B B Non Master Accounting Voucher includes Memoran All of AC42 ________________. Contra dum Receipt Above D Non Master Inventory Vouchers includes Delivery Physical Rejections All of AC43 ________________. Note Stock Out Above D Purchase Order ? Non Master Order Vouchers includes Attendanc Material Material AC44 ________________. Purchases e In Out B Attendanc Both A Nither A AC45 Payroll Vouchers includes ____________. e Payroll and B Nor B C ________________are the resources Manpowe All of AC46 generally used by any business entity. Money Material r Above D ___________ document connectivity is the Both A Nither A AC47 system of linking one document with Inter Intra and B Nor B A E-fi lling website new features are added for Number Transpare Trust AC48 increasing ____________. of User ncy Source None B View Submit Form Check ITR- Services offered by e-filing website includes returns/ 26AS (Tax V receipt All of AC49 _____________. forms Credit) status Above D Financial Statements summarise the All of AC5 individual transactions to show Totals Ratios Statistics Above D  Digital Digital Digital Digitally Signature Source Sign Standard AC50 DSC stands for ________________. Certificate Certificate Certificate Certificate A AC6 Financial statements are classified into 2 3 4 8 B _______________ is a financial statement Trail Balance AC7 that reports a firm’s financial position at a P&L Balance Sheet None C In Balance Sheet F1 is uesd for Condense Both A Nither A AC8 _____________ Detailed d and B Nor B C ______________is a periodic statement, Profit and which shows the net result of business Loss Income Both A Nither A AC9 operations for a specifi ed period. Account Statement and B Nor B C A __________is a list of instructions, telling None of BC1 the computer what to do Process Program Machine the above B Other processor s and In a mainframe computer the Host User Data peripheral All of the BC10 processor manages_________ Interfaces Storage devices above C BC11 Single-user computers fall into 2 3 4 5 A Workstations are commonly used for None of BC12 ________ CAM CAD CAE the above B Super Mini Which computers are also known as "Super computer Mainfram Workstati Computer BC13 micro"? s es ons s C The capability of microcomputers that enables switching between multiple tasks is Multiproc Multiprog Time Multitaski BC14 known as _______ essing ramming Sharing ng D Special-purpose palmtops that keep phone directories and calendars and also provide Personal calculator capabilities are known Digital Docking None of BC15 as_________ Laptops Assistants Stations the above B BC16 Object-Oriented Programming is a concept First Second Third Fourth D BC17 The device that is roughly the size of a RAM ROM CPU Hard disk C BC18 The ________of the CPU sends command ALU RAM IR CU D BC19 Arthmetic Calculations and Data ALU RAM IR CU A Which of the following is not a key element Informatio BC2 of the computing process? Hardware Software People n D Special Logical operations of the ALU include Character All of the BC20 comparison of Numbers Letters s above D Primary Primary Main All of the BC21 Memory associated with CPU is called Storage Memory Storage above D BC22 The loaded programs and software get ROM RAM Flash SAM B BC23 The opposite of RAM is _____ ROM RAM Flash SAM D Serial Stand Special Access Alone Access None of BC24 SAM stands for_________ Memory Memory Memory the above A BC25 __________memory comes with ROM RAM Flash SAM A The main purpose of which memory is to Cache BC26 accelerate the working of the computer ROM memory SAM RAM B BC27 Flash memory is a solid state memory TRUE FALSE A None of BC28 Refreh Rate of a monitor is measured in, Hertz Gigaflop Megaflop the above A BC29 A fast line printer can print as many as 3500 3000 4000 1500 B The number system used in computers is Hexadeci BC3 ______ Decimal Octal Binary mal C __________is a network of satellites that None of BC30 helps users determines a location on Earth. SAN VLAN GPS the above C BC31 _________mouse is exclusively used for T1 T3 T17 T4 C _________is a popular pointing device for None of BC32 portable computers Track ball Joystick Mouse the above A For entering drawings and sketches into the Digitising None of BC33 computer ________device is used Tablet Joystick Track ball the above A The drum scanners rely on All of the BC34 _______technology CCD CAD PMT above C Scanners used to scan large sheets of loose BC35 papers are __________ Flat bed Drum Sheet Fed Hand held C BC36 Which device is used in various competitive OCR OMR BCR MICR B BC37 Supermarkets use a bar code system called UPC UPS POS BCR A Different shades of gray are displayed in a Monochro All of the BC38 ______monitor me Gray scale Color above B Monochro Monochro me me Mono Display Display Display None of BC39 MDA stands for ________ Adapter Array Adapter the above A MS _________is not a General Purpose PowerPoi BC4 Software Tally MS Word MS Excel nt A Full Large Monitors that are 16 0r more inches screen Full Page screen None of BC40 diagonally are often called ________ monitors monitors monitors the above B bytes per bits per pages per characters BC41 Bandwidth is measured in_____ sec sec minute per sec A  The printers that are used in most BC42 calculators and fax machines are Dot matrix Inkjet Laser Thermal D Which of the given device is used in Graphics BC43 engineering applications where precision is Printer Plotter Tablet MICR B Based on data access auxiliary devices are None of BC44 ________ sequential random both a & b the above C Universal Serially Universal Universal Universal accessed Standard BC45 USB stands for_______ Serial Bus Server Bus Bus Bus A ______________is one billion floating-point None of BC46 arithmetic operations per second. Megaflop Gigaflop Flop the above B The Mainframe computers Multiprog Multitaski Multiproc Multithre BC47 exhibit______________. ramming ng essing ading A Ultra Ultra Line Large Ultra Ultra Scale Scale Large Large Integratio Integratio Scale Scale BC48 ULSI stands for, n n Integrator Integer B _______________is used for easy and fast Cache Flash BC49 information storage in such devices as Memory Memory RAM ROM B MS For giving a public presentation, which PowerPoi BC5 software would be used? Tally MS Word MS Excel nt D BC50 ___________scanners are more secure Iris Face Finger Voice A ____________ are examples of sequential- Magnetic BC51 access media. tapes Hard Disk Pen Drive CD A streaming None of BC52 Tapes are sometimes called ____________. streamers tapes both a & b the above C Million Million Multiple Bytes Per Bits Per Bytes Per None of BC53 MBPS stands for _________________. Second Second Second the above A __________come with data already All of the BC54 encoded onto them. CD-R CD-ROMS CD-RW above B A __________drive consists of a NAND-type Flash BC55 fl ash memory data storage device drive DVD CD Hard disk A People Data and Data and Hardware and The systems model describes the Informatio Procedure and Procedure BC6 relationship between n s Software s A Which characteristic of information BC7 indicates that information is condensed into Relevant Timely Concise Complete C  The aerospace, Embedde automotive,chemical,electronics and Micro d petroleum industries Mainfram Supercom Computer Computer BC8 use__________computers es puters s s B Dividing a complex task among several Multitaski Multiprog Multiproc Time BC9 processing units is known as ng ramming essing Sharing C CB1 CBS software developed by TCS is ______. Finacle Quartz Flex Cube Bankmate B CB10 The server is a sophisticated computer that Clients Manager Printers ATMs A Automate Auto Automate d Telling Talking d Teller None of CB11 ATM stands for _______. Machine Machine Machine the above. C Which of the following is not a server of Data Base Web Proxy Personal CB12 CBS? Server Server Server Server D _____ server hosts the core banking Applicatio Proxy Web CB13 application. n Server Server Data Base A _____ of the application is capable of only Final Client Beta Alpha CB14 entering the data at the end point that is Version version Version Version B Network Database Security ______________ is a designated role for Administr Administr Administr CB15 maintenance of the data base. ator Librarian ator ator C Till the central data base becomes Positive Positive accessible, all the ATM transactions are Balance Positive Positive Balancing CB16 passed in the __________file available at File Blank File Bank File File A The __________________ authenticates the Proxy Antivirus CB17 customer with the log in details stored in IBDS server server IBAS D ______________provides network security by preventing malicious data from entering Anti Virus Proxy None of CB18 the network. Server Server Firewall the above B Duties of ________________would include Database Network Security deciding on access rules to data and other IT Administr Administr Administr CB19 resources. ator ator ator Librarian C Bills & Savings Current Remittanc All of the CB2 In CBS _____ modules could be added. Account Account es above D Communi Change management procedures include cation All of the CB20 changes in ___________. Hardware Software Systems above D CB21 ______________is the version of the Gamma Alpha Beta Teta C After a program is tested by the users, it is User pushed into the production Acceptanc Integratio Unit System CB22 environment.This is known as__________. e Test n Testing Testing Testing A  The HSM or SSM are used for the purpose Decryptio Encryptio Withdraw CB23 of _______. n n al of Cash Security B ATM transactions involve the generation of Cash Both A & None of CB24 ________. Journal ATM log B the above C In the remotely placed ATMs, the electronic Electronic Cash journal is retrieved by a mechanism known Journal Journal Journal Journal CB25 as__________. Pulling Pulling Pulling Recording B CB26 In case of RTGS, the money transfer takes SBI RBI BOI Canara B Deferred Net Gross Net EFT and NEFT work on the basis of Settlemen settlemen Settlemen None of CB27 _______________ t t t the above A Every RTGS message is assigned a unique number known as None of CB28 ________________number STP UTR UTN the above B Bussiness Bussiness Continuity Bussiness Control Programm Continuity Programm None of CB29 BCP stands for _____ in CBS. ing Planning ing the above B CBS is a combination of an Application Network Operating Applicatio None of CB3 Software and _______. Devices System n System the above. A Customer Cash Relationsh Cash Reserve Control ip Receipt CB30 CRR stands for _____ in CBS. Ratio Rate Ratio Resource Rate A Disk Disaster Desktop Recovery Recovery Recovery All of the CB31 DRP stands for ____ in CBS. Plan Planning Process above B Bussiness Continuity Planning should cover Branch ATM the following important and critical Operation Internet Operation All of the CB32 processes in CBS. s Banking s above D Which of the following type of processing Cheque charges is/are not associated with CMS in DD issue return Courier None of CB33 CBS? charges charges charges the above D Which of the following type of controls over Clearing Cheque Credit CB34 parameter settings are not appliyed in CMS? cycle limit limit Intrest B _______________ is a process by which the Business Business Disaster bank ensures the maintenance and recovery Recovery Continuity Recovery None of CB35 of operations. Planning Planning Planning the above B  ATM Domain Application software would access the Data base DATA Name Applicatio CB36 ________ server Server Server n Server A __________ are capable of being connected only when devices are connected to a Virtual CB37 switch. LAN Networks MAN WAN B Tax Collected Tax Taxation at Collected Company None of CB38 TCS stands for ____________________. Software at Source Standard the above B Which of the following applications is used Expense to book purchase invoices received from Purchasin Managem Accounts CB39 vendors? g ent Payable Sales C CB4 The CBS is capable of being implemented in TRUE FALSE A Which of the following is not a software Iflex CB40 development companies for CBS? Infosys TCS MCA Solutions C In CBS, ______ is the computer that accepts All of the CB41 service requests from different machines. Server Clients Head above A Applicatio CB42 CBS applications runs on ______ Server. Web n ATM Mail B Bank branch running the CBS version which Final Party Client Server CB43 is called the _________. version version version version C Changes made by CBS application software Applicatio Test Central Client CB44 first saved on _________ server. n servers Server server Sever B Software Which of the following is not treated as applicatio Wireless CB45 Information assets? ns Note Book Laptops network B _____ are the main goals of information Confidenti Availabilit All of the CB46 security. Integrity ality y above D Applicatio Domain Local Web CB47 _______is used for authentication. n servers Controller Server Server B ______ is a process of unauthorized Connectin None of CB48 entering a network. Hacking Mailing g the above A Card Which of the following information is not holder Date of Pin CVV CB49 displayed on ATM card? name expiry number number C Recording of Passbook Interest Core Banking Solutions are developed to transactio maintena calculatio All of the CB5 perform__? ns nce ns above D  Summary of the Analytic reports of the RTGS activity transactio Net Charging All of the CB50 includes _______ in CBS. ns position reports above D ____is more powerful to represent complex CB51 data structures. ISO 20022 ISO 20023 ISO 20024 ISO 20025 A Unique Uniform Transactio Transactio Uniform n n Transactio None of CB52 UTF stands for _______. Reference Reference n Record the above B The objective of the ____ is to meet the All of the CB53 needs of the customers who have CMS Cheques DD above A Charges Clearing Credit (various All of the CB54 In CMS parameter settings includes _____. cycle limit slabs) above D ____ mandates that CB55 every bank should have a security policy. PNB RBI BOI CBDT B ____ control include physical access, logical Managem Operation Organizati access, environmental controls, evaluation Applicatio ent al onal CB56 controls in n Controls Controls Controls Controls C Report The servers in the Data Centre could be Applicatio Generatin All of the CB6 many of _____ servers. Data Base n g above D Availabilit y of 24*7 accurate All of the CB7 Benefits of CBS________. Better MIS support data above D CB8 The servers in the data centre are VLAN WAN LAN MAN A Virtual Virtual Virtual Local Line Area Local Area Around All of the CB9 VLAN stands for _______. Network Network Network above B This data type allows alphanumeric Auto DB1 characters and special symbols in Ms- Text Number Number Date/Time A DB10 A __________ enables you to view data Form Query Macro Report B A __ name must be unique within a DB11 database. Table Field Record Character A If I create ‘Student’ field in ‘Fees’ table to Foreign Composit Primary DB12 store ‘student_id’ of ‘Students’ table, then key Native key e key key A  Tables with fields and Name of relationshi fields, ps Sorting Query design window has two parts. The field type between check DB13 upper part shows _____ in Ms-Access. and size tables Criteria boxes B Every table in relational database contain a Foreign Composit Primary DB14 field or combination of fields that can key Native key e key key D The complete information about an entity in Informatio DB15 a database is called ____ in Ms-Access. Data n Record Field C Right click the relationshi p line and choose Double Edit click the If you need to edit a relationship in MS- Relationsh relationshi Both of None of DB16 Access______. ip p line above the above C It is an association established between RelationshPrimary DB17 common fields of two tables. Line ip key Records B Which of the following is not a field type in OLE Lookup DB18 Access? Money Hyperlink Object Wizard A Write Write Write criteria Write criteria criteria values criteria values in values in To achieve AND effect when you are vertically values same field same field entering criteria in a query design window one in a horizontal separated separated DB19 in Ms-Access is ______. row ly with AND with & B Which of the following is not a database Relationsh DB2 object? Tables Queries ip Reports C Comparis In Ms-Access, a search value can be an exact Logical Relationsh Wild card on DB20 value or it can be____. Operator ip character operation C Once in the Every On the 1st In Ms-Access, When a picture or other beginning At the top after and last graphic image is placed in the report header of the of every record pages of DB21 section it will appear____ report page break the report A DB22 What are the columns in a Microsoft Access Rows Records Fields Columns C  You can automatically include all of the field in a table in a query by___ a strike that Right Double None of DB23 appear list box in query design view in Ms- Clicking clicking clicking the above C It is most common type of query. It retrieves All of the DB24 records from one or more tables and then Parameter Select Crosstab above B In Ms-Access, It is a query that when run DB25 displays its own dialog box prompting you Select crosstab Parameter Append C A(n) ____ is the default control for a Yes/No Option Toggle DB26 field in Ms-Access. Check box button button List box A Ms-Access provides Hyperlink data type to Email All of the DB27 create a clickable link to a __________ Web page File address above D Which of the following is not a benefit of Consisten Redundan Comprehe DB28 relationship in Ms-Access? cy cy Efficiency nsibility B Desktopti All of the DB29 ____ is the text displayed as a tooltip. Screentip Screentop p above B Create Create Create To create a new table, in which method you table in Table Table by don’t need to specify the field type and Design using Entering All of th DB3 size? View wizard data eabove C _____ is recording data in only one place Consisten Redundan Comprehe DB30 implies less disk space in Ms-Access. cy cy Efficiency nsibility C None of DB31 Abs(-50) will give output____ in Ms-Access. -50 500 50 the above C In Ms-Access, ______ form control lets the Insert Option DB32 user to insert a picture. Lable Page Logo Group C Which of the following is not a type of Form DB33 Control in Ms-Access? Related Bound Unbound Calculated A Which of the following activity is not associated with command button in Ms- On Mouse DB34 Access form? On Click On Run Up On Enter B Which of the following category is not found Record Form Macro under Command Button Wizard in Ms- Navigatio Operation Applicatio Operation DB35 Access form? n s n s D DB36 Which of the following Tab is not when we Create Design Arrange Format A DB37 Which of the following is not a type of Append Select Delete Update B DB38 Which of the following option is not Sum Avg Count Min C DB39 Which of the following is not a Logical = ? In C This key uniquely identifies each record in Primary Key Unique Field DB4 Ms-Access. key record key name A Which type of field is incremented Auto AutoNum Auto Auto DB40 automatically in Ms-Access? Elevate ber Increment Value B  Tables Tables Queries Which object is used to create a form in Ms- and Tables and and DB41 Access? Queries only reports reports A Simple Simple Table Which tool do you use to create a query Database filter query query DB42 object in Ms-Access? wizard wizard wizard wizard C Which of the following is not a view for Datasheet Design Layout DB43 interacting with a form object in Ms-Access? view view Form view view D Which data type is better to use for storing AutoNum DB44 phone number in the following format “977- Text ber Number Currency A Which criteria do not return the position Position = Position = Position = Position = DB45 “POLICE” as a match in Ms-Access? “*LI*” “P??ice” ” ?ol*” “P#e” D Once in the Every On the 1st When a picture or other graphic image is beginning At the top after and last placed in the report header section it will of the of every recordpages of DB46 appear____ report page break the report A DB47 Which of the following is not a Database Unix Oracle AccessFoxpro A The data can be entered into a table in the All of the DB48 ____________ view. Design Datasheet Dataview Above B None of DB49 SQL is considered to be a __________ 2GL 3GL 4GL the above C In one-to-many relationship the table in Child , Parent , Brother , Father, DB5 ‘one’ side is called _______ and on ‘many’ Parent Child Sister Son B Default length of numeric data type is long DB50 ____________ in MS Access 2010. 255 char 16 char text Integer D The default query invoked by MS-Access Update Select Delete None of DB51 is_____________. Query Query Query the above B __________ data type field can't be HYPERLIN AUTONU DB52 updated YES/NO K MEMO MBER D A Record is also commonly called as a None of DB53 _________ Column Field tuple the above C DB54 Most database operations that we do Program Query Form Macro D DB55 _________ are what we use to summarize Report Query Form Macro A In MS-Access, what data type can be used All of the DB56 for a phone number field in a database? Number Text Memo above B In a table, _____________ uniquely Unique Foreign Primary Record DB57 identifies each record that is stored in the Key Key Key Key C _________ is used to insert values in Table None of DB58 directly. Query Report Form the above A DB59 Which SQL clause is used to retrieve data SELECT WHERE FROM INSERT A  The size of Yes No field is always___ in Ms- 1 DB6 Access. 1 bit 1 byte character 1 GB A DB60 The __________clause is used to filter SELECT WHERE FROM INSERT B None of DB61 __________is Example of DBMS Word Excel Access the above C A Junction Table creates a _______________ relationship between two One-to- One-to- Many-to- None of DB62 tables. One Many Many the above C The Primary key of one table and the matching column in another table is known Matching Foreign None of DB63 as ______________. Key Key Index key the above B specifying conditions For with ordering group by updating None of DB64 In SQL, having clause is used for _________ records clause records the above B A form can be divided into_________ to None of DB65 increase the readability Pages Section Rows the above A How can you define a field so that when Input Validation DB7 entering data for that field it will display mask Rule Indexed IME Mode A Which field type will you select when DB8 creating a new table if you require to enter Text Memo Currency Hyperlink B DB9 In table design view, which key can be used F3 F4 F5 F6 D Word Spreadshe Presentati Lotus Symphony & Resolver One are Processing et on EX1 examples of ____________. package Package DBMS Software B The name must begin with Names either a Names can be 1 letter or Names can to 255 an cannot be contain Which of the following is not a rule for characters underscor valid cell exclamati EX10 Naming ranges? long e addresses on D EX11 _______ is a Union Operator used in MS : , ; C EX12 Which of the following operators has the : , & % A Maths ___________category of functions in Excel and are used to calculate absolute values, Trignomet EX13 cosines, logarithms, etc. Financial Statistical rical Database C  ______is the interest rate received for an EX14 investment consisting of payments IRR PMT FV PV A EX15 Which of the following functions are used to PV PV PMT IRR C Initial cost Salvage Useful life In the SLN function, the argument LIFE of the value of of the None of EX16 corresponds to? asset the asset asset the above C #Num EX17 FACT(5) =______ 0 120 -120 Error B #DIV/0 EX18 MOD(-6,-4) returns -2 1 2 Error A _________function returns an evenly RANDBET EX19 distributed random real number greater RAND( ) WEEN( ) MOD( ) INT( ) A EX2 By default, a workbook opens with 4 2 3 5 C EX20 ROUND(32.5, -1) returns? 35 32 30 25 C _________function adds the cells specifi ed COUNTIF( EX21 by a given condition or criteria. IF( ) SUMIF( ) ) SUM( ) B Which function returns the largest value in a list of arguments, including numbers, text None of EX22 and logical values? LARGE( ) MAX( ) MAXA( ) the above C EX23 When a formula contains text that Excel #NULL! #VALUE! #NAME? #REF! C The default alignment of dates in MS Excel None of EX24 is_______ Right Left Centre the above A __________option allows the users to Align Orientatio Increase Bottom EX25 rotate text. Right n Indent Align B CTRL+C- CTRL+C- CTRL+C- Shortcut key used to copy formats in Excel >CTRL+V- CTRL+C- >CTRL+V- >CTRL+V- EX26 is, >R >CTRL+V >F >A A EX27 A normal data range can be converted into CTRL+E CTRL+T SHIFT+T ALT+T B Data from two worksheet locations can be easily compared using the Freeze Splitting None of EX28 ___________option. Panes Macro Panes the above C __________is a key that identifies patterns, Data EX29 colors or symbols associated with the Legend Series Gridlines Axes A One can easily access the taskcentered Quick functions such as printing and sharing from Backstage Access EX3 ____________. View Tool Bar Home Tab Ribbon A EX30 Which chart is suitable for a data set that Bar Column Pie Area C _________are used to give the users a quick Pivot EX31 look at trends or patterns that may not be Charts Sparklines Tables Filters B  Sparkline Sparklines can We can are display a also printed trend We can create when we based on create sparklines print a adjacent several for rows worksheet data in a sparklines of data that clear at the that we conatins EX32 The advantage of Sparklines is, manner same time add later them D Shortcut key for Macros are assigned in None of EX33 combination with _____key. SHIFT CTRL ALT the above B We can use _________function to create a hyperlink that opens a document that is Hyperlink( None of EX34 stored on a server, intranet or internet. Index( ) Match( ) ) the above C Text-to- Non-excel files can be easily opened in Excel Cols Import Through All of the EX35 using, wizard wizard Macros above A The________tab in the format cells dialog EX36 box gives absolute control over numeric Font Border Number Alignment C 1 EX37 There are ________ fill colors and patterns. 1 million 10,000 thousand 16 million D EX38 Default alignment of values and dates in MS Left Right Centre Justified B Which kind of conditional formatting Color All of the EX39 provides a visual representation of how the Data Bars Scales Icon Sets above D Absolute Absolute Column- EX4 A$1 is an example of __________reference. Relative Absolute Row-wise wise C Condition One can view different areas of the al worksheet simultaneously by using Split Freeze Formattin None of EX40 the__________option. Panes Panes g the above A __________ is a key in the chart that EX41 identifies patterns, colors or symbols Data Bars Legend Gridlines Axis B EX42 There are _________types of chart types in 50 65 73 80 C Several Column sparklines Sparklines width of It is not can be cannot be the necessary created at printed Column for the the same when we sparkline data to be time by print the can be next to selecting worksheet increased Which of the following is not true about the multiple containing or EX43 sparklines? sparklines cells them decresed C  _______are used to demonstrate the Column Area Pivot EX44 “what”, not the “why” of the data. Chart Sparklines Charts Tables B We have to use________cell reference if we want the macro recorded to run in the same Both A & None of EX45 cell only. Absolute Relative B the Above A ________function can be used to open a Hyperlink( EX46 document that is stored on a network Vlookup() ) lookup() Index() B Which of the following non-excel files can Quattro All of the EX47 be opened in Excel? Text File Lotus 123 Pro above D Field with The first most The last The field While sorting data in MS Excel 2010, the field in duplicate field of containing EX48 best field to first sort by is? the data entries the data text B _______in MS Excel 2010 has built-in Excel None of EX49 filtering features. Table Charts Sparklines the above A _________ are used to exchange data Database Both A & EX5 within Excel and between Excel and other OLE DDE Engine B D Condition ________feature in MS Excel 2010 hides the al rows and columns containing data that do Formattin EX50 not meet the criteria we define. ne. Sort Sparklines Filter g C EX51 We can apply dynamic filters in MS Excel Text Values Dates Formulas C Restrict Restrict dates data to Limit the outside a predefine number of certain d items in text time All of the EX52 Data Validation can be used to, a list characters frame above D We can limit the choices in an Excel data EX53 validation list, by using named ranges and Index( ) Match( ) Indirect( ) Direct( ) C In MS Excel 2010, when a cell is locked, we View its Both A & None of EX54 can't_________ contents Edit it B the above B In MS Excel 2010,_________allow us to turn Pivot EX55 our data inside out, upside down, sideways Sparklines Charts Tables Filters C An Excel A worksheet database database/l A file ist or any collection created in range that of ranges an has to be external Source data for creating a Pivot Table in MS labeled consolidat applicatio All of the EX56 Excel 2010 can be, columns. ed n above D  Creating a Listing pivot unique report values in with sub- any totals and column of custom Transposi All of the EX57 Pivot Tables can be used for, a table. formats ng data above D Each row Each in the column in source the source data The data should source should contain data can contain the details have Data is set Which of the following is not a pre-requisite one type for one blank up as a EX58 for creating a Pivot Table in MS Excel 2010? of data. record rows Table C ______feature of Pivot Tables can be used Summaris None of EX59 to summarise dates by Quarters or Months Group e Slicer the above A _________is the shortcut key to see a EX6 shortcut menu. SHIFT+F10 F10 F2 CTRL+F7 A Inorder to filter the contents of the pivot table on more than one field, we can Running None of EX60 use________. Slicer Totals Filter the above A Apart from the sum function, which other All of the EX61 function can be used in summarisation of Product Varp Average above D All of the EX62 In text files, the delimiter in text can be, Tab Space Comma above D A text file in which a comma separates each Comma column in the data is known as a Fixed- Comma Separated Tab EX63 ________file length Separated Value Separated C _________are used in text files to indicate Text EX64 the beginning and end of text strings. Qualifiers Commas Tabs Spaces A EX65 The extension of a Fixed-width text file.csv.prn.txt.xlm B Shortcut key used to convert a data range Both A & EX66 into a table in MS Excel 2010 is, CTRL+L CTRL+T B CTRL+W C In Pivot Tables, ________work like a filter Calculated None of EX67 without going to drop-down. Slicer Field ListFields the above A In MS Excel 2010, we use ___________to % of % of % of show the current running total which is Grand % Running Parent Column EX68 divided by grand total. Total Total Total Total B  Easy addition The of rows appearanc The biggest advantage of converting a data Easy and e All of the EX69 source into a table for a Pivot Table is, Filtering columns improves above B To fill the same number (or text value) over and over, instead of entering the data Auto Sum Format None of EX7 several times, the user can enter the data button Fill Handle Painter the above B Quick identifi Ineffective cation of Better Instant in data Visual visibility highlightin outliers presentati of all g and Which of the following is not an advantage on of systems in inefficienc correlatio EX70 of Dashboards in MS Excel 2010? data. total ies ns C ________dashboard is used by top-level Operation Informatio EX71 management in decision making. Strategic Analytical al nal A Condition al A dashboard can be created in MS Excel Excel Formattin All of the EX72 2010 by using, Table g Sparklines above D The possibility of error in a cell in MS Excel Blue Green Red Black EX73 2010 is indicated by a____ in the left corner Square triangle triangle square B User comment has been A red triangle in the top right corner of a cell Error in Formattin added to None of EX74 indicates, the cell g Error the cell the above C We can use _________function to show the weeknum( weekday( None of EX75 number of the week in a month. week( ) ) ) the above B If the value in A1 is "ITT" and in B1 is "ICAI ", A1+ "@" + A1 # "@" A1 & "@" A1 $ "@" EX76 which function in Excel will return " ITT @ B1 # B1 & B1 $ B1 C Pagelayou t -> Page Pagelayou Page To frequently print a specific range of cells Setup -> t -> Print Setup -> EX77 on a worksheet , the option used is Print Area Area Print Area Print Area A Text Non-excel files can be opened in MS Excel Developer Import Analysis EX78 using the Add Ins Tab wizard Tool Pak C Freeze Which of the following is not an option Freeze Freeze Last Freeze EX79 under Freeze Panes Panes Top Row Column Last Row D  _________are the basic cell references that All of the EX8 adjust and change when copied or when Absolute Relative Mixed above B EX80 MROUND(-10,-3) returns 9 -9 1.4 #NUM B AVERAGE( AVERAGE( AVERAGE( A1:A6,B1: All of the EX81 Which of the following is correct? 4,5,6,7) A1,B1,C1) B6) above D _______________is not a kind of Interrogati Operation EX82 Dashboard. Strategic Analytical ve al C ____________ are the most widely used Excel Pivot All of the EX83 data visualization components for charts Sparklines Tables above A When a formula is copied that uses a name, the effect is the same as using None of EX9 a___________ cell reference. Relative Mixed Absolute the above C CAATs can be used to audit in a Statutory Internal All of the ID1 computerized manner for Audit Tax Audit Audit above D Time Computer Factors to be considered for using CAATs Constraint Level of Knowledg All of the ID10 are, s Audit Risk e above D Inspection, Observation and Recalculation Audit Audit Audit None of ID11 can be used for obtaining, Evidence Summary Sampling the above A Defining the CAAT objectives is the part of Audit None of ID12 ________audit phase. Execution Planning Evidence the above B Audit The Audit Evidence must necessarily Audit Output Conclusio All of the ID13 include, Findings Produced ns above D __________is defined as the application of audit procedures to less than 100 percent of Audit Audit Audit None of ID14 the population. Sampling Summary Evidence the above A ___________involves the use of techniques Haphazar Judgemen from which mathematically constructed d Statistical tal All of the ID15 conclusions regarding the population can be Sampling Sampling Sampling above B Which Sampling technique ensures that all Systemati Judgemen combinations of sampling units in the Statistical c Random tal ID16 population have an equal chance of Sampling Sampling Sampling Sampling C Systemati Judgemen Haphazar In which sampling method the auditor c Random tal d ID17 places a bias on the sample? Sampling Sampling Sampling Sampling C A______________contains all the IDEA Working None of ID18 databases on which we wish to perform. Folder Folder Group the above B IDEA exports data in a number of formats Mail All of the ID19 such as, Text Database Merge above D  MS CAATs can be applied even by using PowerPoi ID2 commonly used software such as, MS Word MS Excel nt MS Access B ____________accumulates the values of Stratificati Summaris ID20 Numeric fi elds for each unique key. on ation Indexing Sorting B Number Total of List of of records Non- __________is not a task provided by unique for eack numeric None of ID21 Summarisation keys key data the above C ID22 The Quick Summarisation option may be 4000 3000 10000 5000 A ____________option in IDEA is used for Summaris Stratificati All of the ID23 reconciling totals ation Statistics on above B By default, the Field Statistics window All of the ID24 displays the statistics for __________ fields. Numeric Date Text above A Probabilit Both A & Haphazar ID25 Sampling in IDEA is, Statistical y based B d C Judgemen Systematic, Random and Stratified Sampling Probabilit tal Haphazar ID26 are types of_______Sampling Statistical y based Sampling d B Stratification in IDEA can be done All of the ID27 on______fields Numeric Date Character above D The fields selected for sorting the records by None of ID28 are known as, Keys Index Mark the above A Key Functions used in IDEA to identify Gap Duplicate Both A & ID29 Anamolies and exceptions are, Detection Detection B Statistics C To Improve Ensure increase efficiency better audit of audit audit All of the ID3 Why are CAATs needed? quality process Planning above D In IDEA, data completeness can be checked Duplicate Gap Summaris ID30 by, Detection Detection Statistics ation B In order to determine provisions required against bad debts at the end of the year Gap Summaris ID31 ____________can be used. Detection ation Aging Sorting C In IDEA data can be consolidated using a Pivot None of ID32 _________. Table Solver Subtotals the above A __________option in IDEA produces a database that we can analyze to identify Benford's Gap Summaris None of ID33 possible errors, potential fraud, or other Law Detection ation the above A  In IDEA, the parameters in equations are Semi Both A & ID34 separeated by Comma colon B Apostphe C Default date format for a Date Parameter in YYYYMMD MMDDYY DDMMYY ID35 IDEA is, MMDDYY D YY YY B Which search in IDEA enables users to use ID36 AND operator along with the keywords? Boolean Wildcard Proximity Integrated A Non arm's length Which one of the following is not a practical transactio Petty Cash ID37 application of Benford's Law? ns Bad debts book Sales C The_________feature in IDEA can provide a valuable reasonableness test for large data Gap Benford's Stratificati ID38 sets. Detection Law Statistics on B ID39 Which function in IDEA is used to identify date dow day db B File Which of the following is not a key Reorganis Financial Statistical ID4 capabilities of CAATs ? File Access ation functions Functions C __________selection is where the auditor Haphazar Judgemen picks items without basis of any d Statistical tal All of the ID40 mathematical formula Sampling Sampling Sampling above A _______________is a process of of selecting Stratificati None of ID41 a subset of the population. Sampling on Extraction the above A Fields from two databases can be combined Benford's ID42 into a single database for testing by using Law Statistics Join Append C IDEA can compare the financials from one Stratificati Join Compare ID43 year to the next,by___________option on Extraction Database Database D Field Control Both A & None of ID44 In IDEA data can be reconciled using, Statistics Totals B the above C ID45 Which function in IDEA is used to reverse Reverse Replace Repeat Right A File Arithmetic Indexing, Sorting and Merging are the Reorganis Data al ID5 functions of the _______CAAT capability. ation File Access Selection Functions A ____________functions enable intelligent Arithmetic None of ID6 analysis of data using CAATs. Statistical al Financial the above A ___________ are very critical tools for All of the ID7 Auditors MS Office CAATs Tally above B Judgemen Haphazar _______is to identify samples as tal Statistical d None of ID8 required. Sampling Sampling Sampling the above B  Which of the following is not a test Detect Identify Copying of Duplicate ID9 performed during Audits? Frauds Errors samples Payments C OS1 _____ is an interface between hardware OS OP OM OD A Executing a job on a computer system often File requires several of its resources such as Memory storage All of OS10 _____. CPU time space space These D Operating system not acts as the manager None of OS11 of the various resources of a computer TRUE FALSE Can't Say These B Operating system manages many kinds of Printer Name All of OS12 activities ranging from user programs to spooler servers File server These D A process includes the complete Data Execution System OS13 ___________ context context Speed context B None of OS14 Process is not a program. TRUE FALSE Can't Say These A A process is only an ___________of a Data None of OS15 program in execution. context System Instant These C Creation and deletion Mechanis Mechanis of user m for m not for Mechanis and process process m for Which of them is not process management system synchroniz communic deadlock OS16 activities of an operating system? processes ation ation handling C _____________is a large array of words or Primary- Main- Both A Nither A OS17 bytes. Memory Memory and B Nor B C ?To decide To keep 'which track of process is 'which loaded part of into To memory memory allocate are when and de- currently memory allocate The major activities of an operating system being space memory with reference to memory-management are used and becomes space, as All of OS18 __________________ by whom available needed. These D ___________ is a collection of related None of OS19 information defined by file creator. Computer File Data These B  Applicatio Applicatio Applicatio n n n Data,Com programs, hardware, Operating system acts as an intermediary puter Computer Computer None of OS2 between _______ and ________. Data hardware Data These B Examples of storage media are Magnetic Magnetic Optical All of OS20 ______________. tape disk disk These D A file system normally organized into None of OS21 directories to ease their use. TRUE FALSE Can't Say These A Not Support of primitives for Mapping Creation manipulat of fi les Activities of an operating system with and ing files onto reference to file management includes deletion and secondary Both A OS22 ____________. of fi les directions storage and C D A computer system normally consists of All of OS23 several I/O devices such as __________. Terminal Disk Tape These D ensures correct data Issues transmissi I/O command on requests s to the to/from Device Management keeps track of from I/O an I/O All of OS24 ___________. processes devices device These D Computer systems often store large None of OS25 amounts of information, some of which is TRUE FALSE Can't Say These A Which module ensure that user can trust OS26 the system and rely on it only if the various System Security Study Special B The user gives commands with are executed Both A Nither A OS27 by _________ OS OT and B Nor B A The main function of a command Both A Nither A OS28 interpreter is to ________ the next user Get Execute and B Nor B C According to Throughput, if n processes are completed in an interval of t seconds, the OS29 throughput is taken as n+t n*t n/tn-t C Operating systems are found on almost any None of OS3 device that contains a computer. TRUE FALSE Don’t Say These A ___________ is normally measured in Throughp Turnaroun ?Respons None of OS30 processes/hour. ut d time e time These A  Turnaround time is the interval from the Process,Pr OS31 time of submission of a _________ to the Data,Data Job,Job Size,Sizeocess B In any computer system, it is desirable to None of OS32 maximize throughput and to minimize TRUE FALSE Can't Say These A The time of submission of a job to the Throughp Turnaroun ?Respons None of OS33 system for processing to the time the first ut d time e time These C The process is currently able to run, but for Suspende OS34 some reason the OS has not placed the Executing Waiting Blocked d D The operator could periodicall y collect all the submitted programs and would The batch operator them would set together the and then It was not appropriat load them Programm punched e switches all into er would on cards in the the input fi rst write or paper front device of the tape along panel to the Which of them is not a execution of Process program with its run the system at OS35 Management in Early Systems? on paper data. job. one time. B Jobs Jobs Jobs Jobs normally mostly normally mostly input perform input vast perform small numerical amount of no amount of calculatio data, calculatio data, ns, with perform ns, with perform little I/O very little great I/O very little operation computati operation computati OS36 What do you mean by CPU-bound jobs? s. on. s. on. A Which programs used for scientific and CPU- engineering computations usually fall in this bound I/O-bound Both A Nither A OS37 category of jobs? jobs jobs and B Nor B A  Job status Multiprogramming Systems required Large Memory preservati All of OS38 _______. memory protection on These D OS39 ______ is used for each loaded process. PCB JCB MCB SCB A Examples of popular modern operating systems for personal computers are Microsoft All of OS4 ___________. Windows Mac OS Linux These D I/O status A typical Process Control Block includes Process Program informatio All of OS40 ________. identifi er counter n These D _________should contain some CPU-bound Main None of OS41 and some I/O-bound jobs so that at least PCB memory Data These B The part of the The part Computer of the OS The part must must of the OS decide decide must which of which of decide the ready the ready which of jobs jobs the ready should be should not jobs allocated be should be the Job allocated allocated for data the CPU the CPU Preparatio for for None of OS42 What is CPU scheduler? n. execution. execution. These C The act of reassigning a CPU from one task Multitaski Context Multither None of OS43 to another one is called a _________. ng switch ading These B Accountin All threads of a process also share the same g set of operating system resources, such as informatio All of OS44 ________. Open files Signals n These D Due to the sharing of address space, there is None of OS45 no protection between the threads of a TRUE FALSE Can't Say These A Different processes may belong to different Condition Applicatio OS46 ______. Users Data s ns A Thread can be in anyone of several states Terminate Both A Nither A OS47 that name's includes _______. Running d and B Nor B C Lightweig Heavywei Traditional processes are referred to as ht ght No weight All weight OS48 _________. processes processes processes processes B  Applicatio n Multiprocessing is the use of two or more Data,Com Central Processing Units (CPUs) within a puter Computer Networkin OS49 single ________. Data system Data g B Managing Making a the computer resources system of a