MS EXCEL, MS ACCESS AND WORD QUESTIONS
₹600-1500 INR
Paid on delivery
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
Project ID: #16763832
About the project
26 freelancers are bidding on average ₹1212 for this job
Hello sir, I am interedted in your project. I would like to discuss details via pm. Yours sincerely,
hi there i think that you found the right person for acheive this work its"me" but i can give you a sample before starting the work and you decide if you like or no
Dear Sir, I am skilled and experienced your requirement . I have more than 2 years experience in this filed and online marketing. I feel fit for your project. I must give you a better service than others. Please fee More
Assalamu Alaikum I am Imran, I am very much willing to do this, I have done a lot of work here, I am a computer entrepreneur in the Postal Department. These are our jobs, such as elderly allowance, widow allowance, und More
I already designed same application for a company herein Pakistan. Kindly proceed further for development of application.
hi dear, I am Pankaj Mahindru from Chandigarh. I am an accountant and I have 4 year of experience in accountancy. last but not least, accountancy is my passion.
I am the student of accounting and i know how to use excel ... Relevant Skills and Experience 1year online job i done and recently i worked in bank ..
I an IT graduate and can assist you with following skill sets. Typing speed of 40 words per minute I can complete your task within minimum time slot. Effectively analyse financials and data, forecast any future b More
Describe your proposal Your proposal is your chance to make a good first impression with the employer! Make it count!
Hi I am interested to take the project Relevant Skills and Experience I am relevant experienced of 1 year
I am a student studying in degree college in mangalore, India, we had almost the same questions for my college assignment. I am free and can be useful for your work. Also I am in need for money! Let me know if you are More
Hi. As a software developer I have the required know-how to fullfill your requirement in this project. In fact I'm already working on it to deliver it in a few hours, i f you decide to select me. I can guarantee More