NEW
Font size
S
M
L
XL
WorksheetsTally Prime 4.0 Excel Import
Total questions: 15
Worksheet time: 11mins
Name
Class
Date
1.
A business is using the default template provided by Tally to maintain records, but now he wants capture some additional info, for which column I not present, how this can be addressed
a)
User can simply copy paste the field referring from read me sheet
b)
User can add the field in mapping template
c)
User can't add additional field in default template
d)
Can be achieved through TDL customization
2.
How duplication of mapping can be avoided when there is a need of mapping for similar excel sheet
a)
By copying .TSF file
b)
By copying company files
c)
By using Duplicate button
d)
By using F12:Configuration
3.
An E-commerce operator getting sales transaction in very complex format, how this complex excel sheet can be imported
a)
Tally provides the mapping file for major e-commerce platforms
b)
By copy and pasting data in Tally provided sample formats
c)
E-commerce operators will provide TDL files
d)
By importing the .TSF file from Import menu
4.
What advantages a business will have if it uses the default templets provided by Tally
a)
No mapping required, can save time and effort
b)
Can avoid data errors
c)
There is no advantages
d)
All of these
5.
Which behaviour should choose for record the exception and resolve later?
a)
Record exception and import
b)
Stop import at first exception
c)
Ignore exception and record
d)
Reject and resolve later
6.
What is the functionality of "Preview import summary" option
a)
It allows user to preview the summary of records before the import
b)
It allows user to stop the import
c)
It allows user to take print of summary
d)
It provides just a report
7.
How user can identify the mandatory fields in Tally provided default templets.
a)
Mandatory fields are in bold black colour
b)
Mandatory fields are marked in Blue colour
c)
Mandatory fields are in Italic font
d)
Mandatory fields are marked in red colour
8.
What if the user wants to import only Payment vouchers from a sheet which has both Receipts and Payment transactions
a)
Can exclude using "Exclude Rows in Excel" option in mapping screen
b)
Can exclude by mentioning row numbers
c)
Can exclude using F12 configurations option
d)
by deleting the rows in excel sheet
9.
What is the best method user should follow if the import process terminates in between
a)
Starting row can be mentioned during next import
b)
Delete all imported data in Tally and reimport
c)
Delete the imported rows in excel
d)
F12:Configure--> Re-import
10.
Which are the two mandatory fields to mapped while creating mapping template for Ledger master import
a)
Name, Group Name
b)
Name, Ledger Opening Balance
c)
Name, Ledger opening balance Dr/Cr
d)
Name, Amount
11.
Can custom mappings be utilised for all companies available on the same computer?
a)
Yes, by choosing "All Companies" option
b)
Yes, By choosing "This Company" option
c)
No, user has to create mappings for all companies
d)
Yes, by copying .TSF file
12.
How masters can be created from a transaction excel sheet when these masters are not exists in Tally
a)
Create masters from exception report OR create a separate masters mapping and run first
b)
Tally will auto create missing masters
c)
"Master or Transaction" option can be selected while creating mapping template
d)
Tally allows user to create one mapping template for both masters and transactions
13.
Is it possible to create one mapping template for all types of transaction which exists in excel sheet
a)
Not possible
b)
Yes, Possible
14.
Which are the two mandatory fields to be mapped while creating mapping template for Transaction under "General Details"
a)
Voucher Type Name, Voucher Date
b)
Voucher Date, Voucher Number
c)
Voucher Date, Reference No
d)
Ref no, Ref Date
15.
From where user can get sample excel files for any masters or transactions
a)
"Manage" option under "Import" menu
b)
"Manage" option under "Export" menu
c)
"Configurations" option under "Import" menu
d)
"Masters" option under "Import" Menu
Reset
