ITT NEW_015259 PDF - Tally ERP 9 Past Paper Questions

q_id q_desc op1 op2 op3 op4 ans Cash Flow AC1 Analytical reports in Tally.ERP 9 includes ____________...

q_id q_desc op1 op2 op3 op4 ans Cash Flow AC1 Analytical reports in Tally.ERP 9 includes _____________. Ratio Analysis BRS All of Above D Statement AC1 _______________ is a summary of all ledger balances to check P&L Trail Balance Balance Sheet Ledger B 0 whether the figures are correct and balanced. AC1 Tally.ERP 9 allows us to maintain and generate all primary books of Purchase Credit Note Cash Book All of Above D 1 accounts and registers like_______________. Register Register Gateway of Gateway of Gateway of Tally > Display > AC1 Tally > Display > Tally > Display > Path of Sales Register is ____________. Account Books > None A 2 Account Books > Register > Sales Register > Sales Sales Register Register Register AC1 Is Debit Note Register Available in Tally ERP 9. Yes No A ____________ refer to amounts to be received from the sundry Accounts Credit Accounts Debit AC1 debtors while ________________ are the amounts to be paid to Payables,Accou Payables,Debit Receivables,Acc Receivables,Cr C 4 sundry creditors. nts Receivables Receivables ounts Payables edit Payables AC1 F8 used for ___________ Sales Purchase Both A and B Nither A Nor B A AC1 ____________Analysis reports for Outstandings which specify 0 to 30 Movement Ageing Variance All of Above B 6 days, 30 to 45 days and 45 to 75 days and so on. AC1 Movement Sales Predefined Vouchers in Tally.ERP 9 includes ______________ Ageing Voucher None B 7 Voucher Voucher/Invoice In Tally.ERP 9, we can record any money received from debtors AC1 Payment against sales Invoices or on Account and for all transactions where Receipt Voucher Journal Voucher None A 8 Voucher money is received, using the __________. AC1 Is Receipt Voucher available in Single Entry Mode? TRUE FALSE Can't Say None A ___________ Analysis report providing information on critical ratios AC2 (viz., operating cost percentage, return on working capital and so on) Ratio Data Movement Variance A in a single report. AC2 _________voucher adjustments with respect to debit and credit Contra Journal General None B 0 amounts without involving the cash or bank accounts. AC2 Purchase Credit Note Debit Note Ctrl+F9 is used for ______________ Sales Voucher D 1 Voucher Voucher Voucher AC2 Purchase Credit Note Debit Note Ctrl+F8 is used for ______________ Sales Voucher C 2 Voucher Voucher Voucher AC2 _______ voucher is use for all types of Stock Adjustments viz., Inter- Stock Journals Physical Stock Stock Summery All of Above A 3 Godown Transfer, Manufacturing Process etc. AC2 Physical Stock Journal Voucher shortcut key is _____________. Alt+F10 F10 Both A and B Nither A Nor B C Accounting Minimum Timely delivery activity AC2 Accounting activity was one of the most important activities which accuracy level of Financial consumes lot of All of Above D 5 desperately needed automation for which reasons? required is Statements and time and 100% Reports energy. AC2 Understanding Journal / Accounting process includes ______________. Ledger Posting All of Above D 6 the transaction Voucher Entry AC2 Understanding Which activity is performed by software automatically? Balancing Voucher Entry None B 7 the Transactions AC2 Major advantages of accounting software over manual accounting Arithmetical Multiple reports Time saving All of Above D 8 includes _____________. accuracy on timely basis AC2 Accounting software are only two types of ledger accounts includes Accounts having Accounts having Both A and B Nither A Nor B C 9 ___________. debit balance credit balances __________ Analysis Report provides information on the difference AC3 Ratio Variance Data Movement B between the actual vs the budgeted figures. AC3 Zero balance ledgers are not considered in reporting hence ignored. TRUE FALSE A 0 Income ledger AC3 Expense ledger If a ledger is having a credit balance, it can be an ____________. or a liability Both A and B Nither A Nor B B 1 or an Asset ledger  Income ledger AC3 Expense ledger If a ledger is having debit balance, it can be an ______________. or a liability Both A and B Nither A Nor B A 2 or an Asset ledger AC3 Profi t & Loss All income and expense ledger balances are taken to __________. Balance Sheet Both A and B Nither A Nor B A 3 Account AC3 Profi t & Loss All Asset and Liability ledger balances are taken to __________. Balance Sheet Both A and B Nither A Nor B B 4 Account AC3 ___________ is the end point in accounting a mirror showing true and Profi t & Loss Ledger Voucher Balance Sheet D 5 fair position of a concern Account AC3 Non Master Accounting software stored (stores) data in ___________ Master Data Both A and B Nither A Nor B C 6 Data AC3 Accounting Master Data includes _____________. Ledgers Categories Scenarios Both A and C D AC3 Employee Payroll Master Data includes _____________. Employees Unit (Work) All of Above D 8 Groups AC3 Service Inventory Master Data includes _____________. Salary Details Both A and B Nither A Nor B D 9 Categories Movement AC4 Alt + B is a shortcut key of ____________ Budget Variance Ratio Variance Data Variance A Variance AC4 Service Income Tax Statutory Master Data includes _____________. Both A and B Nither A Nor B C 0 Categories Classifi cations AC4 Emp Which voucher is use for recording of employee attendance? Attendance Both A and B Nither A Nor B B 1 Attendance AC4 Non Master Accounting Voucher includes ________________. Contra Memorandum Receipt All of Above D AC4 Non Master Inventory Vouchers includes ________________. Delivery Note Physical Stock Rejections Out All of Above D 3 AC4 Purchase Order Non Master Order Vouchers includes ________________. Purchases Material In Material Out B 4 ? Attendance AC4 Payroll Vouchers includes ____________. Attendance Payroll Both A and B Nither A Nor B C AC4 ________________are the resources generally used by any business Money Material Manpower All of Above D 6 entity. AC4 ___________ document connectivity is the system of linking one Inter Intra Both A and B Nither A Nor B A 7 document with another. AC4 E-fi lling website new features are added for increasing Number of User Transparency Trust Source None B 8 ____________. AC4 Submit returns/ View Form 26AS Check ITR-V Services offered by e-filing website includes _____________. All of Above D 9 forms (Tax Credit) receipt status Financial Statements summarise the individual transactions to show AC5 _______________ required by the users to analyze the company’s fi Totals Ratios Statistics All of Above D nancial data in a wide variety of ways. Digitally AC5 Digital Signature Digital Source Digital Sign DSC stands for ________________. Standard A 0 Certificate Certificate Certificate Certificate AC6 Financial statements are classified into __________ major statements. 2 3 4 8 B _______________ is a financial statement that reports a firm’s AC7 P&L Trail Balance Balance Sheet None C financial position at a specific time. AC8 In Balance Sheet F1 is uesd for _____________ Detailed Condensed Both A and B Nither A Nor B C ______________is a periodic statement, which shows the net result Profit and Loss Income AC9 Both A and B Nither A Nor B C of business operations for a specifi ed period. Account Statement None of the BC1 A __________is a list of instructions, telling the computer what to do Process Program Machine B above Other BC1 processors and All of the In a mainframe computer the Host processor manages_________ User Interfaces Data Storage C 0 peripheral above devices BC1 Single-user computers fall into _____categories 2 3 4 5 A BC1 None of the Workstations are commonly used for ________ CAM CAD CAE B 2 above BC1 Super Mini Which computers are also known as "Super micro"? Mainframes Workstations C 3 computers Computers BC1 The capability of microcomputers that enables switching between Multiprogrammi Multiprocessing Time Sharing Multitasking D 4 multiple tasks is known as _______ ng BC1 Special-purpose palmtops that keep phone directories and calendars Personal Digital Docking None of the Laptops B 5 and also provide calculator capabilities are known as_________ Assistants Stations above BC1 Object-Oriented Programming is a concept of _______generation of First Second Third Fourth D 6 computers. BC1 The device that is roughly the size of a postage stamp and is present RAM ROM CPU Hard disk C 7 at the core of the computer is__________ BC1 The ________of the CPU sends command signals to the other ALU RAM IR CU D 8 components of the system BC1 Arthmetic Calculations and Data manipulations are performed ALU RAM IR CU A 9 by_____ Which of the following is not a key element of the computing BC2 Hardware Software People Information D process? BC2 Special All of the Logical operations of the ALU include comparison of Numbers Letters D 0 Characters above BC2 Primary All of the Memory associated with CPU is called Primary Storage Main Storage D 1 Memory above BC2 The loaded programs and software get stored in _____memory ROM RAM Flash SAM B BC2 The opposite of RAM is _____ ROM RAM Flash SAM D BC2 Serial Access Stand Alone Special Access None of the SAM stands for_________ A 4 Memory Memory Memory above BC2 __________memory comes with instructions permanently stored ROM RAM Flash SAM A 5 inside. BC2 The main purpose of which memory is to accelerate the working of ROM Cache memory SAM RAM B 6 the computer while keeping its price low BC2 Flash memory is a solid state memory TRUE FALSE A BC2 None of the Refreh Rate of a monitor is measured in, Hertz Gigaflop Megaflop A 8 above BC2 A fast line printer can print as many as ________ lines per minute. 3500 3000 4000 1500 B 9 BC3 The number system used in computers is ______ Decimal Octal Binary Hexadecimal C BC3 __________is a network of satellites that helps users determines a None of the SAN VLAN GPS C 0 location on Earth. above BC3 _________mouse is exclusively used for graphics program T1 T3 T17 T4 C BC3 None of the _________is a popular pointing device for portable computers Track ball Joystick Mouse A 2 above BC3 For entering drawings and sketches into the computer None of the Digitising Tablet Joystick Track ball A 3 ________device is used above BC3 All of the The drum scanners rely on _______technology CCD CAD PMT C 4 above BC3 Scanners used to scan large sheets of loose papers are __________ Flat bed Drum Sheet Fed Hand held C 5 BC3 Which device is used in various competitive examinations? OCR OMR BCR MICR B BC3 Supermarkets use a bar code system called the ________ UPC UPS POS BCR A BC3 All of the Different shades of gray are displayed in a ______monitor Monochrome Gray scale Color B 8 above BC3 Monochrome Monochrome Mono Display None of the MDA stands for ________ A 9 Display Adapter Display Array Adapter above MS BC4 _________is not a General Purpose Software Tally MS Word MS Excel A PowerPoint BC4 Monitors that are 16 0r more inches diagonally are often called Full screen Full Page Large screen None of the B 0 ________ monitors monitors monitors above BC4 pages per characters per Bandwidth is measured in_____ bytes per sec bits per sec A 1 minute sec BC4 The printers that are used in most calculators and fax machines are Dot matrix Inkjet Laser Thermal D 2 ______printers BC4 Which of the given device is used in engineering applications where Printer Plotter Graphics Tablet MICR B 3 precision is mandatory? BC4 None of the Based on data access auxiliary devices are ________ sequential random both a & b C 4 above Universal BC4 Universal Serial Universal Server Universal USB stands for_______ Serially A 5 Bus Bus Standard Bus accessed Bus BC4 ______________is one billion floating-point arithmetic operations per None of the Megaflop Gigaflop Flop B 6 second. above BC4 Multiprogrammi The Mainframe computers exhibit______________. Multitasking Multiprocessing Multithreading A 7 ng Ultra Large BC4 Ultra Line Scale Ultra Large Ultra Large ULSI stands for, Scale B 8 Integration Scale Integrator Scale Integer Integration BC4 _______________is used for easy and fast information storage in such Cache Memory Flash Memory RAM ROM B 9 devices as digital cameras and home video game consoles. MS BC5 For giving a public presentation, which software would be used? Tally MS Word MS Excel D PowerPoint BC5 ___________scanners are more secure biometric authentication Iris Face Finger Voice A 0 schemes when compared to the other devices. BC5 ____________ are examples of sequential-access media. Magnetic tapes Hard Disk Pen Drive CD A 1 BC5 None of the Tapes are sometimes called ____________. streamers streaming tapes both a & b C 2 above BC5 Million Bytes Million Bits Per Multiple Bytes None of the MBPS stands for _________________. A 3 Per Second Second Per Second above BC5 All of the __________come with data already encoded onto them. CD-R CD-ROMS CD-RW B 4 above BC5 A __________drive consists of a NAND-type fl ash memory data Flash drive DVD CD Hard disk A 5 storage device integrated with a USB (Universal Serial Bus) interface. Data and Data and Hardware and People and BC6 The systems model describes the relationship between A Information Procedures Software Procedures Which characteristic of information indicates that information is BC7 Relevant Timely Concise Complete C condensed into a usable length The aerospace, automotive,chemical,electronics and petroleum Micro Embedded BC8 Mainframes Supercomputers B industries use__________computers Computers Computers  Multiprogrammi BC9 Dividing a complex task among several processing units is known as Multitasking Multiprocessing Time Sharing C ng CB1 CBS software developed by TCS is ______. Finacle Quartz Flex Cube Bankmate B CB1 The server is a sophisticated computer that accepts service requests Clients Manager Printers ATMs A 0 from different machines which are called _____. CB1 Automated Auto Talking Automated None of the ATM stands for _______. C 1 Telling Machine Machine Teller Machine above. CB1 Data Base Personal Which of the following is not a server of CBS? Web Server Proxy Server D 2 Server Server CB1 _____ server hosts the core banking application. Application Proxy Server Web Server Data Base A CB1 _____ of the application is capable of only entering the data at the Final Version Client version Beta Version Alpha Version B 4 end point that is branches in CBS. CB1 ______________ is a designated role for maintenance of the data Network Database Security Librarian C 5 base. Administrator Administrator Administrator CB1 Till the central data base becomes accessible, all the ATM transactions Positive Balance Positive Blank Positive Bank Positive A 6 are passed in the __________file available at the ATM server. File File File Balancing File CB1 The __________________ authenticates the customer with the log in IBDS Proxy server Antivirus server IBAS D 7 details stored in the IBDS. CB1 ______________provides network security by preventing malicious Anti Virus None of the Proxy Server Firewall B 8 data from entering the network. Server above CB1 Duties of ________________would include deciding on access rules Database Network Security Librarian C 9 to data and other IT resources. Administrator Administrator Administrator Bills & All of the CB2 In CBS _____ modules could be added. Savings Account Current Account D Remittances above CB2 Communication All of the Change management procedures include changes in ___________. Hardware Software D 0 Systems above CB2 ______________is the version of the program given to the users for Gamma Alpha Beta Teta C 1 testing purpose. CB2 After a program is tested by the users, it is pushed into the production User Integration Unit Testing System Testing A 2 environment.This is known as__________. Acceptance Test Testing CB2 Withdrawal of The HSM or SSM are used for the purpose of _______. Decryption Encryption Security B 3 Cash CB2 None of the ATM transactions involve the generation of ________. Cash Journal ATM log Both A & B C 4 above CB2 In the remotely placed ATMs, the electronic journal is retrieved by a Electronic Cash Journal Journal Journal Pulling B 5 mechanism known as__________. Journal Pulling Pulling Recording CB2 In case of RTGS, the money transfer takes place in the books of SBI RBI BOI Canara B 6 ________bank CB2 Deferred Net Gross None of the EFT and NEFT work on the basis of _______________ Net Settlement A 7 Settlement settlement above CB2 Every RTGS message is assigned a unique number known as None of the STP UTR UTN B 8 ________________number above Bussiness Bussiness Bussiness CB2 None of the BCP stands for _____ in CBS. Continuity Continuity Control B 9 above Programming Planning Programming Network Operating Application None of the CB3 CBS is a combination of an Application Software and _______. A Devices System System above. Customer CB3 Cash Reserve Control Rate Cash Receipt CRR stands for _____ in CBS. Relationship A 0 Ratio Ratio Rate Resource Disaster Desktop CB3 Disk Recovery All of the DRP stands for ____ in CBS. Recovery Recovery B 1 Plan above Planning Process CB3 Bussiness Continuity Planning should cover the following important Branch Internet All of the ATM Operations D 2 and critical processes in CBS. Operations Banking above CB3 Which of the following type of processing charges is/are not DD issue Cheque return None of the Courier charges D 3 associated with CMS in CBS? charges charges above CB3 Which of the following type of controls over parameter settings are Clearing cycle Cheque limit Credit limit Intrest B 4 not appliyed in CMS? Business Business Disaster CB3 _______________ is a process by which the bank ensures the None of the Recovery Continuity Recovery B 5 maintenance and recovery of operations. above Planning Planning Planning CB3 Data base ATM DATA Domain Name Application Application software would access the ________ A 6 server Server Server Server CB3 __________ are capable of being connected only when devices are Virtual LAN MAN WAN B 7 connected to a switch. Networks Taxation CB3 Tax Collected at Tax Collected at None of the TCS stands for ____________________. Company B 8 Software Source above Standard CB3 Which of the following applications is used to book purchase invoices Expense Accounts Purchasing Sales C 9 received from vendors? Management Payable CB4 The CBS is capable of being implemented in stages. TRUE FALSE A CB4 Which of the following is not a software development companies for Infosys TCS MCA Iflex Solutions C 0 CBS? CB4 In CBS, ______ is the computer that accepts service requests from All of the Server Clients Head A 1 different machines. above CB4 CBS applications runs on ______ Server. Web Application ATM Mail B CB4 Bank branch running the CBS version which is called the _________. Final version Party version Client version Server version C 3 CB4 Changes made by CBS application software first saved on _________ Application Test Server Central server Client Sever B 4 server. servers CB4 Software Wireless Which of the following is not treated as Information assets? Note Book Laptops B 5 applications network CB4 All of the _____ are the main goals of information security. Integrity Confidentiality Availability D 6 above CB4 Application Domain _______is used for authentication. Local Server Web Server B 7 servers Controller CB4 None of the ______ is a process of unauthorized entering a network. Hacking Mailing Connecting A 8 above CB4 Card holder Which of the following information is not displayed on ATM card? Date of expiry Pin number CVV number C 9 name Recording of Passbook Interest All of the CB5 Core Banking Solutions are developed to perform__? D transactions maintenance calculations above CB5 Summary of the Charging All of the Analytic reports of the RTGS activity includes _______ in CBS. Net position D 0 transactions reports above CB5 ____is more powerful to represent complex data structures. ISO 20022 ISO 20023 ISO 20024 ISO 20025 A Unique Uniform Uniform CB5 None of the UTF stands for _______. Transaction Transaction Transaction B 2 above Reference Reference Record CB5 The objective of the ____ is to meet the needs of the customers who All of the CMS Cheques DD A 3 have operations all over the country. above CB5 Charges (various All of the In CMS parameter settings includes _____. Clearing cycle Credit limit D 4 slabs) above CB5 ____ mandates that PNB RBI BOI CBDT B 5 every bank should have a security policy. ____ control include physical access, logical access, environmental CB5 Application Management Operational Organizational controls, evaluation controls in C 6 Controls Controls Controls Controls operation systems and evaluation controls of network. Report All of the CB6 The servers in the Data Centre could be many of _____ servers. Data Base Application D Generating above Availability of All of the CB7 Benefits of CBS________. Better MIS 24*7 support D accurate data above The servers in the data centre are segregated using the concept of CB8 VLAN WAN LAN MAN A __________ Virtual Local Virtual Line Area Virtual Local All of the CB9 VLAN stands for _______. Around B Network Area Network above Network This data type allows alphanumeric characters and special symbols in DB1 Text Number Auto Number Date/Time A Ms-Access. DB1 A __________ enables you to view data from a table based on a Form Query Macro Report B 0 specific criterion in Ms-Access. DB1 A __ name must be unique within a database. Table Field Record Character A If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of DB1 ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called ____ Foreign key Native key Composite key Primary key A 2 in Ms-Access.  Tables with Name of fields, DB1 Query design window has two parts. The upper part shows _____ in fields and Sorting check field type and Criteria B 3 Ms-Access. relationships boxes size between tables Every table in relational database contain a field or combination of DB1 fields that can uniquely identify each records, it is called ___in Ms- Foreign key Native key Composite key Primary key D 4 Access. DB1 The complete information about an entity in a database is called ____ Data Information Record Field C 5 in Ms-Access. Right click the DB1 relationship line Double click the None of the If you need to edit a relationship in MS-Access______. Both of above C 6 and choose Edit relationship line above Relationship DB1 It is an association established between common fields of two tables. Line Relationship Primary key Records B 7 DB1 Which of the following is not a field type in Access? Money Hyperlink OLE Object Lookup Wizard A 8 Write criteria Write criteria Write criteria Write criteria DB1 To achieve AND effect when you are entering criteria in a query values in same values in same values vertically values B 9 design window in Ms-Access is ______. field separated field separated one in a row horizontally with AND with & DB2 Which of the following is not a database object? Tables Queries Relationship Reports C DB2 Wild card Comparison In Ms-Access, a search value can be an exact value or it can be____. Logical Operator Relationship C 0 character operation Once in the On the 1st and DB2 In Ms-Access, When a picture or other graphic image is placed in the At the top of Every after beginning of the last pages of A 1 report header section it will appear____ every page record break report the report DB2 What are the columns in a Microsoft Access table called? Rows Records Fields Columns C DB2 You can automatically include all of the field in a table in a query None of the Clicking Right clicking Double clicking C 3 by___ a strike that appear list box in query design view in Ms-Access. above DB2 It is most common type of query. It retrieves records from one or All of the Parameter Select Crosstab B 4 more tables and then displays in Ms-Access. above DB2 In Ms-Access, It is a query that when run displays its own dialog box Select crosstab Parameter Append C 5 prompting you for information, such as DB2 A(n) ____ is the default control for a Yes/No field in Ms-Access. Check box Option button Toggle button List box A 6 DB2 Ms-Access provides Hyperlink data type to create a clickable link to a All of the Web page File Email address D 7 __________ above DB2 Comprehensibi Which of the following is not a benefit of relationship in Ms-Access? Consistency Redundancy Efficiency B 8 lity DB2 All of the ____ is the text displayed as a tooltip. Screentip Screentop Desktoptip B 9 above To create a new table, in which method you don’t need to specify the Create table in Create Table Create Table by All of th DB3 C field type and size? Design View using wizard Entering data eabove DB3 _____ is recording data in only one place implies less disk space in Ms- Comprehensibi Consistency Redundancy Efficiency C 0 Access. lity DB3 None of the Abs(-50) will give output____ in Ms-Access. -50 500 50 C 1 above DB3 In Ms-Access, ______ form control lets the user to insert a picture. Lable Insert Page Logo Option Group C 2 DB3 Which of the following is not a type of Form Control in Ms-Access? Related Bound Unbound Calculated A 3 DB3 Which of the following activity is not associated with command On Click On Run On Mouse Up On Enter B 4 button in Ms-Access form? DB3 Which of the following category is not found under Command Button Record Form Macro Application D 5 Wizard in Ms-Access form? Navigation Operations Operations DB3 Which of the following Tab is not when we open Form in Design View Create Design Arrange Format A 6 in Ms-Access? DB3 Which of the following is not a type of Action Query in Ms-Access? Append Select Delete Update B 7 DB3 Which of the following option is not available under Summary Options Sum Avg Count Min C 8 in Ms-Access Reopts? DB3 Which of the following is not a Logical Operator in Ms-Access form? = ? In C 9 DB4 This key uniquely identifies each record in Ms-Access. Primary key Key record Unique key Field name A DB4 Which type of field is incremented automatically in Ms-Access? Auto Elevate AutoNumber Auto Increment Auto Value B 0 DB4 Tables and Tables and Queries and Which object is used to create a form in Ms-Access? Tables only A 1 Queries reports reports DB4 Simple filter Simple query Table query Which tool do you use to create a query object in Ms-Access? Database wizard C 2 wizard wizard wizard DB4 Which of the following is not a view for interacting with a form object Datasheet view Design view Form view Layout view D 3 in Ms-Access? DB4 Which data type is better to use for storing phone number in the Text AutoNumber Number Currency A 4 following format “977-1-1234567” in Ms-Access? DB4 Which criteria do not return the position “POLICE” as a match in Ms- Position = Position = Position = ” Position = D 5 Access? “*LI*” “P??ice” ?ol*” “P#e” Once in the On the 1st and DB4 When a picture or other graphic image is placed in the report header At the top of Every after beginning of the last pages of A 6 section it will appear____ every page record break report the report DB4 Which of the following is not a Database software? Unix Oracle Access Foxpro A DB4 All of the The data can be entered into a table in the ____________ view. Design Datasheet Dataview B 8 Above DB4 None of the SQL is considered to be a __________ 2GL 3GL 4GL C 9 above In one-to-many relationship the table in ‘one’ side is called _______ DB5 Child , Parent Parent , Child Brother , Sister Father, Son B and on ‘many’ side is called _______ in Ms-Access. DB5 Default length of numeric data type is ____________ in MS Access 255 char 16 char text long Integer D 0 2010. DB5 None of the The default query invoked by MS-Access is_____________. Update Query Select Query Delete Query B 1 above DB5 __________ data type field can't be updated YES/NO HYPERLINK MEMO AUTONUMBER D DB5 None of the A Record is also commonly called as a _________ Column Field tuple C 3 above DB5 Most database operations that we do manually can be automated by Program Query Form Macro D 4 using DB5 _________ are what we use to summarize and present data in the Report Query Form Macro A 5 table DB5 In MS-Access, what data type can be used for a phone number field in All of the Number Text Memo B 6 a database? above DB5 In a table, _____________ uniquely identifies each record that is Unique Key Foreign Key Primary Key Record Key C 7 stored in the table. DB5 None of the _________ is used to insert values in Table directly. Query Report Form A 8 above DB5 Which SQL clause is used to retrieve data from database? SELECT WHERE FROM INSERT A DB6 The size of Yes No field is always___ in Ms-Access. 1 bit 1 byte 1 character 1 GB A DB6 The __________clause is used to filter records in database. SELECT WHERE FROM INSERT B DB6 None of the __________is Example of DBMS Word Excel Access C 1 above DB6 A Junction Table creates a _______________ relationship between None of the One-to-One One-to-Many Many-to-Many C 2 two tables. above DB6 The Primary key of one table and the matching column in another None of the Matching Key Foreign Key Index key B 3 table is known as ______________. above specifying DB6 For ordering updating None of the In SQL, having clause is used for _________ conditions with B 4 records records above group by clause DB6 None of the A form can be divided into_________ to increase the readability Pages Section Rows A 5 above How can you define a field so that when entering data for that field it DB7 Input mask Validation Rule Indexed IME Mode A will display ****** instead of actual typed text in Ms-Access? Which field type will you select when creating a new table if you DB8 Text Memo Currency Hyperlink B require to enter long text in that field in Ms-Access?  In table design view, which key can be used to switch between the DB9 F3 F4 F5 F6 D field names and properties panels in Ms-Access? Word Spreadsheet Presentation EX1 Lotus Symphony & Resolver One are examples of ____________. Processing DBMS B Package Software package The name must Names can be 1 Names cannot Names can EX1 begin with Which of the following is not a rule for Naming ranges? to 255 be valid cell contain D 0 either a letter or characters long addresses exclamation an underscore EX1 _______ is a Union Operator used in MS Excel. : , ; C EX1 Which of the following operators has the highest precedence in MS : , & % A 2 Excel 2010? EX1 ___________category of functions in Excel are used to calculate Maths and Financial Statistical Database C 3 absolute values, cosines, logarithms, etc. Trignometrical ______is the interest rate received for an investment consisting of EX1 payments (negative values) and income (positive values) that occur at IRR PMT FV PV A 4 regular periods. EX1 Which of the following functions are used to calculate the loan PV PV PMT IRR C 5 instalments? EX1 Initial cost of Salvage value of Useful life of the None of the In the SLN function, the argument LIFE corresponds to? C 6 the asset the asset asset above EX1 FACT(5) =______ 0 120 -120 #Num Error B EX1 MOD(-6,-4) returns -2 1 2 #DIV/0 Error A EX1 _________function returns an evenly distributed random real number RANDBETWEEN( RAND( ) MOD( ) INT( ) A 9 greater than or equal to 0 and less than 1. ) EX2 By default, a workbook opens with ________worksheets. 4 2 3 5 C EX2 ROUND(32.5, -1) returns? 35 32 30 25 C EX2 _________function adds the cells specifi ed by a given condition or IF( ) SUMIF( ) COUNTIF( ) SUM( ) B 1 criteria. EX2 Which function returns the largest value in a list of arguments, None of the LARGE( ) MAX( ) MAXA( ) C 2 including numbers, text and logical values? above EX2 When a formula contains text that Excel doesn’t #NULL! #VALUE! #NAME? #REF! C 3 recognize________error is dispalyed. EX2 None of the The default alignment of dates in MS Excel is_______ Right Left Centre A 4 above EX2 __________option allows the users to rotate text. Align Right Orientation Increase Indent Bottom Align B 5 EX2 CTRL+C- CTRL+C- CTRL+C- CTRL+C- Shortcut key used to copy formats in Excel is, A 6 >CTRL+V->R >CTRL+V >CTRL+V->F >CTRL+V->A EX2 A normal data range can be converted into a Table by using CTRL+E CTRL+T SHIFT+T ALT+T B 7 _______shortcut. EX2 Data from two worksheet locations can be easily compared using the None of the Freeze Panes Macro Splitting Panes C 8 ___________option. above EX2 __________is a key that identifies patterns, colors or symbols Legend Data Series Gridlines Axes A 9 associated with the markers of a chart data series. One can easily access the taskcentered functions such as printing and Quick Access EX3 Backstage View Home Tab Ribbon A sharing from ____________. Tool Bar EX3 Which chart is suitable for a data set that has only one series of Bar Column Pie Area C 0 information? EX3 _________are used to give the users a quick look at trends or Charts Sparklines Pivot Tables Filters B 1 patterns that may not be easily spotted in the data itself. We can also Sparklines are Sparkline can We can create create printed when display a trend EX3 several sparklines for we print a The advantage of Sparklines is, based on D 2 sparklines at the rows of data worksheet adjacent data in same time that we add that conatins a clear manner later them EX3 None of the Shortcut key for Macros are assigned in combination with _____key. SHIFT CTRL ALT B 3 above EX3 We can use _________function to create a hyperlink that opens a None of the Index( ) Match( ) Hyperlink( ) C 4 document that is stored on a server, intranet or internet. above EX3 Text-to-Cols All of the Non-excel files can be easily opened in Excel using, Import wizard Through Macros A 5 wizard above EX3 The________tab in the format cells dialog box gives absolute control Font Border Number Alignment C 6 over numeric formatting. EX3 There are ________ fill colors and patterns. 1 million 10,000 1 thousand 16 million D EX3 Default alignment of values and dates in MS Excel 2010 is_________ Left Right Centre Justified B 8 Which kind of conditional formatting provides a visual representation EX3 All of the of how the data in each cell compares to the other cells of the Data Bars Color Scales Icon Sets D 9 above worksheet? Absolute Row- Absolute EX4 A$1 is an example of __________reference. Relative Absolute C wise Column-wise EX4 One can view different areas of the worksheet simultaneously by Conditional None of the Split Panes Freeze Panes A 0 using the__________option. Formatting above EX4 __________ is a key in the chart that identifies patterns, colors or Data Bars Legend Gridlines Axis B 1 symbols associated with the markers of a chart data series. EX4 There are _________types of chart types in MS Excel 2010. 50 65 73 80 C Several Sparklines It is not Column width sparklines can cannot be necessary for of the Column EX4 be created at printed when Which of the following is not true about sparklines? the data to be sparkline can C 3 the same time we print the next to the be increased by selecting worksheet sparklines or decresed multiple cells containing them EX4 _______are used to demonstrate the “what”, not the “why” of the Column Chart Sparklines Area Charts Pivot Tables B 4 data. EX4 We have to use________cell reference if we want the macro None of the Absolute Relative Both A & B A 5 recorded to run in the same cell only. Above EX4 ________function can be used to open a document that is stored on a Vlookup() Hyperlink() lookup() Index() B 6 network server, intranet or Internet. EX4 All of the Which of the following non-excel files can be opened in Excel? Text File Lotus 123 Quattro Pro D 7 above  Field with most EX4 The first field in The last field of The field While sorting data in MS Excel 2010, the best field to first sort by is? duplicate B 8 the data the data containing text entries EX4 None of the _______in MS Excel 2010 has built-in filtering features. Excel Table Charts Sparklines A 9 above _________ are used to exchange data within Excel and between Excel Database EX5 OLE DDE Both A & B D and other Windows applications. Engine EX5 ________feature in MS Excel 2010 hides the rows and columns Conditional Sort Sparklines Filter C 0 containing data that do not meet the criteria we define. ne. Formatting EX5 We can apply dynamic filters in MS Excel 2010 for data such as Text Values Dates Formulas C 1 _______. Restrict dates Restrict data to Limit the EX5 outside a All of the Data Validation can be used to, predefined number of text D 2 certain time above items in a list characters frame We can limit the choices in an Excel data validation list, by using EX5 named ranges and the _________function to create dependent Index( ) Match( ) Indirect( ) Direct( ) C 3 validation lists. EX5 View its None of the In MS Excel 2010, when a cell is locked, we can't_________ Edit it Both A & B B 4 contents above In MS Excel 2010,_________allow us to turn our data inside out, EX5 upside down, sideways and backwards, quickly summarize and Sparklines Charts Pivot Tables Filters C 5 analyze large amounts of data in lists and tables. An Excel worksheet A database file A collection of EX5 database/list or created in an All of the Source data for creating a Pivot Table in MS Excel 2010 can be, ranges to be D 6 any range that external above consolidated has labeled application columns.  Listing unique Creating a pivot EX5 values in any report with sub- Transposing All of the Pivot Tables can be used for, D 7 column of a totals and data above table. custom formats Each column in Each row in the the source data source data The source data EX5 Which of the following is not a pre-requisite for creating a Pivot Table Data is set up should contain should contain can have blank C 8 in MS Excel 2010? as a Table one type of the details for rows