MS EXCEL, MS ACCESS AND WORD QUESTIONS

Closed Posted 5 years ago Paid on delivery
Closed 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

Accounting Data Entry Data Processing Excel Word

Project ID: #16763832

About the project

26 proposals Remote project Active 5 years ago

26 freelancers are bidding on average ₹1212 for this job

osmanaydin

Hello sir, I am interedted in your project. I would like to discuss details via pm. Yours sincerely,

₹1300 INR in 1 day
(8 Reviews)
3.5
khawlahd

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

₹1300 INR in 10 days
(1 Review)
0.4
brightpower

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

₹1250 INR in 8 days
(0 Reviews)
0.0
alimranhaw

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

₹1250 INR in 1 day
(0 Reviews)
0.0
jayoyao

Understand their project needs. Explain how your skills and experience make you the right freelancer for the job. Outline how you plan to complete their project and techniques you will use. Invite them to contact yo More

₹1300 INR in 1 day
(0 Reviews)
0.0
mmsalmanmm

I already designed same application for a company herein Pakistan. Kindly proceed further for development of application.

₹1300 INR in 1 day
(0 Reviews)
0.0
kabilankamaraj

A proposal has not yet been provided

₹600 INR in 2 days
(0 Reviews)
0.0
Sweeta04anu

I will submit the work on time

₹1300 INR in 1 day
(0 Reviews)
0.0
Pankajm013

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.

₹850 INR in 3 days
(0 Reviews)
0.0
nimratariq53

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 ..

₹1300 INR in 7 days
(0 Reviews)
0.0
Rosywilly

A proposal has not yet been provided

₹1300 INR in 1 day
(0 Reviews)
0.0
zainabnafees

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

₹1300 INR in 1 day
(0 Reviews)
0.0
ssho7722

A proposal has not yet been provided

₹1250 INR in 2 days
(0 Reviews)
0.0
sufyaanadvertis8

Describe your proposal Your proposal is your chance to make a good first impression with the employer! Make it count!

₹1300 INR in 1 day
(0 Reviews)
0.0
pravalikanavya

Hi I am interested to take the project Relevant Skills and Experience I am relevant experienced of 1 year

₹1300 INR in 1 day
(0 Reviews)
0.0
ShamanthMuroor

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

₹650 INR in 2 days
(0 Reviews)
0.0
narsingbhyramoni

i am interested

₹1300 INR in 1 day
(0 Reviews)
0.0
CeciliaKh

A proposal has not yet been provided

₹1450 INR in 1 day
(0 Reviews)
0.0
datailem

A proposal has not yet been provided

₹600 INR in 3 days
(0 Reviews)
0.0
nicolasbeltrang

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

₹1300 INR in 1 day
(0 Reviews)
0.0