Formula.xlsx

  • Uploaded by: Madina Vali
  • 0
  • 0
  • June 2020
  • PDF

This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA


Overview

Download & View Formula.xlsx as PDF for free.

More details

  • Words: 980
  • Pages: 9
TOTAL, AVG,GRADING, TABLE SL NO 1 2 3 4 5 6 7 8 9 10

REG NO 501 505 506 507 508 509 510 502 503 504

STUDENT NAME A E F G H I J B C D

1 39 39 39 40 41 50 70

2

3

39 39 40 46 51 72 39

39 39 40 45 52 73 39 39 39

39

No of students "A" Grade No of students "B" Grade No of students "C" Grade No of students "F" Grade

MAIL MERGE CONCATENATE STUDENT NAME Year

SL NO

REG NO

left 4 digits

right 4 digits

1

123456789

A

2018

1234

6789

2

123456790

E

2018

1234

6790

3

123456791

F

2018

1234

6791

4

123456792

G

2018

1234

6792

5

123456793

H

2018

1234

6793

6 7 8 9 10

123456794 123456795 123456796 123456797 123456798

I J B C D

1234 1234 1234 1234 1234

6794 6795 6796 6797 6798

SLDFSDBSD JFAJDD LKSDFJLASJ LKSDFJAJS LDFJSLASDJ LSDFJASDL

lower case sldfsdbsd jfajdd lksdfjlasj lksdfjajs ldfjslasdj lsdfjasdl

VLOOKUP SL NO 1 2 3 4 5 6 7 8 9 10

REG NO 123456789 123456790 123456791 123456792 123456793 123456794 123456795 123456796 123456797 123456798

STUDENT NAME A E F G H I J B C D

vlookup A E F G H I J B C D

CASE CHANGING

asdfjlsdjfjs fjlasdjfjsd lljsdflasdjflj sdfjkasdljf sljkfasdkl;jf skl;dfjals;dj

1 123456789 987654321 123456789 987654321 123456789 987654321 123456789

UPPER CASE ASDFJLSDJFJS FJLASDJFJSD LLJSDFLASDJFLJ SDFJKASDLJF SLJKFASDKL;JF SKL;DFJALS;DJ

TRUE AND FALSE 2 1 123456789 1 987654321 1 123456789 1 987654321 1 123456789 1 987654322 123456781

0

0 0

987654321

87654321

0

RANK & CONDITIONAL FORMA S.No 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

REGD.NO ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF ABCD 15L31A0325 ABCDEF

REGD.NO 15L31A0325 14L31A03G7 15L31A0328 15L31A0347 15L31A0309 15L31A0314 15L31A0315 15L31A0322 15L31A0331 15L31A0339 15L31A0317 15L31A0350 14L31A03A8 15L31A0320 15L31A0326 15L31A0366 15L31A0363 14L31A03H3 14L31A0355 15L31A0358

sub 1 71 78 57 55 53 48 46 54 24 39 61 47 43 48 50 56 23 36 AB 13 4

sub 2 92 96 60 51 50 56 52 46 61 47 54 44

left

MID

RIGHT

0 ABCD ABCD ABCD ABCD ABCD

15L31A0325 15L31A0325 15L31A0325 15L31A0325 15L31A0325 15L31A0325

ABCDEF ABCDEF ABCDEF ABCDEF ABCDEF ABCDEF

43 58 40 19 31 36 52 46 2

sub 3 63 58 71 64 55 44 35 36 53 52 31 37 51 AB 44 42 29 27 17 17 6

LEFT DETELETED

D.NO.2-158,VISWESW VISWESWARAYAPURAM,MJYAGROUP,MALIKIPURAM MANDAL,VISWESWARAP

4

5

6

39 39 40 45 53 74

39 39 40 46 54 75

39 40 49 69 76

39 39

39 39

TOTAL 39 195 234 240 272 329 440 78 117 156

AVG 7 33 39 40 45 55 73 13 20 26

GRADE F F F C C B A F F F

GRADING 1 1 2 6

7

6

6

Axis Title

5 4 3

2

2

1

1 0

addings 2018 123456789

2018123456789

2018 123456790

2018123456790

2018 123456791

2018123456791

2018 123456792

2018123456792

2018 123456793

2018123456793

1

2

1 3

2018123456794 2018123456795 2018123456796 2018123456797 2018123456798

SL NO 1 2 3 4 5 6 7 8 9 10

SLDFS DBSD SLDFS DBSD SLDFS DBSD SLDFS DBSD SLDFS DBSD SLDFS DBSD

Proper Sldfs Dbsd Sldfs Dbsd Sldfs Dbsd Sldfs Dbsd Sldfs Dbsd Sldfs Dbsd

v look up data REG NO STUDENT NAME 123456789 A 123456790 E 123456791 F 123456792 G 123456793 H 123456794 I 123456795 J 123456796 B 123456797 C 123456798 D

NK & CONDITIONAL FORMATING & COUNTIF sub 4 78 51 87 85 58 58 52 48 49 35 50 43 40 48 39 29 35 55 16 15 3

sub 5 82 87 59 47 24 46 43 34 31 43 AB 49 48 29 18 21 39 27 26 8 10

sub 6 69 79 78 85 52 35 48 49 40 40 58 33 27 59 41 45 31 20 22 14 6

AM MANDAL,VISWESWARAPURAM,EAST GODAVARI-533254

Total 455 449 412 387 292 287 276 267 258 256 254 253 252 242 232 212 208 201 133 113

Avg 76 75 69 65 49 48 46 45 43 43 42 42 42 40 39 35 35 34 22 19

Grade A B B B D D D D D D D D D D D D D F F F

Rank 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

6

2 1

1 3

SL NO

REG NO STUDENT NAME 101 A 102 B 103 C 104 D 105 E 106 F 107 G 108 H 109 I 110 G

1

2 45 89 42 65 62 63 72 25 46 90

3 42 45 60 62 72 81 55 22 65 92

4 56 55 62 89 85 88 45 30 62 85

No of students "A" Grade No of students "B" Grade No of students "C" Grade No of students "F" Grade

SL NO 1 2 3 4 5 6 7 8 9 10

REG NO STUDENT NAMEYear left 4 digits 123451 A 2018 1234 123551 B 2018 1235 123661 C 2018 1236 123771 D 2018 1237 123881 E 2018 1238 123881 F 2018 1238 123111 G 2018 1231 123222 H 2018 1232 123333 I 2018 1233 123555 G 2018 1235

5 64 62 55 78 80 75 50 38 72 80

6 50 54 62 82 70 90 58 35 70 81

4 2 3 1

right 4 digits 3451 3551 3661 3771 3881 3881 3111 3222 3333 3555

addings

75 56 60 85 65 82 55 32 65 85

TOTAL 332 361 341 461 434 479 335 182 380 513

AVG

GRADE 55 C 60 B 57 C 77 A 72 A 80 A 56 C 30 F 63 B 86 A

More Documents from "Madina Vali"