Scribd
Upload
15 views7 pages

Assignment 1

The document contains a marksheet with scores for students in English, Hindi, and Marathi, along with a sales bonus section for individuals. It also includes salary details for employees, calculations for deductions, and loan payment information. Additionally, there are data entries for fruit counts across different months with specific counting criteria.

Uploaded by

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

Assignment 1

The document contains a marksheet with scores for students in English, Hindi, and Marathi, along with a sales bonus section for individuals. It also includes salary details for employees, calculations for deductions, and loan payment information. Additionally, there are data entries for fruit counts across different months with specific counting criteria.

Uploaded by

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

MARKSHEET

Name English Hindi Marathi TOTAL PER AVG MAX MIN RESULT
Charles S. Billings 28 45 87
Chris Poundsworth 33 76 27
Clark Bickerson 52 38 65
Douglas Williams 49 27 48
Ivan Silberstein 60 70 70
James Millen 59 33 64
Jeffrey P. Jones 78 67 90
Joe Morrison 45 89 67

10000
CREATE PIE CHART BY USING NAME & TOTAL SCORE 8000
12000
SALES DBONUS
JAY 11000
SAM 8000
VIJAY 12000
MAHESH 12500
AJAY 9000
9%
RANK
NAME BASIC SALARY HRA DA TA G SALARY PF PT

John T. Foster 6200


Kurt Kamichoff 5220
Michael Hayden 5300
Phillip A. Todd 6500
Richard E. Card 6000
Rick Fogerty 5400
Robert H. Miller 8000
Stephen C. Carter 8500
Steven H. Katz 9000
Thomas E. Abbott 9500
Tom Brown 8300

BASIC SALARY ABOVE 5000


HRA25% OF BASIC
DA 20% OF BASIC
TA ANY VALUE ABOVE 500
PF 12% OF BASIC
PT WILL BE 300 FOR GROSS SALARY ABOVE 10000 ELSE 200
LIC ANY VALUE ABOVE 1000

DO THE PROPER FORMATING


TOTAL
LIC DEDUCTION NET SALARY
LOAN AMOUNT 150000
RATE 9%
PERIOD 60

PMT 7% 8% 9.0% 10%


36
48
60
72

FIXED AMT 5,000.00


RATE 8%
PERIOD 6

FUTURE VALUE 3 4 5 6
8%
9%
10%
11%

FV 800,000
RATE 8%
PERIOD 8

PV 8% 9% 10% 11%
4
5
6
7
8
NAME MONTHS Data COUNT OF CELL WHICH HAS GOT VALUE
apples JAN 32 COUNT OF CELL WHICH HAS GOT VALUE & TEXT
oranges JAN 54 COUNT OF APPLES IN THE RANGE A2 TO A10
peaches JAN 75 COUNT OF APPLES & PEACHES
apples FEB 86 COUNT FRUIT NAMES ENDING WITH "ES"
peaches FEB 89 COUNT FRUIT NAMES ENDING WITH "ES" AFTER 5 CHARACTER
apple FEB COUNT OF VALUE MORE THAN 55 IN THE RANGE C2 TO C10
mangoes JAN 43
apples JAN 34
mangoes JAN 87
S" AFTER 5 CHARACTER
HE RANGE C2 TO C10

You might also like