47 Sheet1

lish
eng
1/1/2022 123 GOOD time time time
GOOD GOOD 1/2/2022 124 GOOD 11:45
GOOD GOOD 44564 125 GOOD 12:45
GOOD GOOD 44565 126 GOOD 13:45
GOOD GOOD 44566 127 GOOD 14:45
excel is very good for
begineers and 44567 GOOD mon 15:45
GOOD GOOD 44568 GOOD tue 16:45
GOOD GOOD GOOD GOOD wed 17:45
GOOD GOOD GOOD GOOD thu 18:45 Column1 Column2 Column3 Column4 Column5
GOOD GOOD GOOD GOOD fri time
GOOD GOOD GOOD GOOD sat
GOOD GOOD GOOD GOOD sun
GOOD GOOD GOOD GOOD mon
GOOD GOOD GOOD GOOD tue
1
4
8
8
21

p
Column1 Column2 Column3 Column4
1
4 Column2 Column3 Column4 Column5
8 Column2 Column3 Column4 Column5
Column1 Column2 Column3 Column4 8 Column2 Column3 Column4 Column5
21 Column2 Column3 Column4 Column5
Column1 Column2 Column3 Column4 Column5
Column2 Column3 Column4 Column5
Column2 Column3 Column4 Column5
Column2 Column3 Column4 Column5

1 6
5 9 1 5 4 6
4 32 6 9 32 11
6 11

file:///conversion/tmp/activity_task_scratch/647322597.xlsx 02/26/202316:08:29 647322597.xlsx

$ 1.00
$ 2.00 2%
$ 4.00 2%
$ 7.00 5%
$ 8.00 7%
$ 5.00 8% k
$ -

Jeenesha
JEENESHA
 s.no name DATE
7 G1 4/Jun/2021
1 Anita 2/May/2021
2 Sunil 3/Jun/2021
3 Mona 5/May/2021
jeenesha 6 neha 6/Jul/2021
JEENESHA 5 Shreya 7/May/2021
4 Soni 8/May/2021

Jeenesha EJEJE
ID NAME HR 18 HR 19
101 A 1100 1500 2600 3900000 6
102 B 1400 1445 2845
103 C 1900 7856 9756
104 D 9000 2630 11630
105 E 5230 784 6014
106 G 4521 452 4973 11630

6303 2600
ABHGFD UJHGT ABHGFD U

Name Month Product Sales

Ajay Jan CD 400
sunil Feb DVD 250 400
Karan Mar PEN 300 Err:504
POONA Apr HARD DISK 800
NASIL May MOUSE 147
SHEETAL Jun MONIYTER 371
JEERA Jul PEGNS 454 250

Name Month Product Sales

Ajay Jan CD 400

product n price per box quantity total product n

pencil 700 50 35000 pen
pen 500 23 11500
pouch 300 99 29700 11500
pencil 150 100 15000
 122203833

HR 18
10000
9000
8000
7000
6000
5000
4000
3000
2000
1000
0
A B C D E G

price per box

>200
s.no product n Company stock Company
1 pencil natraj 50 natraj
2 pen jalin 23
3 pouch JIFFY 100
4 box cello 90 50
5 rular abhi 60
 TOTAL
DRESS MATERIALSIZE COLOR PIECE

Salwar Cotton S BLACK 9 DRESS MATERIALSIZE COLOR

Plazzo Rayon M WHITE 80 LEGGING RAYON S WHITE
Salwar Cotton XL BLUE 50
Kurta Set Cotton XXL WHITE 40 ###
Salwar Cotton XXL GREEN 24 ###
Plazzo Rayon XL BLACK 65
Dupatta Cotton S WHITE 19
Legging Rayon xl BLUE 8
Dupatta Rayon M WHITE 56
Legging Rayon M GREEN 76
Saree Silk N/A GREY 22
Legging Cotton M PINK 67
Saree Silk N/A GREY 87
Salwar Cotton XXL BLACK 89 20
Dupatta Cotton S WHITE 34 20 20
Legging Cotton S 90
Legging Rayon S WHITE
Legging Cotton M GREY 9
Legging Rayon M GREY 25
Plazzo Cotton XL GREY 46
Plazzo Rayon XXL GREY 58
TOTAL
PIECE
0

4 12/18/2022
s.no name boy/girl %
1 anita girl 63
### 2 sunil boy 49
12:56 PM 3 jeevan boy 85
4 shreya girl 67
5 neha girl 57

AJAY A P P P P P

2
 s.no product name Company stock Company stock
boy 1 1 pencil natraj 50 natraj >=50
girl 2 2 pen jalin 23
3 pouch natraj 100
4 box cello 90
5 rular abhi 60

PRESENT ABSENT
P A A P P A P 9 4
2
 JEENESHA COMPUTERS

01 02 03 04 05 06 07 08 09 10 11 12
S.NO NAME
Sat Sun Mon Tue Wed Thu Fri Sat Sun Mon Tue Wed
1 AJAY P Sun P A P P P P Sun P P A
2 ANISHA A Sun P P P P P P Sun P P P
3 ANITA P Sun A P P P P P Sun P P P
4 BALI P Sun P P P P P P Sun P P P
5 CHAND P Sun P A P P P P Sun P P P
6 DINESH P Sun P P P P P P Sun P P P
7 NIMA P Sun P P P P P P Sun P P P
8 PRIYA P Sun P P P P P P Sun P P P
9 RIYA A Sun P P P P P P Sun P P P
10 SIYA P Sun P P A P P P Sun P P P

NUMBER DIVISOR
45 2 1 ODD
36 3 0 EVEN
987 2 1 ODD
545 2 1 ODD
578 2 0 EVEN
25 5 0 EVEN
546 2 0 EVEN
423 2 1 ODD
875 7 0 EVEN

S.NO NAME ENG HINDI

1 AJAY 24 36
2 VIJAY 65 40
3 POONAM 69 65
4 PRIYA 78 87
5 RITU 5 32
6 RIYA 12 12
7 ANITA 32 39
8 kio 78 24
 13 14 15 16 17 18 19 20 21 22 23
Thu Fri Sat Sun Mon Tue Wed Thu Fri Sat Sun
P P P Sun P P P P P P Sun
P P P Sun P P P P P P Sun
P P P Sun P P P A P P Sun
P P A Sun P P P P P P Sun
P P P Sun P A P P P P Sun
P P P Sun P P P P P P Sun
P P P Sun P P P A P P Sun
P P P Sun P P P P A P Sun
P P P Sun P P P P P P Sun
P A P Sun P P P P P P Sun

S.NO NAME ROLL NO.

236.54 237 1 AJAY 5
2 VIJAY 9
3 POONAM 7
4 PRIYA 18
5 RITU 15
6 RIYA 4
7 ANITA 6
8 NIMA 20
9 JEEVAN 19
MATHS SCIENCE 10 SHREYA 17
89 21 0 0
98 78 1 0 MEGENTA 1
52 85 1 1 ORANGE 1
42 75 1 0 YELLOW 0
69 98 0 0 MEGENTA 1
23 62 0 0 PURPLE 0
10 12 0 0 MEGENTA 1
63 95 0 0 RED 0 5 120
ORANGE 1
YELLOW 0
RED 0
ORANGE 1
RED 0
MEGENTA 1
 24 25 26 27 28 29 30
PRESENT ABSENT
Mon Tue Wed Thu Fri Sat Sun HOLIDAY
P P P P P P Sun 23 2 5
P P P A P P Sun 23 2 5
P P P P P A Sun 22 3 5
P P P P P P Sun 24 1 5
P P P P P P Sun 23 2 5
P P P P P P Sun 25 0 5
P P P P P P Sun 24 1 5
A P A P P P Sun 22 3 5
P P P P P P Sun 24 1 5
P P P P P P Sun 23 2 5

NUMBER
ROOM 1 0 236.56546 236.57 236.57 236.56
ROOM 1 58.25485 58.25 58.26 58.25
ROOM 1 56.2321 56.23 56.24 56.23
ROOM 2 569.61453 569.61 569.62 569.61
ROOM 1 45.3254 45.33 45.33 45.32
ROOM 2 245.365654 245.37 245.37 245.36
ROOM 2
ROOM 2
ROOM 1
ROOM 1
 JEENESHA COMPUTERS

PURCHASE
S.NO PRODUCT QUANTITY PRICE TOTAL DISCOUNT NET GST
1 MOUSE 12 600 7200 720 6480 216
2 MONITER 4 450 1800 180 1620 54
3 KEYBOARD 5 855 4275 427.5 3847.5 128.25
4 PEN DRIVE 8 1500 12000 1200 10800 360
5 SMPS 6 874 5244 524.4 4719.6 157.32

S.NO NAME COURSE NA COURSE FEPAY FEES DUE ADVANCED

1 JEEVAN MSCIT 3350 850 2500 0
2 SHREYA TALLY 4200 3000 1200 0
3 NIPUN C LANGUAGE 3250 7000 0 3750
4 NEHA PAGE MAKE 3350 2000 1350 0
5 RIDDHI MSCIT 3500 2000 1500 0
6 ANITA PHOTOSHOP 3250 5000 0 1750
7 VIPUL CORAL DRA 4000 9000 0 5000
8 RISHI DTP 5000 5000 0 0
9 RITU C++ 3550 2500 1050 0
10 RIYA PAGE MAKE 3350 7000 0 3650
 S.NO NAME TEST 1 TEST 2 TEST 3 TEST 4 TOTAL FINAL %
NET 1 NEHA 88 96 89 45 318 80%
7416 2 RIDDHI 65 89 98 78 330 82.5%
1854 3 ANITA 69 65 52 85 271 67.8%
4403.25 4 VIPUL 98 87 78 86 349 87.3%
12360 5 RISHI 62 32 69 98 261 65.3%
5401.32 6 RITU 12 12 23 62 109 27.3%
7 RIYA 32 39 45 53 169 42.3%
8 SHREYA 96 92 95 98 381 95.3%

400
PASS /FAIL REMARK
PASS C
PASS C
PASS D
PASS B
PASS D
FAIL FAIL
PASS E
PASS A
S.NO NAME MOBILE ADDRESS DOB
1 JEENESHA 8574963210 PUNE 4/5/2003
2 GO 8574763210 4/5/2003
3 KO 8575963210 4/5/2003
4 PA 8574663210 4/5/2003
5 IK 8574963240 4/5/2003
6 RT 8574967210 4/5/2003
7 YG 8574966210 4/5/2003

JEENESHA jikll jkiol

JEENE
JEENESHA

LALU RAM YADAV PANDIT 2 7

2 7 11
-5 -4
$7.00 5 4

PRINCIPAL AMT RATE TIME

15000 10 3
15000 10% 2
15000 10% 48
DOJ CITY STATE
4/10/2015 PUNE MAHA

WHO YOU ?

JEENESHA COMPUTERS

JEENESHAjiklljkiol

JEENEJEENEJEENEJEENEJEENE
1 JEENE

11 13 17

13 17 5 CXXV
-2 -4 12 125.4 125 3999
2 4 12 7895.5 7895
52.6 52
SIMPLE INTEREST

4500 PRINCIPAL AMT 10000 25000

3000 RATE 10 8.5
6000 TIME 3 4
COMPOUND
INTEREST
 WHO YOU /

JEENESHA COMPUTERS NISHKA COMPUTERS

JEENE JEENE JEENE JEENE JEENE

JEENE JEENE JEENE JEENE JEENE

84

MMMCMXCIX

YEARLY 3310
HALF YEARLY 3400.96
QUARTERLY

MONTHLY
LOAN AMOUNT 40,000.00
RATE 4
TIME 12
19,200.00 4 5 6 7
12 Err:504 Err:504 Err:504 Err:504
24 Err:504 Err:504 Err:504 Err:504
36 Err:504 Err:504 Err:504 Err:504
48 Err:504 Err:504 Err:504 Err:504
60 Err:504 Err:504 Err:504 Err:504
72 Err:504 Err:504 Err:504 Err:504

1 4 5
5 1 5 8
7 2 6 4
8 3 7 9
6 4 8
5 9 4

NUMBER DIVISOR DIVIDE CEILING NUMBER

54623 3 18207.666667 54624
54621
26 3 8.6666666667 27

VALUE ISTEXT

Ramesh 1

$#@ 1

123456 0
udaipur0294 1
 8 8 5 8 7
8 7 7 7 8
8 9 8 5 6 7 8
Err:504 Err:504 7 6 8 7 7
Err:504 Err:504 5
Err:504 Err:504 0.57363 1.41923 3.49075 3.51929 1.22332
Err:504 Err:504 2.7067 0.60417 1.32882 2.01665 2.76226
Err:504 Err:504 3.75613 3.87047 3.9606 2.21668 0.01413
Err:504 Err:504 3.32998 2.45151 2.94933 3.01146 3.53868
0.84531 2.8821 0.76567 2.87091 2.92442
1.42556 3.8529 0.50172 1.83775 2.65218
2.40568 2.64264 0.97831 2.18314 2.88402
2.48372 0.32323 3.66366 3.77209 1.91596

EXAM PAPER
ENG
MATHS
NUMBER DIVISOR DIVIDE FLOOR SCIENCE
23624 3 7874.67 23622 SOCIAL STUDY
GEOGRAPHY
27 4 6.75 HISTORY
PERCENTAGE
VALUE ISTEXT 1
Ramesh 0 2
$#@ 0 1
1 1
123456 1
udaipur0294 0
 8 8 5
8 6 8
5 5 5
7 6 0.57363 1.41923 3.49075 3.51929 1.22332 3.12825
2.7067 0.60417 1.32882 2.01665 2.76226 3.96633
3.12825 3.75613 3.87047 3.9606 2.21668 0.01413 3.82133
3.96633 3.32998 2.45151 2.94933 3.01146 3.53868 0.36166
3.82133 0.84531 2.8821 0.76567 2.87091 2.92442 1.83623
0.36166 1.42556 3.8529 0.50172 1.83775 2.65218 2.36949
1.83623 2.40568 2.64264 0.97831 2.18314 2.88402 2.55662
2.36949 2.48372 0.32323 3.66366 3.77209 1.91596 2.27574
2.55662
2.27574

MARKS
45
56
66
78
65
50
60
78
66
45
 YEAR DEPRICIATION
ITEM COMPUTER 1 Rs.13,750.00
INITIAL COST 50,000.00 2 Rs.9,968.75
SALVAGE COST 10,000.00 3 Rs.7,227.34
LIFE PERIOD 5 4 Rs.5,239.82
5 Rs.3,798.87
39985

DIFFERENCE 10,015.21
 DETAILS
S.NO NAME DOB DOJ ADDRESS AGE MOBILE NO.
1 A
2 B
3 C
4 D
5 E
6 F
JOB
 DETAILS
S.NO NAME DOB DOJ ADDRESS AGE MOBILE NO.
1 A
2 B
3 C
4 D
5 E
6 F
JOB
 DETAILS
S.NO NAME DOB DOJ ADDRESS AGE MOBILE NO.
1 A
2 B
3 C
4 D
5 E
6 F

NAME DOB CURRENT DATE

JEEVAN 1/8/2000 2/26/2023
JEENESHA 10/5/2003 2/26/2023

FUTURE VALUE

RD AMOUNT 2000
MONTH 24 CAR
RATE OF INTEREST 6% LOAN AMOUNT 800,000
FUTURE VALUE (Rs.51,118.23) DOWN PAYMENT 300,000
NPER 7
RATE 9%
LIC PREMIUM 10000 PMT (Rs.8,044.54)
YEAR 10
RATE OF INTEREST 8%
(Rs.156,454.87)
 JOB
CAR
LOAN AMOUNT
DOWN PAYMENT
NPER
RATE
PMT

YEAR MONTH DAYS DAY AGE

23 1 18 SAT 23YEARS 1MONTHS 21DAYS
19 4 21 SUN

CAR
LOAN AMOUNT 1,600,000
DOWN PAYMENT 100,000
NPER 10
RATE 7%
PMT (Rs.17,315.27)
9%
7
500,000.00
 1,600,000
100,000
10
7%
(Rs.17,416.27)
Scenario Summary
Current Values: MIN MAX
Changing Cells:
$B$3 10000 9000 12000
$B$4 1000 950 2000
$B$5 900 800 950
$B$6 500 450 500
Result Cells:
$B$7 12400 11200 15450
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
Scenario Summary
Current Values: MIN MAX DEC LATEST
Changing Cells:
$B$3 10000 9000 12000 9800
$B$4 1000 950 2000 1050
$B$5 900 800 950 700
$B$6 500 450 500 450
Result Cells:
$B$7 12400 11200 15450 12000
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
 Peacock Co.
Jan
Plastic 10000
Power 1000
Other Material 900
Labour 500
Total 12400
Scenario Summary
Current Values: MIN DEC MAX DEC
Changing Cells:
$B$3 9800 9000 10000
$B$4 1050 1000 1100
$B$5 600 500 650
$B$6 450 400 500
Result Cells:
$B$7 11900 10900 12250
Notes: Current Values column represents values of changing cells at
time Scenario Summary Report was created. Changing cells for each
scenario are highlighted in gray.
 Peacock Co.
Dec
Plastic 9800
Power 1050
Other Material 600
Labour 450
Total 11900
 Peacock Co.
Dec-01 S.no Fruit in kg
Plastic 9800 1 Banana
Power 1050 2 Chiko
Other Material 700 3 Orange
Labour 450 4 Grapes
Total 12000

Sales Sales
Id No. Name Age Department 2016 2017
100 Mohit 45 Garments 1200 5100
101 Mayank 36 Garments 1100 1500
102 Jay 25 Garments 1400 1400
103 Rohan 46 Garments 1600 2300
104 Kavita 35 Electronic 1800 2500
105 Sonam 26 Electronic 3695 2900
106 Swati 41 Electronic 3200 2654
107 Rahul 32 Furniture 7523 3256
108 Narendra 30 Furniture 800 4597
109 Sahil 28 Furniture 1000 3215
110 Ganesh 29 Furniture 3000 2456

102 Jay 25 Garments 1400 1400

VLOOKUP
Students name Test 1 Test 2 Test 3 Test 4 Total
Mohit 12 36 89 21 158
Mayank 95 93 98 96 382
Jay 90 65 80 85 320
Rohan 78 87 42 75 282
Kavita 62 32 69 98 261
Sonam 32 39 45 53 169
Swati 78 24 63 95 260
Raj Fruits Shop Bharav FruGCD Ratio 8 16 24
50 200 50 1:4 3 6 8
100 200 100 1:2 12 15 20
150 300 150 1:2 3 6 13
200 250 50 4:5 7 4 8

Total 1:4 Name Mohit

6300 AGE
2600 45 Name JAY
2800 ID NO.
3900 Electronic 102
4300
6595
5854
10779 50
5397 Err:502
4215
5456

2800

Final % Grade Score Grade

39.5 E 35 & Below Fail
95.5 B 36 E
80 B 59.5 D
70.5 C 69.5 C
65.25 D 79.5 B
42.25 E 89.5 & Above A
65 D
48
 TERM 1 TEST SERIES
MUKESH RAHUL JAYESH MONA SWATI ALKA
English 98 78 45 54 75 28
Hindi 52 95 36 53 24 97
Maths 63 45 75 24 85 86
Science 74 39 12 97 97 75
S.S 85 78 54 64 34 68
History 96 36 82 87 56 54
G.K. 36 75 31 54 54 78

English Hindi Maths Science S.S History

RAHUL 78 95 45 39 78 36

PRODUCT JAN FEB MAR APR MAY JUN

PRINTER 78 95 45 39

Id No. TITLE Name AGE Department Total MBI

1000123 MR Mohit 45 Mechanical 24418 1254896000
1100124 MRS Mayank 25 Mechanical 19021
1200125 Jay 26 Mechanical 15554 MR
1300126 P Mechanical 21742 MRS
1400127 Kavita Technical 22278 MS
1500128 Sonam Technical 19265
1600129 Swati Technical 23088
1700130 Rahul Technical 20387
1800131 Narendra Furniture 22464
1900132 Sahil Furniture 19727
2000133 Ganesh Furniture 13518
 SALES BY MONTH
BABLU TOTAL PRODUCT MOUSE PRINTER KEYBOARDMONITER SCANNER
36 414 JAN 98 78 45 54 75
85 442 FEB 52 95 36 53 24
72 450 MAR 63 45 75 24 85
64 458 APR 74 39 12 97 97
58 441 MAY 85 78 54 64 34
97 508 JUN 96 36 82 87 56
94 422 JUL 36 23 31 54 54
AUG 25 50 21 35 21
G.K. SEP 32 36 32 12 33
75 OCT 12 23 42 42 23
NOV 54 21 50 23 33
DEC 8 25 14 25 24

JUL AUG SEP OCT NOV DEC

Id No. Name Department Total

1400127 Kavita Technical 22278

S.NO NAME TEST 1 TEST 2 TEST 3 TEST 4 TOTAL FINAL %

1 NEHA 88 96 89 45 318 80%
2 RIDDHI 65 89 98 78 330 82.5%
3 ANITA 69 65 52 85 271 67.8%
4 VIPUL 98 87 78 86 349 87.3%
5 RISHI 62 32 69 98 261 65.3%
6 RITU 12 12 23 62 109 27.3%
7 RIYA 32 39 45 53 169 42.3%
8 SHREYA 96 92 95 98 381 95.3%
TH
RAM HARD DISK
28 11
97 22
86 32
75 42
68 10
54 25
21 6
6 54
42 25
12 21
32 23
42 42

768
Subject Ashin Bablu Chetan Jitendra Firoj Gajendra
Hindi 82 95 95 25 36 86
English 36 62 23 65 95 75 G1
Maths 25 10 65 41 26 98 Gajendra BABLU
Science 42 36 26 25 42 78 490
History 58 42 45 86 36 56
Total 243 245 254 242 235 393
 exam 1
name practical marks theory marks grand total
anita 25 21 46
sunil 22 20 42
jeevan 23 15 38
shreya 19 10 29
neha 12 8 20
 exam 2
name practical marks theory marks grand total
anita 25 21 46
sunil 23 20 43
jeevan 24 20 44
shreya 15 10 25
neha 12 18 30
 S.no Item Quantity Price Amount Sales Tax Total
exam 3 1 Chair 4 200 800 44 844
name practical marks theory marks grand total 2 Table 5 400 2000 110 2110
anita 25 15 40 3 Fan 2 450 900 49.5 949.5
sunil 19 20 39 4 Bed 3 5642 16926 930.93 17856.93
jeevan 23 14 37 GST 5.50%
shreya 6 25 31
neha 10 23 33

1 1.5 2 2.5 3 3.5 4

1 1 1.5 2 2.5 3 3.5 4 91 918527419630 918527419630
1.5 1.5 2.25 3 3.75 4.5 5.25 6 918527419631
2 2 3 4 5 6 7 8 918527419632
2.5 2.5 3.75 5 6.25 7.5 8.75 10 918527419633 CD
3 3 4.5 6 7.5 9 10.5 12 CD
3.5 3.5 5.25 7 8.75 10.5 12.25 14 CD
4 4 6 8 10 12 14 16 14 - 16 CD
0 0 0 0 0 0 0 PEN
PEN
PEN
15 15 PEN
225 30 15 15 15 HARD
22 3375 60 225 210 30
23 50625 120 60
24 759375 240 80
11390625 480 102.5
26 1 170859375 960 100 125 15
27 2562890625 15 3 147.5
28 38443359375 15 5 170
576650390625 7 192.5
9 215
11 237.5
13
 practical marks theory marks grand total
2022 Yesterday 25 21 46
2022 Yesterday 25 21 46
2022 Yesterday 25 15 40
anita 75 57 132
sunil 64 60 124
jeevan 70 49 119
shreya 40 45 85
neha 34 49 83