ADPBA Practical Examination
Please fill out the form to participate in the practical exam, upload your files or screenshots after completion.
Student Full Name
*
First Name
Last Name
Father's Name
*
Student ID
*
Back
Next
Tally Practical Exam
50x3
1. Create a new company with the following details:
Name: Bright Star Traders , Address: Kolkata, West Bengal , Financial Year: 1st April 2024 to 31st March 2025 , Currency: ₹ (Indian Rupees)
Upload Your Exam Files or Screenshots
Upload a File
Drag and drop files here
Choose a file
Cancel
of
2.Create the following groups under Sundry Debtors and Sundry Creditors:
• Debtors: Rahul Enterprises, Shyam Traders • Creditors: Anand Suppliers, Ghosh & Co.
Upload Your Exam Files or Screenshots
Upload a File
Drag and drop files here
Choose a file
Cancel
of
3. Voucher Entries
Record the following transactions for April 2024 (adjusted for Education Version dates):- April 1: Introduced Capital ₹2,00,000 (Cash). April 2: Purchased goods from Anand Suppliers ₹50,000 + GST 18% (Credit). April 2: Sold goods to Rahul Enterprises ₹75,000 + GST 18% (Credit) .April 30: Paid Rent ₹8,000 (Cash). April 30: Deposited ₹25,000 cash into Bank of India (Contra Entry). April 30: Received ₹50,000 from Rahul Enterprises by Cheque. April 30: Paid ₹30,000 to Anand Suppliers by Cheque. April 30: Depreciation on Furniture ₹5,000 (Journal Entry).
Upload Your Exam Files or Screenshots
Upload a File
Drag and drop files here
Choose a file
Cancel
of
Back
Next
GST Practical Exam
10 x 5 = 50
Check this PDF and Download the json and Excel file - https://drive.google.com/file/d/1xU1f5Eo194FpLSndGEOXm8t5FXS99TJG/view?usp=sharing
Back
Next
Advanced Excel Practical Exam
50x3
1. Age & Service Calculation from this table
Calculate the Age (in Years) of each employee, also Calculate the Years of Service (till today).
Upload Your Exam Files or Screenshots
Upload a File
Drag and drop files here
Choose a file
Cancel
of
2. VLOOKUP / XLOOKUP
Find the Price of a product entered in a separate cell, using VLOOKUP or XLOOKUP.
Upload Your Exam Files or Screenshots
Upload a File
Drag and drop files here
Choose a file
Cancel
of
2. Pivot Table Analysis
a) Create a Pivot Table showing Total Sales by Product. b) Create a Pivot Table showing Total Sales by Region. c) Identify the Top 3 Customers by Sales.
Upload Your Exam Files or Screenshots
Upload a File
Drag and drop files here
Choose a file
Cancel
of
Submit Exam Details
Should be Empty: