As many readers requested e to make a special GK Digest for upcoming insurance exams. Today I am uploading GK Digest for Insurance exams.

**Pages**- 44

**Useful for**- NICL, NIACL, LIC and UIICL

**Format**- PDF

**Price**- Free

**Size**- 383 kb

What's new

This GK digest is different from all previous digests. You will see at least 75% of the questions from this digest.

The best part is - It's Free !

#### What's trending in BankExamsToday

*Smart Prep Kit for Banking Exams by Ramandeep Singh - Download here*
thanks a lot

ReplyDeleteThank you sir can we refer this for nicl assistant exam?

ReplyDeleteYes

ReplyDeleteThanks a lot sir much need ..

ReplyDeleteI really appreciate your work.

Thank you

When uiicl assistant exam held

ReplyDeleteThanks for the useful digest given

ReplyDeleteSir How much we have to score in karnataka region for UIICL. Plz give each session cut off marks.

ReplyDeleteSir i just checked whole pdf. I didnt see insurance compnies nd their tag lines nd ceo nd deir headquaters

ReplyDeletethnks big brother

ReplyDeletesir pls provide new indian assurence exam preparation plan and previous papers

ReplyDeleteHello Sir,When will UIIC AO call letter to be released.Kindly inform in fb when released.Thank you

ReplyDeletesir , plz humble request what could be sectional cut off english for obc....

ReplyDeleteI will do

ReplyDeleteThat's for you !

ReplyDeleteI will update

ReplyDeleteIts awesome. thanks for the update man.. I am refering the same. I have tried to find them on all portal including.. Sarkari Naukri and Govt Jobs

ReplyDeletesir i apply for new India assurance officer post,sir PLZ give me FINANCE digest or objectives on finance because i specialized in finance so i select option of finance in application form.....

ReplyDeletethank u sir

ReplyDeletesir ll u tell me the book provided by u for it officer is completely objective???

ReplyDeleteSir please provide techniques

ReplyDeleteSir when will be the xam for uii

ReplyDeleteI have the p.g degree in msc computer engineering network technology from m.g university, kerala,This degree recognized as equivalent to msc computer science/it of mg university kerala.

ReplyDelete(i have the equivalency certificate).is iam eligible for ibps S.O post.pls answer

thanks for this informational thing it will be helpful in interviews

ReplyDeletesir pls reply to my mail

ReplyDeleteSir please provide the technique ,how to solve it.

ReplyDeleteHello sir good morning may be this post is irrelevant here but I don't know how to communicate with you so I'm posting here.Please check IBPS Today forums many unnecessary messages from spammers and abusive comments.So I request please check and put some filter/security.

ReplyDeleteHi sir ye po3 reserve list k baare me bhi kuch btayiye kab tak aayegi sir plzzzzzzz

ReplyDeletesir u have written in this digest Deepak Gupta appointed as the Chairman of Union Public Service Commission, whereas rajni razdan is appointed as UPSC chairman

ReplyDeleteNo.. dat book from Kiran prakashan is subjective and it covers all the topics that are mentioned in the syllabus for IT officer

ReplyDeleteHere an e book was published some days b4..dont think that 50 rs cost of the book ll cover all the chapters..actualy i hv kiran publication bt that 1 is nt at all satisfied.

ReplyDeleteactually dere are 3 books from kiran prakashan, the one which is priced at 295 is the best one out of the lot and it covers all the topic, one is cheaper book which is a waste and another one is priced above 500 which is way too vast and isnt guud enuf as well, not sure which one u have!

ReplyDeleteSpam filteration system is already there but manual moderation is required.

ReplyDeleteAs most of the moderators lost their interest in the forum or they got placed in the banks and I don't have much time to moderate this forum. Right now I am looking for moderators, let me know if somebody want to be a moderator.

You can mail m here - monty.exe@gmail.com

That's subjective

ReplyDeleteI will update

ReplyDeleteI will release a Finance Digest soon

ReplyDeletethnku, not sure thou which ans is correct becoz multiple sites have given both the ans, the google however shoes razdan

ReplyDeleteThank you for replying

ReplyDeleteSecond list will be out last week of Dec (I am not sure about this)

ReplyDeletehow u know sir ki last week of dec mein aayega ? r u sure 2nd list for clerk3 aayega ?

ReplyDeleteHi,

ReplyDeleteIf you are looking for

sbi bank sbi bank probationary officer po exam bookonline for exams preparation, then i refer you, sura books is best online book shop for buy sbi bank po exam books online and prepare self study materials books and mock test available now.sir can you provide the solution to this excel work sheet.. i am having exam nxt week?? please sir.

ReplyDeleteSir pls give the solution for this problem....specialy the tax part .....

ReplyDeleteFor solving the first question i.e DA is 90% of Basic Salary. The command will be =0.90*b2 where b2 is the address of the cell. In address of the cell, alphabet is the name of the column and number is the name of the row.

ReplyDeleteSo, first command to calculate the DA for Ramesh would be =0.90*B2, where 0.90 is 90/100.Similarly for the rest.

To find the HRA, the formula will be =0.35*(b2+c2) for Ramesh and so on.

To find the medical allowance, formula will be =0.15(b2+c2) for ramesh and so on.

Conveyance will be =0.5*b2 for Ramesh and so on.

Now add all of them with the fomula =12*(b2+c2+d2+e2+f2) for Ramesh and so on. We multiplied 12 to get the annual income.

Now, you will find the everyone has an income above 2lakhs. So, everyone has to pay a 20%+10% tax, total is 30%. So for Ramesh tax come out to be =0.30*g2. Here, g2 is the cell of total salary that I added myself to make calculations easier.

Finally the net salary would be total salary-tax. Formula for which is =g2-h2 for Ramesh and so on.

I hope this helps.

Solution of the Tax part:

ReplyDeleteadd a column for gross salary, make it hidden. Now based on gross salary you have to calculate tax. So let us assume gross salary is being stored in column A. The query for calculating tax will be : =IF(A1<200000,0,IF(AND(A1>=200000,A1<300000),A1*10%,IF(A1>=300000,SUM((A1*20%),(A1*20%)*10%))))

Hi Dwijumani,

ReplyDeleteSolution of the Tax part:

add a column for gross salary, make it hidden. Now based on gross salary you have to calculate tax. So let us assume gross salary is being stored in column A. The query for calculating tax will be : =IF(A1<200000,0,IF(AND(A1>=200000,A1<300000),A1*10%,IF(A1>=300000,SUM((A1*20%),(A1*20%)*10%))))

Thank you sir..

ReplyDeleteThanks sir..

ReplyDeleteanyone pls........paste snapshot of final table

ReplyDeleteDo they ask such tough questions inCPT of insurance or it will be simple table creation and adding the contents of it?? help

ReplyDeleteif a1>300000, to 2-300000 ka 10% bhi to include karna padega ..pllss reply

ReplyDeleteYOUR FORMULA IS NOT CORRECT........

ReplyDeleteIF THE INCOME IS >300000, THEN You are calculating 20% tax rate on the entire amount....which is not correct. .... in this case you also need to calculate tax on every slab.............

Upload correct excel file

ReplyDeleteKYA YE SAHI H.....???/

ReplyDeleteName

ReplyDeleteBasic salary (Monthly)

DA

HRA

Medical allowance

Convience

Tax

Net

salary

Ramesh

14000

12600

17500

14700

700

17640

58800

Suresh

19000

17100

23750

19950

950

23940

79800

Rahul

25000

22500

31250

26250

1250

31500

105000

Mahesh

32000

28800

40000

33600

1600

40320

134400