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
data analysis is defined as a process of cleaning, trnasforming, and modeling data to discover useful information for busienss
ETL Stands for Extract, Transform and Load
ETL allows business to gather data from multiple sources and consolidate it into a single centralized location.
text analysis is known as text mining
Big data is a term that describes the large volume of data i.e both structured and un-structured data
excel is the worlds most generally utilized spreadsheet programming and part of the microsoft Suite
excel file extension is .xlsx
excel macro enalbed workbook extension is .xlsm
excel binay workbook extension is .xlsb
excel consists of 1048576 rows and 16384 (XFD) Columns
title bar displays the current file name and at the top of the window
Name Box that displays the current cell address
In MS excel the columns letters are from A to XFD
VBA Stands for Visual Basic for Application
the active cell is also called as current cell
from the spread sheet current cell is the cell with the dark border
QAT stands for Quick Access Tool Bar that consists of regularly used icons
QAT is availble at the left side of a title bar
In excel each cell allows upto 15 digits number. it cannot handle numbers larger than that
the default allignement for text in ms excel is left allignment
the default allignement for number is right allignement
data and time are also stored as number type in excel
january 1,1900 is considered by excel to be 1
excel that doesnot recognize the dates before 01/01/1900
the two new data types in ms excel is Stocks and Geography
paste special can be used to paste only values, formula,formatting,column width
you can change the columns into rows in excel using paste Transpose option
ctrl+page down can be used to move to the next worksheet
ctrl+page up can be used to move to the previous worksheet
To hide a work sheet , right click the worksheet tab, and choose Hide
excel name manager option can be used to define a name to the particular range
Name Manager option is available under the Formulas Tab
Name Manager short cut is ctrl+f3
ctrl+t is the short cut key to create a table in excel
Slicers are new feature in ms excel can be used to filter the table data
Slicer option is availble under the Design tab
Data Validation rule that controls the kind of data into a certain cell
Data validation option is avaialbe under the Data tab in the Data Tools Groups
home-> editing -> find and select ----> data validation path can be used to find the cells that have data validation
to remove the data validation use clear all option
excel allows us to sort the various criteria data i.e text, numbers,dates and times, custom list, cell color,font color
Filtering is the way that you can use excel to qucikly extract the data from your spread sheet
variuos types of filters are text,date,number,font color,cell fill color etc
Use Advance Filter option to filter the data of more than one column
Sub Total option can be used to draw specific information rom one or more sub sections of a data base or list
Sub total option is avaible under the Data menu----> Outline sub option
after applying the filters the row numbers turn into Blue color
Cell references are three types i.e Relative reference , Absolute cell reference, Mixed Cell Reference
relative cell address means a2,b2,c3 etc
Absolute cell reference means $A$2
Mixed Cell Reference means column A
left() can be used to extract the given number of charecters from the left side of the selected text String
right() can be used to extract the given number of charecters from the right side of the selected text String
MID() function is also a text category function
len() returns the number of charecters in a text String
__E-Filing_ is the process of filing tax returns for TDS, TCS,GST etc
TDS Stands for Tax Deducted at Source
substitute() replaces existing text with new text in a text String
replace() replaces part of a text String with a different text String
trim() can be used to remove all spaces from a text String except for single space between words
Flash Fill is only avaiblabe in excel 2013 and later . It is a part of Autofill Feature
round() function it rounds the number to a specified digit
roundup() function it rounds the number up away from zero
rounddown() function it rounds the number down from zero
edate() returns next EMI Date
eomonth() returns the month end date
datedif() can be used to calculate the difference between the twodates i.e days, months, years
text() can be used to converts a value to text in a specific number format
vlookup() function looks for a value in the left most column of a table
Vlookup() function v stands for Vertical
Hlookup() function h stands for Horizontal
match() function returns the relative position (row/column) of a value
index() function returns the intersection value of row and column
=abc+100 displays what type of error #NAME?
#DIV/0! Error Appears when a mathematical operation attempts to divide by zero or an empty cell
#REF! Error appears when a cell reference deleted or moved
#NULL! Error is returned when excel can't figure out the range specified in a cell
#N/A error is returned when a function like match() or vlookup() cannot find the value
##### error is returned when a the column is not wide enough space to display all the charecters in a cell
Trace Precendents that affects the active cell value
Trace Dependents that affected by the active cell
Trace Precedents, Trace Depends options are available under the Formulas Tab----> formula Auditing
Conditional Formatting option is available under home menu---> Styles
Conditional Formatting can be used to High light cell ,top or bottom values, data bars,color scales,Icon Sets
How to delete Conditional Formatting Rule=====> Conditional Formatting---> clear Rules
Excel Pivot Table can be used to Summarize, analyze, explore the data
Pivot table cannot be changed automatically. We need to refresh it
Piovt table is available under the Insert menu
CAAT Stands for Computer Assisted Audit Technique
IDEA Stands for Interactive Data Extraction and Analysis
IDEA Software is an example of a CAAT Tool
importing the data in IDEA path is Home Tab-> Import-> Desktop
In IDEA Equation Editor can be used to type the Expressions
Summarization option is available under the Analysis Tab-> categorize-> summarization
Stratification option is available under the Analysis Tab-> categorize-> Stratification
Pivot table option is available under the Analysis Tab-> categorize-> Piovt table
there are 5 different types of joins in IDEA
Sampling in IDEA is broadly statistical abd Probability Based
Systematic Sampling option is available under the Analysis tab-> Sample-> other->Systematic
all IDEA Files extension is .imd
in IDEA Software Duplicate key option is available under the Analysis tab-> Explore->Duplicate Key
In IDEA Software Sorting option is available under the Data Menu

Forensic Accounting and Fraud Detection

Forensic Accounting is a particular of Accounting that explores fraud and examines historical data which can be used in legal p
Forensic Accounting is a sensible blend of Accounting,Auditing, and investigative abilities to conduct financial inquiries
Forensic Accounting us useful for court action and analytical accounting
what are the two major Forensic Accounting Practices ( Litigation support Services,Investigative/Fact Finding Services)
the Forensic Accountants are also known as Certified Forensic Accounting Professionals
SIFO Stands for Serious Fraud Investigation Office
the establishment of SIFO in india has become the turning point for forensic accountants in the country
Fraud is a type of criminal activity, defined as abuse of position or false representation
TGTBT Stands for Too Good to Be True
the fraud triangle is used to explain the reason behind a fraud

Simple interest is quick method of calculating the interest charged. It is fixed throughtout the period
Compound interest is the interest on interest
how to activate interest calculation gateway of tally-> f11->Accounting features-> Active interest calcualtion as "YES"
What is the path To record the Purchase Transaction? Gateway of tally-> accoutning vouchers-> f9
What is the path To record the Sales Transaction? Gateway of tally-> accoutning vouchers-> f8
f2 can be used to change the Date
alt+f2 can be used to change the date Period
ctrl+A to accept all in tally
how to create a voucher class for simple interest/compound interest? From gateway of tally page-> Accounts info-> Vocuher
Interest Paid ledger comes under Indirect Expenses
Interest Received ledger comes under Indirect Incomes
how to check ledger outstanding Report ? Gateway of Tally-> Display-> Statements of Accounts-> Outstanding-> ledger
How to check the Interest Calculation Report? Gateway of Tally-> Display-> Statements of Accounts-> Interest Calculation
Multi Currency Feature Allows to record transactions with different currencies
How to enable Multi Currency? Gateway of Tally-> f11-> Accoutning Features-> Enable Multi Currency as YES
How to create Foreign Currency? Gateway of Tally -> Accounts Info-> Currencies-> create
BOM Represents Bill of Materials
Inventory is typically Broken down into Three Stages i.e Raw Materials, Work in Process, Finished Goods
Manufacturing Processes is the process of conversion of raw materials/Components into finished Goods
How To Activate BOM? Gateway of Tally-> f12-> Acc/ Inventroy Info-> enable Component list Details (BOM) as YES
To Create Manufacturing Journal , Use as Manufacturing Journal as YES
Stock Journal Voucher can be used to Transfer the goods from one location to another location
Manufacturing Journal can be used to Convert raw materials into finished goods
Stock Transfers/Stock Journal Register displays the list of all the Stock Journal Vouchers used in Tally to make stock adjustmen
How to view Stock Transfer analysis: Gateway of tally-> Display-> Inventory Books-> Movement Analysis-> Transfer Analysis
Cost estimation is a statement that gives the value of the cost incurred in the manufacturing of finished goods
How to view Cost Estimation? Gateway of Tally-> Display-> Statements of Inventory-> Cost Estimation-> select Finished Goo
How to enalbe Job Order Processing: Gateway of Tally-> f11-> Inventory-> Enable job order processing as "YES"
Price List are maintained in various structures for different types of buyers, wholesellers,Dealers, Reatilers etc
How to activate the Multiple Price Levels? Gateway of tally-> f11-> inventory Features-> use Mutltiple price levels as "YES"
How to Create Price List? Gateway of tally-> inventory info-> Price List
How to Display Discount column in invoice Vocuher? Gateway of Tally-> F11-> Inventory-> use separate discount column in i
Customer Name Ledger Comes under Sundry Debtors
Purchase Name ledger Comes under Sundry Creditors
How to Enable Tally Audit Feature? Gateway of Tally -> alt+f3-> comp Info-> Alter-> Use Security Control as "YES" -> U
How to Create User Level Security ? Gateway of Tally -> alt+f3-> Security Control-> types of Security
How to create separate Users ad Passwords? Gateway of Tally -> alt+f3-> Security Control-> Users and Passwords
How to Logout the company from different User levels? Gateway of Tally-> Alt+f3-> Shut Company
How to View Tally Audit Satistics? Gateway of tally-> Display-> Statemens of Accounts-> Tally Audit-> select voucher type-> t
TSS Stands for Tally Software Services

Immediate posting and updation of books of accounts as soon as the transactions are entered. This is called as __________
Which of the following ETDS forms are available in Tally.ERP 9?
The exported eTDS file from Tally.ERP 9 can be validated through NSDL's freely downloadable utility called ________________
ERP systems provide an access to the__________ data
The exported eTDS file from Tally.ERP 9 can be validated through NSDL's freely downloadable utility called ________________
With ______________ technology the characters are reduced in breadth and user is allowed to input additional characters wh
In Tally.ERP 9 __________________ provides the user with administrator rights and the capability to check the entries made b
__________________ is an enabling framework which establishes a connection through which the remote user can access the
If we want the company to be connected automatically for remote access on load, the property __________ needs to be set it
________ is an independent,objective assurance and consulting activity designed to add value and improve an organization's o
Which of the following is/are the main purpose of the internal audit?
As per _____________of the Income tax Act,every person carrying on business or profession is requires to get his accounts au
________ is a process used in statistical analysis in which a predetermined number of observations will be taken from a larger
Which function that is used to calculate the payment for specific loan terms ____________
________helps to break down the Return on Equity
_______ is a common method for financing property, facilities, and equipment.
Which option can be used to split windows into four in ms excel 2010?
How to restrict the values of a cell so that only a list can be entered in a cell?
What does the COUNTA() function do in MS Excel 2010 ?
If the value in A1 is "ITT" and in B1 is "ICAI ", which function in Excel will return " ITT @ ICAI " in cell C1?
Which of the following function will return a value of 7?
A tiny chart embedded in a worksheet cell that provides a visual representation of data is a _________
_________is a graphical equivalent of a pivot table, which is used to visualise PivotTable report summary data
To frequently print a specific range of cells on a worksheet , the option used is
Non-excel files can be opened in MS Excel using the
_____is a text concatenation operator.
Which of the following is correct?
___ function in MS-Excel returns the remainder after number is divided by divisor.
In Ms-Excel 2010, ______ is Last Column Name?
In Excel 2010, the default criteria setting for AutoFilter in each field is __________.
Subtotal option is in __________ group of Data tab in Excel 2010.
Which of the following cannot store connection information of an external data source in Excel 2010?
The default pivot chart type in Excel 2010 is a ________ chart.
To consolidate Excel data, ________________________ is used when worksheet data does not have a consistent layout or pa
In Excel 2010, the __________ function is used to generate a forecast.
______function calculates the payment for a loan (installment) based on constant payments and a constant interest rate.
__________ are easy-to-use filtering components that enable the user to quickly filter the data in a PivotTable report in MS-Ex
In Excel 2010, range C3:C6 indicates _______________.
Keyboard shortcut to show a shortcut menu in MS Excel 2010 is _______________.
To select multiple non-adjacent cells in an Excel 2010 worksheet, click them holding _________ key.
A quick way to return to a specific area of a worksheet in Excel 2010 is to type the cell address or range name in the ________
In MS-Excel 2010, the Name Box shows the ________________________.
In Excel 2010, what is represented by the small black square in the lower-right corner of an active cell or range?
Suppose we accidentally erased a record in an Excel worksheet. Which command can be used to restore it immediately?
Excel 2010 offers up to____________sort levels.
Which feature in Excel 2010 enables us to find the input values needed to achieve a goal or objective?
Which of the following statements about scenarios is not true?
What is a scenario summary report?
What does Solver uses in its dialog box?
What term describes a feature that gives Excel enhanced capability?
What dialog box allows you to change a field name in a PivotTable?
Why are PivotTables considered interactive?
In SQL, DML stands for _________
To see more than one record at a time in a form we use _______
The default query invoked by ms-access is
__________ software serves as the Intermediary between the user and the database
Distributed database have now come to know as a __________ database
DDL Stands for -.
In DBMS, view level data abstraction is known as __________
In DBMS, Normalization concept responsible for _______________
one 2 one, one 2 many and many 2 many Relationship exist in _________ model
Record is also known as ________ in a Relational data base
____________ is extention of ACCESS DATABASE
Default length of numeric data type is ____________
Default value option in field property use for ________
Value of Report Header exist on ___________ page of report
__________ is an action or set of actions that you can use to automate tasks
SQL is a _________ Language
Which one is the Second Level of Data Abstraction?
Memo data type store _________ number of characters.
__________ data type field can't be updated
A Record is also commonly called as a _________
Most database operations that we do manually can be automated by using
_________ are what we use to summarize and present data in the table
A database tabel is similar in appearance to a _______
SQL is considered to be a _______
SQL is considered to as an ideal Language for _______
DBMS that supports a database located at a single site is called a _____
DBMS that supports a database distributed across several different site is called a _____
The _________key does not accept Duplicate and Null values in Field.
______ is often implemented as an array of records
In MS-Access 2010,the ________ control in the form lets the user insert a picture into it.
Which query should be used to retrieve the following information from table of databases "Which employees earn more than
Queries in MS-Access 2010 can be used as ________________________.
What is a form in MS-Access?
Which of the following degree of relationship cannot be applied in MS-Access 2010?
In an ER model, a/an ___________ is any object, place, person, event or concept about which an enterprise records data.
The process of arranging data in a logical sequence is called ____________.
If some chunk of data is stored at two places in a database, then ___________.
In MS-Access, what data type can be used for a phone number field in a database?
E-R Diagram is ________________ Model.
Which of the following can be a primary key in an employee database?
Which of the following is a Database Management System?
Which of the following is not a data type in MS-Access 2010?
Which of the following is a New data type in MS-Access 2010?
In MS-Access 2010, __________ queries are best suitable to summarize information and looking for trends.
Which of the following is not a section in Report Design view in MS-Access 2010?
Which of the following is not an action query in MS-Access 2010?
In MS-Access 2010, which data type is best suitable for storing the price of a commodity?
In MS-Access 2010, which of the following data type creates a field that allows the user to choose a value from another table o
In a table, _____________ uniquely identifies each record that is stored in the table.
_________ is used to insert values in Table directly.
DCL provides commands to perform actions like _________.
A database _______ presents summarized information retrieved from a table in a preformatted, attractive manner.
In MS-Access 2010, which type of query extracts the data from one or more existing tables and puts them into separate table?
In an MS-Access report, in which section we can keep the count[Sales] to calculate the total sales for each month?
What is the first step in creating a form or report using the Form Wizard or the Report Wizard in MS-Access 2010?
Which of the following is not an advantage of using a DBMS?
___________ provides in Access 2010 is used to convert database tables to the normalized form.
Which Ribbon command tab includes the Table Analyzer Wizard in MS Access 2010 ?
A Junction Table creates a _______________ relationship between two tables.
The Primary key of one table and the matching column in another table is known as ______________.
In SQL, having clause is used for _________
To compact the database in MS Access 2010, the database must be opened in the ___________.
In MS Access 2010,_________ help protect a database from system failures and against mistakes that the Undo command can
Improving the performance of a database in MS Access 2010 used______________ tool.
The _________ can be used to create reports on database objects for planning and modifying database design.
Use _____________ to grant or revoke permissions or to change the owner of database objects.
_____________ commands are used to enforce database security in a multiple user database environment.
Which SQL clause is used to retrieve data from database?
The __________clause is used to filter records in database.
DCL(Data Control Language) used for
__________is Example of DBMS
The methods LIFO, FIFO, Moving Average are used to ….
The report prepared taking the asset and liability type accounts from the Trial Balance is called….
The report that depicts operating profit/loss for a period is …..
The day book contains transactions relating to ………
The Bills Receivable details are maintained in a ……..
Creditors ledger has details of your dues to ……..
The sundry debtors are placed in the Balance sheet on the ……
The first step in Tally before any transaction is entered or saved is creating a ………
To configure country specific details use the function key……
Identify the security mechanism used in Tally.
The basic document where transactions are entered chronologically is….
After selecting a company in Tally, you will be in the……
Tally software is based on ……… accounting system.
Identify the primary group of capital nature that uses bank account and cash in hand as sub groups.
All financial entries in Tally are done using…….
The Direct expenses, Purchase account, Direct income are primary groups of …..
The option to delete a sub-group is admissible through the menu……
The behavioural attributes of this group cannot be changed.
Credit limits for personal accounts and branches can be done in the ledger mode……
We are not allowed to delete a ledger from this mode.
All account heads except Cash and Bank are placed in the……
These are the basis for analysis by potential investors, banks etc.
Identify the primary group of capital nature that has the sub-groups: Bank OD Account, Bank OCC Account.
The primary document for recording all financial transactions in Tally is the……
You can customize the voucher entry screen using the function key…….
Identify the voucher type that records fund transfers between cash and bank accounts.
This voucher type records adjustments between ledgers.
The use of classes for payment, receipt and contra vouchers enables data input in ……
The details of a voucher entry can be given in the …….
The credit note voucher can hold account types: ……..
The suffix and prefix details for the voucher type can be made applicable only from the …….
The voucher used to record all bank and cash payments is …..
The accounts that the business owns is called ….
Tally's age-wise
3. Generate Dayanalysis
Books considers the voucher's ……
4. Update journals for financial transactions
For day-to-day transactions the voucher types used are
Say for example a payment is made to a creditor ABC - Rs.10000 by cash, it can be entered into the voucher type…..
Identify the purchase voucher type, the transaction for purchase of 10 CPUs,10 monitors by credit.
Identify the voucher type to be chosen for the sale of computers to Anand by cash @ Rs.210000 per unit.
A bank overdraft repaid by cheque at Rs.25000 can be made in the voucher…..
The financial statement that consolidates ledger balances is …..
The F9 function key in the left side of the Gateway of Tally screen displays the……
The option on the Gateway of Tally that will generate the P&L account statement is…..
The expenditure for running the business for a period is …..
This displays the balance daywise for a selected voucher type.
The feature in Tally to analyze accounts of a company is…..
The age-wise statement is displayed based on……
The ratio analysis of receivables can be done based on……
Name the statement that helps the management in the decision making process.
Identify the budget type which is chosen where transaction amounts are to be monitored.
Choose the budget type to be used where bank accounts balances are to be monitored.
The management that needs to consolidate the accounts of its various enterprises uses ……. in Tally.
Identify the user who can access audit trails in Tally.
Identify the accounting feature in tally that facilitates splitting financial years for a company data.
Identify the account type by the rule: "Debit the receiver and credit the giver".
The tracking of changes in vouchers and ledger masters is done by…..
Tally can import data from other programs and creates a log about the activity in the file…..
Import and export of data between Tally and other programs is possible with the help of…..
The manual option of voucher numbering leads to…..

The tab in Expression Builder in which we write expressions is known as _____________.

The criteria expression LIKE?B*.
__________ queries are useful for summarizing information, and are somewhat similar to pivot tables in MS-Excel.
While entering record in Datasheet view, in which order the records can be entered
When you delete the record in form, it deletes the record from__________.
Having clause is used in the aggregate query in MS Access 2010
The controls that are not linked to any field of the table or query on the form are known as ________.
Which property of the form can be used to insert a background image in MS Access 2010?
___________ is a report that is inserted in another report in MS Access 2010.
A bound main report is based on a ______________ and its _____________ contain realted information.
DDL stands for ____________

A________used to compare trends over a period of time.

To create a read-only copy of the database, which of the following file format can be used?
The database administrator created a split database and created a front-end database and back-end database file.Which of th
In which formats can the Collect Data through email message feature can send the data entry form?
Once a mail is sent using the collect data through email message feature in Access 2010. The mail status can be checked using
The ___________ type of data cannot be collected using Collect data through email messages.
What is the memo data type field used for?
The filter By selection feature allows you to filter:
DML stands for _____________
Which editor was provided for use with Access Basic?
How do you update Pivot Table report data after changes are made to the source data?
What are the different views to display a Table ?
Which Of The Following Creates A Drop Down List Of Values To Choose From?
A __________ Enables You To View Data From A Table Based On A Specific Criterion
The Database Language That Allows You To Access Or Maintain Data In A Database
DCL Provides Commands To Perform Actions Like
Which is not a Database Model ?
Which Of The Field Has Width 8 Bytes?
This Is The Stage In Database Design Where One Gathers And List All The Necessary Fields For The Database Project.
Whenever a tables gets update, the dependent query will
The Third Stage In Designing A Database Is When We Analyze Our Tables More Closely And Create A ___________ Between Ta
What is the purpose of the Switchboard Manager in Microsoft Access 2010?
How does a query-based report differ in design to a report based on just one table?
How would you include some plain text into a mailing label report?
In a Microsoft Access 2010 report, the page numbering would most likely be placed into the:
If you wished to present a professionally looking form on screen that would show all the necessary information, which of the f
An .ACCDE file is a ___________ version of the original .ACCDB file.
Which type of the query is used to accept the value from the user while executing the query and fetch records accordingly
To encrypt the databse in Access 2010 must be opened in the __________________.
To extract the records based on date field, which of the symbol should be used
FIX() is a kind of ____ function in MS-Access 2010.
MS-Access 2010 has added new features of ______ to eliminate the need of VBA code
Encrypting a database does not restrict access to database objects, but to __________ the database.
Third Party Encryption Technology can also be applied to the database of Microsoft Access 2010.
To create a split database in MS Access 2010 go to which tab?
After spliting database,frontend database holds_________________.
After spliting database,backend database holds_________________.
When an Access database is split, it creates two files_________________.
A Data Access Page is a special type of _________ that allows users to interface with database using Internet Explorer.
OLAP systems use concept of OLAP cube called a ______________ cube
The data which is to be exported from Tally.ERP 9 can be in ________ format.
In Tally ERP-9 Remote Access is also known as __________.
Accessing data store on a remote location using Internet in Tally.ERP9 is called____________.
Tally.ERP9 can be classified user in two categories are___________.
Which of the following is not a predefined security level provided by Tally.ERP 9?
The business model is represented in the graphical form using ______________ and ________________
_______ integrates supply and demand mangement within and across companies.
OLAP stands for _________________.
Interactive Processing
Form 26, Annexure to 26
File Validation Program
integrated
File Validation Program
Tally Fix
User-defined Security
Direct Web Browser Access
Allow to Connect Company
Statutory audit
Financial reporting
Section 45
Snowball sampling
SUMIF()
Du Point Analysis
Mortagage
Format -> Window
Settings Tab under the Tab Format -> Cells
Counts cells having alphabets
A1+ "@" + B1
ROUNDUP(7.4999,0)
Bar Chart
Bar Chart
Pagelayout -> Page Setup -> Print Area
Add Ins
#
AVERAGE(4,5,6,7)
MOD()
XWE
Top10
Sort & Filter
Workbook
Column
Consolidation by position
TREND
PV
Sparklines
Cells C3 through C6
Shift + F10
Ctrl
Name Box
Name of the workbook currently working on
Copy handle
Insert
32
Goal Seek
A scenario is a set of values saved with the workbook.
A formatted description of each scenario on a separate worksheet
Arguments
Trendlining
Field Options
They allow you to add dynamic data.
Data manipulation language
Tabular
Update Query
DATABASE
Client data base
Data Design Language
Internal Schema
Increase data duplication
Hierachical
Attribute
.mdb
255 char
enter a value automatically
every
program
Programming
Physical level
256
YES/NO
column
Program
Report
MS-WORD
3 GL
Java
Multiuser DBMS
Client-Server database
key field
Record
Title
Search Query
View, change and analyze data in different ways
It is a printed page where users will enter data
One-to-One
Entity
Classifying
Storage space is wasted
Number
Conceptual Model
Employee Code
Java
Memo
Memo
Crosstab
Report Header Section
Select
Text
OLE Object
Unique Key
Query
Changing the structure of tables
Form
Parameter query
In the Report Header Section
Selecting the fields that we want to appear in the form or report
Data independence
Table Analyzer Wizard
Create
One-to-One
Matching Key
For ordering records
Inclusive Mode
Backups
Performance Analyzer
Table Documenter
User and Group Accounts
Security
SELECT
SELECT
Entering Data
Word
Value closing stock
P & L statement
Trial balance
Income or expenditure
Journal sheet
Customers
Income side
File
F10
Tally Secure
Ledger
Accounts of Tally
Sales
Fixed assets
Vouchers
Capital nature
Alter
Sub-group
Single
Single
Sub Ledger master
Journal and Ledger
Expenses
Journal
F13
Credit Note
Sales
Double entry mode
Comment
Sales account, Sales tax account
End of a month
Credit Note
Liability
Previous date
1, 2, 3, 4
Credit purchase
Loan
Credit Purchases
Cash Ledger
Payment
Balance sheet
Accounting reports
Net Loss
Expense
Record book
Ratio analysis
Income
Bill date
Data flow
On closing balance
On closing balance
Consolidate company
Owner
Month-less accounting
Real accounts
Tally Vault
Tally.imp
OLE
Auto numbers

Expression Elements
Will match all text starting from B
Select query
Alphabetical Order
Form only
FALSE
ActiveX control
Caption
Inner-Report
Table or query,Inner-Report
Data Definition Language
Pie Chart
Pie Chart
.ACCDB
Front-end database
HTML and InfoPath
Export to Outlook
Text
To add table
Those records that match an entity in a field
Detailed Maintaining Language
The Visual Basic 1.0 editor
Save your changes, close the workbook, and then reopen it.
Datasheet View
Ole Object
Form
DCL
Change The Structure Of Tables
Network Database Model
Memo
Data Definition
Not update
Relationship
To build a main switchboard form that controls all other forms.
The reports are restricted in size.
Type the text directly into the label.
Report Footer
Pivot Table
Fixed-down
Make Table Query
Open Secure mode
$
Math
Macro
Open
TRUE
Create Tab
Forms
Tables
A back-end database & front-end database
XML page
single dimensional
XML
Networking
Local Data
Local User
Owner
charts, pictures
BPM
Online Analysis Processing
Immediate Processing
Form 27, Annexure to 27
File Validation Utility
distributed
File Validation Utility
Tally Adjust
HTTP-XML based data interchange
Web Publishing
Contact On Load
Tax audit
Operations of the organization
Section 44AD
Sampling
PMT()
Return on Investment
Leasing
Window -> Split
Settings Tab under the tab Data -> Validation
Counts empty cells
A1 # "@" # B1
ROUNDDOWN(7.4999,0)
Sparkline
Pivot Chart
Pagelayout -> Print Area
Developer Tab
$
AVERAGE(A1,B1,C1)
INT()
XFD
Bottom10
Outline
.odc file
Line
Consolidation by category
STANDARDIZE
NPV
Slicers
Cell C3 and Cell C6
Shift + F1
Alt
Formula Bar
Name of the worksheet currently working on
Fill handle
Replace
64
Consolidate
A workbook can have one scenario per sheet.
A formatted defined range of Solver and Goal Seek solutions
Limitations
Enhancement bit
Field Pane
They allow you to rearrange row and column data.
Data mathematical language
columnar
Select Query
DBMS
Server data base
Define Data Language
Conceptual Schema
Reduce Redundancy
FLAT FILE SYSTEM
Entity
.dbf
16 chra
for checking
first
check
Non-Procedural
Logical Level
1000
HYPERLINK
field
query
Query
Excel/spreadsheet
4GL
Internet
Distributed DBMS
Distributed DBMS
Primary key
Tuple
Logo
Make Table Query
A source of records for forms and reports
It is a Data Entry Screen to make viewing, entering and editing data in the database table
One-to-Many
Attribute
Filtering
Changing the data at one place only will cause data inconsistency
Text
Structural Model
Employee Name
Oracle
Yes/No
Yes/No
Parameter
Page Header Section
Delete
Number
Memo
Foreign Key
Report
Creating views and indexes
Query
Update query
In the Report Footer Section
Selecting the underlying table or query on which we want to base the form or report
Data integrity and security
Database Analyzer Wizard
External Data
One-to-Many
Foreign Key
specifying conditions with group by clause
Exclusive Mode
Save Database
Hi-tech Analyzer
Database Documenter
User-level Security Wizard
Grant and revoke
WHERE
WHERE
Defining Data
Excel
Value clearing stock
Income statement
Trading account
Sales or purchase
Voucher debtors
Assets
Assets side
Company
F2
Tally Pack
Journal
Gateway of Tally
Production
Current assets
Groups
Expense nature
Delete
Ledger-group
Multiple
Sub-group
Group Ledger master
P & L Account and Journal
Income
Trial sheet
F12
Payment
Receipt
List entry mode
Memo
Ledger account, Bank account
First of a year
Contra
Income
Effective date
1, 3, 4, 2
Cash purchase
Payment
Cash Purchases
Sale Sheet
Receipt
Profit & Loss statement
Inventory reports
Net Income
Example
Ledger book
Account analysis
Payables
Effective date
Funds flow
On net credit flow
On net credit flow
Group company
Data Entry operator
Yearly-entry accounting
Personal accounts
Tally Audit
Tally.cfg
DBMS
Duplicate number

Operator Button
Will match all text ending from B
Crosstab query
At the end of the table
Form but not in table
TRUE
Unbounded Controls
Background
Sub-Report
Table or query,Main-Report
Data Defined Language
Area Chart
Line Chart
.ACCDE
Back-end database
Access Forms
Options in Tool menu of Access
Number
To store objects created in other programs
Records based on a criterion you specify
Data Maintaining Language
Notepad
Select the Pivot Table worksheet and press F9 on the keyboard
Design View
Hyperlink
Query
DML
Insert, Update Or Delete Records And Data Values
Relational Database Model
Number
Data Refinement
update automatically
Join
Creates the macros used to program an automatic application.
It doesn’t
Use the > button.
Section Header
Pivot Chart
Locked-down
Update Query
Open Inclusive mode
#
Date
Form
Modify
FALSE
External Tab
Query
Forms
A new database & Old database.
HTML Page
hyper dimensional
HTML
VB.Net
Remote Data
Remote User
Public User
smart art, clip art
SCM
Online Analytical Processing
Real Time Processing
Form 26Q, Annexure to 26Q
File Valuation Program
isolated
File Valuation Program
Tally Fit
Unlimited multi-user support
Tally.NET
Either A or B
Internal auditiing
Both A and B
Section 43B
Systematic sampling
COUNTIF()
Profitability Ration
Rent
View -> Window -> Split
Settings Tab under the tab Data -> Filter ->Advanced Filter
Counts cells having number
A1 & "@" & B1
ROUND(7.4999,0)
Pivot Chart
Sparklines
Page Setup -> Print Area
Text Import wizard
&
AVERAGE(A1:A6,B1:B6)
DIV()
XAA
Top half
Data Tools
.htm file
Scatter
Consolidation using 3-D formulas
CORREL
IRR
Macros
Cell C4 and Cell C5
Shift + F11
Shift
Zoom Box
Name of the cell or range currently working on
Insert handle
Paste
60
Data Validation
Scenarios provide a way to see different solutions for worksheet formulas.
A worksheet with a separate thumbnail for each formula
Constraints
Thumbnail
Field Settings
They allow you to generate e-mail enabled reports.
both a and b
both a and b
Delete Query
O.S
Client-Server database
Data Definition Language
External Schema
Increase Efficiency
Relational model
Tuple
.accdb
text
for validation check
last
macro
Application
View Level
16536
MEMO
tuple
form
Form
Powerpoint
5GL
Database
Centralized DBMS
Multiuser DBMS
Reference Key
Tabel
Picture
Aggregate Query
Both A and B
It is a part of database used by the analysts to draw conclusions
Many-to-Many
Relationship
Sorting
It can be more easily accessed
Memo
Object Model
Date of Birth
Lotus 1-2-3
Image
Calculated Field
Action
Detail Section
Make Table
Currency
Hyperlink
Primary Key
Form
Authorizing access and other control over database
Macro
Crosstab query
In the Page Footer Section
Reading several screens of mostly useless information and clicking next
Decentralized data
Form Analyzer Wizard
Home
Many-to-Many
Index key
updating records
Normal Mode
Save As Databse
Online Analyzer
Query & Report Documenter
User and Group Permissions
Select
FROM
FROM
Controlling/Accessing Data
Access
Value expense stock
Balance sheet
P & L statement
Asset or liability
Sundry debtors
Liabilities
Expense side
Project
F12
Tally Group
Voucher
Entry of Tally
Mercantile
Loan assets
Journal
Revenue nature
Display
Primary-group
Sub-group
Alter-group
General Ledger master
P & L Account and Balance Sheet
Assets
Voucher
F10
Receipt
Payment
Choice entry mode
File
Suppliers account, Purchases account
First of a month
Sales Note
Sales
Current year
2, 4, 3, 1
Both A and B
Receipt
Expense Purchases
Stock Journal
Debit
Trial balance
P & L reports
Net Profit
Taxes
Journal book
Data analysis
Expenses
Voucher date
Stock flow
On net transactions
On net transactions
Set company
Accountant
Period-less accounting
Nominal accounts
Tally Report
Tally.exp
ODBC
Sequence number

Expression Box
Will match all text having second character as B
Action query
Any where in the table
Table but not in Form

Graphics Control
Record Source
Inside-Report
Table or query,Sub-Report
Detailed Definition Language
Bar Chart
Bar Chart
.MDW
Both of them
Visual Basic Application
Manage replies
Date/time
For long text entries
Records that meet any of several criteria you specify
Data Manipulation Language
The QuickBasic editor
Click the report, and on the Pivot Table toolbar, click the refresh data button
Pivote Table & Pivot Chart View
Memo
Macro
DDL
Authorizing Access And Other Control Over Database
Object Oriented Database Model
Date/time
Establishing Relationship
have to update manually
Query
To allow the user to switch from one database file to another.
It doesn't have as many design options.
Use the Mailing label wizard text option.
Page Footer
All The tools of the form design control gallery.
Open-down
Delete Query
Open Exclusive mode
()
Text
Report
Read

File tab
Report
Query
primary database & secondary database
Web page
multi dimensional
ASCII
Tally.Net
Internet Data
Both A & B
Data Entry
flowcharts, flow diagrams
PLM
Online Analytical Programming
Business Processing C
All of the above D
File Valuation Utility B
de-centralized A
File Valuation Utility B
Tally AutoFit C
Audit Feature D
Email facility C
None of the above B
None of the Above C
Either A or B C
Section 44AB D
Simple random sampling B
None of the above B
None of the above A
All the above B
View -> Split B
All of the above B
Counts non-empty cells D
A1 $ "@" $ B1 C
Only B & C D
Pie Chart B
None of the above B
Print Area A
Analysis Tool Pak C
* C
All of the above D
REMAINDER() A
AAA B
All D
Calculation B
.udcx file C
Bubble A
Any of the above C
GROWTH A
PMT D
Data Forms B
None of the above A
Shift + F12 A
Ctrl + Shift A
Sheet Tab A
Formula in the cell currently working on C
Border B
Undo D
80 B
Subtotal A
Scenarios help to perform what-if analysis. B
A worksheet with separate macros for each scenario A
Parameters D
Add-in D
Field Structure C
They allow you to print the reports with various settings. B
None A
None A
None B
None B
None C
None C
None C
All B
None C
None C
None C
long Integer D
None A
None B
All C
None B
None B
63999 D
AUTONUMBER D
None C
macro D
Macro A
None B
None B
Visual Basic C
Database C
Centralized DBMS B
None B
Attribute B
Graphic B
Select Query D
Neither A nor B C
None of the above B
Many-to-One D
None of the above A
Summarizing C
Both A and B D
Any of the above B
Interface A
Joining Date A
MS-Outlook B
AutoNumber C
AutoNumber C
None of the above A
Summary Section D
Update A
AutoNumber C
Lookup Wizard D
Record Key C
None A
Inserting, updating or deleting records C
Report D
Make Table query D
In the Month Group Footer Section D
Selecting how the form or report should be formatted B
Reduced application development time C
None of the above A
Database Tools D
None of the above C
None of the above B
None B
Save Mode B
None of the above A
None of the above A
None of the above B
None of the above C
Create B
INSERT A
INSERT B
All C
None C
Value income stock A
Asset sheet C
Suspense accounts C
Profit or loss B
Original entry C
Suppliers D
Payable side B
Application B
F11 C
Tally Vault D
Trial Balance B
Groups of Tally B
Manufacture C
Capital assets B
Ledgers D
Income nature C
Shift A
Alter-group C
Alter-group B
Multiple D
Journal Ledger master C
Voucher Account and Balance Sheet C
Loans D
File C
F11 B
Contra D
Journals D
File entry mode B
Narration D
Buyer's account, Cash account A
End of a month C
Payment D
Asset D
Configured date B
3, 4, 2, 1 C
Contra purchase C
Sales B
Debit Purchases A
Purchase Voucher C
Contra D
Journal C
Expense reports B
Net Account C
Income A
Day book D
Transaction analysis A
Loans B
Previous date A
Cheque flow B
On net cash flow C
On net cash flow A
Alter company B
Administrator D
Transaction-number accounting C
Expense accounts B
Tally Group B
Tally.ole A
MS-XLS C
Range number B

Expression Builder window C

Will match all text starting with a digit A
Parameter query B
Beginning of the table B
Form & Table D
B
Bound Controls B
Picture D
Insert-Report C
None of the above C
Data Detailed Language A
Column Chart D
Column Chart B
.ACCDT B
None of them B
Excel attachment A
All of the above C
AutoNumber D
For shout text entries of no more than 255 characters C
All of above A
Detailed Manipulation Language C
All of above B
All of the above C
All Of Above D
Lookup Wizard  D
Report B
None Of Above A
None Of Above C
Structureed Database Model D
Hyperlink C
None Of The Above A
never update B
None Of These A
To allow changing from one report to another. A
The only report type available is the Design Report. B
Use the >> button. C
Page Header C
Form Wizard Columnar C
None of the above B
Parameter Query D
Open Read Mode C
"" B
None of the above A
None of the above A
Write A
A
Database Tools D
All of the above D
Report A
None of the above A
None of the above C
none C
ALL D
None of the above C
None of the above B
None of the above C
Tally.NET User B
graphs, shapes C
CRM B
None of the above B