fastread homefastrread library fastread menu

EXCEL : GOODWILL

Tutorial by:RAHUL      Date: 2016-09-28 09:10:44

❰ Previous Next ❱

SUM

 

 

 

VALUE 1

VALUE 2

VALUE 3

VALUE 4

VALUE 5

SUM

   

 

85

96

99

85

22

387

=SUM(ALL SELECT VALUE)

55

65

88

77

 

285

=SUM(ALL SELECT VALUE)

65

35

32

 

 

132

=SUM(ALL SELECT VALUE)

45

94

 

 

 

139

=SUM(ALL SELECT VALUE)

 

               

MAX

 

 

 

VALUE 1

VALUE 2

VALUE 3

VALUE 4

VALUE 5

MAX

   

 

10

20

30

40

50

50

=MAX(ALL SELECT VALUE)

1

2

3

4

5

5

=MAX(ALL SELECT VALUE)

20

50

0

5

500

500

=MAX(ALL SELECT VALUE)

45

94

500

10

20

500

=MAX(ALL SELECT VALUE)

 

               

MIN

 

 

 

VALUE 1

VALUE 2

VALUE 3

VALUE 4

VALUE 5

MIN

   

 

10

20

30

40

50

10

=MIN(ALL SELECT VALUE)

1

2

3

4

5

1

=MIN(ALL SELECT VALUE)

20

50

0

5

500

0

=MIN(ALL SELECT VALUE)

45

94

500

9

20

9

=MIN(ALL SELECT VALUE)

 

               

AVERAGE

 

 

 

VALUE 1

VALUE 2

VALUE 3

VALUE 4

VALUE 5

AVERAGE

   

 

50

20

10

20

40

28

=AVERAGE(ALL SELECT VALUE)

10

50

40

14

10

24.8

=AVERAGE(ALL SELECT VALUE)

15

16

45

48

78

40.4

=AVERAGE(ALL SELECT VALUE)

15

45

60

78

90

57.6

=AVERAGE(ALL SELECT VALUE)

 

             

UPPER & LOWER & PROPER

TEXT

UPPER

LOWER

PROPER

Aadeshkumar is

AADESH KUMAR IS

aadeshkumar is

Aadesh Kumar Is

Nirdeshkumar

NIRDESH KUMAR

nirdeshkumar

Nirdesh Kumar

Raj kumar

RAJ KUMAR

raj kumar

Raj Kumar

poojakumari

POOJA KUMARI

poojakumari

PoojaKumari

Vikramsingh

VIKRAM SINGH

vikramsingh

Vikram Singh

 

 

 

 

                       

 

❰ Previous Next ❱


EXCEL

Submit Your Thought, Tutorial, Articls etc.

Submit Your Information India's Number one online promotion website