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

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

Tietoa työnantajasta:
( 0 arvostelua ) India

Projektin tunnus: #16763832

26 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

osmanaydin

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

₹1300 INR 1 päivässä
(8 arvostelua)
3.5
rcnvw

Hi, I have already solved example 1 in the attached. [login to view URL] Please note the formulas are password protected On acceptance of the bid, I will complete t Lisää

₹1500 INR 1 päivässä
(4 arvostelua)
3.0
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 10 päivässä
(1 arvostelu)
0.4
Rosywilly

A proposal has not yet been provided

₹1300 INR 1 päivässä
(0 arvostelua)
0.0
datailem

A proposal has not yet been provided

₹600 INR 3 päivässä
(0 arvostelua)
0.0
CeciliaKh

A proposal has not yet been provided

₹1450 INR 1 päivässä
(0 arvostelua)
0.0
narsingbhyramoni

i am interested

₹1300 INR 1 päivässä
(0 arvostelua)
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 Lisää

₹650 INR 2 päivässä
(0 arvostelua)
0.0
pravalikanavya

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

₹1300 INR 1 päivässä
(0 arvostelua)
0.0
₹1300 INR 1 päivässä
(0 arvostelua)
0.0

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

₹1300 INR 1 päivässä
(0 arvostelua)
0.0
ssho7722

A proposal has not yet been provided

₹1250 INR 2 päivässä
(0 arvostelua)
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 Lisää

₹1300 INR 1 päivässä
(0 arvostelua)
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 7 päivässä
(0 arvostelua)
0.0
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 Lisää

₹1250 INR 8 päivässä
(0 arvostelua)
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 3 päivässä
(0 arvostelua)
0.0
Sweeta04anu

I will submit the work on time

₹1300 INR 1 päivässä
(0 arvostelua)
0.0
kabilankamaraj

A proposal has not yet been provided

₹600 INR 2 päivässä
(0 arvostelua)
0.0
mmsalmanmm

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

₹1300 INR 1 päivässä
(0 arvostelua)
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 Lisää

₹1300 INR 1 päivässä
(0 arvostelua)
0.0