S.

NO
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
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
 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 sta
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 to
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), V
______________ 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
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 audito
During subsequent years of the audit, when GITCs and relevant Business process controls are tested & effect
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 requiremen
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
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
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 onoperatio
__________ refers to the separation or distribution of job roles among employees in such a way that incompat
___________ are typically regular employees who carry out day-to-day business operations and transactions
________ 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 activ
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
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 t
Roles offer an easy to understand, fast and reliable way to manage user access to an ERP. This feature is
A ________ represents a high-level grouping
A _________ is the more granular internal technical grouping of authorisations, permissions and access righ
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 sens
______ 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__________
 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 int including the entity's ext excluding the entity's int excluding the entity's ext

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 locinterfaces between the apsecurity within the applicaAll the above

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

SA 330 SA 300 SA 610 None of the above

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

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

nature of business outsourced processes volume of transactions ar Systems distributed withi

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

audit strategy audit procuedure audit evidence None of the above

1 FALSE
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
Program change Access control Data center and Network Application system acqui
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 access of daTemporary access Unauthorized changes to Direct data changes

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

Types of control Timing of test History of errors and expeRisk management
How is the department orHave formal IT policies a How does IT communicateAre a the employees traine
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

All change requests Approved change requestMajor changes None of the above
system administrator database 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 between sy Data transfer between sy Either A or B Both A & B
accuracy of data completeness of data the validity of the transac 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
Debit=Credit depreciation 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 process nato look into the process f a walkthrough of the contNone of the above
Entity Personnel to perforAuditor to test a relevant Auditor to perform substaAll 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 FALSE
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 GITC are effec Controls in Business ProceBoth A and B Either A or B
se16 se16n sa38 All the above
vendor company finance controller IT personnel
alert change management file backup
controls, compliance controls, efficiency completeness, accuracy accuracy, impact
no further testing need t reliance can be placed on Both A and B None of the above
used by management to mfor compliance purposes relied upon by the auditorAll the above
adopt appropriate controladopt substantive audit p 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 change sappropriate date of changappropriate approvals shou appropriate report output
Standard Reports Customised Reports Database Queries None of the above
Database Queries Custom Reports Standard Reports None of the above
controls in all domains of there are no relevant defi controls are ineffective in all domains of GITC's
Inclusion of Period and EnCompany Policy New ERP implementation All the above
One Sample One Sample in each ScenaAppropriate substantive 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 ignore the deficiency record the deficiency should evaluate the impact
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 ManagemenInventory Management Materials 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 segregatioOpen items Master data All of the above
When reviewing general
During pre-implementatioIT Controls Both A& B None of the above
Documentation Allocation of Budget Configuration Technical Migration
Procurement & Inventory Material & Inventory Migration and Inventory None of the above
QuickBooks Microsoft Dynamics Open Bravo All of the above
Information processed by Information planned by enInformation projected 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 VouchersMissing Journal Vouchers Match Journal 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 Journal EnNon Standard Journal EntrNon Sensitive Journal EntrNon Segregated Journal En
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 and Timing of passing the
entries Business teams entries All of the above
Personal gain such as Debts requirements for
Sales Targets Bonus, incentives etc. banks etc. All of the above
Ask close ended Ask open ended
questions No discussions required questions None of the above
Risk of Material Risk of management Risk of lack of sensitive Risk of lack of
misstatement override of controls access 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-Monetary
Non-Debt Requirements Monetary Requirements Requirements Debt Requirements

Developer Scripts Software Scripts Testing Scripts Hardware Scripts

Automated command lan Automated control languaAutomated corrected lan Automated computer lan
 ANSWER
C

B
A

D
B
A

B
B
D

A
D

B
C

D
B
C
D

A
D
C
C
B
B

C
B

B
D
D
B
C

B
D

B
D
B
A
D
D
A
B

C
B
D
A

A
C
D
A
C
A
B
C
A
A
A
B
C
D
D
B
C
D
A
B
C
C
C
A
A
B
B
C
C
A
C
D
B
B
D
A
B
D
B
C
D
C
B
D
D
C
C
A
B
B
C
D
B
C
D
C
A
A
B
C
D
A

C
B

A
D
B
A
C
B

C
C
B
D

C
A
A
A
D

A
C
A
D
B

D
A

A
B

A
D
C
B
B
C

B
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 sh
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 th
________ controls are usually graphical objects that do not operate as standalone solutions, and they run only in the
___________ 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 co
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 p
_______________ 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 int
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 TRUE B
1 FALSE A
0 TRUE 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 FALSE A
1 FALSE B
0 TRUE 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 FALSE 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 FALSE 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 FALSE 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 LanguaEXtensible Markup Langu EXtensible Makeup Langu C
W3C W1C W2C W4C A
C HTML C++ JAVA B
1 FALSE 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 FALSE B
(.xml) (.xsd) (.xlm) (.mlx) B
Visual Basic for Applicatio Visual 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 depreci 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 depreci 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 Point Break Equal Point B
1 FALSE A
= n / (1+a) - r = 1 + (1/r) * n = 1 / (1+a) ^ 2 = 1 / (1+r) ^ n D
1 FALSE 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 FALSE 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 FALSE B
1 FALSE A
Total Principal Value Per value Total Interest Value Total Number of Periods D

Pivot Table Solver Scenario Macro D

1 FALSE 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 val p-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 depre"no_switch" argument is ' Both A and B either A or B C

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

Goal seek scenario manager Data Table None of the Above C

3 1 4 2D

NPV(10%,10000,3000,4200
NPV(10,-10000,-3000,-420NPV(10%,-10000,6800,420NPV(10%,-10000,3000,420D
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 theThe search is alwaThe column index A n ll 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_numberrow_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 mC
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 red 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 iBoth 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 FALSE B
We cannot insert rIf the number of r Pivot Tables Upda All 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
16 Which of the following is/are the data warehousing activity?
20 Data Warehousing can be used for
35 Which of the following is the limitation of Open Source ERP?
53 Which of the following ETDS forms are available in [Link] 9?
55 The ETCS forms available in [Link] 9 are _________ and ____________
75 To utilize [Link] in [Link] 9, which of the following is the pre-requisite?
77 Which of the following will be displayed in the List of Companies screen?
85 Which of the following is the advantage of the Control Centre?
 Option-A Option-B
Option-C Option-D Ans
Identifying and prioDefiniEstablis All of the above D
Credit Card Churn InsuraLogisti All of the above D
Increased ComplexitLegal UnsuitabAll of the above D
Form 26, Annexure Form 2Form 26All of the above D
Form 27E Form Form 26All of the above D
Configuring [Link] Authori All of the above D
Company Name Accoun Serial All of the above D
Surrender, Confirm Manage
o Create uAll of the above 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

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
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
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 A
______ deals with the auditor's respnsibility to design and implement responses in the form of audit procedures i
The audit procedures are required for the _______
A/An ______system inherently means that all the modules within the system are seamlessly connected with each
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
Say of controls
whether TRUEisor
anFALSE?
_____ to test the effectiveness of a control used by a client entity to prevent or detect ma
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 ne
______ controls are basically manual controls that make use of some form of data or information or report produ
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 func
_____ 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 managemen
______ 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
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 statemen
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 man
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 bu
The Key Phases in any ERP migration project will consist of planning,system design,________,Testing and Go Liv
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-e
__________ 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
The auditor may consider using the work performed by internal auditors in accordance with guidance given in __
How many types of journal
_________transactions entriestoaresales,
pertaining therepurchases,
? 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 pas
_____________are residing outside the books – for example in excel sheets etc. and may impact the financial state
If the journal entries are passed using a specific journal type then a list of such entries can be extracted from th
ERP/application should have ________ many fields and the company must be entering data in these fields for them
_________ the entries passed during the year to the balances in the Trial Balance. The auditor may use ACL/ID
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 b
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 te
______________ to be achieved may be a key fraud risk factor from an investor/ stock holder perspective leading t
_____________ 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 t
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
____________ is one of the core principals of finance and is the primary factor used in pricing a stream of cash flo
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 f
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,
_____________________ 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 lon
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 agen
__________ 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 ris
It is a technique used to determine how different values of an independent variable will impact a particular depe
_______ involves computing different reinvestment rates for expected returns that are reinvested during the inv
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 analy
________ 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 predefi
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 b
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 differen
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, lia
This ratio shows ability of company to pay back long term loans along with interest or other charges from generati
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 findo
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
A businessman planned to get a loan Rs.1800000. If he get a loan at 8% interest for 6 years, Monthly Installment w
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
______ 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 Fr
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 us
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 left
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
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 t
________________ 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
Information systems can be designed so that accurate and timely data are shared between functional areas. Th
The approach to ERP is to first develop a ____________________ comprising the business processes or activities th
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 facilit
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
________________ databases contain detailed data that is needed to satisfy processing requirements but which ha
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 rel
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 ma
_______ 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 department
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
________ must consider the fundamental issues of system integration by analyzing the organization's vision and co
ERP ________________ requires organizations to reengineer their key business processes reengineering of the exis
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 sof
A __________________ review is recommended to ensure that all business objectives established during the plan
In _________________ stages, auditors have access to rudimentary ERP tools and capabilities for auditing securit
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 a
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
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
With ______________ technology the characters are reduced in breadth and user is allowed to input additional
The [Link] 9 __________________ provides the user with administrator rights and the capability to check the en
[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
__________________ is an enabling framework which establishes a connection through which the remote user can
[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 u
A chartered accountant as an __________________ is exposed to various operational risk factors viz., time, increas
The ____________ edition provides the Chartered Accountants with Tax Audit and Statutory Compliance tools whic
Generate Annexure for Tax Audit under Sec _____ using Auditors' Edition of [Link] 9, a Chartered Accountant ca
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
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 starting [Link] 9 the Gateway of Tally screen appears displaying the Edition and Users are under Version
______________________ 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 ANSWER
SAP Oracle All the above None of the above C
SA330 SA315 SA300 None of the above B
including the entity's including the entity's excluding the entity's excluding the entity's 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 All the above B
less many moderate All the above B
due to the number andinterfaces
l between thesecurity within the applAll the above D
142,internal controls s 143,internal financial c 142,external controls s 143,external financial B
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 pl integrated Enterprise r Entity resource planninNone of the above B
one,few many,all one,all many,few C
nature of business outsourced processes volume of transactions Systems distributed wi D
Indian Standard for A International Standard Indian Standard for Au International Standard B
Payment Compliance Ind Payment Compliance InPayment Card Industry-Payment Card Industry-C
Involvement of key t areas where CAATS mayAll the above None of the above D
audit strategy audit procuedure audit evidence None of the above B
1 FALSE 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 NetwoApplication system acqB
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 ofTemporary access Unauthorized changes Direct data changes B
Information produced bManual controls IT-Dependent controls None of the above B
Types of control Timing of test History of errors and e Risk management D
How is the departmentHave formal IT policie How does IT communicat Are the employees traiD
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 requeMajor changes None of the above B
system administrator database administratornetwrok 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 Data transfer between Either A or B Both A & B D
accuracy of data completeness of data the validity of the tran All the above D
Inherent configurable security embedded A
operation deficiency design deficiency control deficiency communicating deficie B
SA 315 SA 330 SA 265 SA 300 C
Inherent configurable security embedded B
Inherent configurable embedded Both B & C D
Debit=Credit depreciation calculatio 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 processto look into the proces a walkthrough of the coNone of the above C
Entity Personnel to perAuditor to test a relevaAuditor to perform subAll 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 FALSE 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 Business
Processes are
Controls in GITC are ef effective Both 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, accurac accuracy, impact C

reliance can be placed

no further testing needon the report Both A and B None of the above C
for compliance
used by management to
purposes relied upon by the audiAll the above C
adopt substantive
adopt appropriate contaudit procedures Either 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 changappropriate date of chaappropriate approvals sappropriate report outpC

Standard Reports Customised Reports Database Queries None of the above C

Database Queries Custom Reports Standard Reports None of the above A

there are no relevant

controls in all domains deficiencies controls are ineffective in all domains of GITC' C
Inclusion of Period
and Entries Company Policy New ERP implementatiAll the above D

Appropriate
One Sample in each substantive
One Sample Scenario procedures 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 to
management ignore the deficiency record the deficiency should evaluate the impD

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 ManagemeInventory ManagementMaterials Management Accounts Management C
Non-Technical Migrati 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 7 B
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 segregaOpen items Master data All of the above D
During pre-implementaWhen reviewing general Both A& B None of the above C
Documentation Allocation of Budget Configuration Technical Migration A
Procurement & InventoMaterial & Inventory Migration and InventorNone of the above A
QuickBooks Microsoft Dynamics Open Bravo All of the above A
Information processed Information planned byInformation 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 4 A
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 VouchMissing Journal VoucheMatch Journal VoucherManual Journal Vouche 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 JournalNon Standard Journal ENon Sensitive Journal ENon Segregated Journal B
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 eSA/SOD among IT and Timing of passing the eAll of the above D
Sales Targets Personal gain such as BDebts requirements forAll of the above D
Ask close ended questi No discussions require Ask open ended questi None of the above C
Risk of Material misst Risk of management ove Risk of lack of sensitiveRisk of lack of segregat 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-Debt RequirementMonetary RequirementNon-Monetary RequireDebt Requirements D
Developer Scripts Software Scripts Testing Scripts Hardware Scripts B
Automated command lAutomated control lan Automated corrected l Automated computer l A
one two three four B
+ - & * D
[] () {} # B
0 TRUE B
1 FALSE A
0 TRUE 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 FALSE A
1 FALSE B
0 TRUE 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 query Find unique query Find duplicate query B
select query action query other sub queries All of the above D
1 FALSE 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 FALSE 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 Operators Arithmetic 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, OpenQueryOpenTable, OpenForm OpenQuery, OpenRepoOpenForm, OpenReporD

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 9C
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 FALSE A

Sub Query Totals Query Crosstab Query Unmatched Query C

Yes, include column su Yes, include row sums Yes, include Grand TotaYes, include column graB

Crosstab Query Totals Query Pivot Chart Pivot Table D

Expansion Markup Lan Expansion Makeup LanEXtensible Markup LanEXtensible Makeup LanC
W3C W1C W2C W4C A
C HTML C++ JAVA B
1 FALSE C
Direct to Direct Document Type DefinitData Type Definition Data to Data B
Add-Ins Developer Data Review A
(.xsd) (.xml) (.mlx) (.xlm) B
Review Add-Ins Developer Data C
1 FALSE B
(.xml) (.xsd) (.xlm) (.mlx) B
Visual Basic for ApplicaVisual Basic for AppletsVisual Basic for Apple Visual Basic for Auto MA
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 depr For calculation of depr For calculation of depr For calculation of depr B
For calculation of depr For calculation of depr For calculation of depr For calculation of depr A
For calculation of depr For calculation of depr For calculation of depr For calculation of depr C
calculate depreciation calculate depreciation calculate depreciation calculate depreciation D
calculate depreciation For calculation of depr For calculation of depr For calculation of depr A
Point Volume Ratio Point Varaiance Ratio Profit Volume Ratio Profit Variance Ratio C
Balance sheet Even PoiBreak Even Point Balance sheet Equal PoBreak Equal Point B
1 FALSE A
= n / (1+a) - r = 1 + (1/r) * n = 1 / (1+a) ^ 2 = 1 / (1+r) ^ n D
1 FALSE 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 FALSE A
planning for Expenditu 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' digitsD

declining balance VDB SYD SLN A
Virtual Declining Balan Variable Discounting B variable declining bala None C
Double Declining BalanVariable Decling BalancStraight 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 denone 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 samplinB
Clustered sampling Sampling Systematic sampling Simple random samplinC
Snowball sampling Convenience sampling Systematic sampling Simple random samplinD
Region of uncertainty Region of curve Region of confidence None of the above D
Quota Sampling Sampling Snowball sampling Simple random samplinC
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 analysisScenario analysis B
Sensitivity analysis Risk analysis Qualitative risk analysisScenario 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 simulationCorporate Planning Personal Finance plannB
Corporate planning Monte Carlo simulationFinancial planning Personal Finance plannC
Monte Carlo simulationCorporate planning Decision Tree analysis Sensitivity analysis B
1 FALSE B
1 FALSE A
Total Principal Value Per value Total Interest Value Total Number of PeriodD
Pivot Table Solver Scenario Macro D
 1 FALSE 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 columntip wizard B
Goal seek Pivot table Solver Data table. D
Data table Pivot table Scenario Manager Solver B
text import wizard convert text to columntip wizard function wizard B
absolute relative mixed constant A
Consolidate What-if Analysis Calculate Sheet Data Validation D
text import wizard convert text to columntip wizard function wizard A
Balance Sheet Profit & Loss Income & Expenditure None A
Debt Assets Ratio Interest Coverage RatioTotal Fund Ration None B
Return on Investment Interest Coverage RatioTotal Fund Ration Net Profit Margin RatioA
Earnings Per share Fixed Asset Over ratio Price Earnings MultipleGross 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 Test statistic <=critical Test statistic < critical p-value<= a C
VDB(400000,50000,10,1 VDB(400000,50000,1,4VDB(50000,400000,10,VDB(50000,400000,10,1 A
4 1 3 2D
when the stright line de"no_switch" argument B i oth A and B either A or B C
PMT(8%,5,-1000000,10PMT(8%,60,1000000,10PMT(8%/12,60,1000000PMT(8%,60,-1000000,1C
Goal seek scenario manager Data Table None of the Above C
3 1 4 2D
NPV(10%,10000,3000,4NPV(10,-10000,-3000,-NPV(10%,-10000,6800,NPV(10%,-10000,3000,D
XML CSV PDF TEXT C
FV PV NPV IRR C
FV PV NPV IRR D
0.09 0.14 0.1 0.13 C
PV & IRR XNPV & XIRR NPV & IRR None of the above B
SLN DB All the Above None of the above B
DB SLN All the Above None of the above A
Date Month NetworkDays None of the above D
before 2 months after 2 months #N/A None of the above B
YES NO A
Next day previous day same day None of the above C
unequal equal Either A or B Neither A or B B
start date end date Either A or B Both A & B D
excluding Saturday & including Saturday & None of the above A
NETWORKDAYS() [Link]() [Link]() None of the above D
Number Date Number or Date None of the above B
Zero Positive Negative None of the above C
QUOTIENT() MOD() Either A or B None of the above B
QUOTIENT() MOD() Either A or B None of the above A
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 the valThe search is always peThe column index number All the four arguments D
EXACT MATCH APPROXIMATE MATEither 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_number row_index_number Both A & B D
Hlookup Vlookup Match Index D
Lookup value lookup array match type None of the above C
Only one row Only one column one row or one columnmultiple rows or multi C
INDEX() MATCH() Both A or B Either A or B C
It performs left to righ The processing require It can also be used as It avoids data redundanA
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 above A
remained blank where data entry is inc Both A & B None of the above C
MAX LARGE Either A or B None of the above B
Trace Precedents Trace Dependents Either A or B Both A & B D
#NAME? #N/A #REF! None of the above C
Go to special Trace Dependents Trace 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 FALSE B
We cannot insert rows oIf the number of recordPivot Tables Update th All the above C
VLOOKUP() MATCH() INDEX() None of the above A
[Link] Nigrini Frank Benford Mark Benford None of the above B
second first third last B
0.2222 0.3333 0 None of the above D
highest least most probable None of the above B
heterogeneous,homoge homogeneous,heteroge humongous,homogeneoNone of the above A
MEAN MEDIAN MOD LARGE C
Company Enterprise Organization Concern B
Costing Production Sales Resources D
Business Model Business Function Business Process Business Operation C
Integrated Information Isolated Information S Non-Integrated InformaNon-Isolated InformatiA
Business Model Business Function Business Process Business Operation A
charts, pictures smart art, clip art flowcharts, flow diagr graphs, shapes C
Online Analysis ProcesOnline Analytical Proc Online Analytical Pro None of the above B
Data Warehousing Data Modeling Business Modeling Business Intelligence D
Information Systems Integrated Information Decision Support Syst Non-Isolated InformatiC
Data Warehousing Data Modeling Business Modeling Business Intelligence A
Data Models Data Warehouses Data Mines Operational Data B
Operational Non-Operational Subject-Oriented Informational A
Dynamic, Static Non-Volatile, Static Volatile, Static Static, Dynamic D
Operational Data Stora Optional Data Storage Operational Data Store Optional Data Store C
Operational, InformatioOperational, Static Informational, Static Informational, OperatioD
Identifying and priorit Defining the correct le Establishing a data wareAll of the above D
Masterdata Detaileddata Metadata Basedata C
Structured Unstructured Informational Operational B
1 FALSE A
Credit Card Churn AnalInsurance Fraud AnalysLogistics Management All of the above D
Data Analysis Data Warehousing Data Mining Data Modeling C
Business Processing MOnline Analytical Proc Product Life Cycle Ma Supply Chain ManagemB
Matrix Columnar Stepped Outline A
Business Processing MOnline Analytical Proc Product Life Cycle Ma Supply Chain ManagemC
Online Analysis ProcesBusiness Processing Supply Chain Product Life Cycle C
BPM SCM PLM CRM B
Inbound Operations Outbound Operations Sourcing planning Production planning A
Logistics Asset Management PLM CRM D
Operational Analytical Consumer RelationshipSocial A
Operational Collaborative Consumer RelationshipSocial B
Really simple syndicatiReally super syndicatioRare simple syndicatio Rare super syndication A
Revenue on InvestmentReturn on Investment Both A & B None of the above B
B2B B2C C2B C2C B
Network as platform Architecture of participBoth A & B None of the above C
Increased ComplexitiesLegal Complexities Unsuitable for conventiAll of the above D
Openbravo SQL-Ledger Open-Project ERP5ERP C
EDI ERP BPM None of the above B
Manager Auditor Top Management Comm Either A or B or C A
Traps Security Audit Implementation None of the above C
modules process package units D
Step 1 Step 2 Step 3 Step 4 B
implementation upgradation installation migration C
pre implementation under process review post implementation None of the above C
post implementation pre implementation Both A & B Either A Or B A
1 FALSE A
Tally [Link] 9 Both A & B None of the above B
Interactive Processing Immediate Processing Real Time Processing Business Processing C
1 FALSE A
Import Export Split Backup C
Intranet Internet Extranet Any of the above B
We can fill up the deta Select Alt+E from the Either A or B Neither A Nor B C
1 FALSE B
Form 26, Annexure to Form 27, Annexure to Form 26Q, Annexure t All of the above D
File Validation ProgramFile Validation Utility File Valuation Program File Valuation Utility B
Form 27E Form 27 Form 26 All of the above A
1 FALSE A
1 FALSE A
Tally Fix Tally Adjust Tally Fit Tally AutoFit C
User-defined Security HTTP-XML based data iUnlimited multi-user s Audit Feature D
Tally Data Encryption Tally Data Encoding Tally Vault Tally Data Conversion C
Open Database ConnecOpen Database ConnectOracle Database ConneOracle Database Connec B
Serialization Randomization Synchronization Asynchronization C
Tally 4.5 Tally 6.4 Tally 7.2 Tally 8.1 B
Yes No B
Tally Forum Tally FAQ Tally Support Tally Chat D
Direct Web Browser AcWeb Publishing [Link] Email facility C
Data Centre Control Centre Cloud Centre Administration Centre B
Encoding Decoding Encryption Decryption C
Control Centre Data Centre Cloud Centre Administration Centre A
Administrator Auditor Expert Entrepreneur D
Educational Mode Silver Gold Auditor D
44A 44B 44AB Both A & B C
Concurrent multi-linguaReal time processing Data Reliability and A Accounting without CoC
Codeless user interfaceGraphical analysis of d Split Company Data Scalability D
Configuring [Link] f Creating Remote UsersAuthorizing Remote UsAll of the above D
F1 F2 F3 F4 D
Company Name Account ID Serial Number All of the above D
Allow to Connect Com Contact On Load Either A or B None of the above B
Enable [Link] Contact On Load Security Controls Allow to Connect Com C
Calculator Version License Configuration A
two three four five A
Owner Standard User Either A or B None of the above B
Account ID User Name Email ID None of the above C
Data Centre Control Centre Cloud Centre Administration Centre B
Surrender, Confirm or ReManage Jobs and RecruCreate users with predeAll of the above D
Owner [Link] User [Link] Owner [Link] Auditor C
Administrator Owner Auditor User A
Horizontal Bar Information Panel Vertical Bar None of the above B
User Management Change Account AdminProfile Management Licensing & ConfiguratiC
User Management Change Account AdminProfile Management Licensing & ConfiguratiB
Enable ODBC Server can be overridden localWant to set client/servNone of the above C
Alter Account Admin Manage Sites Manage Users Manage Passwords D
[Link] [Link] Authenticati [Link] Auditor [Link] Auditor Auth B
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
Weightage based on no. of hours
26.6666666666667
13.3333333333333
20
20
20
100