S.

NO QUESTION
1 Which of these is an ERP Systems?
______states that the objective of the auditor is to identify and assess the risks of material misstatement
2 whether due to fraud or error
3 As per SA315,understanding the entity and its control environment means _____

4 As per SA315,the auditor has to understand the information systems environment relevan to _____
5 In Governance Framework,The _______ is the owner of the application
6 In Governance Framework,The _______ is the owner of the data residing within the application
The communication lines are strictly drawn between the Chief Information Officer and Chief Financial
7 Officer so as to maintain the ____ of the data within the application
8 The risk in an automated environment are _____
9 The risk in an automated environment may be ______
In addtion to SA315,the auditor's in response to Clause (i) of Sub-Section 3 of Section _____ of the
10 Companies Act,2013,have to report whether the entity has adequate ______
______ deals with the auditor's respnsibility to design and implement responses in the form of audit
11 procedures in response to work done as part of SA 315.
12 The audit procedures are required for the _______
A/An ______system inherently means that all the modules within the system are seamlessly connected
13 with each other and the transactions flow through the relevant modules
14 In ERP,____Primary set of Books are there and _____ transactions reside here.

15 Which of these is not the possible reason of why substantive procedures may not be feasible in ERP?
16 ISAE means ______
17 PCI-DSS means _____
18 Which of the following are not the key aspects of SA 300?
A test of controls is an _____ to test the effectiveness of a control used by a client entity to prevent or
19 detect material missatements

Say whether TRUE or FALSE?

When auditors have access to systems,Auditors should always request access to the production or live
20 environment
21 The type of access that auditors request should be ______
22 Auditor should request for _____access for the duration of the audit
23 General IT controls are known as ____ controls
24 Which of the following is not a category of GITC?
25 ______ controls are embedded into IT applications
______ controls are activities in a business process that are performed by individuals or employees
26 without the need to rely on a IT system
______ controls are basically manual controls that make use of some form of data or information or report
27 produced from IT system and application.
28 Which of the following is not a risk in IT?
Which of the following is not essential for the effective implementation and operation of General IT
29 controls?
30 Which of the following are to be considered for determining the sample size
31 Find the odd one out in the IT Governance Review Checklist?
 The objective of program changes is to ensure that modified systmes continue to meet _____________
32 objectives
33 _____ are changes required in the existing functionality of the ERP due to a business need.
______ are changes provided by the vendor of ERP to address known bugs,security or provide
34 improvements to functionality to existing ERP.

35 _____ are high risk because they bypass the application controls and impact the integrity of financial data
36 Which is the last step in change management process?

37 _______ are provided to the IT department where the systems analysts perform analysis and design
38 A priviliged user may be a _______
39 In a security log of ERP,if the system default value is OFF it indicates the table log are _____
40 Environment controls form part of the ______ of access security
41 When a company has two or more IT systems as an interface ,what is the risk involved?
42 The objecive of AAC's are to ensure______
43 _______ controls come along with the implemented ERP and also called as Input control
44 ________ may not prevent or detect misstatements

As per ________,communicating deficiencies in internal contol to those charged with governance and
45 management makes it necessary for the auditor to communicate control deficiencies to the management.
46 ______ controls are implemented by the company at the time of installing the ERP
47 _____ controls are also known as processing controls
48 Which of the following are some basic controls in inherent controls?
If the GITC's are found to be ineffective,then the auditor will have to test the auomated controls _______
49 Balance sheet date to support the opinion on internal financial controls

50 Do the auditor will have to mention if the deficiencies were present in the prior periods of audit?
51 One commonly preferred method for testing design effectiveness is
52 IPE is used by
53 The IPE can be in ___ forms
54 How many types of reports can be extracted from ERP systems
55 These are reports that are available at the time of implementation of the ERP systems by the entity
56 These reports are created by the entities with respect to their businesses, revenue streams, divisions etc.
57 ________ are used to retrieve information or data from a database in a readable format using a SELECT sta
58 These reports are inbuilt into the systems
59 ERP comes with a set of reports that can be used as is, if the company has implemented the ERP without t
60 Cash flow statement is one of the examples of _________________ reports
61 In ___________ reports, the company has followed their own pattern or code for Chart of Accounts (CoA),
62 ______________ can be used to extract payroll information such as leaves available per employee
63 Which of the following is not an element for determining the testing strategy for reports
64 Validation of Reports includes
65 The Auditor has to check the ____________ of the data before planning to understand the types of reports
66 The auditor may limit the test procedures to validate / test the reports when ________________
67 Which of the folowing indicative commands will be used by the company in SAP to generate reports?
68 In case of a standard report, the creator/modifier of the report would be the _____________
 69 The evidence of the creator/modifier of the report can be found in _________________ logs
70 During 1st year of audit of the entity, after ensuring the creator/modifier value of the report, the audit
71 During subsequent years of the audit, when GITCs and relevant Business process controls are tested & effect
72 Why to test the reports by the auditors?
73 In quarterly review of aging analysis, when report logic is working correctly, what is the next step to be don
74 These reports are created by the business/IT persons in the company for their use and reporting requireme
75 The procedure to test the completeness and accuracy of the reports have to be performed every year in
76 While testing for users who have access to create/modify the custom report, the auditor will have to verif
77 If any change to the custom report has happened in the year of audit, then _____________
78 These reports are extracted on ad hoc basis or on as and when basis
79 These reports have a high probability of the data being manipulated after creation
80 The auditor cannot rely on just one sample to test the completeness and accuracy assertions of the report
81 The criteria to be used to decide timing of report testing
82 When GITC's are effective, the auditor needs to follow which sampling procedure to test a report
83 When there are deficiencies in the reports/IPE that have been tested, the errors at a minimum may be of _
84 ____________ is when a user has the ability to perform critical business activities in an ERP
85 The users who have the business activities that carry a higher risk and could have wider impact onoperati
86 __________ refers to the separation or distribution of job roles among employees in such a way that incompat
87 ___________ are typically regular employees who carry out day-to-day business operations and transaction
88 ________ users are internally used within the ERP to perform automated operations and transactions
89 These are a type of super users who have very extensive or unlimited access to carry out all or several activ
90 These are the users that come packaged along with the ERP software
91 _________ represent a title, position, designation or function, place or region within a company and do not
92 These are users who are given user id for a limited time period
93 These are users who do not belong to the company
94 Users access to ERP is based on _______ of respective users
95 The relationship between ERP Roles and Users is __________________
96 ___________ are access control features in an ERP that enable grouping of several related access rights in t
97 Roles offer an easy to understand, fast and reliable way to manage user access to an ERP. This feature is
98 A ________ represents a high-level grouping
99 A _________ is the more granular internal technical grouping of authorisations, permissions and access rig
100 Segregation of duties can be implemented as _____________ control
101 Tool used in implementing and review of segregation of duties and sensitive access
102 Auditing standards require auditors to obtain the evidence for _________
103 User access controls are like ________ in an ERP environment
104 When an auditor found deficiencies in User Access Controls, the auditor __________________
105 The auditor should first gain and understand the ___________ before auditing segregation of duties and sen
106 ______ make it easy to manage user access to an ERP
107 Reliability of user access controls in an ERP depend on effectiveness of __________________
108 Business rules for implementing segregation of duties should be defined by the ________
109 Which of the following is an example of Generic Users?
110 Which of the following is an example of External Users?
111 Which of the following is an example of Temporary Users?

112 SAP the purchase and inventory processes are provided in the module known as____________.
 ____________Where the IT infrastructure including operating system,database,Network or hardware are
113 changed but not change in version or functioning of ERP.
The Key Phases in any ERP migration project will consist of planning,system design,________,Testing and
114 Go Live.
115 Which of the following is example of an ERP
116 Which of the following activity is part of the system design phase of a migration
117 __________ happens in Planning Phase.
118 ________is part of Data conversion phase.
119 How many Phases are there in data migration strategy

120 __________ In this phase of migration the objectives of migration and the migration strategy are defined.
121 At which phase of the migration would rollback procedures be triggered,if necessary
122 Rollback procedure are defined in the ____________ phase.
123 Which of the following require specific considerations during a migration.

124 Where would auditors review migration process and controls.

125 ___________ should be prepared and maintained for all phases of migration
126 In Oracle the purchase and inventory processes are provided in the __________ module
127 _________ can be used for implementation of a completely new accounting system.
128 Reports and system generated data IPE i.e._________________ could change.
___________phase of migration process prepares including the process flows,data flows and business
129 process re-engineering.
__________ phase of migration involves identification of source data,mapping between source and target
130 system
131 Intermediary data stores called ____ areas are used to hold convert and transfer data.
132 In __________ phase integrity checks are done to ensure completeness and accuracy of data.
133 _____________ are carried out iteratively to rectify errors and data inconsistencies.
134 In ______ phase scenarios and scripts are prepared for the new system.
A_______________ project provides an opportunity to review and carry forward only the relevant data
135 and discard obsolete data.
The auditor may consider using the work performed by internal auditors in accordance with guidance
136 given in __________
137 How many types of journal entries are there ?
_________transactions pertaining to sales, purchases, inventory, rent, audit fees, AMC
138 expenses, salaries etc. are subject to internal controls as defined by the company.

139 _________these entities record nonrecurring,unusual transactions or adjustment entries in the ERP’s.
__________These entries may not be subject to the same level of rigour of the internal controls or may
140 not have passed through any controls at all.
_____________are residing outside the books – for example in excel sheets etc. and may impact the
141 financial statements.
If the journal entries are passed using a specific journal type then a list of such entries can be extracted
142 from the system. For example, journal types could be MJV i.e._____________
ERP/application should have ________ many fields and the company must be entering data in these fields
143 for them to be extracted.
 _________ the entries passed during the year to the balances in the Trial Balance. The auditor may use
144 ACL/IDEA Caseware/MS Access/Excel to perform __________ testing
Using tools such as ______, IDEA Caseware, MS Access, Excel etc., the auditor can test the data for
145 completeness
146 __________ can also help in finding out if there are duplicate journal numbers used.
147 ______Accounts that are used very infrequently.
148 What is the expansion of NSJE__________
149 The unusual, non-recurring transactions may generally be directly entered in_________
150 Estimates, impairments are generally a type of__________

151 While understanding the IT/ERP systems used to record entries, the points to note are___________

152 Some of the fraud risk factors to note which may lead to unusual transactions are_____

153 A key factor to be kept in mind while making enquiries of personnel are_______

154 Which is the main risk due to Non Standard Journal entries:
__________are entries that may be passed as a result of fraud. Hence, this is the main risk. Another risk
155 can also be risk of management override of controls.

156 It is possible that a Non-standard journal entry may not have relevant ____________ supporting.
In industries/sectors, where volume of data is huge, ________________ testing may not be an appropriate
157 way of testing completeness of data.
______________ to be achieved may be a key fraud risk factor from an investor/ stock holder perspective
158 leading to Non-standard journal entries.

159 _____________ to be achieved may be a key fraud risk factor from a bank/financial institution perspective.
To bring in efficiencies in the process of extraction and analysis of JE data, the auditor may use
160 ____________
161 What is the expansion of ACL__________
 OPTION A OPTION B OPTION C OPTION D ANSWER
SAP Oracle All the above None of the above C

SA330 SA315 SA300 None of the above B

including the entity's int including the entity's ext excluding the entity's int excluding the entity's ext A

Financial reporting Communication Either A or B Both A & B D

Business team IT team Either A or B None of the above B
Business team IT team Either A or B None of the above A

confidentiality integrity availability All the above B

less many moderate All the above B
due to the number and locinterfaces between the apsecurity within the applic All the above D

142,internal controls syst 143,internal financial con 142,external controls syst143,external financial conB

SA 330 SA 300 SA 610 None of the above A

listed companies unlisted companies Either A or B Both A & B D

Enterprise resource plannintegrated Enterprise res Entity resource planning None of the above B
one,few many,all one,all many,few C

nature of business outsourced processes volume of transactions arSystems distributed withi D

Indian Standard for Assu International Standard f Indian Standard for Audi International Standard fo B
Payment Compliance Indus Payment Compliance Indus Payment Card Industry-DaPayment Card Industry-Dat C
Involvement of key team areas where CAATS may be All the above None of the above D

audit strategy audit procuedure audit evidence None of the above B

1 0 A
Display-only read-only Either A or B Both A & B D
priviliged access administrative access temporary access super user C
pervasive indirect Both A & B None of the above C
Program change Access control Data center and Network Application system acqui B
Manual controls Automated controls IT-Dependent controls None of the above B

Manual controls Automated controls IT-Dependent controls None of the above A

Manual controls Automated controls IT-Dependent controls None of the above C

Unauthorized access of d Temporary access Unauthorized changes to Direct data changes B

Information produced by EManual controls IT-Dependent controls None of the above B

Types of control Timing of test History of errors and expeRisk management D
How is the department orHave formal IT policies a How does IT communicateAre the employees traine D
Internal reporting Financial reporting Both A & B None of the above B
Minor change major change normal change data changes C

Minor change major change Bug fixes patches and updates D

emergency changes direct data changes major changes patches and updates B
change request implementation testing documentation D

All change requests Approved change requestMajor changes None of the above B
system administrator database administrator netwrok administrator All the above D
enabled disabled not defined None of the above B
Physical layer Network layer Application layer None of the above A
Data transfer between sy Data transfer between sy Either A or B Both A & B D
accuracy of data completeness of data the validity of the transacAll the above D
Inherent configurable security embedded A
operation deficiency design deficiency control deficiency communicating deficiencyB

SA 315 SA 330 SA 265 SA 300 C

Inherent configurable security embedded B
Inherent configurable embedded Both B & C D
Debit=Credit depreciation calculation discount calculation None of the above A

on closer to the Either A or B None of the above A

yes no A
to look into the process n to look into the process f a walkthrough of the contNone of the above C
Entity Personnel to perforAuditor to test a relevant Auditor to perform substaAll the above D
2 3 4 1A
1 2 3 4C
Standard Reports Customised Reports Database Queries None of the above A
Standard Reports Customised Reports Database Queries None of the above B
Standard Reports Customised Reports Database Queries None of the above C
Standard Reports Customised Reports Database Queries None of the above A
1 0 A
Standard Customised Database Queries None of the above A
Standard Reports Customised Reports Database Queries None of the above B
Standard Reports Customised Reports Database Queries None of the above C
Source Data Report Logic Report Parameters Functions D
Accuracy of Logic Completeness of Data Accuracy of Data All the above D
consistency integrity independency redundancy B
Controls in GITC are effec Controls in Business ProceBoth A and B Either A or B C
se16 se16n sa38 All the above D
vendor company finance controller IT personnel A
alert change management file backup B
controls, compliance controls, efficiency completeness, accuracy accuracy, impact C
no further testing need t reliance can be placed onBoth A and B None of the above C
used by management to mfor compliance purposes relied upon by the auditorAll the above C
adopt appropriate controladopt substantive audit pEither A or B None of the above A
Customised Reports Database Queries Standard Reports Other tools A
Standard Reports customized reports Both A and B Either A or B B
end users authorised users programmers technical consultant B
appropriate code change sappropriate date of changappropriate approvals shoappropriate report outputC
Standard Reports Customised Reports Database Queries None of the above C
Database Queries Custom Reports Standard Reports None of the above A
controls in all domains of there are no relevant deficontrols are ineffective in all domains of GITC's C
Inclusion of Period and EnCompany Policy New ERP implementationAll the above D
One Sample One Sample in each ScenaAppropriate substantive None of the above B
1 type 2 types 3 types 4 types B
Role Responsibility Authorized Access Sensitive Access D
Sensitive Access Authorized Access Responsibility Role A
Sensitive Access Segregation of Duties Roles Profiles B
Normal Users End Users Business Users All the above D
Normal Users System Users End Users Business Users B
Normal Users System Users Previleged Users Business Users C
Normal Users System Users Previleged Users Default Users D
System Users Previleged Users Generic Users Default Users C
System Users Temporary Users Generic Users Default Users B
System Users Temporary Users Generic Users External Users D
Job Roles Responsibilities Either A or B Both A and B D
One to Many Many to One Many to Many One to One C
Roles Profile Both A and B None of the above C
RBAC RBFC RBOC None of the above A
User Role Profile None of the above B
User Profile Either A or B Both A and B B
Preventive Detective Either A or B None of the above C
SAP GRC Oracle GRC BIZRights All the above D
point-in-time full period of audit Either A or B None of the above B
GITCs IT dependent controls application controls None of the above C
should report deficiency ignore the deficiency record the deficiency should evaluate the impact
D
Business Environment IT Environment Both A and B Either A or B C
Role Profile SA SOD A
GITCs IT dependent controls application controls None of the above A
Auditor Company IT Consultant Government B
Auditors Consultants Sales User Business Partners C
Auditors Support Users Sales User Business Partners D
Auditors Vendors Sales User Customers A

Procurement ManagemenInventory Management Materials Management Accounts Management C

Non-Technical Migration Technical Migration Data Migration Non-Data Migration B

Data Conversion Data Migration Data Convergence Data Configuration A

SAP Oracle R12 In-House Developed All of the above D
Allocation of Budget Configuration Mock Conversion All of the above B
Allocation of Budget Configuration Mock Conversion All of the above A
Allocation of Budget Configuration Mock Conversion All of the above C
4 5 6 7B

System Design Data Conversion Planning Testing C

Planning Data Conversion Go-Live Migration Testing C
Data Conversion Planning Go-Live Migration Testing B
User access and segregatiOpen items Master data All of the above D
When reviewing general
During pre-implementatioIT Controls Both A& B None of the above C
Documentation Allocation of Budget Configuration Technical Migration A
Procurement & InventoryMaterial & Inventory Migration and Inventory None of the above A
QuickBooks Microsoft Dynamics Open Bravo All of the above A
Information processed by Information planned by enInformation projected by entity D

Data Conversion System Design Planning Go-Live B

Data Conversion System Design Planning Go-Live A

Integrity Data Conversion Staging Mock Conversion C
Data Conversion Sysmen Design Planning Go-Live A
Planning Data Conversion Sysmen Design Mock Conversion D
System Design Testing Data Conversion Go-Live B

Technical Functional Migration Accounts C

SA 630 SA 330 SA 310 SA 610 D

3 2 5 4A

Standard Entries Non Standard Entries Top up Entries Top Down Entries A

Standard Entries Non Standard Entries Top up Entries Top Down Entries B

Standard Entries Non Standard Entries Top up Entries Top Down Entries B

Standard Entries Non Standard Entries Top up Entries Top Down Entries C

Material Journal VouchersMissing Journal Vouchers Match Journal Vouchers Manual Journal Vouchers D

17 18 19 20 A
Roll Down Roll forward Roll Back Roll up B

ACL ADL ABL AGL A

ACL Ms Access CAAT All of the above D
Unusual Intercompany Seldom Non General C
Non Stimulated Journal EnNon Standard Journal EntrNon Sensitive Journal EntrNon Segregated Journal EnB
Sub ledgers General Ledger Excel sheets None of the above B
Standard Journals Top up journals Non Standard journals None of the above C
Automated or Manual SA/SOD among IT and Timing of passing the
entries Business teams entries All of the above D
Personal gain such as Debts requirements for
Sales Targets Bonus, incentives etc. banks etc. All of the above D
Ask close ended Ask open ended
questions No discussions required questions None of the above C
Risk of Material Risk of management Risk of lack of sensitive Risk of lack of
misstatement override of controls access segregation of duties. A

NSJE NSVE NSUE NSWE A

Non-Printed Printed All of the above None of the above B

Roll Down Roll forward Roll Back Roll up B

Purchase Targets Marketing Targets Sales Targets Operational Target C

Non-Monetary
Non-Debt Requirements Monetary Requirements Requirements Debt Requirements D

Developer Scripts Software Scripts Testing Scripts Hardware Scripts B

Automated command lanAutomated control langu Automated corrected lan Automated computer lan A
[Link]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
QUESTION
To perform un-matched Query, minimum required tables/fields are
Which of the follwing wild card character is to be represent more than 1 characters
Which of the following symbol is used to write a sub query
The Sub query must always be written as a SQL Statement
The where clause can be used in both aggregate and non-aggregate query
Having clause is used in the aggregate query
If the sub query is returning more than 1 row, which operator should be sued
Which of the following is an aggregate function
How many different joins available In Access Databse
In MS-Access, forms help to display, add, modify and delete data
In Access form, un-bound coltrols are linked with any field of Table/Query
In MS-Access, data can be edited in Reports
In MS-Access, Report Header is used to print information in
In MS-Access, Page Header is used to print information in
A _______________ is a query nested inside another query
___________________ will return the records from the first table which do not have matching values in second table
Sub queries can be used within ______________________
Sub queries in select statement can be the part of Where clause or Having clause in Group By query
The queries that can be used for obtaining the aggregated results instead of individual records are known as ______
A _______________ can be considered as a modified form of Crosstab queries
Pivot Chart helps visualize a ____________________
Joins created in a _______ are temporary
The __________________ query returns all of the rows from left table, and also those rows from the right table that s
Access query result is not restricted to the table fields but can display many other computed columns known as ___
Unbound controls are also known as ____________________
Computed results may be bounded to some field in the table or may be unbounded
A _______________ is a compact method of presenting a list of choices and allows user to enter a value that is not in t
________ controls are usually graphical objects that do not operate as standalone solutions, and they run only in th
___________ controls are useful for presenting grouped information that can be assembled by category
___________ can be created in forms to display a summary of data
______________ represents the data in a graphical form
The calculated values in reports are added using a _____________ and specifying an expression
The calculated values in queries are displayed as _______ in reports which use them
______________ is a report that is inserted into another report called the Main report
An ___________ is not based on a table or query, but can serve as a container for one or more sub-reports
_________ are a way of communicating database information
The best way to display the summary report is to create _____ to represent the data
The multiple columns for the report can be set using the ___________ property
The report event _______________ can be used to cancel the printing of report when no data is returned
Expressions can be used with ____________________
An ___________ is a value on which a calculation is performed
Operands can be _____________
Literals are also referred as ______________
Identifiers are ________________
[XYZ] denotes __________ in LIKE Operator
The BETWEEN operator cannot be used with ______________ datatype
Logical Operators are also known as ___________________
______________ are used to override the default order of precedence
A text box in which expressions are written
Among +, <>, MOD, AND operator which operator has the highest priority
A _________ allows you to automate tasks and add functionality to your forms, reports, and controls
In Access, ___________ can be considered as a simplified version of VBA programming
MS Access 2010 provides a _________ that contained large list of actions to be chosen, enabling a wide range of c
Macros can automate responses to many types of __________ without using a programming language
The Where condition is applicable as an argument for the macro actions __________ and ___________
____________ provide a good flexibility to place complex validation
A ______________ is a Microsoft Office Access 2010 form that facilitates navigation in Access and access to different
_______________ forms are an invaluable way to keep users focused on using the database as intended
Switchboard Manager only allows a maximum of ____________ command buttons on a switchboard
Open Form in Edit Mode allows any record to be _______________
Displaying the ______________ at startup helps to implement a level of security by hiding the key elements of the in
When same table is being used for the main query and sub-query, it is mandatory to provide __________ to the table
The _______ option creates a query that reports which records in a table are duplicated by matching one or more field
To calculate the count of orders placed for each product and arrange them in descending order of the counts, which
A criterion in Total queries can be created against ___________ fields
For the Non-Aggregate Total field, the criteria can only be specified using the ______ clause
For Group By and Aggregate Total, criteria can be mentioned using Criteria tab of Query Design window
This is a special type of query that can be created to describe one numerical quantity in terms of two other fields
This option allows the inclusion of the grand total of values in the row as a column in the query result
A _______________ is a view in Access Queries that allows summarising and examining data in a datasheet form
OPTION A OPTION B OPTION C OPTION D ANSWER
one two three four B
+ - & * D
[] () {} # B
0 1 B
1 0 A
0 1 B
IN ANY Any one of the above None of the above C
Sum() AVG() Count() All of the Above D
1 3 2 4 B
1 0 A
1 0 B
0 1 A
Page Header Report Header All of the Above Non of the above B
Page Header Report Header All of the Above Non of the above A
select query parameter query sub-query group by query C
Find matched query Find unmatched queryFind unique query Find duplicate query B
select query action query other sub queries All of the above D
1 0 A
Find unmatched querieFind duplicate queries Group By queries Parameter queries C
Datasheet form Pivot Table Pivot Chart Multiple items B
Pivot Table Query Form All of the above D
Table Query Either A or B Both A and B B
Left Outer Join Right Outer Join Inner Join Cross Join A
Bounded Fields Unbounded Fields Calculated Fields Expression Fields C
Variables Memory Variables Either A or B None of the above C
1 0 A
Option Button Check Box Tab Control Combo box D
Add-in Plug-in Com Add-in Active X D
List Box Tab Calendar Combo Box B
Pivot Table Form with Sub form Linked form Split form A
Pivot Table Pivot Chart Multiple Items Modal Dialog B
Label box Text Box List Box Combo box B
Data Variables Fields Values C
Unbound Report Bound Report Child Report Sub-Report D
Bound main report Unbound main report Main report None of the above B
Tables Queries Forms Reports D
Pivot Table Queries Charts Sub-Report C
Report Page Setup Report Wizard Report Report Print A
On Print Cancel Print Cancel Event On No Data D
Tables & Queries Forms & Reports Macros All the above D
Operator Operand Expression Paranthesis B
literals identifiers functions All of the above D
Identifiers Operators Constants Operands C
Variables Operators Constants Operands A
0 or any number of chaa single character a set of characters a single digit C
Numeric Text Date Either A or B or C B
Comparison OperatorsArithmetic Operators Miscellaneous OperatoBoolean Operators D
Operator Precedence Orders Parentheses None of the above C
Code Builder Macro Builder Expression Box Expression Elements C
+ MOD AND <> B
Function Expression Macro Module C
Expressions Macros Modules Switchboard B
Task Pane Navigation Pane Action Catalog Pane Action Pane C
events queries controls Either A or B or C A
OpenTable, OpenQuerOpenTable, OpenFormOpenQuery, OpenRepoOpenForm, OpenRepor D
Query Advanced Filter Macros Switchboard C
Navigation Pane Switchboard Tabbed Windows None of the above B
Switchboard Split Columnar Pivot Table A
6 7 8 9 C
added edited Either A or B Both A and B D
Switchboard Login Form Password None of the above A
prefix aliases suffix None of the above B
Unmatched Queries Duplicate Queries Crosstab Queries Group by queries B
Sub Query Crosstab Query Total Query Pivot Table Query C
Group By Aggregate Total Non-Aggregate Total All the above D
where group by having order by A
1 0 A
Sub Query Totals Query Crosstab Query Unmatched Query C
Yes, include column s Yes, include row sums Yes, include Grand TotaYes, include column gr B
Crosstab Query Totals Query Pivot Chart Pivot Table D
[Link]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30

31
32

33
34
35
36

37
38
39
40
41

42
43

44
45

46

47
48

49
50
51

52

53

54

55

56
57

58

59

60
61
62
63

64
65
66
67
68

69
70
71
72
73
74

75

76
77

78
79
80
81
82
83

84
85
86

87

88
89

90
 Question
XML stands for_________
XML is a ___________ Recommendation
XML is a language that’s very similar to ____________
XML Tag names are not case sensitive.
DTD stands for ___________
XML Tools would be available in
XML data file extension is
XML group available in____________Tab.
XML tags are predefined
Schema files extension is __________________.
VBA stands for_______________
Macro written in___________
Macro enabled workbook file extension is ___________ .
ANOVA stands for___________
_______function doesn’t require an argument.
SLN function is used _________________
SYD function is used ______________________.
DB function is used ______________________.
DDB is used to _______________
VDB function is used ______________________.
PV Ratio stands for _______________________
BEP stands for __________________________
Excel provides a readymade template for preparation of personal monthly budget
Discounting Factor formula is ___________________
In excel-Protect sheet option, Password is not optional.
In which tab, Data Validation is available?
Which of the following function categorie is not available in excel
____________ is the area under the normal curve that is outside of the region of certinty
Normally bank transactions are also considered in cash budget.
Budget stands for _______________________
________________ is considered as non cash expenditure and occupies a prominent place in Profit & Loss
Account.
what function is used for Sum of Years’ Digits?

____________ method of depreciation is one of the accelerated depreciation techniques which are based on
the assumption that assets are generally more productive when they are new and their productivity
decreases as they become old.
_______method uses a fixed rate to calculate depreciation
VDB stands for ______________
The VDB function uses the______ method by default.
__________ stands for change in the total cost that arises when the quantity produced has an increment by
unit.
Excel can also be used for taking decision on ___________
____________ is prepared for planning for future as far as movement of cash is concerned.
___________ is an estimate of pupulation Standard Deviation from data taken from a samples
____________ is the process of determining the present value of a payment or a stream of payments that is
to be received in the future.
____________ is one of the core principals of finance and is the primary factor used in pricing a stream of
cash flows, such as those found in a traditional bond or annuity.
Which function is used to calculate the principal portion in every installment
________ is a process used in statistical analysis in which a predetermined number of observations will be
taken from a larger population.
In this Method, Individuals are selected at regular intervals from a list of the whole population.
In this case each individual is chosen entirely by chance and each member of the population has an equal
chance, or probability, of being selected.
_____________________ is the area under the normal curve that corresponds to the required level of
confidence.
This method is commonly used in social sciences when investigating hard to reach groups.
It is a process in which a business determines whether projects such as building a new plant or investing in a
long-term venture are worth pursuing.
Popular methods of capital budgeting include payback period and _________________.
_________ is the value of all future cash inflows less future cash outflows as on today.
___________is the process of defining and analyzing the dangers to individuals, businesses and government
agencies posed by potential natural and human-caused adverse events.

__________ which is used more often, does not involve numerical probabilities or predictions of loss.
________ are generally used to present information in a simple and better way and also be used to analyse
the risk in a better way.
It is a technique used to determine how different values of an independent variable will impact a particular
dependent variable under a given set of assumptions.
_______ involves computing different reinvestment rates for expected returns that are reinvested during the
investment horizon.
A typical value that represents all the data points is called as ___________
__________ is a computerized mathematical technique that allows people to account for risk in quantitative
analysis and decision making.

________ is the process of meeting the financial goals through the proper management of finances.
___________ can be defined as the process of setting the procedures in the organization for achieving the
predefined goals.
Add_in is default Tab in Excel
By default all the cells in any excel sheet are locked.
NPER stands for______________________________
A __________ is a series of commands and functions that are stored in a Microsoft Visual Basic module and
can be run whenever the user need to perform the task
Consolidate is a What-If Analysis Tool.
Which function that is used to calculate the payment for specific loan terms ____________
_________ are not allowed in a macro name
The wizard that is used to create and edit charts _______________
Which one of the following will be the tool that provides a way to view and compare the results of all the
different variations together on the worksheet ?
The ______ generates a summarised report in tabular form in an interactive manner
The _________ wizard separates contents in a cell into different cells
A cell reference that does not change during a copy operation is known as ________ .
Circle Invalid Data option is available in ____________
The wizard that is used to import text files is_________________
A ___________ is a summary of the financial position of a business at a specific point in time, showing all
assets, liabilities, and equity.
This ratio shows ability of company to pay back long term loans along with interest or other charges from
generation of profit from its operations
Which ratio indicate efficiency with which company used its capital ( Equity as well as debt)

It is the simplest method of comparing different stocks at a point of time to make investment decisions
________helps to break down the Return on Equity
_______ is a common method for financing property, facilities, and equipment.
xml schema file extention is _______
In hypothesis test, when we can reject the H0(Null Hypothesis)
In Hypothesis test, when we can reject the H1 (alternate hypothesis)

A product is purchased for Rs 400000, the salvage value of the product is 50000 after 10 years. Now I want to
findout the depreciation value of first 4 years. In the given following which would be the currect function.
In VDB function what is the "factor" if it is omitted?
When VDB function calculate the depreciation by using Stright line method?

A machine was purchased for Rs.1000000 in EMI at 8% interest rate. Planned to repay the loan in 5 Years. In
total cost Rs.100000 paid at the time of purchase . What is the correct function to calculate the monthly
installment amount.

A businessman planned to get a loan Rs.1800000. If he get a loan at 8% interest for 6 years, Monthly
Installment will be Rs.31599.83. he calculate the same for various interest rates and loan repayment periods.
Which Excel option will you suggest to him to make it easy.
In Data table, at a time how many arguments maximum can be used for analysis?

In a business, Intial cost of investment one year from today is Rs.10000, return from 1st yeare is 3000, from
2nd year Rs.4200 and from third year Rs.6800. Annual discount rate is 10%. Then to find Net Present Value of
this investment what would be the correct function in the given following?
 Option A Option B Option C Option D Ans
Expansion Markup LanguaExpansion Makeup Langu EXtensible Markup Langu EXtensible Makeup LanguC
W3C W1C W2C W4C A
C HTML C++ JAVA B
1 0 C
Direct to Direct Document Type DefinitionData Type Definition Data to Data B
Add-Ins Developer Data Review A
(.xsd) (.xml) (.mlx) (.xlm) B
Review Add-Ins Developer Data C
1 0 B
(.xml) (.xsd) (.xlm) (.mlx) B
Visual Basic for ApplicatioVisual Basic for Applets Visual Basic for Apple Visual Basic for Auto MobiA
Java Visual Basic V++ C++ B
.xlsx .xlsm .xlsv .xlsw B
Analysis of Value Analysis of Varity Analog of Variance Analysis of Variance D
DATE() TODAY() MONTH() YEAR() B
For calculation of depreci For calculation of depreci For calculation of depreci For calculation of deprec B
For calculation of depreci For calculation of depreci For calculation of depreci For calculation of deprec A
For calculation of depreci For calculation of depreci For calculation of deprec For calculation of deprec C
calculate depreciation as calculate depreciation as calculate depreciation as calculate depreciation as D
calculate depreciation as For calculation of depreci For calculation of deprec For calculation of deprec A
Point Volume Ratio Point Varaiance Ratio Profit Volume Ratio Profit Variance Ratio C
Balance sheet Even Point Break Even Point Balance sheet Equal PointBreak Equal Point B
1 0 A
= n / (1+a) - r = 1 + (1/r) * n = 1 / (1+a) ^ 2 = 1 / (1+r) ^ n D
1 0 B
Formulas Insert Data Developer C
Statistical Engineering Math & Trig Trignometrical D
Region of uncertainty Region of curve Region of certainty None of the Above A
1 0 A
planning for Expenditure. planning for future. planning for Event. planning for Meeting. B

Cash Flow Depreciation Fund flow Expenditure B

SOYD Digits of the Year SYD None C

SLN DB VDB Sum of the years' digits D

declining balance VDB SYD SLN A
Virtual Declining Balance Variable Discounting Bala variable declining balanceNone C
Double Declining Balance Variable Decling Balance Straight Line Method Costing Method A

marginal cost Fixed Cost Variable cost Contribution A

Fixed Cost Marginal cost Both A& B None B
Capital Budgeting Cash budget Both A& B Actual Budget B
Standard Deviation Standard Error Standard population devianone of the above B
Marginal costing Capital Budgeting Discounting None C

Marginal costing Discounting PMT None B

IPMT PPMT PMT None B

Snowball sampling Sampling Systematic sampling Simple random sampling B

Clustered sampling Sampling Systematic sampling Simple random sampling C

Snowball sampling Convenience sampling Systematic sampling Simple random sampling D

Region of uncertainty Region of curve Region of confidence None of the above D

Quota Sampling Sampling Snowball sampling Simple random sampling C

Business Investment Capital Budgeting IRR NPV B

discounted cash flow internal rate of return net present value All the above D
Net present value Working capital IRR PMT A

Sensitivity analysis Risk analysis Qualitative risk analysis Scenario analysis B

Sensitivity analysis Risk analysis Qualitative risk analysis Scenario analysis C

Graphs Sparklines Both A& B Charts D

Decision Tree analysis Sensitivity analysis Both A& B Neither A &B B

Scenario analysis Sensitivity analysis Decision Tree Analysis None A

Median Arithmatic Mean all the above None B

Finanical Planning Monte Carlo simulation Corporate Planning Personal Finance planningB

Corporate planning Monte Carlo simulation Financial planning Personal Finance planningC

Monte Carlo simulation Corporate planning Decision Tree analysis Sensitivity analysis B
1 0 B
1 0 A
Total Principal Value Per value Total Interest Value Total Number of Periods D

Pivot Table Solver Scenario Macro D

1 0 B
sumif pmt countif none of the above B
spaces wild card characters symbols none of the above A
pivot table wizard chart wizard convert text to columns wtip wizard B

Goal seek Pivot table Solver Data table. D

Data table Pivot table Scenario Manager Solver B
text import wizard convert text to columns wtip wizard function wizard B
absolute relative mixed constant A
Consolidate What-if Analysis Calculate Sheet Data Validation D
text import wizard convert text to columns wtip wizard function wizard A

Balance Sheet Profit & Loss Income & Expenditure None A

Debt Assets Ratio Interest Coverage Ratio Total Fund Ration None B
Return on Investment Interest Coverage Ratio Total Fund Ration Net Profit Margin Ratio A

Earnings Per share Fixed Asset Over ratio Price Earnings Multiple Gross Profit Ratio C
Du Point Analysis Return on Investment Profitability Ration None A
Mortagage Leasing Rent All the above B
.xml .xmd .xsd None of the Above C
p-value> a p-value>=a p-value< a p-value<= a D
Test statistic >= critical va Test statistic <=critical val Test statistic < critical valup-value<= a C

VDB(400000,50000,10,1,4VDB(400000,50000,1,4) VDB(50000,400000,10,4) VDB(50000,400000,10,1,4A

4 1 3 2D
when the stright line depr"no_switch" argument is 'Both A and B either A or B C

PMT(8%,5,-1000000,1000PMT(8%,60,1000000,1000PMT(8%/12,60,1000000,-PMT(8%,60,-1000000,100C

Goal seek scenario manager Data Table None of the Above C

3 1 4 2D

NPV(10%,10000,3000,420NPV(10,-10000,-3000,-420NPV(10%,-10000,6800,42NPV(10%,-10000,3000,42D
QNO
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51

52
53
54
55
56
57
58
59
60
QUESTION
______ file cannot be easily converted into Excel
______ function is used to calculate the present values of all future cashflows.
_____ is the rate of discounting at which NPV=0
If Guess parameter is not specified by the user in IRR,Excel assumes it to be ___
In case if the cash flows occur unevenly,then we may use ____ and ____ in excel
_____ Function is used for calculating depreciation as per Written Down Value Method
_______ Function can be used while verifying depreciation expense claimed by the auditee
_____ Function is used for calculationg maturity dates
In EOMONTH() , if the second argument(months) is defined as 2 it will yield month end date ______
Will the EOMONTH() will take the leap year factor into account?
EDATE() returns the date with the _____ which is specified number of months before and after the start date.
EDATE() can be used to derive schedule of dates at _____intervals
Which of these is/are mandatory arguments in NETWORKDAYS()?
In NETWORKDAYS(), holidays argument will contain the holidays list______
Which of these function can be used,If we had to calculate the working days where the weekends are treated as Friday and Sa
The output of WORKDAY() will be a ______
In WORKDAY(),if we want to go backwards and derive a date in the past,then we must specify days as_____
If you wish to obtain the days remaining after casting out completed weeks,then which of these function can be used?
If you wish to obtain the completed weeks,then which of these function can be used?
Which of these operator can be used for joining two or more text strings together?
Can we perform a non case-sensitive comparison?
_____searches for a value in first column of data/table array
In VLOOKUP(),the search of the lookup value is performed in the ____ most colum of the table array
Which of these is incorrect with respect to VLOOKUP()?
In VLOOKUP(),if the lookup_value being searched in a slab/range of numbers then_____should be used
While using Approximate match type in VLOOKUP(),the table should be sorted in ______ on the basis of the leftmost column.
Which of these is not an argument in HLOOKUP()?
______function returns the value or reference at the intersection of a specified row and column,from an array.
Which of the following is an optional argument in MATCH()?
Lookup array means you can select ______
If we need to perform right to left lookup in a table,then _____ can be used
Which of the following is not an advantage of Index match combination?
_____ returns the reference specified by a text
IFERROR() is a brilliant function introduced in Excel _____
In IFERROR(),value if error argument will be executed if value argument generates _____
Countblank function is the reverse of _____function
Countblank could be used in detectinig cells which have inadverently _________
_____ function returns the kth largest number from a list of numbers.
Which of these helps us to understand the interelationship between the cells
If the cell is deleted without bothering about tracing its dependents,then the resultant cell will carry _______ error
_____ is a dedicated tool for tracking down the errors
Error checking feature will not identify errors in the ____behind formula construction
If we want a quick evaluation of only one of the parts of the formula,we can make use of ____
Which of these operators will be executed 2nd in Excel?
By using Conditional Formatiing,you can hghlight cells containing _____values
Remove Duplicates is introduced in Excel___
In Excel,Using Number Filters,We cannot extract______ values
In Date Filter, all dates in the period option helps to obtain records for different____
For using Pivot tables,we need to have a dataset in ______ format
In Excel,Which of the following is not a field in Pivot Table?
Which of the following cannot be computed in value fields of pivot table?
Say whether TRUE or FALSE
In Pivot table, we cannot eliminate blank cell from data section
Which of the following is not a limitation of Pivot Table?
If we want a list of the missing invoice numbers,we can make use of _______
Benford's law was propounded by _____
Benford's Law is also known as law of _____digit
As per Benford's law,Conventional probability says that the probability of a particular digit being the 1st digit of a number is _
Benford observed that the probability of 1st digit being 9 is the ____ among all digits
Stratification involves breaking _____ data into _____ groups called as strata
Which of the following is not a result of descriptive statistics?
OPTION A OPTION B OPTION C OPTION D ANSWER
XML CSV PDF TEXT C
FV PV NPV IRR C
FV PV NPV IRR D
9% 14% 10% 13% C
PV & IRR XNPV & XIRR NPV & IRR None of the aboveB
SLN DB All the Above None of the aboveB
DB SLN All the Above None of the aboveA
Date Month NetworkDays None of the aboveD
before 2 months after 2 months #N/A None of the aboveB
YES NO A
Next day previous day same day None of the aboveC
unequal equal Either A or B Neither A or B B
start date end date Either A or B Both A & B D
excluding Saturda including Saturda None of the above A
NETWORKDAYS() [Link]() [Link]() None of the aboveD
Number Date Number or Date None of the aboveB
Zero Positive Negative None of the aboveC
QUOTIENT() MOD() Either A or B None of the aboveB
QUOTIENT() MOD() Either A or B None of the aboveA
comma ampersand space hash B
YES NO A
Hlookup Vlookup Match Index B
Left Right Either A or B Neither A or B A
Lookup value is thThe search is alwaThe column index All the four argu D
EXACT MATCH APPROXIMATE MAEither A or B Neither A or B B
ascending order descending order Either A or B Neither A or B A
lookup_array col_index_numberow_index_numbeBoth A & B D
Hlookup Vlookup Match Index D
Lookup value lookup array match type None of the aboveC
Only one row Only one column one row or one c multiple rows or C
INDEX() MATCH() Both A or B Either A or B C
It performs left to The processing re It can also be use It avoids data re A
INDEX() MATCH() INDIRECT() All the above C
2010 2007 2013 2003 B
#REF! #VALUE? #N/A #DIV/0! B
COUNTA() COUNTIFS() COUNTIF() None of the aboveA
remained blank where data entry Both A & B None of the aboveC
MAX LARGE Either A or B None of the aboveB
Trace Precedents Trace DependentsEither A or B Both A & B D
#NAME? #N/A #REF! None of the aboveC
Go to special Trace DependentsTrace Precedents Error Checking D
syntax logic Either A or B Both A & B B
Evaluate formula F9 Either A or B Both A & B B
Brackets Addition Exponents Division C
duplicate unique Either A or B Both A & B D
2010 2007 2003 2013 B
Top 10 Bottom 10 Above Average Below Average B
months quarters years All the above D
rectagular flat Either A or B Neither A or B C
Report Filter Column Labels Row Labels Filter field D
large max min sum A

1 0 B
We cannot insert If the number of rPivot Tables UpdaAll the above C
VLOOKUP() MATCH() INDEX() None of the aboveA
[Link] Nigrini Frank Benford Mark Benford None of the aboveB
second first third last B
0.2222 0.3333 0 None of the aboveD
highest least most probable None of the aboveB
heterogeneous,h homogeneous,hethumongous,homoNone of the aboveA
MEAN MEDIAN MOD LARGE C
[Link] Questions
1 An _____________ is a group of people with a common goal, having certain resources at its disp
2 ________________ include money, manpower, materials, machines, technologies etc.
3 A _______________ is a collection of activities that make one or more kinds of input and creates a
4 Information systems can be designed so that accurate and timely data are shared between funct
5 The approach to ERP is to first develop a ____________________ comprising the business processes
6 The business model is represented in the graphical form using ______________ and _________
7 OLAP stands for _________________
8 ________________ is a tool that refers to skills, processes, technologies, applications and practice
9 Business Intelligence Systems are data-driven ___________________
10 ___________________ technology is the process of creating and utilizing the company's historica
11 ______________ can be defined as subject-oriented, integrated, time-variant, non-volatile collect
12 ________________ databases contain detailed data that is needed to satisfy processing requireme
13 Data in the Data Warehouse is ______________, not ____________
14 ODS stands for _______________________________
15 ____________ data contains an historical perspective that is not generally used by the ________
16 Which of the following is/are the data warehousing activity?
17 The definition of data elements in the data warehouse and in the data sources, and the transformat
18 Data warehouses are not the optimal environment for ____________ data
19 Maintenance Costs are high for Data Warehousing
20 Data Warehousing can be used for
21 _________________ is the process of extracting patterns from data
22 ___________________ is an approach to quickly answer multi-dimensional analytical queries
23 The Output of an OLAP query is typically displayed in a ___________ format
24 ___________________ is the succession of strategies used by management as a product goes throug
25 A _____________ is a network of facilities and distribution options that performs the functions of
26 _______ integrates supply and demand mangement within and across companies
27 __________ includes transportation from Suppliers and receiving inventory
28 Which of the following is not the service area of SCM?
29 ______________ CRM provides support to "front office" business processes
30 _____________ CRM covers aspects of a company's dealings with customers that are handled by v
31 RSS stands for _____________________
32 ROI stands for _____________________
33 ______________ companies is planning to support tens of millions of customers with just hundre
34 Which of the following is the decisive feature of the framework?
35 Which of the following is the limitation of Open Source ERP?
36 Which of the following is not an Open ERP software?
37 _____ is the process of integrating all the business functions and processes in an organization to
38 ________ must consider the fundamental issues of system integration by analyzing the organizatio
39 ERP ________________ requires organizations to reengineer their key business processes reenginee
40 The more the number of __________, the longer the implementation time
41 In which step of the ERP implementation, educating and recruiting end users will be involved
42 The system ____________ process will address issues such as software configuration, hardware ac
43 A __________________ review is recommended to ensure that all business objectives established
44 In _________________ stages, auditors have access to rudimentary ERP tools and capabilities for
45 Customization of ERP systems is one of the major challenges in auditing ERP security
46 __________ is the World's one of the fastest and most powerful concurrent multi-lingual busine
47 Immediate posting and updation of books of accounts as soon as the transactions are entered. Thi
48 [Link] 9 provides graphical analysis of data which helps the user to perform deeper analysis
49 The user can ________ the company data into multiple companies as per financial periods require
50 E-Filing of Returns refers to the process of electronically filing your tax returns through the ___
51 Which of the following is true?
52 [Link] 9 does not allows you to export the ETDS forms in NSDL compliant formats as well as f
53 Which of the following ETDS forms are available in [Link] 9?
54 The exported eTDS file from [Link] 9 can be validated through NSDL's freely downloadable
55 The ETCS forms available in [Link] 9 are _________ and ____________
56 [Link] 9 allows accounting with the regular names without any account codes
57 A multi-user version of [Link] 9 can be installed on a network, having any number of computer
58 With ______________ technology the characters are reduced in breadth and user is allowed to in
59 The [Link] 9 __________________ provides the user with administrator rights and the capability
60 [Link] 9 offers a data encryption option called _______________
61 ODBC stands for ___________________________
62 ___________________ is the process of exchanging [Link] 9 data between two or more locati
63 Which of the following is the not the previous version of Tally?
64 Can data of new version be migrated to old version?
65 The Tally website offers _______________, by which a user can communicate with a Tally represe
66 __________________ is an enabling framework which establishes a connection through which the re
67 [Link] use _______________ for centralised Account Management
68 The data is transferred between the remote location and the server using a secured mechanism
69 _____________ works as an interface between the user and [Link] 9 installed at different sites,
70 A chartered accountant as an __________________ is exposed to various operational risk factors viz
71 The ____________ edition provides the Chartered Accountants with Tax Audit and Statutory Compl
72 Generate Annexure for Tax Audit under Sec _____ using Auditors' Edition of [Link] 9, a Charte
73 Which of the following is one of the Technological Features in [Link] 9?
74 Which of the following is one of the salient features of [Link] 9?
75 To utilize [Link] in [Link] 9, which of the following is the pre-requisite?
76 What is the short cut key for [Link] features?
77 Which of the following will be displayed in the List of Companies screen?
78 If we want the company to be connected automatically for remote access on load, the property ___
79 In order to enable [Link] in [Link] 9, the ___________ needs to be set to "Yes"
80 A message "Company connected successfully" is displayed in the ________________ panel
81 The remote users are broadly classified into _____ security levels
82 To create Remote Users, the security level should be _________________
83 [Link] ID has to be a valid _________ only
84 ______________ enables the user to centrally configure and administer Site / User belonging to a
85 Which of the following is the advantage of the Control Centre?
86 Which of the following is not the predefined security levels in [Link] 9?
87 The Account _________________ is authorised to surrender, confirm a site license or Reject the re
88 On starting [Link] 9 the Gateway of Tally screen appears displaying the Edition and Users a
89 ______________________ enables user to enter the essential information related to the Account/S
90 _______________ enables user to change the Account Administrator's ID
91 Set ___________________ to "Yes" to create a fresh set of configuration
92 Which one of the following is not an access right?
93 _________________ should be set to "No" for local users
 Option-A Option-B Option-C
Company Enterprise Organization
Costing Production Sales
Business Model Business Function Business Process
Integrated Information Syste Isolated Information SystemsNon-Integrated Information
Business Model Business Function Business Process
charts, pictures smart art, clip art flowcharts, flow diagrams
Online Analysis Processing Online Analytical Processing Online Analytical Programmi
Data Warehousing Data Modeling Business Modeling
Information Systems Integrated Information Syste Decision Support Systems
Data Warehousing Data Modeling Business Modeling
Data Models Data Warehouses Data Mines
Operational Non-Operational Subject-Oriented
Dynamic, Static Non-Volatile, Static Volatile, Static
Operational Data Storage Optional Data Storage Operational Data Store
Operational, Informational Operational, Static Informational, Static
Identifying and prioritizing s Defining the correct level of Establishing a data warehouse
Masterdata Detaileddata Metadata
Structured Unstructured Informational
1 0
Credit Card Churn Analysis Insurance Fraud Analysis Logistics Management
Data Analysis Data Warehousing Data Mining
Business Processing Manage Online Analytical Processing Product Life Cycle Managem
Matrix Columnar Stepped
Business Processing Manage Online Analytical Processing Product Life Cycle Managem
Online Analysis Processing Business Processing Supply Chain
BPM SCM PLM
Inbound Operations Outbound Operations Sourcing planning
Logistics Asset Management PLM
Operational Analytical Consumer Relationship
Operational Collaborative Consumer Relationship
Really simple syndication Really super syndication Rare simple syndication
Revenue on Investment Return on Investment Both A & B
B2B B2C C2B
Network as platform Architecture of participation Both A & B
Increased Complexities Legal Complexities Unsuitable for conventional a
Openbravo SQL-Ledger Open-Project
EDI ERP BPM
Manager Auditor Top Management Commitmen
Traps Security Audit Implementation
modules process package
Step 1 Step 2 Step 3
implementation upgradation installation
pre implementation under process review post implementation
post implementation pre implementation Both A & B
 1 0
Tally [Link] 9 Both A & B
Interactive Processing Immediate Processing Real Time Processing
1 0
Import Export Split
Intranet Internet Extranet
We can fill up the details on Select Alt+E from the requireEither A or B
1 0
Form 26, Annexure to 26 Form 27, Annexure to 27 Form 26Q, Annexure to 26Q
File Validation Program File Validation Utility File Valuation Program
Form 27E Form 27 Form 26
1 0
1 0
Tally Fix Tally Adjust Tally Fit
User-defined Security HTTP-XML based data intercUnlimited multi-user support
Tally Data Encryption Tally Data Encoding Tally Vault
Open Database Connection Open Database Connectivity Oracle Database Connection
Serialization Randomization Synchronization
Tally 4.5 Tally 6.4 Tally 7.2
Yes No
Tally Forum Tally FAQ Tally Support
Direct Web Browser Access Web Publishing [Link]
Data Centre Control Centre Cloud Centre
Encoding Decoding Encryption
Control Centre Data Centre Cloud Centre
Administrator Auditor Expert
Educational Mode Silver Gold
44A 44B 44AB
Concurrent multi-lingual capaReal time processing Data Reliability and Automat
Codeless user interface Graphical analysis of data Split Company Data
Configuring [Link] featurCreating Remote Users Authorizing Remote Users
F1 F2 F3
Company Name Account ID Serial Number
Allow to Connect Company Contact On Load Either A or B
Enable [Link] Contact On Load Security Controls
Calculator Version License
two three four
Owner Standard User Either A or B
Account ID User Name Email ID
Data Centre Control Centre Cloud Centre
Surrender, Confirm or Reject M a anage Jobs and RecruitmentCreate users with predefined s
Owner [Link] User [Link] Owner
Administrator Owner Auditor
Horizontal Bar Information Panel Vertical Bar
User Management Change Account Admin Profile Management
User Management Change Account Admin Profile Management
Enable ODBC Server can be overridden locally Want to set client/server conf
Alter Account Admin Manage Sites Manage Users
[Link] Authorisation [Link] Authentication [Link] Auditor Authorisat
 Option-D Ans
Concern B
Resources D
Business Operation C
Non-Isolated Information Sy A
Business Operation A
graphs, shapes C
None of the above B
Business Intelligence D
Non-Isolated Information Sy C
Business Intelligence A
Operational Data B
Informational A
Static, Dynamic D
Optional Data Store C
Informational, Operational D
All of the above D
Basedata C
Operational B
A
All of the above D
Data Modeling C
Supply Chain Management B
Outline A
Supply Chain Management C
Product Life Cycle C
CRM B
Production planning A
CRM D
Social A
Social B
Rare super syndication A
None of the above B
C2C B
None of the above C
All of the above D
ERP5ERP C
None of the above B
Either A or B or C A
None of the above C
units D
Step 4 B
migration C
None of the above C
Either A Or B A
 A
None of the above B
Business Processing C
A
Backup C
Any of the above B
Neither A Nor B C
B
All of the above D
File Valuation Utility B
All of the above A
A
A
Tally AutoFit C
Audit Feature D
Tally Data Conversion C
Oracle Database ConnectivityB
Asynchronization C
Tally 8.1 B
B
Tally Chat D
Email facility C
Administration Centre B
Decryption C
Administration Centre A
Entrepreneur D
Auditor D
Both A & B C
Accounting without Codes C
Scalability D
All of the above D
F4 D
All of the above D
None of the above B
Allow to Connect Company C
Configuration A
five A
None of the above B
None of the above C
Administration Centre B
All of the above D
[Link] Auditor C
User A
None of the above B
Licensing & Configuration C
Licensing & Configuration B
None of the above C
Manage Passwords D
[Link] Auditor AuthenticaB
[Link]
1

3
4
5
6

7
8

10

11
12

13
14

15

16

17

18

19
20
21

22
23

24

25

26

27

28

29

30

31

32
33

34

35
36

37

38
39
40
41

42
43

44

45
46
47

48

49
50

51

52
53
54

55

56

57

58

59
60

61

62
63

64
65

66

67
68

69

70

71

72

73

74

75

76

77

78
79

80

81

82

83
84
85

86

87

88

89
90

91
92
93
94
95

96

97
98

99
100
101
102

103

104

105
106

107
108
109
110
111

112

113
114

115

116

117

118
119

120
121
122

123

124

125

126
127

128

129

130
131
132
133
134

135

136
137

138
139

140

141

142

143

144

145
146
147

148
149

150

151

152

153

154

155
156

157

158

159

160

161
162
163
164
165
166
167

168
169
170
171
172
173
174
175
176

177
178
179

180
181
182
183

184

185
186
187

188

189

190

191
192
193
194
195

196
197
198
199

200
201
202
203
204
205

206
207

208

209
210
211
212
213

214

215

216
217

218

219
220
221

222

223

224

225

226
227
228

229

230

231

232
233
234
235

236
237
238
239
240
241

242
243
244
245
246

247

248

249

250
251

252

253
254
255
256
257
258

259
260

261

262
263

264
265

266

267

268
269
270

271

272

273
274

275
276

277

278
279

280

281
282

283

284

285

286

287
288

289

290

291
292
293

294

295
296
297

298

299

300
301
302
303
304

305

306

307

308

309

310
311
312
313

314

315
316

317

318

319
320

321
322
323
324
325
326
327
328
329
330
331

332
333
334

335

336
337

338

339
340
341
342
343
344

345

346

347
348

349
350

351
352

353
354
355
356
357

358
359
360

361
362
363
364
365
366
367
368
369
370
371
372

373

374
375
376
377

378
379

380
381

382
383

384

385

386

387
388

389

390
391

392

393
394

395

396

397

398
399
400

401
402

403
404

405

406
407

408
409

410

411
412

413

414

415

416
417

418

419

420
421
422

423

424

425
426

427

428
429
430

431

432

433
434

435
436
437

438

439

440

441

442
443
444
445

446

447
448

449

450

451

452

453

454

455

456
457
458

459
460
461
462
463
464

465

466
467

468

469

470

471

472

473

474
 QUESTION
Which of these is an ERP Systems?
______states that the objective of the auditor is to identify and assess the risks of material misstatement
whether due to fraud or error

As per SA315,understanding the entity and its control environment means _____
As per SA315,the auditor has to understand the information systems environment relevan to _____
In Governance Framework,The _______ is the owner of the application
In Governance Framework,The _______ is the owner of the data residing within the application
The communication lines are strictly drawn between the Chief Information Officer and Chief Financial Officer so
as to maintain the ____ of the data within the application
The risk in an automated environment are _____

The risk in an automated environment may be ______

In addtion to SA315,the auditor's in response to Clause (i) of Sub-Section 3 of Section _____ of the Companies
Act,2013,have to report whether the entity has adequate ______
______ deals with the auditor's respnsibility to design and implement responses in the form of audit procedures
in response to work done as part of SA 315.
The audit procedures are required for the _______

A/An ______system inherently means that all the modules within the system are seamlessly connected with
each other and the transactions flow through the relevant modules
In ERP,____Primary set of Books are there and _____ transactions reside here.

Which of these is not the possible reason of why substantive procedures may not be feasible in ERP?

ISAE means ______

PCI-DSS means _____

Which of the following are not the key aspects of SA 300?

A test of controls is an _____ to test the effectiveness of a control used by a client entity to prevent or detect
material missatements
Say whether TRUE or FALSE?
When auditors have access to systems,Auditors should always request access to the production or live
environment
The type of access that auditors request should be ______

Auditor should request for _____access for the duration of the audit
General IT controls are known as ____ controls

Which of the following is not a category of GITC?

______ controls are embedded into IT applications

______ controls are activities in a business process that are performed by individuals or employees without the
need to rely on a IT system
______ controls are basically manual controls that make use of some form of data or information or report
produced from IT system and application.

Which of the following is not a risk in IT?

Which of the following is not essential for the effective implementation and operation of General IT controls?

Which of the following are to be considered for determining the sample size

Find the odd one out in the IT Governance Review Checklist?

The objective of program changes is to ensure that modified systmes continue to meet _____________
objectives
_____ are changes required in the existing functionality of the ERP due to a business need.
______ are changes provided by the vendor of ERP to address known bugs,security or provide improvements to
functionality to existing ERP.

_____ are high risk because they bypass the application controls and impact the integrity of financial data
Which is the last step in change management process?

_______ are provided to the IT department where the systems analysts perform analysis and design

A priviliged user may be a _______

In a security log of ERP,if the system default value is OFF it indicates the table log are _____
Environment controls form part of the ______ of access security
When a company has two or more IT systems as an interface ,what is the risk involved?

The objecive of AAC's are to ensure______

_______ controls come along with the implemented ERP and also called as Input control

________ may not prevent or detect misstatements

As per ________,communicating deficiencies in internal contol to those charged with governance and
management makes it necessary for the auditor to communicate control deficiencies to the management.
______ controls are implemented by the company at the time of installing the ERP
_____ controls are also known as processing controls

Which of the following are some basic controls in inherent controls?

If the GITC's are found to be ineffective,then the auditor will have to test the auomated controls _______
Balance sheet date to support the opinion on internal financial controls
Do the auditor will have to mention if the deficiencies were present in the prior periods of audit?

One commonly preferred method for testing design effectiveness is

IPE is used by
The IPE can be in ___ forms
How many types of reports can be extracted from ERP systems

These are reports that are available at the time of implementation of the ERP systems by the entity

These reports are created by the entities with respect to their businesses, revenue streams, divisions etc.
________ are used to retrieve information or data from a database in a readable format using a SELECT
statement

These reports are inbuilt into the systems

ERP comes with a set of reports that can be used as is, if the company has implemented the ERP without too
many modifications
Cash flow statement is one of the examples of _________________ reports
In ___________ reports, the company has followed their own pattern or code for Chart of Accounts (CoA),
Vendors, Customers etc.

______________ can be used to extract payroll information such as leaves available per employee
Which of the following is not an element for determining the testing strategy for reports

Validation of Reports includes

The Auditor has to check the ____________ of the data before planning to understand the types of reports and
the procedure to validate them

The auditor may limit the test procedures to validate / test the reports when ________________

Which of the folowing indicative commands will be used by the company in SAP to generate reports?
In case of a standard report, the creator/modifier of the report would be the _____________

The evidence of the creator/modifier of the report can be found in _________________ logs
During 1st year of audit of the entity, after ensuring the creator/modifier value of the report, the auditor needs
to then understand and test the _____________ and ______________ of the report

During subsequent years of the audit, when GITCs and relevant Business process controls are tested & effective,
and there is no change in the creator/modifier value of the standard reports, what need to be done by the
auditor?

Why to test the reports by the auditors?

In quarterly review of aging analysis, when report logic is working correctly, what is the next step to be done?

These reports are created by the business/IT persons in the company for their use and reporting requirements
The procedure to test the completeness and accuracy of the reports have to be performed every year in
________________
While testing for users who have access to create/modify the custom report, the auditor will have to verify
whether the users are __________

If any change to the custom report has happened in the year of audit, then _____________

These reports are extracted on ad hoc basis or on as and when basis

These reports have a high probability of the data being manipulated after creation

The auditor cannot rely on just one sample to test the completeness and accuracy assertions of the report when

The criteria to be used to decide timing of report testing

When GITC's are effective, the auditor needs to follow which sampling procedure to test a report
When there are deficiencies in the reports/IPE that have been tested, the errors at a minimum may be of
_______
____________ is when a user has the ability to perform critical business activities in an ERP
The users who have the business activities that carry a higher risk and could have wider impact onoperations
are said to have _____________
__________ refers to the separation or distribution of job roles among employees in such a way that
incompatible or conflicting job roles are assigned to different persons
___________ are typically regular employees who carry out day-to-day business operations and transactions
using the ERP

________ users are internally used within the ERP to perform automated operations and transactions
These are a type of super users who have very extensive or unlimited access to carry out all or several activities
in an ERP environment
These are the users that come packaged along with the ERP software
_________ represent a title, position, designation or function, place or region within a company and do not
represent an individual or person
These are users who are given user id for a limited time period
These are users who do not belong to the company
Users access to ERP is based on _______ of respective users
The relationship between ERP Roles and Users is __________________
___________ are access control features in an ERP that enable grouping of several related access rights in to a
form
Roles offer an easy to understand, fast and reliable way to manage user access to an ERP. This feature is known
as ____________
A ________ represents a high-level grouping
A _________ is the more granular internal technical grouping of authorisations, permissions and access rights
winin the ERP based on the input derived from the Role
Segregation of duties can be implemented as _____________ control
Tool used in implementing and review of segregation of duties and sensitive access
Auditing standards require auditors to obtain the evidence for _________

User access controls are like ________ in an ERP environment

When an auditor found deficiencies in User Access Controls, the auditor __________________
The auditor should first gain and understand the ___________ before auditing segregation of duties and
sensitive access in an ERP
______ make it easy to manage user access to an ERP

Reliability of user access controls in an ERP depend on effectiveness of __________________

Business rules for implementing segregation of duties should be defined by the ________
Which of the following is an example of Generic Users?
Which of the following is an example of External Users?
Which of the following is an example of Temporary Users?

SAP the purchase and inventory processes are provided in the module known as____________.
____________Where the IT infrastructure including operating system,database,Network or hardware are
changed but not change in version or functioning of ERP.
The Key Phases in any ERP migration project will consist of planning,system design,________,Testing and Go
Live.

Which of the following is example of an ERP

Which of the following activity is part of the system design phase of a migration

__________ happens in Planning Phase.

________is part of Data conversion phase.

How many Phases are there in data migration strategy

__________ In this phase of migration the objectives of migration and the migration strategy are defined.
At which phase of the migration would rollback procedures be triggered,if necessary
Rollback procedure are defined in the ____________ phase.

Which of the following require specific considerations during a migration.

Where would auditors review migration process and controls.

___________ should be prepared and maintained for all phases of migration

In Oracle the purchase and inventory processes are provided in the __________ module
_________ can be used for implementation of a completely new accounting system.

Reports and system generated data IPE i.e._________________ could change.

___________phase of migration process prepares including the process flows,data flows and business process
re-engineering.
__________ phase of migration involves identification of source data,mapping between source and target
system
Intermediary data stores called ____ areas are used to hold convert and transfer data.
In __________ phase integrity checks are done to ensure completeness and accuracy of data.
_____________ are carried out iteratively to rectify errors and data inconsistencies.
In ______ phase scenarios and scripts are prepared for the new system.
A_______________ project provides an opportunity to review and carry forward only the relevant data and
discard obsolete data.
The auditor may consider using the work performed by internal auditors in accordance with guidance given in
__________
How many types of journal entries are there ?
_________transactions pertaining to sales, purchases, inventory, rent, audit fees, AMC
expenses, salaries etc. are subject to internal controls as defined by the company.
_________these entities record nonrecurring,unusual transactions or adjustment entries in the ERP’s.
__________These entries may not be subject to the same level of rigour of the internal controls or may not have
passed through any controls at all.
_____________are residing outside the books – for example in excel sheets etc. and may impact the financial
statements.
If the journal entries are passed using a specific journal type then a list of such entries can be extracted from the
system. For example, journal types could be MJV i.e._____________
ERP/application should have ________ many fields and the company must be entering data in these fields for
them to be extracted.
_________ the entries passed during the year to the balances in the Trial Balance. The auditor may use
ACL/IDEA Caseware/MS Access/Excel to perform __________ testing
Using tools such as ______, IDEA Caseware, MS Access, Excel etc., the auditor can test the data for
completeness
__________ can also help in finding out if there are duplicate journal numbers used.
______Accounts that are used very infrequently.

What is the expansion of NSJE__________

The unusual, non-recurring transactions may generally be directly entered in_________

Estimates, impairments are generally a type of__________

While understanding the IT/ERP systems used to record entries, the points to note are___________

Some of the fraud risk factors to note which may lead to unusual transactions are_____

A key factor to be kept in mind while making enquiries of personnel are_______

Which is the main risk due to Non Standard Journal entries:

__________are entries that may be passed as a result of fraud. Hence, this is the main risk. Another risk can also
be risk of management override of controls.
It is possible that a Non-standard journal entry may not have relevant ____________ supporting.
In industries/sectors, where volume of data is huge, ________________ testing may not be an appropriate way
of testing completeness of data.
______________ to be achieved may be a key fraud risk factor from an investor/ stock holder perspective
leading to Non-standard journal entries.

_____________ to be achieved may be a key fraud risk factor from a bank/financial institution perspective.

To bring in efficiencies in the process of extraction and analysis of JE data, the auditor may use ____________

What is the expansion of ACL__________

To perform un-matched Query, minimum required tables/fields are
Which of the follwing wild card character is to be represent more than 1 characters
Which of the following symbol is used to write a sub query
The Sub query must always be written as a SQL Statement
The where clause can be used in both aggregate and non-aggregate query
Having clause is used in the aggregate query

If the sub query is returning more than 1 row, which operator should be sued
Which of the following is an aggregate function
How many different joins available In Access Databse
In MS-Access, forms help to display, add, modify and delete data
In Access form, un-bound coltrols are linked with any field of Table/Query
In MS-Access, data can be edited in Reports
In MS-Access, Report Header is used to print information in
In MS-Access, Page Header is used to print information in
A _______________ is a query nested inside another query
___________________ will return the records from the first table which do not have matching values in second
table
Sub queries can be used within ______________________
Sub queries in select statement can be the part of Where clause or Having clause in Group By query
The queries that can be used for obtaining the aggregated results instead of individual records are known as
_______________
A _______________ can be considered as a modified form of Crosstab queries
Pivot Chart helps visualize a ____________________
Joins created in a _______ are temporary
The __________________ query returns all of the rows from left table, and also those rows from the right table
that share a common value on both sides of the join
Access query result is not restricted to the table fields but can display many other computed columns known as
_________________
Unbound controls are also known as ____________________
Computed results may be bounded to some field in the table or may be unbounded
A _______________ is a compact method of presenting a list of choices and allows user to enter a value that is
not in the list
________ controls are usually graphical objects that do not operate as standalone solutions, and they run only
in the Windows environment

___________ controls are useful for presenting grouped information that can be assembled by category

___________ can be created in forms to display a summary of data

______________ represents the data in a graphical form
The calculated values in reports are added using a _____________ and specifying an expression
The calculated values in queries are displayed as _______ in reports which use them
______________ is a report that is inserted into another report called the Main report

An ___________ is not based on a table or query, but can serve as a container for one or more sub-reports
_________ are a way of communicating database information
The best way to display the summary report is to create _____ to represent the data
The multiple columns for the report can be set using the ___________ property

The report event _______________ can be used to cancel the printing of report when no data is returned
Expressions can be used with ____________________
An ___________ is a value on which a calculation is performed
Operands can be _____________
Literals are also referred as ______________
Identifiers are ________________

[XYZ] denotes __________ in LIKE Operator

The BETWEEN operator cannot be used with ______________ datatype

Logical Operators are also known as ___________________

______________ are used to override the default order of precedence

A text box in which expressions are written
Among +, <>, MOD, AND operator which operator has the highest priority
A _________ allows you to automate tasks and add functionality to your forms, reports, and controls
In Access, ___________ can be considered as a simplified version of VBA programming
MS Access 2010 provides a _________ that contained large list of actions to be chosen, enabling a wide range of
commands that can be performed

Macros can automate responses to many types of __________ without using a programming language

The Where condition is applicable as an argument for the macro actions __________ and ___________
____________ provide a good flexibility to place complex validation
A ______________ is a Microsoft Office Access 2010 form that facilitates navigation in Access and access to
different parts of an application

_______________ forms are an invaluable way to keep users focused on using the database as intended
Switchboard Manager only allows a maximum of ____________ command buttons on a switchboard
Open Form in Edit Mode allows any record to be _______________
Displaying the ______________ at startup helps to implement a level of security by hiding the key elements of
the interface from the user
When same table is being used for the main query and sub-query, it is mandatory to provide __________ to the
tables
The _______ option creates a query that reports which records in a table are duplicated by matching one or
more fields in the table
To calculate the count of orders placed for each product and arrange them in descending order of the counts,
which query should be created?

A criterion in Total queries can be created against ___________ fields

For the Non-Aggregate Total field, the criteria can only be specified using the ______ clause
For Group By and Aggregate Total, criteria can be mentioned using Criteria tab of Query Design window
This is a special type of query that can be created to describe one numerical quantity in terms of two other
fields

This option allows the inclusion of the grand total of values in the row as a column in the query result
A _______________ is a view in Access Queries that allows summarising and examining data in a datasheet
form

XML stands for_________

XML is a ___________ Recommendation
XML is a language that’s very similar to ____________
XML Tag names are not case sensitive.

DTD stands for ___________

XML Tools would be available in
XML data file extension is
XML group available in____________Tab.
XML tags are predefined
Schema files extension is __________________.

VBA stands for_______________

Macro written in___________
Macro enabled workbook file extension is ___________ .
ANOVA stands for___________
_______function doesn’t require an argument.

SLN function is used _________________

SYD function is used ______________________.

DB function is used ______________________.

DDB is used to _______________

VDB function is used ______________________.

PV Ratio stands for _______________________

BEP stands for __________________________

Excel provides a readymade template for preparation of personal monthly budget
Discounting Factor formula is ___________________
In excel-Protect sheet option, Password is not optional.
In which tab, Data Validation is available?
Which of the following function categorie is not available in excel

____________ is the area under the normal curve that is outside of the region of certinty
Normally bank transactions are also considered in cash budget.

Budget stands for _______________________

________________ is considered as non cash expenditure and occupies a prominent place in Profit & Loss
Account.
what function is used for Sum of Years’ Digits?

____________ method of depreciation is one of the accelerated depreciation techniques which are based on
the assumption that assets are generally more productive when they are new and their productivity decreases
as they become old.
_______method uses a fixed rate to calculate depreciation

VDB stands for ______________

The VDB function uses the______ method by default.

__________ stands for change in the total cost that arises when the quantity produced has an increment by
unit.
Excel can also be used for taking decision on ___________
____________ is prepared for planning for future as far as movement of cash is concerned.

___________ is an estimate of pupulation Standard Deviation from data taken from a samples
____________ is the process of determining the present value of a payment or a stream of payments that is to
be received in the future.
____________ is one of the core principals of finance and is the primary factor used in pricing a stream of cash
flows, such as those found in a traditional bond or annuity.
Which function is used to calculate the principal portion in every installment
________ is a process used in statistical analysis in which a predetermined number of observations will be taken
from a larger population.
In this Method, Individuals are selected at regular intervals from a list of the whole population.
In this case each individual is chosen entirely by chance and each member of the population has an equal
chance, or probability, of being selected.
_____________________ is the area under the normal curve that corresponds to the required level of
confidence.
This method is commonly used in social sciences when investigating hard to reach groups.
It is a process in which a business determines whether projects such as building a new plant or investing in a
long-term venture are worth pursuing.

Popular methods of capital budgeting include payback period and _________________.

_________ is the value of all future cash inflows less future cash outflows as on today.
___________is the process of defining and analyzing the dangers to individuals, businesses and government
agencies posed by potential natural and human-caused adverse events.

__________ which is used more often, does not involve numerical probabilities or predictions of loss.
________ are generally used to present information in a simple and better way and also be used to analyse the
risk in a better way.
It is a technique used to determine how different values of an independent variable will impact a particular
dependent variable under a given set of assumptions.
_______ involves computing different reinvestment rates for expected returns that are reinvested during the
investment horizon.
A typical value that represents all the data points is called as ___________
__________ is a computerized mathematical technique that allows people to account for risk in quantitative
analysis and decision making.

________ is the process of meeting the financial goals through the proper management of finances.
___________ can be defined as the process of setting the procedures in the organization for achieving the
predefined goals.
Add_in is default Tab in Excel
By default all the cells in any excel sheet are locked.

NPER stands for______________________________

A __________ is a series of commands and functions that are stored in a Microsoft Visual Basic module and can
be run whenever the user need to perform the task
Consolidate is a What-If Analysis Tool.
Which function that is used to calculate the payment for specific loan terms ____________

_________ are not allowed in a macro name

The wizard that is used to create and edit charts _______________

Which one of the following will be the tool that provides a way to view and compare the results of all the
different variations together on the worksheet ?
The ______ generates a summarised report in tabular form in an interactive manner
The _________ wizard separates contents in a cell into different cells
A cell reference that does not change during a copy operation is known as ________ .
Circle Invalid Data option is available in ____________

The wizard that is used to import text files is_________________

A ___________ is a summary of the financial position of a business at a specific point in time, showing all
assets, liabilities, and equity.
This ratio shows ability of company to pay back long term loans along with interest or other charges from
generation of profit from its operations

Which ratio indicate efficiency with which company used its capital ( Equity as well as debt)

It is the simplest method of comparing different stocks at a point of time to make investment decisions

________helps to break down the Return on Equity

_______ is a common method for financing property, facilities, and equipment.
xml schema file extention is _______
In hypothesis test, when we can reject the H0(Null Hypothesis)

In Hypothesis test, when we can reject the H1 (alternate hypothesis)

A product is purchased for Rs 400000, the salvage value of the product is 50000 after 10 years. Now I want to
findout the depreciation value of first 4 years. In the given following which would be the currect function.
In VDB function what is the "factor" if it is omitted?

When VDB function calculate the depreciation by using Stright line method?

A machine was purchased for Rs.1000000 in EMI at 8% interest rate. Planned to repay the loan in 5 Years. In
total cost Rs.100000 paid at the time of purchase . What is the correct function to calculate the monthly
installment amount.

A businessman planned to get a loan Rs.1800000. If he get a loan at 8% interest for 6 years, Monthly Installment
will be Rs.31599.83. he calculate the same for various interest rates and loan repayment periods. Which Excel
option will you suggest to him to make it easy.
In Data table, at a time how many arguments maximum can be used for analysis?

In a business, Intial cost of investment one year from today is Rs.10000, return from 1st yeare is 3000, from 2nd
year Rs.4200 and from third year Rs.6800. Annual discount rate is 10%. Then to find Net Present Value of this
investment what would be the correct function in the given following?
______ file cannot be easily converted into Excel
______ function is used to calculate the present values of all future cashflows.
_____ is the rate of discounting at which NPV=0
If Guess parameter is not specified by the user in IRR,Excel assumes it to be ___
In case if the cash flows occur unevenly,then we may use ____ and ____ in excel
_____ Function is used for calculating depreciation as per Written Down Value Method
_______ Function can be used while verifying depreciation expense claimed by the auditee
_____ Function is used for calculationg maturity dates
In EOMONTH() , if the second argument(months) is defined as 2 it will yield month end date ______
Will the EOMONTH() will take the leap year factor into account?

EDATE() returns the date with the _____ which is specified number of months before and after the start date.

EDATE() can be used to derive schedule of dates at _____intervals

Which of these is/are mandatory arguments in NETWORKDAYS()?

In NETWORKDAYS(), holidays argument will contain the holidays list______

Which of these function can be used,If we had to calculate the working days where the weekends are treated as
Friday and Saturday?
The output of WORKDAY() will be a ______

In WORKDAY(),if we want to go backwards and derive a date in the past,then we must specify days as_____

If you wish to obtain the days remaining after casting out completed weeks,then which of these function can be
used?
If you wish to obtain the completed weeks,then which of these function can be used?
Which of these operator can be used for joining two or more text strings together?
Can we perform a non case-sensitive comparison?
_____searches for a value in first column of data/table array
In VLOOKUP(),the search of the lookup value is performed in the ____ most colum of the table array

Which of these is incorrect with respect to VLOOKUP()?

In VLOOKUP(),if the lookup_value being searched in a slab/range of numbers then_____should be used

While using Approximate match type in VLOOKUP(),the table should be sorted in ______ on the basis of the
leftmost column.
Which of these is not an argument in HLOOKUP()?

______function returns the value or reference at the intersection of a specified row and column,from an array.

Which of the following is an optional argument in MATCH()?

Lookup array means you can select ______

If we need to perform right to left lookup in a table,then _____ can be used

Which of the following is not an advantage of Index match combination?

_____ returns the reference specified by a text

IFERROR() is a brilliant function introduced in Excel _____
In IFERROR(),value if error argument will be executed if value argument generates _____
Countblank function is the reverse of _____function

Countblank could be used in detectinig cells which have inadverently _________

_____ function returns the kth largest number from a list of numbers.
Which of these helps us to understand the interelationship between the cells
If the cell is deleted without bothering about tracing its dependents,then the resultant cell will carry _______
error
_____ is a dedicated tool for tracking down the errors
Error checking feature will not identify errors in the ____behind formula construction
If we want a quick evaluation of only one of the parts of the formula,we can make use of ____
Which of these operators will be executed 2nd in Excel?
By using Conditional Formatiing,you can hghlight cells containing _____values
Remove Duplicates is introduced in Excel___
In Excel,Using Number Filters,We cannot extract______ values
In Date Filter, all dates in the period option helps to obtain records for different____
For using Pivot tables,we need to have a dataset in ______ format
In Excel,Which of the following is not a field in Pivot Table?
Which of the following cannot be computed in value fields of pivot table?
Say whether TRUE or FALSE
In Pivot table, we cannot eliminate blank cell from data section

Which of the following is not a limitation of Pivot Table?

If we want a list of the missing invoice numbers,we can make use of _______
Benford's law was propounded by _____
Benford's Law is also known as law of _____digit
As per Benford's law,Conventional probability says that the probability of a particular digit being the 1st digit of
a number is ____
Benford observed that the probability of 1st digit being 9 is the ____ among all digits

Stratification involves breaking _____ data into _____ groups called as strata

Which of the following is not a result of descriptive statistics?

An _____________ is a group of people with a common goal, having certain resources at its disposal to achieve
the common goal
________________ include money, manpower, materials, machines, technologies etc.
A _______________ is a collection of activities that make one or more kinds of input and creates an output that
is of value to the customer
Information systems can be designed so that accurate and timely data are shared between functional areas.
These systems are called _______________________________
The approach to ERP is to first develop a ____________________ comprising the business processes or
activities that are the essence of a business

The business model is represented in the graphical form using ______________ and ________________
OLAP stands for _________________

________________ is a tool that refers to skills, processes, technologies, applications and practices used to
facilitate better, accurate and quicker decision making

Business Intelligence Systems are data-driven ___________________

___________________ technology is the process of creating and utilizing the company's historical data
______________ can be defined as subject-oriented, integrated, time-variant, non-volatile collections of data
used to support analytical decision making
________________ databases contain detailed data that is needed to satisfy processing requirements but which
has no relevance to management or analysis
Data in the Data Warehouse is ______________, not ____________

ODS stands for _______________________________

____________ data contains an historical perspective that is not generally used by the _____________ systems

Which of the following is/are the data warehousing activity?

The definition of data elements in the data warehouse and in the data sources, and the transformation rules that
relate them, are referred to as ___________
Data warehouses are not the optimal environment for ____________ data
Maintenance Costs are high for Data Warehousing

Data Warehousing can be used for

_________________ is the process of extracting patterns from data

___________________ is an approach to quickly answer multi-dimensional analytical queries

The Output of an OLAP query is typically displayed in a ___________ format

___________________ is the succession of strategies used by management as a product goes through its life
cycle
A _____________ is a network of facilities and distribution options that performs the functions of procurement
of materials, transformations of these materials into intermediate and finished products and the distribution of
these finished products to the customer
_______ integrates supply and demand mangement within and across companies

__________ includes transportation from Suppliers and receiving inventory

Which of the following is not the service area of SCM?

______________ CRM provides support to "front office" business processes

_____________ CRM covers aspects of a company's dealings with customers that are handled by various
departments within a company, such as sales, technical support and marketing
RSS stands for _____________________

ROI stands for _____________________

______________ companies is planning to support tens of millions of customers with just hundreds of
employees

Which of the following is the decisive feature of the framework?

Which of the following is the limitation of Open Source ERP?

Which of the following is not an Open ERP software?

_____ is the process of integrating all the business functions and processes in an organization to achieve
numerous benefits
________ must consider the fundamental issues of system integration by analyzing the organization's vision and
corporate objectives
ERP ________________ requires organizations to reengineer their key business processes reengineering of the
existing processes, integration of ERP with other business information systems, selection of right employees, and
training of employees on the new system
The more the number of __________, the longer the implementation time
In which step of the ERP implementation, educating and recruiting end users will be involved
The system ____________ process will address issues such as software configuration, hardware acquisition and
software testing
A __________________ review is recommended to ensure that all business objectives established during the
planning phase are achieved
In _________________ stages, auditors have access to rudimentary ERP tools and capabilities for auditing
security configurations
Customization of ERP systems is one of the major challenges in auditing ERP security
__________ is the World's one of the fastest and most powerful concurrent multi-lingual business accounting
and inventory management software
Immediate posting and updation of books of accounts as soon as the transactions are entered. This is called as
__________
[Link] 9 provides graphical analysis of data which helps the user to perform deeper analysis
The user can ________ the company data into multiple companies as per financial periods required

E-Filing of Returns refers to the process of electronically filing your tax returns through the ___________

Which of the following is true?

[Link] 9 does not allows you to export the ETDS forms in NSDL compliant formats as well as facilitates printing
of TDS Forms in Physical Form. True or False
Which of the following ETDS forms are available in [Link] 9?
The exported eTDS file from [Link] 9 can be validated through NSDL's freely downloadable utility called
__________________
The ETCS forms available in [Link] 9 are _________ and ____________
[Link] 9 allows accounting with the regular names without any account codes

A multi-user version of [Link] 9 can be installed on a network, having any number of computers with different
operating systems such as win 95, 98, NT, 2000, XP, Vista, Windows 7, Windows 8, etc.,
With ______________ technology the characters are reduced in breadth and user is allowed to input additional
characters which would make the account name, entity complete and readable
The [Link] 9 __________________ provides the user with administrator rights and the capability to check the
entries made by the authorised users and alter these entries, if necessary

[Link] 9 offers a data encryption option called _______________

ODBC stands for ___________________________

___________________ is the process of exchanging [Link] 9 data between two or more locations
Which of the following is the not the previous version of Tally?
Can data of new version be migrated to old version?
The Tally website offers _______________, by which a user can communicate with a Tally representative and get
required information
__________________ is an enabling framework which establishes a connection through which the remote user
can access the Client's data without copying/transferring the data
[Link] use _______________ for centralised Account Management
The data is transferred between the remote location and the server using a secured mechanism called
__________________
_____________ works as an interface between the user and [Link] 9 installed at different sites, it enables the
user to centrally configure and administer site / user belonging to an account

A chartered accountant as an __________________ is exposed to various operational risk factors viz., time,
increasing travel & people costs, limited availability of skilled manpower, intense audit periods

The ____________ edition provides the Chartered Accountants with Tax Audit and Statutory Compliance tools
which equips him/her to retrieve the required information on the basis on which he form an opinion
Generate Annexure for Tax Audit under Sec _____ using Auditors' Edition of [Link] 9, a Chartered Accountant
can provide services to their clients

Which of the following is one of the Technological Features in [Link] 9?

Which of the following is one of the salient features of [Link] 9?

To utilize [Link] in [Link] 9, which of the following is the pre-requisite?

What is the short cut key for [Link] features?
Which of the following will be displayed in the List of Companies screen?
If we want the company to be connected automatically for remote access on load, the property __________
needs to be set it as Yes
In order to enable [Link] in [Link] 9, the ___________ needs to be set to "Yes"
A message "Company connected successfully" is displayed in the ________________ panel
The remote users are broadly classified into _____ security levels
To create Remote Users, the security level should be _________________
[Link] ID has to be a valid _________ only

______________ enables the user to centrally configure and administer Site / User belonging to an account

Which of the following is the advantage of the Control Centre?

Which of the following is not the predefined security levels in [Link] 9?
The Account _________________ is authorised to surrender, confirm a site license or Reject the request
received on activation from another site

On starting [Link] 9 the Gateway of Tally screen appears displaying the Edition and Users are under Version
block, and the Serial Number and Account ID under License block of the ______________

______________________ enables user to enter the essential information related to the Account/Site ID

_______________ enables user to change the Account Administrator's ID

Set ___________________ to "Yes" to create a fresh set of configuration

Which one of the following is not an access right?

_________________ should be set to "No" for local users

 OPTION A OPTION B OPTION C OPTION D
SAP Oracle All the above None of the above

SA330 SA315 SA300 None of the above

including the entity's including the entity's excluding the entity's

internal control external control internal control excluding the entity's external control
frameworks frameworks frameworks frameworks
Financial reporting Communication Either A or B Both A & B
Business team IT team Either A or B None of the above
Business team IT team Either A or B None of the above

confidentiality integrity availability All the above

less many moderate All the above

due to the number

and location of interfaces between security within the
applications the applications applications All the above

143,internal financial
142,internal controls controls system in 142,external controls 143,external financial controls system in
system in place place system in place place

SA 330 SA 300 SA 610 None of the above

listed companies unlisted companies Either A or B Both A & B

Enterprise resource integrated Enterprise Entity resource

planning resource planning planning None of the above
one,few many,all one,all many,few

volume of Systems distributed within the same

nature of business outsourced processes transactions are high geographies

International
Indian Standard for Standard for
Assurance Assurance Indian Standard for International Standard for Audit
Engagements Engagements Audit Engagements Engagements

Payment Compliance Payment Compliance Payment Card

Industry-Data Industry-Data Security Industry-Data Security Payment Card Industry-Data Sensitivity
Sensitivity Standard Standard Standard Standard

areas where CAATS

may be used as part
Involvement of key of the audit
team members procedures All the above None of the above

audit strategy audit procuedure audit evidence None of the above

 1 0
Display-only read-only Either A or B Both A & B

priviliged access administrative access temporary access super user

pervasive indirect Both A & B None of the above

Data center and Application system acquisition,development

Program change Access control Network operations and maintenance

Manual controls Automated controls IT-Dependent controls None of the above

Manual controls Automated controls IT-Dependent controls None of the above

Manual controls Automated controls IT-Dependent controls None of the above

Unauthorized changes
Unauthorized access to systems or
of data Temporary access programs Direct data changes

Information produced
by Entity(IPE) Manual controls IT-Dependent controls None of the above
History of errors and
Types of control Timing of test expectations Risk management

Have formal IT How does IT

policies and communicate and
How is the procedures been collaborate with other
department organised defined business functions Are the employees trained

Internal reporting Financial reporting Both A & B None of the above

Minor change major change normal change data changes

Minor change major change Bug fixes patches and updates

emergency changes direct data changes major changes patches and updates
change request implementation testing documentation
Approved change
All change requests requests Major changes None of the above
database
system administrator administrator netwrok administrator All the above
enabled disabled not defined None of the above
Physical layer Network layer Application layer None of the above
Data transfer Data transfer
between systems may between systems may
be incomplete be inaccurate Either A or B Both A & B
the validity of the
accuracy of data completeness of data transactions All the above
Inherent configurable security embedded

operation deficiency design deficiency control deficiency communicating deficiency

SA 315 SA 330 SA 265 SA 300

Inherent configurable security embedded
Inherent configurable embedded Both B & C
depreciation
Debit=Credit calculation discount calculation None of the above

on closer to the Either A or B None of the above

yes no

to look into the to look into the a walkthrough of the

process narratives process flow diagrams control None of the above

Entity Personnel to Auditor to perform

perform a relevant Auditor to test a substantive
control relevant control procedures All the above
2 3 4 1
1 2 3 4

Standard Reports Customised Reports Database Queries None of the above

Standard Reports Customised Reports Database Queries None of the above

Standard Reports Customised Reports Database Queries None of the above

Standard Reports Customised Reports Database Queries None of the above

1 0
Standard Customised Database Queries None of the above

Standard Reports Customised Reports Database Queries None of the above

Standard Reports Customised Reports Database Queries None of the above

Source Data Report Logic Report Parameters Functions

Accuracy of Logic Completeness of Data Accuracy of Data All the above

consistency integrity independency redundancy

Controls in Business
Controls in GITC are Processes are
effectuve effective Both A and B Either A or B

se16 se16n sa38 All the above

vendor company finance controller IT personnel

alert change management file backup

completeness,
controls, compliance controls, efficiency accuracy accuracy, impact

no further testing reliance can be placed

need to be done on the report Both A and B None of the above

relied upon by the

used by management for compliance auditors during the
to make decisions purposes course of the audit All the above

adopt appropriate
controls based and
substantive audit adopt substantive
procedures audit procedures Either A or B None of the above

Customised Reports Database Queries Standard Reports Other tools

Standard Reports customized reports Both A and B Either A or B

end users authorised users programmers technical consultant

appropriate code appropriate date of

change should be change should be appropriate approvals
verified verified should be verified appropriate report output should be verified

Standard Reports Customised Reports Database Queries None of the above

Database Queries Custom Reports Standard Reports None of the above

controls in all controls are

domains of GITC's are there are no relevant ineffective in all
effective deficiencies domains of GITC's
Inclusion of Period New ERP
and Entries Company Policy implementation All the above

Appropriate
One Sample in each substantive
One Sample Scenario procedures None of the above

1 type 2 types 3 types 4 types

Role Responsibility Authorized Access Sensitive Access
Sensitive Access Authorized Access Responsibility Role

Sensitive Access Segregation of Duties Roles Profiles

Normal Users End Users Business Users All the above

Normal Users System Users End Users Business Users

Normal Users System Users Previleged Users Business Users

Normal Users System Users Previleged Users Default Users

System Users Previleged Users Generic Users Default Users

System Users Temporary Users Generic Users Default Users
System Users Temporary Users Generic Users External Users
Job Roles Responsibilities Either A or B Both A and B
One to Many Many to One Many to Many One to One

Roles Profile Both A and B None of the above

RBAC RBFC RBOC None of the above

User Role Profile None of the above

User Profile Either A or B Both A and B

Preventive Detective Either A or B None of the above
SAP GRC Oracle GRC BIZRights All the above
point-in-time full period of audit Either A or B None of the above

GITCs IT dependent controls application controls None of the above

should report
deficiency to should evaluate the impact of these
management ignore the deficiency record the deficiency deficiencies on the audit

Business Environment IT Environment Both A and B Either A or B

Role Profile SA SOD

GITCs IT dependent controls application controls None of the above

Auditor Company IT Consultant Government
Auditors Consultants Sales User Business Partners
Auditors Support Users Sales User Business Partners
Auditors Vendors Sales User Customers
Procurement Inventory Materials
Management Management Management Accounts Management
Non-Technical
Migration Technical Migration Data Migration Non-Data Migration
Data Conversion Data Migration Data Convergence Data Configuration

SAP Oracle R12 In-House Developed All of the above

Allocation of Budget Configuration Mock Conversion All of the above

Allocation of Budget Configuration Mock Conversion All of the above

Allocation of Budget Configuration Mock Conversion All of the above

4 5 6 7

System Design Data Conversion Planning Testing

Planning Data Conversion Go-Live Migration Testing
Data Conversion Planning Go-Live Migration Testing

User access and

segregation of duties Open items Master data All of the above

During pre-
implementation
/Post-implementation When reviewing
reivews general IT Controls Both A& B None of the above

Documentation Allocation of Budget Configuration Technical Migration

Procurement & Migration and
Inventory Material & Inventory Inventory None of the above
QuickBooks Microsoft Dynamics Open Bravo All of the above
Information Information planned Information projected
processed by entity by entity by entity

Data Conversion System Design Planning Go-Live

Data Conversion System Design Planning Go-Live

Integrity Data Conversion Staging Mock Conversion
Data Conversion Sysmen Design Planning Go-Live
Planning Data Conversion Sysmen Design Mock Conversion
System Design Testing Data Conversion Go-Live

Technical Functional Migration Accounts

SA 630 SA 330 SA 310 SA 610

3 2 5 4

Standard Entries Non Standard Entries Top up Entries Top Down Entries
Standard Entries Non Standard Entries Top up Entries Top Down Entries

Standard Entries Non Standard Entries Top up Entries Top Down Entries

Standard Entries Non Standard Entries Top up Entries Top Down Entries
Material Journal Missing Journal Match Journal
Vouchers Vouchers Vouchers Manual Journal Vouchers

17 18 19 20

Roll Down Roll forward Roll Back Roll up

ACL ADL ABL AGL

ACL Ms Access CAAT All of the above
Unusual Intercompany Seldom Non General
Non Stimulated Non Standard Journal Non Sensitive Journal
Journal Entries Entries Entries Non Segregated Journal Entries
Sub ledgers General Ledger Excel sheets None of the above

Standard Journals Top up journals Non Standard journals None of the above
Automated or Manual SA/SOD among IT Timing of passing the
entries and Business teams entries All of the above

Personal gain such as Debts requirements

Sales Targets Bonus, incentives etc. for banks etc. All of the above
Ask close ended No discussions Ask open ended
questions required questions None of the above

Risk of Material Risk of management Risk of lack of

misstatement override of controls sensitive access Risk of lack of segregation of duties.

NSJE NSVE NSUE NSWE

Non-Printed Printed All of the above None of the above

Roll Down Roll forward Roll Back Roll up

Purchase Targets Marketing Targets Sales Targets Operational Target

Non-Debt Monetary Non-Monetary
Requirements Requirements Requirements Debt Requirements

Developer Scripts Software Scripts Testing Scripts Hardware Scripts

Automated command Automated control Automated corrected
language language language Automated computer language
one two three four
+ - & *
[] () {} #
0 1
1 0
0 1

IN ANY Any one of the above None of the above

Sum() AVG() Count() All of the Above
1 3 2 4
1 0
1 0
0 1
Page Header Report Header All of the Above Non of the above
Page Header Report Header All of the Above Non of the above
select query parameter query sub-query group by query
Find unmatched
Find matched query query Find unique query Find duplicate query
select query action query other sub queries All of the above
1 0
Find unmatched
queries Find duplicate queries Group By queries Parameter queries
Datasheet form Pivot Table Pivot Chart Multiple items
Pivot Table Query Form All of the above
Table Query Either A or B Both A and B

Left Outer Join Right Outer Join Inner Join Cross Join

Bounded Fields Unbounded Fields Calculated Fields Expression Fields

Variables Memory Variables Either A or B None of the above
1 0

Option Button Check Box Tab Control Combo box

Add-in Plug-in Com Add-in Active X

List Box Tab Calendar Combo Box

Pivot Table Form with Sub form Linked form Split form
Pivot Table Pivot Chart Multiple Items Modal Dialog
Label box Text Box List Box Combo box
Data Variables Fields Values
Unbound Report Bound Report Child Report Sub-Report

Bound main report Unbound main report Main report None of the above
Tables Queries Forms Reports
Pivot Table Queries Charts Sub-Report
Report Page Setup Report Wizard Report Report Print

On Print Cancel Print Cancel Event On No Data

Tables & Queries Forms & Reports Macros All the above
Operator Operand Expression Paranthesis
literals identifiers functions All of the above
Identifiers Operators Constants Operands
Variables Operators Constants Operands
0 or any number of
characters a single character a set of characters a single digit
Numeric Text Date Either A or B or C
Comparison Miscellaneous
Operators Arithmetic Operators Operators Boolean Operators

Operator Precedence Orders Parentheses None of the above

Code Builder Macro Builder Expression Box Expression Elements
+ MOD AND <>
Function Expression Macro Module
Expressions Macros Modules Switchboard

Task Pane Navigation Pane Action Catalog Pane Action Pane

events queries controls Either A or B or C

OpenTable, OpenTable, OpenQuery,
OpenQuery OpenForm OpenReport OpenForm, OpenReport
Query Advanced Filter Macros Switchboard

Navigation Pane Switchboard Tabbed Windows None of the above

Switchboard Split Columnar Pivot Table

6 7 8 9
added edited Either A or B Both A and B

Switchboard Login Form Password None of the above

prefix aliases suffix None of the above

Unmatched Queries Duplicate Queries Crosstab Queries Group by queries

Sub Query Crosstab Query Total Query Pivot Table Query

Group By Aggregate Total Non-Aggregate Total All the above

where group by having order by
 1 0

Sub Query Totals Query Crosstab Query Unmatched Query

Yes, include column Yes, include Grand
sums Yes, include row sums Total Yes, include column grand total

Crosstab Query Totals Query Pivot Chart Pivot Table

Expansion Markup Expansion Makeup EXtensible Markup
Language Language Language EXtensible Makeup Language
W3C W1C W2C W4C
C HTML C++ JAVA
1 0
Document Type
Direct to Direct Definition Data Type Definition Data to Data
Add-Ins Developer Data Review
(.xsd) (.xml) (.mlx) (.xlm)
Review Add-Ins Developer Data
1 0
(.xml) (.xsd) (.xlm) (.mlx)
Visual Basic for Visual Basic for
Application Applets Visual Basic for Apple Visual Basic for Auto Mobile
Java Visual Basic V++ C++
.xlsx .xlsm .xlsv .xlsw
Analysis of Value Analysis of Varity Analog of Variance Analysis of Variance
DATE() TODAY() MONTH() YEAR()

For calculation of For calculation of

depreciation as per For calculation of depreciation as per
Sum of Years’ Digit depreciation as per Variable Declining For calculation of depreciation as per
Method Straight Line Method. Balance Method Double Declining Balance Method

For calculation of For calculation of

depreciation as per For calculation of depreciation as per
Sum of Years’ Digit depreciation as per Variable Declining For calculation of depreciation as per
Method Straight Line Method. Balance Method Double Declining Balance Method

For calculation of For calculation of

depreciation as per For calculation of depreciation as per
Sum of Years’ Digit depreciation as per Declining For calculation of depreciation as per
Method Straight Line Method. BalanceMethod. Double Declining Balance Method

calculate depreciation calculate depreciation calculate depreciation

as per Sum of Years’ as per Straight Line as per Declining calculate depreciation as per Double
Digit Method Method. BalanceMethod. Declining Balance Method
calculate depreciation For calculation of
as per Variable For calculation of depreciation as per
Declining Balance depreciation as per Declining For calculation of depreciation as per
Method Straight Line Method. BalanceMethod. Double Declining Balance Method

Point Volume Ratio Point Varaiance Ratio Profit Volume Ratio Profit Variance Ratio
Balance sheet Even Balance sheet Equal
Point Break Even Point Point Break Equal Point
1 0
= n / (1+a) - r = 1 + (1/r) * n = 1 / (1+a) ^ 2 = 1 / (1+r) ^ n
1 0
Formulas Insert Data Developer
Statistical Engineering Math & Trig Trignometrical

Region of uncertainty Region of curve Region of certainty None of the Above

1 0
planning for
Expenditure. planning for future. planning for Event. planning for Meeting.

Cash Flow Depreciation Fund flow Expenditure

SOYD Digits of the Year SYD None

SLN DB VDB Sum of the years' digits

declining balance VDB SYD SLN

Virtual Declining Variable Discounting variable declining

Balance Balance balance None
Double Declining Variable Decling
Balance Balance Straight Line Method Costing Method

marginal cost Fixed Cost Variable cost Contribution

Fixed Cost Marginal cost Both A& B None
Capital Budgeting Cash budget Both A& B Actual Budget

Standard population
Standard Deviation Standard Error deviation none of the above

Marginal costing Capital Budgeting Discounting None

Marginal costing Discounting PMT None

IPMT PPMT PMT None

Snowball sampling Sampling Systematic sampling Simple random sampling

Clustered sampling Sampling Systematic sampling Simple random sampling
Convenience
Snowball sampling sampling Systematic sampling Simple random sampling

Region of uncertainty Region of curve Region of confidence None of the above

Quota Sampling Sampling Snowball sampling Simple random sampling

Business Investment Capital Budgeting IRR NPV

discounted cash flow internal rate of return net present value All the above
Net present value Working capital IRR PMT
Qualitative risk
Sensitivity analysis Risk analysis analysis Scenario analysis
Qualitative risk
Sensitivity analysis Risk analysis analysis Scenario analysis

Graphs Sparklines Both A& B Charts

Decision Tree analysis Sensitivity analysis Both A& B Neither A &B

Scenario analysis Sensitivity analysis Decision Tree Analysis None

Median Arithmatic Mean all the above None
Monte Carlo
Finanical Planning simulation Corporate Planning Personal Finance planning
Monte Carlo
Corporate planning simulation Financial planning Personal Finance planning
Monte Carlo
simulation Corporate planning Decision Tree analysis Sensitivity analysis
1 0
1 0

Total Principal Value Per value Total Interest Value Total Number of Periods

Pivot Table Solver Scenario Macro

1 0
sumif pmt countif none of the above

spaces wild card characters symbols none of the above

convert text to
pivot table wizard chart wizard columns wizard tip wizard

Goal seek Pivot table Solver Data table.

Data table Pivot table Scenario Manager Solver
 convert text to
text import wizard columns wizard tip wizard function wizard
absolute relative mixed constant
Consolidate What-if Analysis Calculate Sheet Data Validation
convert text to
text import wizard columns wizard tip wizard function wizard
Income &
Balance Sheet Profit & Loss Expenditure None
Interest Coverage
Debt Assets Ratio Ratio Total Fund Ration None
Interest Coverage
Return on Investment Ratio Total Fund Ration Net Profit Margin Ratio
Price Earnings
Earnings Per share Fixed Asset Over ratio Multiple Gross Profit Ratio

Du Point Analysis Return on Investment Profitability Ration None

Mortagage Leasing Rent All the above
.xml .xmd .xsd None of the Above
p-value> a p-value>=a p-value< a p-value<= a
Test statistic >= critical Test statistic <=critical Test statistic < critical
value value value p-value<= a

VDB(400000,50000,1 VDB(400000,50000,1, VDB(50000,400000,1

0,1,4) 4) 0,4) VDB(50000,400000,10,1,4)
4 1 3 2

when the stright line

depreciation is
greater than the
declining balance "no_switch"
calculation. argument is 'FALSE' Both A and B either A or B

PMT(8%,5,- PMT(8%,60,1000000, PMT(8%/12,60,10000

1000000,100000,1) 100000,0) 00,-100000,1) PMT(8%,60,-1000000,100000,0)

Goal seek scenario manager Data Table None of the Above

3 1 4 2

NPV(10%,-
NPV(10%,10000,3000, NPV(10,-10000,- 10000,6800,4200,300
4200,6800) 3000,-4200,-6800) 0) NPV(10%,-10000,3000,4200,6800)
XML CSV PDF TEXT
FV PV NPV IRR
FV PV NPV IRR
0.09 0.14 0.1 0.13
PV & IRR XNPV & XIRR NPV & IRR None of the above
SLN DB All the Above None of the above
DB SLN All the Above None of the above
Date Month NetworkDays None of the above
before 2 months after 2 months #N/A None of the above
YES NO

Next day previous day same day None of the above

unequal equal Either A or B Neither A or B

start date end date Either A or B Both A & B
excluding Saturday & including Saturday &
None of the above
Sunday Sunday

NETWORKDAYS() [Link]() [Link]() None of the above

Number Date Number or Date None of the above

Zero Positive Negative None of the above

QUOTIENT() MOD() Either A or B None of the above

QUOTIENT() MOD() Either A or B None of the above

comma ampersand space hash
YES NO
Hlookup Vlookup Match Index
Left Right Either A or B Neither A or B

The search is always The column index

Lookup value is the
performed in the number should be the All the four arguments are mandatory
value which is to be
leftmost column of relative position of the arguments
searched in table array
the tavle array respect column

APPROXIMATE
EXACT MATCH Either A or B Neither A or B
MATCH

ascending order descending order Either A or B Neither A or B

lookup_array col_index_number row_index_number Both A & B

Hlookup Vlookup Match Index

Lookup value lookup array match type None of the above

one row or one
Only one row Only one column multiple rows or multiple columns
column
INDEX() MATCH() Both A or B Either A or B
The processing
It performs left to requirement is lower It can also be used as
It avoids data redundancy
right lookup as compared to Hlookup
Vlookup
INDEX() MATCH() INDIRECT() All the above
2010 2007 2013 2003
 #REF! #VALUE? #N/A #DIV/0!
COUNTA() COUNTIFS() COUNTIF() None of the above
where data entry is
remained blank Both A & B None of the above
incomplete
MAX LARGE Either A or B None of the above
Trace Precedents Trace Dependents Either A or B Both A & B

#NAME? #N/A #REF! None of the above

Go to special Trace Dependents Trace Precedents Error Checking

syntax logic Either A or B Both A & B
Evaluate formula F9 Either A or B Both A & B
Brackets Addition Exponents Division
duplicate unique Either A or B Both A & B
2010 2007 2003 2013
Top 10 Bottom 10 Above Average Below Average
months quarters years All the above
rectagular flat Either A or B Neither A or B
Report Filter Column Labels Row Labels Filter field
large max min sum

1 0

We cannot insert rows If the number of

Pivot Tables Update
or columns in records are very
themselves,We All the above
between a Pivot Table large,Pivot table may
neednot refresh them
report respond slowly
VLOOKUP() MATCH() INDEX() None of the above
[Link] Nigrini Frank Benford Mark Benford None of the above
second first third last

0.2222 0.3333 0 None of the above

highest least most probable None of the above

heterogeneous,homog homogeneous,heterog humongous,homogen
None of the above
eneous eneous eous
MEAN MEDIAN MOD LARGE

Company Enterprise Organization Concern

Costing Production Sales Resources

Business Model Business Function Business Process Business Operation

Integrated Isolated Information Non-Integrated

Non-Isolated Information Systems
Information Systems Systems Information Systems

Business Model Business Function Business Process Business Operation

flowcharts, flow
charts, pictures smart art, clip art graphs, shapes
diagrams
Online Analysis Online Analytical Online Analytical
None of the above
Processing Processing Programming

Data Warehousing Data Modeling Business Modeling Business Intelligence

Integrated Decision Support

Information Systems Non-Isolated Information Systems
Information Systems Systems
Data Warehousing Data Modeling Business Modeling Business Intelligence

Data Models Data Warehouses Data Mines Operational Data

Operational Non-Operational Subject-Oriented Informational

Dynamic, Static Non-Volatile, Static Volatile, Static Static, Dynamic

Operational Data Operational Data
Optional Data Storage Optional Data Store
Storage Store
Operational,
Operational, Static Informational, Static Informational, Operational
Informational

Defining the correct Establishing a data

Identifying and
level of warehouse help desk
prioritizing subject
summarization to and training users to All of the above
areas to be included in
support business effectively utilize the
the Data Warehouse
decision making desktop tools

Masterdata Detaileddata Metadata Basedata

Structured Unstructured Informational Operational

1 0
Credit Card Churn Insurance Fraud Logistics
All of the above
Analysis Analysis Management
Data Analysis Data Warehousing Data Mining Data Modeling
Business Processing Online Analytical Product Life Cycle
Supply Chain Management
Management Processing Management
Matrix Columnar Stepped Outline
Business Processing Online Analytical Product Life Cycle
Supply Chain Management
Management Processing Management

Online Analysis
Business Processing Supply Chain Product Life Cycle
Processing

BPM SCM PLM CRM

Inbound Operations Outbound Operations Sourcing planning Production planning

Logistics Asset Management PLM CRM

Consumer
Operational Analytical Social
Relationship
Consumer
Operational Collaborative Social
Relationship
Really simple Really super Rare simple
Rare super syndication
syndication syndication syndication
Revenue on
Return on Investment Both A & B None of the above
Investment

B2B B2C C2B C2C

Architecture of
Network as platform Both A & B None of the above
participation
Unsuitable for
Increased
Legal Complexities conventional All of the above
Complexities
applications
Openbravo SQL-Ledger Open-Project ERP5ERP

EDI ERP BPM None of the above

Top Management
Manager Auditor Either A or B or C
Commitment

Traps Security Audit Implementation None of the above

modules process package units

Step 1 Step 2 Step 3 Step 4

implementation upgradation installation migration

pre implementation under process review post implementation None of the above

post implementation pre implementation Both A & B Either A Or B

1 0

Tally [Link] 9 Both A & B None of the above

Interactive Processing Immediate Processing Real Time Processing Business Processing

1 0
Import Export Split Backup

Intranet Internet Extranet Any of the above

Select Alt+E from the

required
Return/Form/Annexur
We can fill up the e to export to .xls
details online and format and then
submit eVAT returns upload the same Either A or B Neither A Nor B

1 0
Form 26, Annexure to Form 27, Annexure to Form 26Q, Annexure
26 27 to 26Q All of the above
File Validation File Valuation
Program File Validation Utility Program File Valuation Utility
Form 27E Form 27 Form 26 All of the above
1 0

1 0

Tally Fix Tally Adjust Tally Fit Tally AutoFit

HTTP-XML based data Unlimited multi-user
User-defined Security interchange support Audit Feature

Tally Data Encryption Tally Data Encoding Tally Vault Tally Data Conversion
Open Database Open Database Oracle Database
Connection Connectivity Connection Oracle Database Connectivity
Serialization Randomization Synchronization Asynchronization
Tally 4.5 Tally 6.4 Tally 7.2 Tally 8.1
Yes No

Tally Forum Tally FAQ Tally Support Tally Chat

Direct Web Browser
Access Web Publishing [Link] Email facility
Data Centre Control Centre Cloud Centre Administration Centre

Encoding Decoding Encryption Decryption

Control Centre Data Centre Cloud Centre Administration Centre

Administrator Auditor Expert Entrepreneur

Educational Mode Silver Gold Auditor

44A 44B 44AB Both A & B

Concurrent multi- Data Reliability and

lingual capability Real time processing Automatic Recovery Accounting without Codes
Codeless user Graphical analysis of
interface data Split Company Data Scalability
Configuring [Link] Creating Remote Authorizing Remote
features Users Users All of the above
F1 F2 F3 F4
Company Name Account ID Serial Number All of the above
Allow to Connect
Company Contact On Load Either A or B None of the above
Enable [Link] Contact On Load Security Controls Allow to Connect Company
Calculator Version License Configuration
two three four five
Owner Standard User Either A or B None of the above
Account ID User Name Email ID None of the above

Data Centre Control Centre Cloud Centre Administration Centre

Surrender, Confirm or Create users with

Reject activation of a Manage Jobs and predefined security
site Recruitments levels All of the above
Owner [Link] User [Link] Owner [Link] Auditor

Administrator Owner Auditor User

Horizontal Bar Information Panel Vertical Bar None of the above

Change Account
User Management Admin Profile Management Licensing & Configuration
Change Account
User Management Admin Profile Management Licensing & Configuration

Want to set
can be overridden client/server
Enable ODBC Server locally configuration None of the above

Alter Account Admin Manage Sites Manage Users Manage Passwords

[Link] [Link] [Link] Auditor
Authorisation Authentication Authorisation [Link] Auditor Authentication
ANSWER
C

A
D
B
A

B
B

A
D

B
C

B
A
D

C
C

B
C

B
D

D
B
A
D

D
A

C
B
D

A
A

D
A
C

A
A

C
D

D
B

D
A

C
A

B
D
A

C
D

C
B
D
D
C

A
B

B
C
D
B

C
A

A
B
C
D
A

B
A

C
B

C
A
D
B

A
B

D
C

A
B
D
B
B
A
B

D
B
A
B
A
B
A
C

B
D
A

C
B
D
B

C
C
A

A
B
B
C
D

B
D
C
A

D
D
B
D
C
A

C
B

C
C
B
C
B

D
C

A
C
D

D
A
A

C
A
B
C

B
A
B
C
B
B

A
B
B
D
B

D
A

B
A
D
B
C
D

A
A

B
C

D
A

A
B
B

B
B

B
C

D
C

D
A

A
B

B
B
A

D
B
B

D
B
B
A
D

A
B
C
D

A
D

C
D

D
C
C
D
C
B
B
A
D
B
A

B
D

A
B
A
B
A

C
B
B
A

B
D

D
B
B
C
D
B
B
D
C
D
A

A
B
B

C
B

B
A

B
A

D
B

A
A

C
A
C

B
D

B
A
A

B
C
B
B

C
B

D
D
D

B
C
A
A
B
C

D
C

B
Sl.
Question Answer
No
1 XML stands for_________ Extensible Markup Language
2 XML is a ___________ Recommendation. W3C
3 XML is a language that is very similar to which language ? HTML
4 DTD stands for ___________, which is called XML Schema. Document Type Definition
5 The extension of a XML document is ______________. (.xml)
To create a XML Map from XML schema, Go to which Tab in Excel Developer
6
____________.
7 XML is case-sensitive ? TRUE
8 Excel works primarily with ________ types of XML files. 2
9 What is the file extension of Schema file which contain schema tags ? (.xsd)
10 VBA stands for_______________ . Visual Basic for Applications
11 Macro enabled workbook file extension is _______________ .xlsm
12 There are _________ ways to open a Macro enabled workbook. 3
13 ANOVA stands for___________ Analysis of Variance
14 A function doesn’t require an argument is___________. TODAY()
15 In Excel, there are __________ functions for calculation of depreciation. 5

For calculation of depreciation as per

16 SLN function used to calculate depreciation as per_________________. Straight Line Method.
For calculation of depreciation as per
17 SYD function used to calculate depreciation as per_________________. Sum of Years Digit Method.
For calculation of depreciation as per
18 DB function used to calculate depreciation as per_________________. Declining Balance Method.

For calculation of depreciation as per

19 DDB function used to calculate depreciation as per_________________. Double Declining Balance Method

For calculation of depreciation as per

20 VDB function used to calculate depreciation as per_________________. Variable Declining Balance Method.

21 PV Ratio stands for _____________________. Profit Volume Ratio

22 BEP stands for __________________________ Break Even Point
23 Data Validation available in which Tab? Data
___________function returns value from a given data range based on row INDEX()
24
and column.
25 Which function categories are not available in Excel. Arts
26 PMT Function is belongs to which categories of Excel function ? Financial
27 NPV stands for_______________________________ Net Present Value
28 _______function uses a fixed rate to calculate depreciation DB
29 Which of them is not a Conditional Operators symbols? </
Strings are to be always enclosed in double quotes when used in a TRUE
30
formula.
31 Parentheses are used to change the order of calculation. TRUE
32 In Excel the function =Abs(-4) returns __________. 4
_______ function returns the remainder after a number is divided by a MOD()
33
divisor.
If User want to display the formulas rather than the results of the formulas Formulas > Formula Auditing > Show
34 Formulas.
then choose______________.
_______________ reveal about the current and future financial condition Financial statements
35
of the company.
36 Which of them is a Intangible assets? Goodwill and Patents.
37 CR stands for___________________. Current Ratio
38 QR stands for___________________. Quick Ratio
39 Debt – Equity Ratio =Long term debt / Shareholders funds. TRUE
40 ACP stands for _____________. Average collection period
41 FATR stands for _____________. Fixed assets turnover ratio
42 A _________ can be a numerical fact. Statistic
43 __________ stands for reduction in value of fixed assets. Depreciation
Value of fixed assets is generally reduced over the period of time due to Wear & Tear,Change in taste of
44 people,Change in technology
__________.
45 Profit equals to __________. Sales - Total Cost
Salary of administrative staff,office
46 Examples of fixed cost are __________. rent
Cash budget is prepared for planning for future as far as movement of TRUE
47
cash is concerned.
Discounting is not the process of determining the present value of a
48 FALSE
payment or a stream of payments that is to be received in the future.
49 PAN must have ________ characters only. 10
Sample means the units or items selected for study or consideration and TRUE
50
population means the total set of data used for selection of samples.

_______________ analysis relates items in the financial statements in a Financial ratio

51
manner that drives out performance information about the company.
Hold down the SHIFT key during start
52 How to restrict to run a macro automatically when starting Microsoft Excel? up.

Which option allows you to Bold all the negative values within the selected Conditional Formatting
53
cell range?
_____________ allow us to perform calculations or operations that would Worksheet functions
54
otherwise be too cumbersome or impossible altogether.
55 Statistical functions in Excel help to calculate __________________ Arithmetic Mean,Median,Mode
56 Discounting Factor formula is ___________________ = 1 / (1+r) ^ n
________________ is considered as non cash expenditure and occupies Depreciation
57
a prominent place in Profit & Loss Account.
The value which can be realized at the end of life of fixed asset by selling it Salvage Value
58
is called _________________
____________ is prepared for planning for future as far as movement of Cash budget
59
cash is concerned.
____________ is the process of determining the present value of a
60 Discounting
payment or a stream of payments that is to be received in the future.
____________ is one of the core principals of finance and is the primary
61 factor used in pricing a stream of cash flows, such as those found in a Discounting
traditional bond or annuity.
62 XML schemas in Excel are called XML _____________. Elements
Financial analysis,Equity
Excel allows us to use various functions and even simple mathematical analysis,Leasing decisions and the list
63
calculations which can be used for _____________. goes on
Which cell reference show the reference to other sheet or reference to Sheet2!C4
64
other workbook in excel ?
65 Which of them is not a Range References? A1, A2 , A3, A4
66 Interest Coverage Ratio equals to _________. EBIT / Debt interest
If particular workbook have to open each time Excel started, where the XLSTART folder
67
workbook should be placed?
There is an absolute reference to cell
68 If the cell B1 contains the formula=$A$1, which of the statement is true ? A1.

__________ is a computerized mathematical technique that allows people Monte Carlo Simulation
69
to account for risk in quantitative analysis and decision making.

________ is the process of meeting the financial goals through the proper Financial planning
70
management of finances.
 ___________ can be defined as the process of setting the procedures in Corporate Planning
71
the organization for achieving the predefined goals.

________ shows ability of company to pay back long term loans along Interest Coverage Ratio
72
with interest or other charges from generation of profit from its operations.

_____________________is the simplest method of comparing different Price Earnings Multiple

73
stocks at a point of time to make investment decisions.
<?xml version="1.0" encoding="ISO-
74 The very first line of code of XML file is_____________. 8859-1"?>
75 Every bit of data has to start and end with an identical tag <TagName>Data</TagName>
76 The exact syntax of PMT function is________________. PMT(rate, nper, pv, [fv], [type])

77 The exact syntax of IPMT function is__________________. IPMT(rate, per, nper, pv, [fv], [type])

78 To see the XML Map user must go ______________. Developer>XML> Source

79 Deletion of XML Map is done through __________. XML Maps Dialog Box

80 Method of tax calculations shall change according to _________. Annual Income,DOB,status of assess

81 EMI stands for ______________. Equated monthly installment

Which function is used to calculate the principal portion in every PPMT
82
installment ?
________ is a process used in statistical analysis in which a
83 predetermined number of observations will be taken from a larger Sampling
population.
In __________, Individuals are selected at regular intervals from a list of Systematic sampling
84
the whole population.
In ______________ each individual is chosen entirely by chance and each
85 member of the population has an equal chance, or probability, of being Simple random sampling
selected.
Which method is commonly used in social sciences when investigating Snowball sampling
86
hard to reach groups?
__________ are useful for quick reading and easy understanding, Summary reports
87
particularly for top management.

It is a process in which a business determines whether projects such as Capital Budgeting

88
building a new plant or investing in a long-term venture are worth pursuing.

Popular methods of capital budgeting include _________ and payback discounted cash flow,internal rate of
89 return,net present value
period.
_________ is the value of all future cash inflows less future cash outflows Net present value
90
as on today.
___________is the process of defining and analyzing the dangers to
91 individuals, businesses and government agencies posed by potential Risk analysis
natural and human-caused adverse events.
__________ which is used more often, does not involve numerical Qualitative risk analysis
92
probabilities or predictions of loss.
________ are generally used to present information in a simple and better Charts
93
way and also be used to analyse the risk in a better way.
It is a technique used to determine how different values of an independent
94 variable will impact a particular dependent variable under a given set of Sensitivity analysis
assumptions.
_______ involves computing different reinvestment rates for expected Scenario analysis
95
returns that are reinvested during the investment horizon.
96 NPER stands for______________________________ Number of Periods
Which function that is used to calculate the payment for specific loan terms PMT
97
____________
98 ________helps to break down the Return on Equity Du Point Analysis
_______ is a common method for financing property, facilities, and Leasing
99
equipment.
 Structure, store, and transport
100 Find the correct sequence in case of XML file, are information.

101 Programming of Macros is done in programming Language ___________. VBA

As Bank auditors,Many Banking applications generate text files in Txt format,Csv format
102
____________.

103 Macro security is enabling through __________. Developer tab>Code>Macro Security

104 In Excel, Sampling option is available in ___________ . Data Analysis

105 Requirements for preparation of cash budget in Excel. Knowledge of all of the above.
106 ROE stands for __________. Return on Equity
___________ is a statistical procedure that uses sample evidence and
107 probability theory to determine whether a statement about the value of a Hypothesis
population parameter should be rejected or should not be rejected.
108 ____________ is a statistical tool used to create predictive models. Multiple Regression
__________ shows the ability of a company to pay its current financial Liquidity Ratio
109
obligations.
110 ___________ shows dependency of a firm on outside long term finance. Leverage Ratio
To record a Macro in relative mode,"Üse Realtive References" available in Developer Tab,View Tab
111
which tab of excel ?
An _____________ is a group of people with a common goal, having Enterprise
112
certain resources at its disposal to achieve the common goal.
________________ include money, manpower, materials, machines, Resources
113
technologies etc.
___________ is a collection of activities that make one or more kinds of Business Process
114
input and creates an output that is of value to the customer.
Information systems can be designed so that accurate and timely data are
115 shared between functional areas. These systems are called Integrated Information Systems
_______________________________.

The approach to ERP is to first develop a ______________ comprising the Business Model
116
business processes or activities that are the essence of a business.

117 OLAP stands for _________________. Online Analytical Processing

________________ is a tool that refers to skills, processes, technologies,
118 applications and practices used to facilitate better, accurate and quicker Business Intelligence
decision making.

119 Business Intelligence Systems are data-driven ___________________. Decision Support Systems
120 Finacle developed by _________ Infosys
121 Flexcube developed by ________ I-Flex
122 Quarz developed by ____ TCS
The server is a sophisticated computer that accepts service requests from Clients
123
different machines which are called__________
__________ server has to be a powerful and robust system as it has to Application Server
124
perform all the core banking operations.
125 ATMS stands for_________ Automated Teller Machine Server

126 IBAS stands for ___________ Internet Banking Application Server

127 PBF stands for________ Positive Balance File

Internet banking refers to a banking transactions routed through the Internet
128
________
Computer Planning and Policy
129 CPPD Stands for ______________. Department
The _________ is generally a hardware and it plays the role of preventing Firewall
130
unauthorized access.
131 ________enable data transmission over different networks. Routers
 _________have many ports that are connected to different systems and it Switches
132
facilitates data transmission with the network.
133 A Proxy server always acts in conjunction with a _________. Firewall
The ________ provides network security by preventing malicious data Proxy Server
134
from entering the network.
135 _________is used for authentication. Domain Controller
136 Access to a set of servers is controlled by the ________. Domain Controller
137 ________is a process of unauthorized entering a network. Hacking
____________ facility provides a customer to access financial Automated Teller Machine
138
transactions in a public place.
Cash Withdrawal,Balance
139 Which is the Function of ATM? Inquiry,Registering requests for
Cheque book
140 Every bank branch should madatorily have a security policy. TRUE
Physical Access,Logical
141 The Operational Controls include controls on ___________ Access,Environmental Controls
Input Controls,Output
142 Application Controls are broadly classified into __________________ Controls,Processing Controls

143 __________controls check that the data entered is complete and correct. Input Controls

144 Reasonableness check is a _________. Input Controls

145 Which of the following is not a module of the CBS? Equity Share management
Performance Guarantee,Deferred
146 Bank guarantees can be __________________________ Payment Guarantee
147 SLR stands for ________________________________ Statutory Liquidity Ratio
________are record of activities that have taken place in the system Logs
148
irrespective of the modules.
Activity performed,User details,Date
149 The contents of a log includes _____________________ and Time
E-mail policy,Firewall security
150 Communication and Operations management must include which policies? policy,Internet policy

Logs of the various activities in CBS can be deleted immediately and also FALSE
151
be accessed by anybody.
152 CRR stands for _________________________ in terms of CBS. Cash Reserve Ratio
Does the IS Audit also include audit of the outsourcing activites carried out Yes
153
in the CBS system?
154 DRP stands for ___________________________ in terms of CBS. Disaster Recovery Planning
_____________are soultions applied when any kind of vulnerabilities Patches
155
discovered in networks in the CBS system.
156 __________can be viewed only by the DBA of an organisation. Database Log
Is performing periodic vulnerability assessment of the networks is Yes
157
necessary?
KYC stands for _________________________________ in terms
158 Know Your Customer
banking.

In CBS, the Accounts Management module deals with Creation of Savings Account,Creation
159 of Current Account,Overdraft
_____________________

160 Soft copy of the ATM journal rolls is called_____________ Electronic Journal
161 The ATM switch consists of a _____________________ computer,server
_______________testing should be done to check the unauthorised Penetration
162
access to the network in CBS.
_________enables transfer of money from one bank to another in "Real RTGS
163
time" and on "Gross" basis.
In _______system money transfers are done on a one to one basis while RTGS,NEFT
164
in _______system transfer is done in batches.
 All the money transfers take place in the books of the Central bank(RBI)
165
_________________
166 EFT and NEFT work on _______________basis DNS
167 ________system of money transfer is primarily used for large transactions. RTGS
In RTGS, the STP generates an ___________for every outbound RTGS UTR
168
transaction.
169 UTR full form _________________________________ in terms of CBS. Unique Transaction Reference

170 STP stands for ________________________________ in terms of CBS. Straight Through Processing
171 CMS stands for ______________________________ in terms of CBS. Cash Management System

Systems audit are important for the

172 Which of the following statements is true? verification of the internal controls

173 The Management Controls does not include ___________ Managing of Assets
_______is supported by advanced technology infrastructure and has high Core Banking Solution
174
standards of business functionality.
175 Which type of joins not available in Access 2010? Full join
A join returns only those rows from both tables that match on the joining Inner join
176
field is___________ in MS Access 2010.
The query returns all of the rows from left table, and also those rows from Left outer join
177
the right table that is known as____________.
The query using ___________ returns all the rows from right table, and
178 also those rows from the left table that share a common value on both Right outer join
sides of join.
179 How can we add a table to the Query Design window_________? Select Design -> Show Table
180 ___________can be considered a questions in a data base. Queries
181 Operands can be_________ in MS Access 2010. Literals,Identifiers,Function
182 In example "Hello"+" " +" everyone" ,hello is _____ Text Literal
183 Length("Ms Access") will return the count of charcters is __________. 9
184 AND ,OR is a kind of ________ in MS-Access 2010. Logical
185 Comparision operators is also known as_______ in MS-Access 2010. Relational
186 LIKE operator works with______in MS Access 2010. Text,Date

187 IN operator is used __________ in MS Access 2010. To match the value to a set of values

Operator precedence is similar to _____ that is follwed in Algebra in MS- BODMAS

188
Access 2010.
___________________ technology is the process of creating and utilizing Data Warehousing
189
the company's historical data.
______________ can be defined as subject-oriented, integrated, time-
190 variant, non-volatile collections of data used to support analytical decision Data Warehouses
making.
________________ databases contain detailed data that is needed to
191 satisfy processing requirements but which has no relevance to Operational
management or analysis.
192 Data in the Data Warehouse is ______________ , not ____________. Static, Dynamic
____________ data contains an historical perspective that is not generally Informational, Operational
193
used by the _____________ systems.
The definition of data elements in the data warehouse and in the data
194 sources and the transformation rules that relate them, are referred to as Metadata
___________.

195 Data warehouses are not the optimal environment for ____________ data. Unstructured

196 Maintenance Costs are high for Data Warehousing. TRUE

 Credit Card Churn Analysis,Insurance
197 Data Warehousing can be used for ___________________. Fraud Analysis,Logistics Management

198 _________________ is the process of extracting patterns from data. Data Mining
___________________ is an approach to quickly answer multi- Online Analytical Processing
199
dimensional analytical queries.
The Output of an OLAP query is typically displayed in a ___________ Matrix
200
format.
______________ companies is planning to support tens of millions of B2C
201
customers with just hundreds of employees.
Increased Complexities,Legal
202 Which of the following is the limitation of Open Source ERP? Complexities,Unsuitable for
conventional applications
203 Which of the following is not an Open ERP software? Open-Project
_____ is the process of integrating all the business functions and ERP
204
processes in an organization to achieve numerous benefits.
________ must consider the fundamental issues of system integration by Manager
205
analyzing the organization's vision and corporate objectives.
206 The more the number of __________, the longer the implementation time. units
Customization of ERP systems is one of the major challenges in auditing TRUE
207
ERP security.
[Link] 9 provides graphical analysis of data which helps the user to TRUE
208
perform deeper analysis.
The user can ________ the company data into multiple companies as per Split
209
financial periods required.
E-Filing of Returns refers to the process of electronically filing your tax Internet
210
returns through the ___________.
[Link] 9 does not allows you to export the ETDS forms in NSDL
211 compliant formats as well as facilitates printing of TDS Forms in Physical FALSE
Form.
212 [Link] 9 offers a data encryption option called _______________. Tally Vault
___________________ is the process of exchanging [Link] 9 data Synchronization
213
between two or more locations.
The Tally website offers _______________, by which a user can Tally Chat
214
communicate with a Tally representative and get required information.
215 [Link] use _______________ for centralised Account Management. Control Centre
The data is transferred between the remote location and the server using a Encryption
216
secured mechanism called __________________.
217 Sales Tax Ledger falls under which Group? Duties and Taxes

218 Alias represents ___________ in Tally.ERP9. Short name,Nickname,Code name

219 If we purchase any Fixed asset in credit, we can pass it from _________. Journal mode
220 To save entry without any amount, we have to use _____________. Allow 0 value entry
Transfer of materials from one godown to another godown, use Stock Journal
221
______________.
222 While exporting Ledgers from Tally to Web Page, we use _________. HTML Format

223 Budget represents _______________________. Estimation,Forecasting,Assumption

224 In Service tax Credit Adjustment (%) should be either ____________. 0.2,1
225 Service Tax Report can be seen from _________________. Display > Statutory Reports
226 Can we allow Expenses/Fixed Assets in Purchase vouchers? Yes
Transfer from Main Cash to Petty Cash we require to pass _______ Contra
227
voucher.
228 Income Tax number of the Company will appear in which report? None of these
229 A business model is not a ___________ model. mathematical
230 OLAP systems use concept of OLAP cube called a ______________ cube multi dimensional
The data which is to be exported from [Link] 9 can be in ________ XML,HTML,ASCII
231
format.
232 In Tally ERP-9 Remote Access is also known as __________. [Link]
Accessing data store on a remote location using Internet in Tally.ERP9 is Remote Data
233
called____________.
234 Tally.ERP9 can be classified user in two categories are___________. Local User,Remote User
Which of the following is not a predefined security level provided by Public User
235
[Link] 9?
The business model is represented in the graphical form using flowcharts, flow diagrams
236
______________ and ________________

Identifying and prioritizing subject

areas to be included in the Data
Warehouse,Defining the correct level
of summarization to support business
237 Which of the following is/are the data warehousing activity? decision making,Establishing a data
warehouse help desk and training
users to effectively utilize the desktop
tools

___________________ is the succession of strategies used by Product Life Cycle Management

238
management as a product goes through its life cycle.
_______ integrates supply and demand mangement within and across SCM
239
companies.
__________ includes transportation from Suppliers and receiving Inbound Operations
240
inventory.
241 Which of the following is not the service area of SCM? CRM
Which step of the ERP implementation involves, educating and recruiting
242 Step 2
end users throughtout the implementation process?
The system ____________ process will address issues such as software installation
243
configuration, hardware acquisition and software testing.

A __________________ review is recommended to ensure that all post implementation

244
business objectives established during the planning phase are achieved.

In _________________ stages, auditors have access to rudimentary ERP post implementation

245
tools and capabilities for auditing security configurations.
Immediate posting and updation of books of accounts as soon as the Real Time Processing
246
transactions are entered. This is called as __________
Form 26, Annexure to 26,Form 27,
247 Which of the following ETDS forms are available in [Link] 9? Annexure to 27,Form 26Q, Annexure
to 26Q
The exported eTDS file from [Link] 9 can be validated through NSDL's File Validation Utility
248
freely downloadable utility called __________________
249 ERP systems provide an access to the__________ data integrated
250 Business intelligence systems are ________ Decision Support Systems. data-driven
Data warehousing technology is the process of creating and utilizing the historical data
251
company’s __________
The data in the Warehouse comes from the _________ environment and operational
252
external sources.
In essence, SCM integrates ___________ management within and across supply and demand
253
companies.
_____________ including all fulfillment activities, warehousing and outbound operations
254
transportation to customers.
Customer Relationship Management is a ________________ level corporate
255
strategy.
256 Operational CRM provides support to ___________ business processes. front office

Collaborative ______ ultimate goal is to use information collected by all CRM's

257
departments to improve the quality of services provided by the company.

258 [Link] 9 follows the DES __________ method to safeguard the data. encryption
Immediate posting and updation of books of accounts as soon as the Real Time Processing
259
transactions are entered. This is called as __________
Form 26, Annexure to 26,Form 27,
260 Which of the following ETDS forms are available in [Link] 9? Annexure to 27,Form 26Q, Annexure
to 26Q
The exported eTDS file from [Link] 9 can be validated through NSDL's File Validation Utility
261
freely downloadable utility called __________________
With ______________ technology the characters are reduced in breadth
262 and user is allowed to input additional characters which would make the Tally Fit
account name, entity complete and readable.
In [Link] 9 __________________ provides the user with administrator
263 rights and the capability to check the entries made by the authorised users Audit Feature
and alter these entries, if necessary.
__________________ is an enabling framework which establishes a
264 connection through which the remote user can access the Client's data [Link]
without copying/transferring the data.
If we want the company to be connected automatically for remote access Contact On Load
265
on load, the property __________ needs to be set it as Yes.
266 _______ is centralized Banking Application Software. Core Banking Solution
_________has several components which have been designed to meet CBS
267
the demands of the banking industry.
Core Banking Solutions is a combination of an application software and
268 Network devices
________
______ is a large data housing infrastructure that provides high band width Data Centre
269
access to its clients.
Application servers,Data Base
270 Data centre servers are known as_____________. Servers,Web server
________ is a method of creating virtual networks within a physical VLAN
271
network.
Data communication between ______ VLANs can be controlled as per 2
272
business requirements.
273 Bank mate is developed by the _______ HCL Technologies
CBS Software resides in a Central application server which is located in Central Office Data Centre.
274
the ___________
A________ that runs the core banking solutions (CBS) and is centrally Central Application Server
275
accessed by the branches.
The _________of the application is capable of only entering the data at Client version
276
the end point that is branches.
The application server would be placed in a trusted inside zone in a Virtual Local Area Network
277
separate ____________
278 Application software would access the ________ Data base server
__________ are capable of being connected only when devices are Virtual Networks
279
connected to a switch.
A special feature of STP is that _____________ number for any outbound Uniform Transaction Reference
280
RTGS transaction is generated by the STP System.
_____________refers to the process of developing software which would
281 produce the required output from the input provided of course, using the System Development
necessary hardware and communication systems.
The______________is essential to ensure that computer security records Log management
282
are stored in sufficient detail for appropriate period of time.
Which of the following is “False“ in case of penetration testing in an IT Ensure recoverability of data in case
283 of system failure.
environment of CBS?
 It is important that correct latest
Which of the following is erroneous statement in case of Change version of programe is used but
284
Management Control? version number need not be changed.

With respect to the customer changing the Pin at the ATM which procedure Old offset value used to derive new
285 PIN.
is the ”false“ procedure?
IN CBS, changes to the application server are not made directly to it, Test Server
286
instead done first on a __________
All the various servers in the central data centre are seggregated through VLANs
287
_______

The __________ is a complete process in the computer so that it ensures Validation

288
that data that is fed in conforms to certain prerequisite conditions.

When the central Data base is busy with central end of day activities or for
289 any other reason, the file containing the account balance of the customer Positive Balance File
is sent to the ATM switch. Such a file is called __________
290 The IBDS is located in a ____________ demilitarised zone
291 The main components of Internet Banking system consist of __________ Web server,IBAS,IBDS
Copy of the Anti Virus Software was updated promptly and regularly at the
292 Data Centre and pushed into all of the servers and in all the systems in the Push-pull method
branches by ________
The __________which is also residing in the server at the branch actually Application Software
293
does the banking operations.
In Core Banking concept all the systems of the bank are connected to the
294 Central office by means of a connectivity which may be either a Leased line
_________ or a dial up line.
The ________ is generated by the software and directly sent to equipment Personal Identification Number
295
for printed the Pin Mailer.
____________would also include the existence of built in controls in the
296 system to ensure proper processing of input data so as to provide the Process Control
required output.
____________refers to an arrangement wherein the issuing bank acts on Letter of Credit
297
the request and instructions of a customer.
_______________ is a process by which the bank ensures the Business Continuity Planning
298
maintenance and recovery of operations.
299 At which phase of testing the version of software is called “ beta version”? Programmer testing,User testing

In an Organization structure of IT Department which of the following Network administrator and Database
300 Administrator.
function is incompatible?
The number that is stored in the ATM switch is the difference of which of Pin No - Natural Pin
301
the following number?
The information retrieval of transactions taking place at ATM located at Soft copy of Electronic journal
302
remote locations is through _________
The number that is generated as soon as the customer inserts the card in Natural Pin
303
the ATM machine is __________
304 Which is not a Database management system. Unix
305 The _________ operator is used to find the null records in a table. IS NULL
When you create relationship between two tables, the Common field's data Same data type
306
type should be
307 SQL stands for____________________. Structured Query Language
MS Acces 2010 reads and writes to the .accdb file format in chunks also Pages
308
known as_____________.
309 DDL stands for ____________ Data Definition Language
310 DML stands for _____________ Data Manipulation Language
311 Whenever a tables gets update, the dependent query will update automatically
To extract the records based on date field, which of the symbol should be #
312
used
313 The data can be entered into a table in the ____________ view. Datasheet
314 In a Query the data can be sorted based Single column,Multiple columns
When you create a field using text data type in MS Access 2010, by 255
315
default field will have ____ character.
If we are using the same table for main query and sub-query,we need to Alternate names to the tables,Aliases
316 name to the tables
provide___________.
317 Update Query can be used to update_________ in MS Access 2010. Single Record,More than 1 record
318 Delete Query can be used to delete Single Record,More than 1 record
319 How many Primary key constraints can create in a table______. Only one
Unmatched Query can help to find records that have no corresponding TRUE
320
reord in other tables.
MS Access 2010 provides queries that can be used for obtaining the Sum(),Count(),Avg()
321
aggregated results instead of individual records are____________.
A function that Counts the set of values that satisfy the given criteria in MS Count()
322
Access 2010 is___________.
323 Aggreagate Query also known as___________. Group By queries,Total query
324 Which Query wizard is used to find repeated records in a table? Duplicate Query Wizard
325 Append Query is used to ______________ in a table in MS Access. Add Records
How does a query-based report differ in design to a report based on just It doesn’t
326
one table?
Use the Mailing label wizard text
327 How would you include some plain text into a mailing label report? option.
In a Microsoft Access 2010 report, the page numbering would most likely Page Footer
328
be placed into the:
If you wished to present a professionally looking form on screen that would All The tools of the form design
329 show all the necessary information, which of the following form design control gallery.
tools would you most likely use?

Reduces the size of the

database,Optimizes memory usage
What are the benefits of an ACCDE file__________________________ in and improves performance.,Protects
330
Access the VBA code from being viewed or
edited while still allowing it to run.

331 An .ACCDE file is a ___________ version of the original .ACCDB file. Locked-down
Which type of the query is used to accept the value from the user while Parameter Query
332
executing the query and fetch records accordingly
To encrypt the databse in Access 2010 must be opened in the Open Exclusive mode
333
__________________.
334 FIX() is a kind of ____ function in MS-Access 2010. Math
MS-Access 2010 has added new features of ______ to eliminate the need
335 Macro
of VBA code
Encrypting a database does not restrict access to database objects, but to Open
336
__________ the database.
File Tab ->Access Options, and
The setting for the Security option can be handled selecting the Trust Centre tab from
337
using_______________________ in Access 2010. the Access Option window
Third Party Encryption Technology can also be applied to the database of TRUE
338
Microsoft Access 2010.
339 To create a split database in MS Access 2010 go to which tab? Database Tools
340 After spliting database,frontend database holds_________________. Forms,Query,Report
341 After spliting database,backend database holds_________________. Tables
When an Access database is split, it creates two A back-end database & front-end
342 database
files_________________.
A Data Access Page is a special type of _________ that allows users to Web page
343
interface with database using Internet Explorer.
 MS Access provide__________ datatype to create link to a web Hyperlink
344
page,file,or email address.
Set as Switchboard startup Option in
345 To make a switchboard appear while opening the database. Access Option
To add or delete buttons to Switchboard, which option is used in Edit Option
346
Switchboard Manager is used.
The Switchboard Manager is a dialog box that allows creating a TRUE
347
switchboard for an Access database.
348 A macro can automate data entry in Access 2010. TRUE
349 Which of the following data-type is not available in MS-ACCESS AlphaNumeric
350 The validation can be defined at____________ level in Access 2010 Table,Form
A macro can be attached to an event of a A form,A report,A button
351
control_________________________.

Click->File tab->Option Button->Quick

Access Toolbar->Command not in
352 How to add switchboard in Access 2010? Ribbon->Switchboard Manager->Add-
>OK
The command Design Application performed action____________ on Opens the Switchboard Manager.
353
switchboard.
Switchboard Manager only allows a maximum of __________command Eight
354
buttons on a switchboard
MS Access 2010 provides a __________pane that contained large list of
355 actions to be chosen,enabling a wide range of commands that can be Action Catalog
performed
356 SQL is considered to be a __________ 4GL
Which action in MS Access macro applies a fliter or query to a table,form ApplyFilter
357
or report.
Opens a query in the Datasheet view, Design view, or Print Preview which OpenQuery
358
macro action used in MS Access.
Among +, <>, MOD, AND, <= operator which operator has the highest MOD
359
priority.
360 The Strcomp() function is a__________type function. Text
361 The SGN() function is a ____________ type function Math
362 Which of the following symbol is used to write a sub query ()
For the Non-Aggregate Total field, the criteria can only be specified using TRUE
363
the Where clause.
To export an access table to an XML File, which of the below steps must Right-click the table and select Export
364 ->XML
be followed?
In IDEA, import Assistant wizard is used to import data Excel,Access,XML
365
from____________.
File->Import Assistant-> Import to
366 What is the procedure for importing data into IDEA ? IDEA
text,database,spreadsheet and mail
367 IDEA exports data in a number of _______________________. merge format
In IDEA,Data Extraction select data form a file for further___________ for Investigation
368
creating a new file of logically selected records.
369 What is step by step procedure for using Bendford's law function in IDEA ? Analysis->Benford's Law

Comprised of similar sized values for

similar phenomena.,Without built-in
minimum and maximum
370 A Benford's Law analysis is most effective on data________________. values.,Without assigned numbers,
such as bank accounts numbers and
zip codes and with four or more
digits.

371 In IDEA, blank value data can be extracted by using_________. @isblank()

 In IDEA, Summarization, Pivot Table, Stratify, Duplicate Key functions Analysis
372
comes under which menu.
In IDEA, Extraction, Sort, Indices, Search functions comes under which Data
373
menu.
Text files that are organized properly fall into one of two types Delimited files,Fixed-width files
374
are__________
To create an unmatched Query using wizard, minimum required number of two
375
table or fields is_________.
Only one,More than One Field,As
376 While creating the query, the criteria can be set in many field
In MS Access query which logical operator returns True if both the AND
377
expressions compared are true.
In MS Access query which logical operator returns True if either of the OR
378
expressions compared are true.
379 Enfore Referencial Integrity option is used to restrict enerting data in Child Table
380 In MS Access left("Access",3) function will return__________. Acc
Which function is used to converts the text to lower case in MS Access Lcase()
381
2010.
Which function is used to remove leading or trailing spaces in a text in MS Trim()
382
Access 2010.
_____________ is contains a set of predefined functions in MS Acccess Expression Builder
383
and helps build complex expression.
384 Which of the following is a Database Software Oracle

Each column has a specific range of

385 Which of the following is not the characteristics of a Relational Table? values known as the Tuple domain

386 Which record will be retrieved if the query criteria is < #1/1/11#? Records with date before 2011
The tab in Expression Builder in which we write expressions is known as Expression Box
387
_____________.
388 The criteria expression LIKE?B*. Will match all text starting from B
__________ queries are useful for summarizing information, and are Crosstab query
389
somewhat similar to pivot tables in MS-Excel.
While entering record in Datasheet view, in which order the records can be At the end of the table
390
entered
391 When you delete the record in form, it deletes the record from__________. Form & Table

392 Having clause is used in the aggregate query in MS Access 2010 TRUE
The controls that are not linked to any field of the table or query on the Unbounded Controls
393
form are known as ________.
Which property of the form can be used to insert a background image in Picture
394
MS Access 2010?
___________ is a report that is inserted in another report in MS Access Inside-Report
395
2010.
A bound main report is based on a ______________ and its Table or query,Sub-Report
396
_____________ contain realted information.
A___________used to compare multiple values of categories or Column Chart
397
differences over a period of time.
398 A________used to compare trends over a period of time. Line Chart
To create a read-only copy of the database, which of the following file .ACCDE
399
format can be used?
The database administrator created a split database and created a front-
400 end database and back-end database [Link] of the file should be Back-end database
stored on the server ?
To make database package and digitally sign using which option in Access File->Save&Publish->Save Database
401 as->Package and sign
2010 ?
In which formats can the Collect Data through email message feature can HTML and InfoPath
402
send the data entry form?
 Once a mail is sent using the collect data through email message feature
403 in Access 2010. The mail status can be checked Manage replies
using________________.
The ___________ type of data cannot be collected using Collect data
404 AutoNumber
through email messages.
405 What is the memo data type field used for? For long text entries
Those records that match an entity in
406 The filter By selection feature allows you to filter: a field
407 Which editor was provided for use with Access Basic? Notepad
Click the report, and on the Pivot
How do you update Pivot Table report data after changes are made to the Table toolbar, click the refresh data
408
source data? button

Datasheet View,Design View,Pivote

409 What are the different views to display a Table ? Table & Pivot Chart View

Which Of The Following Creates A Drop Down List Of Values To Choose Lookup Wizard
410
From?
A __________ Enables You To View Data From A Table Based On A Query
411
Specific Criterion
The Database Language That Allows You To Access Or Maintain Data In A DCL
412
Database
Authorizing Access And Other Control
413 DCL Provides Commands To Perform Actions Like Over Database
414 Which is not a Database Model ? Structureed Database Model
415 Which Of The Field Has Width 8 Bytes? Date/time
This Is The Stage In Database Design Where One Gathers And List All Data Definition
416
The Necessary Fields For The Database Project.
The Third Stage In Designing A Database Is When We Analyze Our Tables Relationship
417
More Closely And Create A ___________ Between Tables
What is the purpose of the Switchboard Manager in Microsoft Access To build a main switchboard form that
418 controls all other forms.
2010?
Identify an audit finding w.r.t.
419 Which of the following is a benefit of using CAATs? materiality in an IT environment
420 Is there a fixed qualification for internal auditor_________. FALSE
__________________ refers to use software/applications to automatically
perform tasks such as accounting,preparing trial balance, financial Office automation
421
statements etc. and electronically transmit data or information using
internet..
________,___________,__________ are commonly referred to as CIA in Confidentiality,Integrity and
422 Availability
information security parlance.
_____________means information available in the organization should not
423 Integrity
be altered or modified by unauthorized personnel.
The process of identifying an individual, usually based on user id and Authentication
424
password in an organization is called______________.
Which of the following is not a software equipment required in a CA's None of the Above
425
office?
426 Which of the following is not an application arranged by ICAI? ICAI-TOC
427 How many stages are there in the sales cycle? 3
428 PBX stands for ________ Private Branch exchange
429 Which of the following will not appear in the home page of K-Doc? Paste Document
To change an email header so that the message appears to have
430 originated from someone or somewhere other than the actual source is Email Spoofing.
known as___________.
431 To playfully satirize a website is known as_____________. Web spoofing
_________is the complete package to manage the billing requirements of Billing and Accounting software
432
a CA firm on cash system of accounting.
433 Which of the following is not a/an feature of eSecretary? Share certificate printing
434 Annual return preparation can be done using ________. ICAI-ROC application
________is correspondence automation & management software that is eSecretary
435
seamlessly integrated with Microsoft Office.

________ is an independent,objective assurance and consulting activity Internal auditiing

436
designed to add value and improve an organization's operations.

Financial reporting,Operations of the

437 Which of the following is/are the main purpose of the internal audit? organization
As per _____________of the Income tax Act,every person carrying on
438 business or profession is requires to get his accounts audited by a CA Section 44AB
before the "specified date".

439 FEMA Stands for _______________. Foreign Exchange Managament Act

Which application helps the management to allocate the revenue to the Client management
440
credit of the right employee who identified the opportunity?
441 Who has full privileges in the financial accounting application? System administrator
_________is the centre point of the financial accounting application as any
442 transactions having financial impact carried out in any other module will GL module
reflect in this module.
In Financial Accounting Application,the transactions flow from GL (General FALSE
443
ledger) to other modules.
Which of the functionalities is not provided in the purchasing module of Comparison with budgets
444
Financial Accounting Application.
In Financial Accounting Application,automatic sequence number of Expense Management
445
documents control is not required in which of the following module?
Which module of Financial Accounting Application can be used for Sales
446
assigning credit limit to customers?
447 Which of these will trigger/alert for timely payment ? Expense Management
We can manage interviews,offers and job vacancies by using which of the HR and Payroll applications
448
application?
___________provides information about updation of project cost based on Timesheet application
449
time spent by employees on various projects.
Employee designation and reporting
450 Which of the follwing is not a/an functionality provided by PMS? structure
___________automates the calculation of salary for taking inputs from the
451 timesheet application, leaves from Leave Management System and salary Payroll System
details from the HR master data.
452 Which of the follwing is not a control in Leave Management System? Error free capture of leave details
453 Permanent Audit File are obtained once but updated on __________basis. yearly

Copies of clients’ incorporation

454 In Permanent Audit file, _______ is not the key data documented. documents like MoC

Role based access,Complete audit

455 The Document Management Sytem offers the features___________. trail,Cost effective to maintain the
documents in soft copy

________is a type of training in which user logon on the training server E-Learning
456
with a user ID and password.
In some cases, trainee is supposed to appear for the examination/test at E-Learning
457
the end of the training is____________.
458 ________ are the hardware/infrastructure equipments used in a CA firm. PC,Application Server,WAN

459 Which of these is/are the standard email program used in an organization? Microsoft Exchange,Lotus Notes

Compared to LAN, its transmission

460 Which of the following is not a characteristics of WAN? speed is low
 _________is protection of information assets from threats to preserve their Information Security
461
value.

462 Which types of information assets need to be secured in a CA Office? Client data,Own data,Own documents

The extent and level of _________ would depend on the nature of Confidentiality
463
information.
__________ of information might be affected due to denial of service Availability
464
attack or some other reasons.
__________means the sender cannot deny having sent a message and Non-Repudiation
465
receiver cannot deny receiving the message.
466 Risk may not be _______ in nature. vulnerable
467 In IDEA, Append functions can be used to_________. Add data at the end
468 In IDEA, Statistics functions can be applied on_________. Numeric Data,Date Data
In IDEA, increment value in Stratification function can be fixed or free TRUE
469
interval.
470 In IDEA, Stratified Random functions is a part of which menu. Sampling
471 Which of the following is not an Audit Software Unix
Using which functions to perform more complex calculations and exception Equation Editor
472
testing in IDEA?

File->Print->Create Report,Click on
473 Which is the step by step procedure for reporting in IDEA. Create Report button on the
Operation toolbars->Report Assistant.

Items of audit interest,Data

474 Which of the following are categories of computer audit function ? Analysis,System validation
475 In the following list which is not an audit function ? Export
476 In the following list which is a audit function? Stratification
Review Programming
Which is the following step involved in a source code review standards,Understand program
477 specifications,Formulate flaw
methodology ?
hypotheses
478 In IDEA which functions should be used to find repeated values ? Detection
Numeric Data,Date Data,Character
479 In IDEA, Stratification functions can be applied on which type of data ? Data
In IDEA,Summarization accumulates the values of Numeric fields for Unique Key
480
each____________.
In which sampling,selecting sampling units using a fixed interval between Systematic
481
selections is_______________.
Ensures that all combinations of sampling units in the population have an Random
482
equal chance of selection is____________.
In Audit tool, to built relation between two tables, both table should Common Field
483
have_____________.
484 Input Control method is a part of Application Control Group. TRUE
Which is the following type of check that can be run when data is input Field check
485
through terminal ?
Which is the following is the correct types of Field checks on processed Overflow,Range,Sign Test
486
data ?
Which is the following is the correct types of Record checks on input Resonableness
487
data ?
488 Which is the correct types of Batch Checks ? Control Totals
Data Integrity,Controls are required
489 Which is the need for table level tests ? for authorization
 This may make the entire child tables
referenced by the master field in the
490 Which is the following is the major points with respect to inter table tests ? main table un-available,Their Master
& Child relationship reference the
table from one another

Which is the software used by the auditor to take a view of a file of data or Snapshots
491
transaction passing through the system at a particular point of time ?

Which is the software used by the auditor to compare the source version
492 Souce comparison
of a program with a secure master copy ?
Which is the techniques whereby the auditor arranges or manipulates data
493 either real or fictitious, in order to see that a specific program or screen On-line Testing
edit test is doing its work ?
Which is the software used by the auditor to list un-used program Mapping
494
instruction ?
Which is the software used by auditor to read and analyze records of Log Analyzers Software
495
machine activity ?
Lack of Visible Transaction
496 Which of the following reason strongly call for Control & Audit Function ? Trail,Absence of Input Document
497 Which is the correct types of Field checks on input data ? Both type
To ensure the input data is valid
498 Which is the major points to be consider with respect to System tests ? before entering the value
In Data analysis techniques, which law is used to idenfity statistical report Benford Law
499
on numeric data ?
500 Which is not a feature of File reorganization with an auditor perspective? Filtering

Identify data, which are not in

501 What do you understand by the term, “Data Consistency” in using CAATs? agreement with the regular format.

Functions involving use of arithmetic operators, which enable performing

502 Arithmetic function
re-computations and re-performance of results is an example of?
Subjects [Link] No. of Ques Weightage Hrs
Auditing in an ERP Environment 1-161 54 27 24
Advanced DBMS 162-231 26 13 12
Advanced Excel 232-321 40 20 18
Excel as an audit tool 322-381 40 20 18
ERP 382-474 40 20 18
200 100 90

1 161 161
162 231 70
232 321 90
322 381 60
382 474 93
474
Weightage based on no. of hours
26.6666666667
13.3333333333
20
20
20
100