Column1 Column2 Column3

211 jdlflsdj 976887

212 nkjbhkh 6465456
213 khggkgh 5757576
214 hkhhg 3464466
215 jhgjg 4354336
216 ljhhlh 7657565
217 gjhggk 6435434
218 ,hkhhg 87786
219 kjkkjhk 8687
220 oipoijl 321321
Roll No Studetn Name Fees USN Student
1 Student1 456789 3vc22cs123 Student1 Criteria
2 Student2 345678 3vc22cs171 Student2
3 Student3 123456 3vc22cs101
2 Student2 10000 3vc22cs171
1 Student1 20000 3vc22cs123
4 Student4 90123 3vc22cs172
5 Student5 89012 3vc22cs079
Roll No Studetn NamFees USN Studetn Name
1 Student1 456789 3vc22cs123 Student1
2 Student2 345678 3vc22cs171 Student2
3 Student3 123456 3vc22cs101
2 Student2 10000 3vc22cs171
1 Student1 20000 3vc22cs123
4 Student4 90123 3vc22cs172
5 Student5 89012 3vc22cs079 Roll No Studetn N Fees USN
1 Student1 456789 3vc22cs123
2 Student2 345678 3vc22cs171
2 Student2 10000 3vc22cs171
1 Student1 20000 3vc22cs123
Jan 100
Feb 200
March 150
April 300
whole Numbers Text Length Dates Time drop down lidecimal
10 carrom 1/1/2016 1:00 bellary 1.2
11 cricket 1/2/2016 1:10 coorg 1.3
12 hockey 1/3/2016 1:20 coorg 1.4
13 balloon 1/4/2016 1:30 bangalore 1.5
14 batman 1/5/2016 1:40 mysore 1.6
15 catch 1/6/2016 1:50 mysore 1.7
input message
error message

0
NAME HEIGHT AGE
Mahesh 5.1 17 6
Bhagath 5.3 19
Sachin 5.5 21
Rahul 5.7 23
Narendra 5.9 25
Bharath 6.1 27
roll no name usn mobile no mobile no
3 kljklj 4556 6546464 4579866
5 bvn 67657 6546464 4579866
7 yuyj 7868 65787798 4579866
8 jhkj 987 43543434 4579866 66
9 hfhf 3465 768764 4579866 66
11 fsfd 546 66464465 4579866 66
12 sdfds 435 7768767 4579866 65

Axis Title
65
65

usn 5
7868
Sum of mobile no usn name
546 Char t Title
546 Result 7868 7868 ResultTotal Result
roll no fsfd yuyj
66500000 66464465 66464465
7 65787798 65787798 65787798
11 66300000 66464465 66464465 66464465
Total Result 66100000 66464465 66464465 65787798 65787798 132252263
65900000 usn 546 fsfd
65787798 65787798
Axis Title

Linear (usn 546 fsfd)

65700000 7868 yuyj
65500000
7 11 Total Result
usn 546 fsfd NaN 66464465 66464465
7868 yuyj 65787798 NaN 65787798

Axis Title
Calculated Field
Solve Order Field Formula

Calculated Item
Solve Order Item Formula

Note: When a cell is updated by more than one formula,

the value is set by the formula with the last solve order.

To change the solve order for multiple calculated items or fields,

on the Options tab, in the Calculations group, click Fields, Items, & Sets, and then click Solve Order.
n click Solve Order.
Roll No Student Name USN Marks Fee branch
1 asdf 123 56 10000 cse
1 asdf 123 23 10000 cse
Roll No Student Name USN Marks Fee branch
1 asdf 123 56 10000 cse
1 asdf 123 23 10000 cse
Roll No Student Name USN Marks Fee branch Date
1 asdf 123 56 10000 cse 1/9/2024
10 qazx 876 76 989978 ds 1/18/2024
1 asdf 123 23 10000 cse 1/19/2024
2 qwer 234 67 45656 cse 1/10/2024
3 zxcv 345 87 678858 aiml 1/11/2024
4 tyui 456 98 67886 aiml 1/12/2024
5 ghjk 567 88 7 aiml 1/13/2024
6 bnmv 687 86 634435 aiml 1/14/2024
7 rfvb 789 47 67577 aiml 1/15/2024
8 edcv 543 77 87678 aiml 1/16/2024
9 wsxc 765 79 989978 ise 1/17/2024
saving
100
100
110
20
30
40
50
60
70
80
90
Column1 Column2 Column3
219 kjkkjhk 8687
218 ,hkhhg 87786 Sum of Column1 Column2
220 oipoijl 321321 Column1 ,hkhhg gjhggk hkhhg jdlflsdj
211 jdlflsdj 976887 211 211
214 hkhhg 3464466 212
215 jhgjg 4354336 213
213 khggkgh 5757576 214 214
217 gjhggk 6435434 215
212 nkjbhkh 6465456 216
216 ljhhlh 7657565 217 217
218 218
219
220
Total Result 218 217 214 211
jhgjg khggkgh kjkkjhk ljhhlh nkjbhkh oipoijl Total Result
211
212 212
213 213
214
215 215
216 216
217
218
219 219
220 220
215 213 219 216 212 220 2155
 num of months

LOAN 200000
month 12 #NUM!
RATE 9.00%
EMI ₹ 17,490.30
₹ 17,490.30 12 36 48 60 72 84
100000
200000
300000
400000
500000
600000
700000
800000
900000
1000000
 PMT FORMULA
PMT(rate,nper,pv)
Roll No Student Name USN Marks Fee branch
1 asdf 123 56 10000 cse
1 asdf 123 23 10000 cse
Total 2 2
Scenario Summary
Current Values: Feb mar jan
Changing Cells:
$C$4 cem cem cem cem
$D$4 100 150 175 100
$C$5 steel steel steel steel
$D$5 200 250 275 200
$C$6 bricks bricks bricks bricks
$D$6 300 350 375 300
$C$7 labour labour labour labour
$D$7 350 400 425 350
$C$8 others others others others
$D$8 500 550 575 500
Result Cells:
$D$9 1450 1700 1825 1450
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: Feb mar jan
Changing Cells:
$C$4 cem cem cem cem
cem 100 150 175 100
$C$5 steel steel steel steel
steel 200 250 275 200
$C$6 bricks bricks bricks bricks
bricks 300 350 375 300
$C$7 labour labour labour labour
labour 350 400 425 350
$C$8 others others others others
$D$8 others 550 575 500
Result Cells:
$D$9 950 1700 1825 1450
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: Feb mar jan
Changing Cells:
$C$4 cem cem cem cem
cem 100 150 175 100
$C$5 steel steel steel steel
steel 200 250 275 200
$C$6 bricks bricks bricks bricks
bricks 300 350 375 300
$C$7 labour labour labour labour
labour 350 400 425 350
$C$8 others others others others
$D$8 400 550 575 500
Result Cells:
$D$9 1350 1700 1825 1450
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.
$C$4:$D$8 by (All)

Row Labels $D$9

jan 1450
Feb 1700
mar 1825
$C$4:$D$8 by (All)

Row Labels $D$9

jan 1450
Feb 1700
mar 1825
 Scenario manager
item price
cem 150
steel 250
bricks 350
labour 400
others 550
Total 1700
ldfdf ldfdf LDFDF lksfljdls
fdf fdf FDF manju
dflk dflk DFLK
dfs dfs DFS
hgh hgh HGH
hvg hvg HVG
bhjb bhjb BHJB

gh gh GH
hgh hgh HGH

HGH HGH hgh

HVG HVG hvg
BHJB BHJB bhjb

GH GH gh
HGH HGH hgh

raja verma raja verma

raja verma
I love reading
fddf 34
raja verma raja verma

12 13
3vc22cs12 3vc22cs124
55000 75000
89 78
manju.avi [email protected]
 TRIM FUNCTION
SACHIN TENDULKAR SACHIN TENDULKAR
BHAGAT SINGH BHAGAT SINGH
SUBHASH CHANDRA BOSE SUBHASH CHANDRA BOSE
D SOUZA D SOUZA
SOURAV KUMAR SOURAV KUMAR
SACHIN TENDULKAR SACHIN TENDULKAR
BHAGAT SINGH BHAGAT SINGH
SUBHASH CHANDRA BOSE SUBHASH CHANDRA BOSE
D SOUZA D SOUZA
SOURAV KUMAR SOURAV KUMAR

Concatenate FUNCTION
NAME ROLLL NO USN FEES
MANJU 12 3vc22cs123 55000

first name last name full name

qwerty asdfgh QWERTY ASDFGH QWERTY asdfgh

2/12/2024 2024-02-12
2/13/2024 2024-02-13

Manju Nath Reddy Nath

Manju
Reddy
#NAME?
Manju Nath Reddy nath
7
nathrama
Manju rama Reddy
 MARKS EMAIL
89 [email protected] #VALUE!
MANJU,12,3vc22cs123,55000,89,[email protected]
MANJU,12

QWERTY asdfgh
 11
3
2011 40777
40885
40685
40597
45478
40613
0.1
0.274306 1/1/2022
#NAME?
 1/1/1901
12/31/1899
1/1/10000
2/2/2009
9/2/2007