Question
Use Google Sheets and create a spreadsheet containing the yearly Salary details of 10 employees of a university under the headings employee name, yearly basic salary, DA percentage, Provident fund deductions, Income Tax deduction, and net salary. You may use the following formulas for making the spreadsheet:
DA amount = DA percentage * yearly basic salary Provident fund = 8% of yearly basic salary Income Tax deduction is computed as: For yearly basic salary < 5,00,000 tax=0 For yearly basic salary >= 5,00,000 but <10,00,000 tax = 20% of (yearly basic salary - 5,00,000) For yearly basic salary >= 10,00,000 tax = 1,00,000+ 30% of (yearly basic salary 10,00,000) Net Salary = yearly basic salary + DA amount - Provident fund - tax
Answer :
Word Count : 487
आइए हम एक उदाहरण के रूप में 10 कर्मचारियों की सैलरी शीट को मैन्युअल रूप से (Google Sheets में लागू करने योग्य फार्मूलों सहित) संख्यात्मक रूप से तैयार करें। नीचे सभी कॉलम और गणनाएँ क्रमवार दी गई हैं: --- ### स्तंभ शीर्षक (Column Headings): 1. Employee Name 2. Yearly Basic Salary 3. DA % 4. DA Amount = (DA % × Basic Salary) 5. Provident Fund = 8% of Basic Salary 6. Income Tax Deduction (As per rules given) 7. Net ________ ______ ________ _________ _______ ______ __________ ________ ____ _______.
____ ____ _______ _______ _______ ________ ______ ____ _____ ______ __________.
_____ ________ __________ ___ ______.
____ ________ ______ _____ ____ __________ __________.
____ _________ __________ ___ _________ _______ _____.
_________ __________ ________ _________ __________ _________ ____ _______ ______.
________ ______ ___ _____ ____ __________ _________ _______ ____.
_____ ____ _______ _________ _______ ____ ____ ___ ______ ____.
_______ _________ ____ ________ ___ ________ ________ ___ ________ ________ ___.
_____ _____ _______ _____ __________ ______ ___ _______ ______ _____ _________.
_________ ___ ________ _______ _________ ________ _____ _______ __________ __________.
____ ___ _________ _______ ________ _______ _______ ________ _____ ________ ___ __________.
________ _________ _________ _____ ____ _______ ________ __________ _________ __________ _____.
____ _________ __________ _____ ______ _____ ________ _____ ____ _____ _____.
___ ______ _______ ________ _________ ___ _______ __________ __________.
__________ __________ _________ ___ __________ ____ ________.
____ ___ _______ _____ ___ ___.
__________ _____ __________ _________ ____ ______ ______.
______ ________ _________ ________ ________ ____ ________ _________ ______ ___ _____.
______ __________ ______ _____ _______ __________ _______ ________.
________ __________ ___ _______ __________.
________ ____ ______ ___ ______ ______.
_____ ____ _________ ______ __________ ____ _____ ____ _______ _______.
_________ _______ ______ ______ __________ __________ _______ ______ ____ ____ ___ _________.
___ _____ __________ ______ _____ ______ _________ ________ _______ ____ ___.
____ _______ ______ __________ __________ __________ _______ _______.
____ ______ ____ ______ ________ ___ _____ __________ ____ _______ _____ ___.
__________ _______ ____ _______ ______ __________ ________.
____ ___ _______ _______ _______ _______ __________ __________ __________ _________ ______.
______ ___ _______ ___ _________ ______ ____ __________ ___ ________ ___ _____.
____ __________ ____ _______ _______.
_________ _____ ________ _______ ______ ____ _______ _____ ____.
__________ ________ __________ _______ _________ ____ ________ ________.
________ ______ ________ _____ ________ __________ _____ __________ __________ _______ ______.
______ _________ ______ ______ ______ ____ ____ ____ ______.
_____ ________ _______ _____ ___ __________.
_____ _____ _____ ________ _________ ___ ______ ____ _____ ______.
_____ ____ __________ _____ ______ _________ _______.
_________ ______ ________ ___ _____ _____ ______ _____.
___ _________ _________ ____ _________ ______ _________ ____ _________ _______ _________.
____ _____ ____ _________ _____ _____ ___ _______.
____ ____ ___ _________ ________ ____ ____ ______ ___ ___ ____ ____.
__________ __________ ______ _________ _________ _____ ________ __________ ____.
__________ ________ ______ _______ ___ _________ _____ ________ ________ ________.
_____ _________ _________ _________ ___ ____ _____.
Get Full Answer on WhatsApp
आइए हम एक उदाहरण के रूप में 10 कर्मचारियों की सैलरी शीट को मैन्युअल रूप से (Google Sheets में लागू करने योग्य फार्मूलों सहित) संख्यात्मक रूप से तैयार करें। नीचे सभी कॉलम और गणनाएँ क्रमवार दी गई हैं: --- ### स्तंभ शीर्षक (Column Headings): 1. Employee Name 2. Yearly Basic Salary 3. DA % 4. DA Amount = (DA % × Basic Salary) 5. Provident Fund = 8% of Basic Salary 6. Income Tax Deduction (As per rules given) 7. Net ________ ______ ________ _________ _______ ______ __________ ________ ____ _______.
____ ____ _______ _______ _______ ________ ______ ____ _____ ______ __________.
_____ ________ __________ ___ ______.
____ ________ ______ _____ ____ __________ __________.
____ _________ __________ ___ _________ _______ _____.
_________ __________ ________ _________ __________ _________ ____ _______ ______.
________ ______ ___ _____ ____ __________ _________ _______ ____.
_____ ____ _______ _________ _______ ____ ____ ___ ______ ____.
_______ _________ ____ ________ ___ ________ ________ ___ ________ ________ ___.
_____ _____ _______ _____ __________ ______ ___ _______ ______ _____ _________.
_________ ___ ________ _______ _________ ________ _____ _______ __________ __________.
____ ___ _________ _______ ________ _______ _______ ________ _____ ________ ___ __________.
________ _________ _________ _____ ____ _______ ________ __________ _________ __________ _____.
____ _________ __________ _____ ______ _____ ________ _____ ____ _____ _____.
___ ______ _______ ________ _________ ___ _______ __________ __________.
__________ __________ _________ ___ __________ ____ ________.
____ ___ _______ _____ ___ ___.
__________ _____ __________ _________ ____ ______ ______.
______ ________ _________ ________ ________ ____ ________ _________ ______ ___ _____.
______ __________ ______ _____ _______ __________ _______ ________.
________ __________ ___ _______ __________.
________ ____ ______ ___ ______ ______.
_____ ____ _________ ______ __________ ____ _____ ____ _______ _______.
_________ _______ ______ ______ __________ __________ _______ ______ ____ ____ ___ _________.
___ _____ __________ ______ _____ ______ _________ ________ _______ ____ ___.
____ _______ ______ __________ __________ __________ _______ _______.
____ ______ ____ ______ ________ ___ _____ __________ ____ _______ _____ ___.
__________ _______ ____ _______ ______ __________ ________.
____ ___ _______ _______ _______ _______ __________ __________ __________ _________ ______.
______ ___ _______ ___ _________ ______ ____ __________ ___ ________ ___ _____.
____ __________ ____ _______ _______.
_________ _____ ________ _______ ______ ____ _______ _____ ____.
__________ ________ __________ _______ _________ ____ ________ ________.
________ ______ ________ _____ ________ __________ _____ __________ __________ _______ ______.
______ _________ ______ ______ ______ ____ ____ ____ ______.
_____ ________ _______ _____ ___ __________.
_____ _____ _____ ________ _________ ___ ______ ____ _____ ______.
_____ ____ __________ _____ ______ _________ _______.
_________ ______ ________ ___ _____ _____ ______ _____.
___ _________ _________ ____ _________ ______ _________ ____ _________ _______ _________.
____ _____ ____ _________ _____ _____ ___ _______.
____ ____ ___ _________ ________ ____ ____ ______ ___ ___ ____ ____.
__________ __________ ______ _________ _________ _____ ________ __________ ____.
__________ ________ ______ _______ ___ _________ _____ ________ ________ ________.
_____ _________ _________ _________ ___ ____ _____.
Get Full Answer on WhatsApp
IGNOU NEWS
Assignment Submission Last Date Extended Till 30 June 2026 Click Here★★★IGNOU June 2026 TEE Date Sheet Released Click Here★★★