Ditutup

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

Kemahiran: Perakaunan, Pemasukan Data, Pemprosesan Data, Excel, Word

Lihat lagi: vba access export word template excel, word forms macro excel access, dutch english translator ms excel access, vba excel access word visio, word excel access powerpoint, access and excel, automation expert excel vba and ms access kerala, data entry in excel and word, data entry microsoft excel and word, data entry project available no investment excel and word, data entry/ microsoft excel and word, excel and word project - vba, excel and word project vba, how to find computer programmer in pittsburgh familiar with access and word, data entry ,ms excel and word

Tentang Majikan:
( 0 ulasan ) India

ID Projek: #16763832

26 pekerja bebas membida secara purata ₹1212 untuk pekerjaan ini

osmanaydin

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

₹1300 INR dalam sehari
(8 Ulasan)
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 Lagi

₹1500 INR dalam sehari
(4 Ulasan)
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 dalam 10 hari
(1 Ulasan)
0.4
Rosywilly

A proposal has not yet been provided

₹1300 INR dalam sehari
(0 Ulasan)
0.0
datailem

A proposal has not yet been provided

₹600 INR dalam 3 hari
(0 Ulasan)
0.0
CeciliaKh

A proposal has not yet been provided

₹1450 INR dalam sehari
(0 Ulasan)
0.0
narsingbhyramoni

i am interested

₹1300 INR dalam sehari
(0 Ulasan)
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 Lagi

₹650 INR dalam 2 hari
(0 Ulasan)
0.0
pravalikanavya

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

₹1300 INR dalam sehari
(0 Ulasan)
0.0
₹1300 INR dalam sehari
(0 Ulasan)
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 dalam sehari
(0 Ulasan)
0.0
ssho7722

A proposal has not yet been provided

₹1250 INR dalam 2 hari
(0 Ulasan)
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 Lagi

₹1300 INR dalam sehari
(0 Ulasan)
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 dalam 7 hari
(0 Ulasan)
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 Lagi

₹1250 INR dalam 8 hari
(0 Ulasan)
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 dalam 3 hari
(0 Ulasan)
0.0
Sweeta04anu

I will submit the work on time

₹1300 INR dalam sehari
(0 Ulasan)
0.0
kabilankamaraj

A proposal has not yet been provided

₹600 INR dalam 2 hari
(0 Ulasan)
0.0
mmsalmanmm

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

₹1300 INR dalam sehari
(0 Ulasan)
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 Lagi

₹1300 INR dalam sehari
(0 Ulasan)
0.0