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 Salary = Basic + DA - PF - Tax --- ### कर्मचारियों का डेटा और गणनाएँ: _____ _________ ____ _______ ________ __________.
______ ______ ______ ___ __________.
_________ ______ _____ ________ _____ _____ ________ ____ _____.
______ _______ __________ __________ __________ ______ _________ ________.
________ _________ ______ _________ _________ _____ ______.
____ _______ _________ ________ _______ _________ ___ ______ __________ _______.
_______ ___ _________ __________ _________.
___ _________ ________ _______ _____ _____ ______ _________ _________ ______ ______.
_______ _______ _____ ____ ________ __________ ________ ______ ___ ________ __________ _________.
______ _______ _______ __________ ____ ______.
__________ _________ _____ ______ _________.
_______ _____ _______ ___ ____ ______ ________ __________ __________ ___.
________ ___ ________ _______ ____ _______ _____ ______ ____ _________ ___.
_____ ________ _____ ____ ____ ________.
_____ ______ ______ ___ ___ _________ ______ _________ ____ ________ __________ _____.
_____ ___ ______ ______ _______ ____ ________ _____ ______ ______ __________ _________.
______ __________ _______ ________ ______ _______.
_____ ________ _________ ______ _________ ____ ___ _______.
_______ _________ ______ ________ _________.
___ ______ _________ ________ ____ ________ _________ __________ ______.
_______ _______ ____ ________ ________ ____ _______ ________ _______ ______ _________ _____.
______ _____ ____ ___ _____ ________.
_________ _____ ___ ____ ______ ________ _________ ____ ___ ____ _____.
__________ ___ ________ ______ __________.
_____ ___ __________ ___ _____ ________ _______ _____ ________.
________ ________ ____ ________ _____ ________ ____ _____ ___ ____ _____ ___.
_________ _______ _____ _______ ____ _______.
______ _____ __________ ___ _________.
_______ _________ __________ _______ ________ ______ ________ ______ ___ ______ _________.
_____ _______ ______ ______ _____ ________ _________ _____ _______ _____.
___ ______ ____ __________ _________ __________ _________.
_________ __________ ____ ________ __________ ______ __________ ___ ____ ___ __________.
________ ____ _____ ____ ______ _____ ________ ____ __________.
_______ _____ __________ ________ ______ _______ ____ _______ __________ __________.
_____ _______ ________ ________ _________ ______ _________.
____ __________ _______ ___ __________ ___ ____.
______ _______ ______ ____ ________ _____.
__________ ________ ________ ___ _______ ________ _______.
_____ _________ ___ _________ _______ _________ ___ ____ ________ _____ _____.
_________ ______ _____ _______ __________.
______ __________ _____ ________ __________ _______ _______ _______ ______ ______ __________.
________ ________ _____ __________ ____ ___ _______ ________ _______ ________ ___.
__________ ___ __________ _________ _________ ______ _____.
_________ ________ ________ __________ ___ _______.
____ ________ _________ ___ ________ _____.
___ ___ _____ _________ ______ ______.
___ ___ _____ _________ _________.
_____ ___ _______ __________ _______ ________ ________ _______.
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 Salary = Basic + DA - PF - Tax --- ### कर्मचारियों का डेटा और गणनाएँ: _____ _________ ____ _______ ________ __________.
______ ______ ______ ___ __________.
_________ ______ _____ ________ _____ _____ ________ ____ _____.
______ _______ __________ __________ __________ ______ _________ ________.
________ _________ ______ _________ _________ _____ ______.
____ _______ _________ ________ _______ _________ ___ ______ __________ _______.
_______ ___ _________ __________ _________.
___ _________ ________ _______ _____ _____ ______ _________ _________ ______ ______.
_______ _______ _____ ____ ________ __________ ________ ______ ___ ________ __________ _________.
______ _______ _______ __________ ____ ______.
__________ _________ _____ ______ _________.
_______ _____ _______ ___ ____ ______ ________ __________ __________ ___.
________ ___ ________ _______ ____ _______ _____ ______ ____ _________ ___.
_____ ________ _____ ____ ____ ________.
_____ ______ ______ ___ ___ _________ ______ _________ ____ ________ __________ _____.
_____ ___ ______ ______ _______ ____ ________ _____ ______ ______ __________ _________.
______ __________ _______ ________ ______ _______.
_____ ________ _________ ______ _________ ____ ___ _______.
_______ _________ ______ ________ _________.
___ ______ _________ ________ ____ ________ _________ __________ ______.
_______ _______ ____ ________ ________ ____ _______ ________ _______ ______ _________ _____.
______ _____ ____ ___ _____ ________.
_________ _____ ___ ____ ______ ________ _________ ____ ___ ____ _____.
__________ ___ ________ ______ __________.
_____ ___ __________ ___ _____ ________ _______ _____ ________.
________ ________ ____ ________ _____ ________ ____ _____ ___ ____ _____ ___.
_________ _______ _____ _______ ____ _______.
______ _____ __________ ___ _________.
_______ _________ __________ _______ ________ ______ ________ ______ ___ ______ _________.
_____ _______ ______ ______ _____ ________ _________ _____ _______ _____.
___ ______ ____ __________ _________ __________ _________.
_________ __________ ____ ________ __________ ______ __________ ___ ____ ___ __________.
________ ____ _____ ____ ______ _____ ________ ____ __________.
_______ _____ __________ ________ ______ _______ ____ _______ __________ __________.
_____ _______ ________ ________ _________ ______ _________.
____ __________ _______ ___ __________ ___ ____.
______ _______ ______ ____ ________ _____.
__________ ________ ________ ___ _______ ________ _______.
_____ _________ ___ _________ _______ _________ ___ ____ ________ _____ _____.
_________ ______ _____ _______ __________.
______ __________ _____ ________ __________ _______ _______ _______ ______ ______ __________.
________ ________ _____ __________ ____ ___ _______ ________ _______ ________ ___.
__________ ___ __________ _________ _________ ______ _____.
_________ ________ ________ __________ ___ _______.
____ ________ _________ ___ ________ _____.
___ ___ _____ _________ ______ ______.
___ ___ _____ _________ _________.
_____ ___ _______ __________ _______ ________ ________ _______.
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★★★