Tally ERP-9 and MS Access Essentials
Tally ERP-9 and MS Access Essentials
The bank gives us one book,which is called __________ Bank Book Cash Book
_______
Once we is the the
audit mainentries,Tally
source point for preparing
ERP9 displays forother
us allReports.
the altered Trail Balance
with the user's name who altered the P&L A/c
the Entry,the date and time of
entries ________ Entry,the date and time of alteration alteration
Tally.ERP9 offers a data encryption option called _________ Tally Passward Tally Value
which one is not a method of closing stock valuation? Moving Average Hash Average
TCS Stands for Tax Column at Source Tax Collected at Source
In Tally ERP-9 Tally .NET is activated through_________ F1 F2
In
In Tally
Tally ERP-9
ERP-9 Cost Center
Balance Sheetis Enable through the shortcut
Detailed/Condensed Activatedkeythrough
_________ F11,F1 F11,F2
ShortCut Key ________
In [Link]-9 Once the Data has been Split,the closing balance of first Alt F1 Ctrl F1
period become __________for the next period Opening Balance Closing Balance
In Tally ERP-9 Gateway of Tally>Reports>P&L A/c>Ctrl+F12 is used for Range Configration
Which of the following is not a type of Company Features in [Link] 9? Accounting Features Auditing Features
What is the Shortcut Key to change the Current Period? F2 ALT+F2
Vat,Service tax, TDS and TCS are available in___________ Inventory Features Accounting Features
Accounting is a keeping track of_________ Income Assets and Liabilities
In Tally ERP-9 ShortCut Key of Period in Balance Sheet is ___________. F2 ALT+F2
Financial aspects are considered in_________ Books Accounting
Accounts Receivable is also knows as _________ Bill Receivable Bill Relation
The first document where the transction is entered is called________ Voucher
Gateway of Tally > Display > Ledger
Gateway of Tally > Display > Accounts
In Tally ERP-9 What is the exact path of Tally Audit? Statements of Accounts > Tally Audit Books > Tally Audit
In CAAT The Role's of Auditor's are _________. Prevention Detection
Which of theprogram
The unused following is not a type
instructions canofbe
System
listed Testing?
using the Top down Bottom up
________software
_________is a software used by the auditor to examine transactions Mapping Modelling
passing
________ through
focuses the
onsystem
findingby placingare
if there a program
any defective execution paths Core Image Comparison Database Analyzers
Under Data
in a program. Integrity related updated protcols, whenever monetary Top down White Box testing
transactions are processed against master files, the update program
Checks that can be
should maintain run when data is to
a ______________ input through
record such atransactions
terminal arethat Field Checks Record Checks
does not have a matching master file record.
The Core Image Comparison audit technique compares the Transaction account Master account
Executable program with secure
________________. Database with master table master copy
PBX Standsare
________ For_________________.
designed to ensure that the integrity of the data entered Private Breach Exchange Private Box Exchange
into the computer
Checking whether asystem
user's isage
maintained.
entered is not negative or a value Input Control Output Control
exceeding 120 is a _________ field check. Range Missing data
_____ ensuring that the originators of messages cannot deny that they
in
In fact sent the check
__________ messages is to the recipients
,it generated
checked that data entrysuch
follows a particular Non-repudiation Authentication
The stream of test data with test tools as correctness
order while checking the records.
proof, data flow analysis and control flow analysis, is called Limit Sequence
_______________. Test item block Test data pack
Checking the valid sign of a numeric field is a kind of _______ check Record Check Field Check
OLE
Which Stands
of theFor _____________.
Audit Techniques has the main Advantage that is Object Line and Embedding Object Linking and Embedding
"Performs a wide variety of audit tasks"? Audit
View, Software
change and analyze data in Embedded
A source of Code
records for forms and
Queries in MS-Access
In MS-Access 2007, which2007datacan type
be used as ________________________.
is best suitable for storing the price different ways reports
of a commodity?
one 2 one, one 2 many and many 2 many Relationship exist in Text Number
_________ model Hierachical FLAT FILE SYSTEM
It is a Data Entry Screen to make
Value of Report Header exist on ___________ page of report every
It is a printed page where users will first
viewing, entering and editing data in
What is a form in MS-Access? enter data the database table
SQL is considered to be a _______ 3GL 4GL
A database tabel is similar in appearance to a _______ MS-WORD Excel/spreadsheet
E-R
In anDiagram
ER model, is ________________
a/an ___________ Model. is any object, place, person, event or Conceptual Model Structural Model
concept about which an enterprise records data. Entity Attribute
Which of the following is a Database Management System? Java Oracle
Memo
A data type store
database _________ number of characters. 256 1000
Which query_______
should bepresents
used tosummarized
retrieve theinformation retrieved from
following information froma
table in a preformatted, attractive manner.
table of databases "Which employees earn more than Rs.30,000 a Form Query
month?" Search Query Make Table Query
SQL is considered to as an ideal Language for _______ Java Internet
Which of theisfollowing
__________ an actioncan or be
setaofprimary
actionskeythatinyou
an employee
can use todatabase?
automate Employee Code Employee Name
tasks program check
The default query invoked by ms-access is Update Query Select Query
Selecting the underlying table or
Which
What isofthe thefirst
following
step iniscreating
not a data typeorinreport
a form MS-Access?
using the Form Wizard Number
Selecting the fields that we want to Character
query on which we want to base the
or the Report Wizard in MS-Access 2007?
DBMS that supports a database distributed across several different site appear in the form or report form or report
is called a _____ Client-Server database Distributed DBMS
DBMS
To make that supports
changes a databaseform
in MS-Access located at a be
should single site isincalled a _____
opened Multiuser DBMS Distributed DBMS
__________________ Form view Form Design
MS-Access
Most database is _________________
operations that we do manually can be automated by DBMS RDBMS
using Program Query
DB2 is an example of __________ ODBMS RDBMS
_______layout of a form displays one record at a time Tabular columnar
Which one is the Second Level of Data Abstraction? Physical level Logical Level
The _________key does not accept Duplicate and Null values in Field. key field Primary key
Which of the following is not an advantage of using a DBMS? Data independence Data integrity and security
____________ is extention or Secondary file name of ACCESS DATABASE .mdb .dbf
Benefits of digital signatures include __________. Authentication Integration
CA stands for ________________.
_________are on-line databases of certificates and other information Certification Agency Centralized Authority
The cost of
available forestablishing
retrieval and and utilizing
use certification
in verifying authorities,
digital signatures Repositories Result
repositories, and other important services, as well as assuring quality in
Which of the following
the performance of theiris not a typeisofreferred
functions Digital Certificate?
to as Server Certificates Developer Certificates
_________________. Institutional prospect Company expense
Drawbacks
__________ofare digital
usedsignatures include
by individuals when__________.
they exchange messages with Non-repudiation WYSIWYS
other users or online services. Server Certificates Developer Certificates
SRN stands for ___________. Service Request Notification Service Return Number
It is mandatory to file return of income after getting PAN. By furnishing the return in a paper 1 By furnishing the return electronically
FALSE
Which of the following is not a way of filing an income tax return? form under digital signature
Schedule- ______ is the statement of tax deducted at source on salary. TDS2 TDS1
Which of these is an optional field in ITR-1 sheet? Last Name First Name
PAN stands for _________. Personal Account Number Permanent Account Number
An acknowledgment
A duly is issued
verified ITR-V form when
should be return
submittedis received
at CPC and
withinaccepted.
____ days 1 FALSE
of E-filing. 30 days 120 days
UTN stands
Assessee for ___________.
is always a person but a person may or may not be an Universal Transaction Number Unique Transmission Number
assessee. 1 FALSE
Which of the following function will return a value of 7? ROUNDUP(7.4999,0) ROUNDDOWN(7.4999,0)
Full form of OLE is __________________. Object Linking and Embedding Object Loading and Embedding
Subtotal
Tally.ERP9 option
allowsis us
in __________
to import data group of Data
as well tab indata
as export Excelto2010.
other Sort & Filter Outline
softwares in _________
In [Link]-9 which one is not a part of Licensing Operations Startup ASCII Excel
Screen? Activate License Tally License
BRS stands
In Tally ERP-9for__________
the Inventory features are sub-divided into _______ Bank Rectification Statement Bank Recognisation Statement
Sections 5 6
The Basic
In Tally documents
ERP-9 used in Financial
the accounting features areAccounting System
sub-divided intoare:-
_______ Voucher Journal
Sections 5 6
Every financial transaction in an Organisation has _________ aspects. 4 1
ERP stands for__________ Enterprise resource planning Entry resource planning
In
In Tally
Tally ERP-9
ERP-9 statistics(Display
Which of the followingMenu)isarenotavailable
a name of in Inventory
__________ Statements of Accounts Statements of Inventory
features(F11>F2)? General
Alt+F3>Company Info.>Split Company Sales ManagementInfo.>Split
Ctrl+F3>Company
Choose The correct
The transactions areOption to split Company
to be recorded primarilyData
in some ________Later Data. Company Data.
they are to be ___________ Documents,Account Data,Grouped
How
In TallyMany Vouchers
ERP-9 What isare theavailable
ShortcutinKey Tally ERP-9? the over all entries in
to accept 16 18
Tally Audit? F7 Ctrl+F7
Account Payables
In Tally ERP-9 is alsoKey
ShortCut knows as _________
of Schedule -VI Balance Sheet is Bill Receivable Bill Relation
___________.
In Tally ERP-9 Which of the following is a name of accounting Ctrl + S Alt+ S
features(F11>F1)?
In Tally ERP9 _________ provides remote capabilities to access the data General Invoicing
from
Usingany where
Audit and anytime.
Techniques Log Analyzers Software used by the auditor to Remote Control Tally Machine
read and analyze records of __________. Client's Computer's
In the context of system tests, hybrid tests are Top down tests Bottom up tests
Description of audit work performed
In Concurrent Audit, Audit Evidence Includes _____________.
Checking whether a given source code meets user requirements or not is Output Provided on the Output
said to be identifying
________ ensuring that _________
information is no accessed by unauthorized Erroneous code Unathorized code
person
The sample data created and used forby
thethe
purpose Confidentiality Authentication
__________Audit Techniques is used auditoroftotesting
take athe
picture of
application
file of datasystem
a__________can or abe is called ___________.
transactions passing through the system such
at a particular Test data pack Table data
very effective in certain circumstances as testing
point
paymentsin time.
or looking for double input of inventory tags during inventory Source Comparison Snapshots
counts. Duplicates Testing Wrong Testing
___________are designed to ensure that the appropriate computer
Two strategies
processes haveof System
been Testingon
performed arethe data inputted to the computer Top down & Bottom up Big Bang & Incremental
system
To analysing the data with IDEA which of them is not a features to Input Control Processing Control
analyse the data?
______ means controlling the coming and goings of people and Mechanical Accuracy Validity
materials
_________Ensuring that information is not accessed by unauthorized Network Security Pernonnel Security
persons Authentication Confidentiality
DCL(Data Control Language) used for
In MS-Access 2007, which type of query extracts the data from one or Entering Data Defining Data
more existing tables and puts them into separate table? Parameter query Update query
_________
In MS-Access is used
2007,to insert values
__________ in Table
queries aredirectly.
best suitable to summarize Query Report
information and looking for trends. Crosstab Parameter
specifying conditions with group by
In SQL, having clause is used for _________ For ordering records clause
Which of the following is not a data type in MS-Access 2007? Memo Yes/No
Distributed database have now come to know as a __________ database Client data base Server data base
_________ are what we use to summarize and present data in the table Report Query
DDL Stands for -. Data Design Language Define Data Language
To see more than one record at a time in a form we use _______ Tabular columnar
SQL is a _________ Language Programming Retrival
In DBMS, Normalization
__________ concept responsible
are on-line databases for _______________
of certificates and other information Increase data duplication Reduce Redundancy
available for retrieval and use in verifying digital signatures.
Every __________ is not a Digital Signature because DS is always Re-storage Repositories
Verified. Electronic Signature Digital Signature
CRL
The stands for ___________.
digital certificate that offers assurance of verification of the owner's Certificate Renovation Lists Certified Revocation Listing
personal identity is of
_____ serves the ceremonial _________ level.
and approval functions of a signature and Class 1 Class 4
establishes the sense of having legally consummated a transaction. Server Certificate Cryptography
Form 16 issued by the _____ in respect of salary income. Employee Employer(s)
As
Theper E-Filing,
Income TaxMCA
Return stands
formfor ______________.
launched by Income Tax Department is Masters of Computer Application Ministry of Corporate Affairs
known
How many as ________.
copies of the ITR-1 form need to be filled and submitted to Saral Suraj
the ITD? is a form that is received from all the payers who have got their
_______ 1 2
tax
Whichdeducted.
of the following form is for individuals who are partners in a Form No. 16 Form No. 15
partnership
Section _____ firm?
of the Income-tax Act, covers deductions in respect of the ITR-1 ITR-2
Married persons filing a separate
investments. 80C
Companies requiring statutory audit 80CC
return, and live in a community
_________________ are required to file tax return on paper. u/s 44AB property state
In Tally ERP-9 Remote Access is also known as __________ Networking [Link]
In Tallyare
There ERP-9
threeExceptions
accounting Reports(Display
rules one of them Menu) includesaccounts
in nominal __________and Negative Stock Negative Ledgers
Nominal Account is also Known as:- Expences Revenue
In the context of system tests, hybrid tests are Top down tests Bottom up tests
SSL stands For______________.
_________is one of the Standard Secure Layer Secure Socket Layer
Descriptive Statistics toolmost
thatpowerful
provides and effective the
the provides ways of detecting
Auditor with an
fraud within an organization
easy way to calculate summary statistics for a set of sample data Program Analysis Computer Analysis
includes__________. Mean Median
Generalized audit software permits auditors to undertake only Concurrent Auditing ex. Post auditing
Process
_____ of grouping
means, transactions
whenwhich
all elseoffails, of
besame typeto
prepared is knownoutasbackup
pull creates media Grouping Combining
In MS-Access 2007, the following data type a field that
and
allowsresotre from
the user toscratch
choose a value from another table or from a list of Non-repudiation Authentication
values by using a list box or combo box? OLE Object Memo
______ is often implemented as an array of records Record Tuple
__________is
In an MS-Access Example
report,ofinDBMS
which section we can keep the sum[Sales] to Word Excel
calculate the total sales
Which of the following degree for each ofmonth?
relationship cannot be applied in MS- In the Report Header Section In the Report Footer Section
Access 2007?
If some chunk of data is stored at two places in a database, then One-to-One One-to-Many
Changing the data at one place only
___________. Storage space is wasted will cause data inconsistency
__________ data type field can't be updated YES/NO HYPERLINK
DCL provides
In a table, commands touniquely
_____________ perform identifies
actions like _________.
each record that is stored Changing the structure of tables Creating views and indexes
in the table. Unique Key Foreign Key
Default value option
A hash function is an in field property
algorithm which use for ________
creates a digital representations or enter a value automatically for checking
"________" in the form
While downloading of a hash
software fromvalue or Hash
Internet, Result Certificate is used Fingerprint
Developer Finger marks
in conjunction with ___________________ technology. Microsoft AuthorityTM Microsoft software key
Digital signature are created and verified by ________. Public Key assurance of Creating of
additional Private Keyassurance of verification of
additional
In Digital Signatures Class 2 Digital Signatures offers the the owner's personal Identity the owner's personal Identity
Which of the following is not a benefit of E-filing?
____refers to the deduction in respect of interest on loan taken for Accuracy Duplication
higher education.
____ form is for individuals having income from Salary / Pension / family Section 80D Section 80C
pension & Interest. ITR-2 ITR-1
ITR
_____stands
formfor ____________________.
is required to filed by all Companies for P&L Account with Indirect Tax Return Interest Tax Return
RoC. 23AC 23CA
SSL is a global standard security
Which of theoffollowing
The process statement
electronically filing is incorrect?
Income Tax returns through the SSL stands for Secure Sockets Layer. technology.
Internet is known as ________. E-marketing E-Filing
Uniform Communication
____ provides Standard(UCS)
a way of viewing stands for
e-mail messages in ______
a folderindustry.
only if they Warehouse Ocean
meet specific
In Group criteria.______ option finds available times for all group
Schedules, Filters Folders
members.
____ allow to set actions that will be performed automatically after Refresh Free/Buzy AutoPick
receiving
If you wanta message
to reply to that meetsofthe
a group criteria.
people, click the _____________ Rules Alerts
command. Reply Reply to All
C D
Day Book Pass Book
Balance
Entry butSheet
not the date and time of None
the Of These
Entry and also not any date and
alteration time of alteration
Tally Vault None Of These
FIFO Weighted Average
Tax Call at Source Tax Can be a Source
F3 F4
F12,F1 F12,F2
Alt + Ctrl + F1 F1
Both A & B None Of These
Value None of These
Inventory Features [Link] features
CTRL+F2 None Of These
Statutory Features [Link] features
Expences All of These
Both A & B Nither A Nor B
Ledgers Vouchers
Bill Payable Bill Payment
Gateway of Tally > Display >
Entry
Statements of Accounts > Ledgers > Transaction
Gateway of Tally > Display >
Tally Audit Statements of Books > Tally Audit
Investigation All of These
Hybrid Hierarchical
On-line Testing Source Comparison
Embedded Code Snapshots
Black Box testing Hybrid testing
File Checks All of These
Suspense
Transaction account
data with master Sequence account
transaction Module programs with snapshots
Private Bell Exchange Private Bed Exchange
Processing Control All of These
Blank data Check digit
Access Control Privacy
Range None Of These
Test program pack Test record pack
Batch Check File Check
Test Data-'Live','Dead',Integrated
Object Length
Test Facility orand
baseEmbedding
Case System Open Line and Embedding
Evaluation All of These
Both A and B Neither A nor B
Currency AutoNumber
Relational model None Of These
last
It is a part of database used by the None Of These
analysts to draw conclusions None Of These
5GL None Of These
Powerpoint None Of These
Object Model Interface
Relationship None Of These
Lotus 1-2-3 MS-Outlook
16536 63999
Macro Report
Aggregate Query Select Query
Database Visual Basic
Date of Birth Joining Date
macro All of These
Delete Query None Of These
Memo
Reading several screens of mostly Date
Selecting how the form or report
useless information and clicking next should be formatted
Multiuser DBMS Centralized DBMS
Centralized DBMS Database
Change Form None Of These
ODBMS None Of These
Form Macro
DBMS None Of These
Datasheet None Of These
View Level None Of These
Reference Key None
ReducedOf These
application development
Decentralized data time
.accdb None Of These
Efficiency All of These
Centralized Agency Certification Authority
Data base Response
Digital Certificates Personal Certificates
Institutional
Association ofoverhead
Digital Signatures and Implementation overhead
trusted time stamping All of These
Personal Digital Certificates None Of These
Service Request Number Storage Request Number
By furnishing a bar-coded paper
return None Of These
CG OS
PAN Residential Status
Permanent Action Number Personal Activation Number