MS EXCEL, MS ACCESS AND WORD QUESTIONS

Question 1 : A renowned private company pays to its employees the salary on the basis of Basic pay. The components of salary are computed according to the following terms of contract of service: Dearness Allowance is paid @ 32% of basic pay rounded to next 10’s. HRA and TA are computed as: Category HRA(Rs.) TA A 20% of basic 3000 B 30% of basic 5000 C 40% of basic 8000 However, the amount of HRA cannot exceed Rs. 11,000 in any case. Children education allowance is Rs. 500 per month per child up to 2 children. The contribution towards provident fund is 10% of (basic + DA) rounded to next 100’s. Income tax is 15% on (gross –PF) rounded to nearest 10. The basic pay is in the pay scale of 10000-1000-30000. Assume category of employees and generate no. of children between 0 to 5 randomly and fix them before entering them in column. Find out the totals below if basic pay is more than Rs. 15000. Prepare a payroll statement. Q2Question 2 : Prepare a spread sheet in MS EXCEL to classify 100 integers (varying between 200 to 500, Generated at Random) according to the following class intervals: (Fix them before grouping) Class Intervals Frequency < 260 260 - 320 320 - 380 380 - 420 420 < TOTAL Required: • Prepare a pie chart for the above frequency distribution. • Compute mean and standard deviation on the basis of discrete data (Raw data) • Find out sum of the integers which are more than 400 Q3 Question 3 : Given below are the particulars of a Plant and M/c purchased this year COST of Plant & M/c Rs.500,000.00 SALVAGE Value Rs.5,000.00 LIFE of the Plant & M/c (5-20 years) 5 MONTHs in the first (year 1-12) 12 You are required to prepare a generalized depreciation schedule in the given format DEPRICIATION SCHEDULE PERIOD DB METHOD 1 2 3 4 5 Total (The sheet should automatically sum the depreciation charged with change in its life at the end of the life) Q4 Question 4 : An airline company has resized its staff and issuing termination letters to its employees. The information about employee name, gender, address, post, date of termination and compensation due is available in a database. Create a database for at least 5 Employees and write the letter as follows: <<employee name>> <<post>> <<address>> <<here give sir or madam>> SUB: TERMINATION LETTER <<Greeting Line>> You have been terminated from the services from the pos <<post>>due to resizing organization staff with effect from <<date of termination>>. Your compensation of Rs.<<compensation>> has been transferred in the account number 1234567890 of KBI Bank. XYZ Managing Director. DO ALL THE QUESTIONS IN FILE ATTACHED BELOW