Holi Offer - Use Code HOLI24

Register Now

SSC CGL - Sample Computer Proficiency Test (CPT)

Published on Saturday, December 13, 2014
As SSC CGL Tier II has been complete and soon CPT schedules will out, today I am sharing previous year's CPT Sheet sheet based on memory.

Name Basic salary (Monthly) DA HRA Medical allowance Convience Tax Net salary
Ramesh 14000






Suresh 19000





Rahul 25000





Mahesh 32000





  • DA is 90% of the basic salary
  • HRA is 35% of Basic salary + DA
  • Medical allowance is 15% of Basic salary + DA
  • Convience is Rs 5% of Basic salary
  • Annnual income upto Rs 2,00,000 is tax free. 
  • Tax slabs : Upto 2 lakhs - Nil, 2 lakh to 3 lakh - 10% , More than 3 lakh - 20% + 10 % surcharge on gross tax 

Make an excel sheet using follwoing steps :-

  • Make an excel sheet
  • Enter the given data
  • Set font as Arial 12 px and margins 1 inches
  • Adjust height, width and borders of the worksheet
  • Calculate Net salary using excel formaule and print the worksheet

   
ebook store

About us

ramandeep singh

Ramandeep Singh is a seasoned educator and banking exam expert at BankExamsToday. With a passion for simplifying complex concepts, he has been instrumental in helping numerous aspirants achieve their banking career goals. His expertise and dedication make him a trusted guide in the journey to banking success.

  • Follow me:
Close Menu
Close Menu