New Student Offer - Use Code HELLO

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


Can I help you?

ramandeep singh

Hey I am Ramandeep Singh. I am determined to help students preparing for RBI, SEBI, NABARD and IBPS exams. Do you want me to help you ?

Join my class here
    Follow me:
Close Menu
Close Menu