GOODWILL

Course- EXCEL >

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