[go: up one dir, main page]
Scribd
Upload
21 views4 pages

Excel Basic

The document outlines an Excel assignment requiring calculations related to income, employee pay slips, and student marks. It includes specific instructions for calculating various financial metrics such as DA, HRA, and PF for employees, as well as total and average marks for students across different subjects. Additionally, it specifies formatting and data analysis tasks to be performed in Excel.

Uploaded by

pavankumarmpadagali9632
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
21 views4 pages

Excel Basic

The document outlines an Excel assignment requiring calculations related to income, employee pay slips, and student marks. It includes specific instructions for calculating various financial metrics such as DA, HRA, and PF for employees, as well as total and average marks for students across different subjects. Additionally, it specifies formatting and data analysis tasks to be performed in Excel.

Uploaded by

pavankumarmpadagali9632
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 4

EXCEL ASSINMENT

YEAR TOTAL INCOME INTEREST PAID PROFIT TAX PROFIT AFTER TAX
1992 4.222
1993 5.555
1994 7.331 CALCULATED
CALCULATED AS INCOME CALCULATED CALCULATED AS
1995 8.058
AS 20% OF THE (-)MINUS AS 10 % AT PROFIT (-)MINUS
1996 9.02 INCOME INTEREST THE PROFIT TAX ( PROFIT )- (TAX)
1997 13.74 (INCOME)
1998 15.161
1999 20.988

NAME AGE BASIC DA HRA TA GROSS PF NET


ARUN 25 1500
MARY 21 1400
JAMES 19 2200
SUNIL 24 2100
GANESH 29 2500
VINAY 32 3000
VISHAL 18 2500
ARTHI 20 2200
RAVI 29 2000
PREETI 30 1100

CALCULATE THE FOLLOWING

1) Calculate DA at 30% of basic


2) Calculate HRA at 15% of basic
3) Calculate TA at 10% of basic
4) Calculate PF 3% of basic
5) Gross = Basic + DA +HRA + TA
6) Calculate Net = Gross-PF
7) Include two decimals to pf & net amount
8) Insert a Row at the top & type the heading "EMPLOYEES INFORMATION PAY SLIP"
9) Format the Row heading & column heading
By including Bold with font size 14
10) Apply Center alignment for all headings.
11) Calculate total of Basic, TA, DA, Gross, Net
12) Calculate maximum of Basic
13) Calculate minimum of Basic
14) Calculate maximum and minimum of gross
15) Calculate average of Gross.
STUDENTS NAME SUBJECTS MARKS
ARUN WORD 54
ARUN EXCEL 53
DINESH WINDOW 65
DINESH WORD 88
DINESH EXCEL 62
GANESH WORD 72
GANESH WINDOWS 35
MAHESH WORD 83
MAHESH WINDOW 84
SATISH WINDOWS 73
SATISH EXCEL 88
VINAY EXCEL 92
VINAY WORD 72

CALCULATE THE FOLLOWING


1) TOTAL MARKS
2) AVERAGE MARKS
3) MAXIMUN MARKS
4) MINIMUM MARKS
5) COUNT FOR WORD
6) COUNT FOR EXCEL
7) Count for windows
8) Total marks of word.
9) Total marks of excel
10) Total marks of windows
11) Count for ganesh
12) Total of marks for dinesh
13) Find the remarks for using if condion as given below.
MARKS Remarks
>=75 excellent
>=60 good.
>=50 poor
<=50 bad

You might also like