SSC CGL - Sample Computer Proficiency Test (CPT)

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


Smart Prep Kit for Banking Exams by Ramandeep Singh - Download here

Join 40,000+ readers and get free notes in your email

1 comment:

  1. Sir please provide ibps po interview digest for commerce background students


Thanks for commenting. Follow us on Telegram. Search BankExamsToday