1. Total tuition is $3050 for full-time students taking 12 credits or more and $125 per credit hour for part-time students (taking less than 12 credits). Use a function to determine the correct tuition charges.
2. In order to encourage students to major in business the college is providing $250 tuition assistance for business majors. Use a function to determine tuition assistance.
3. To determine how much a student owe subtract tuition assistance from total tuition.
4. Students should deposit one-third of what they owe or $500 whichever is smaller (MIN). Use a function to determine the amount of deposit.
5. Calculate the balance for each student.
6. Move to cell B7 and use a function to determine how many students have received tuition assistance.
7. Sort the students by last name alphabetically

Last Name	First Name		Major	H.S. GPA	Credit Hours	Total Tuition	Tuition Assistance	Owe	Deposit	Balance
Eliot	Marianne	EMarianne	BUS	1.85	6
Guisemme	Angelo	GAngelo	EDU	1.85	9
Kellog	Ben	KBen	CSC	1.85	15
Helstein	Natalia	HNatalia	EDU	1.85	15
Hesse	Greta	HGreta	ENG	1.85	18
Tutuska	Justine	TJustine	EDU	1.95	3
Thiessen	Edvard	TEdvard	ENG	1.95	3
Thomas	Jacob	TJacob	ENG	1.95	6
Friessen	Helga	FHelga	BUS	1.95	9
Tasha	Fari	TFari	EDU	1.95	9
Tamaka	Hiromi	THiromi	BUS	1.95	12
Ver	Jen	VJen	UND	1.95	15
Whtachten	Pieter	WPieter	UND	1.95	15
Talty	Daniel	TDaniel	UND	1.98	3
Lawrence	Fisher	LFisher	CSC	2.00	3
Norton	Jane	NJane	CSC	2.00	6
Lomax	Ren	LRen	EDU	2.00	6
Switzer	Inez	SInez	PSY	2.00	6
Gomez	Sylvia	GSylvia	CSC	2.00	12
Mizumo	Mari	MMari	POS	2.15	3