Homeroom #	First Name	Last Name	T-Shirt Size	Payment Method		Total Orders By Date
220-B	Malik	Reynolds	Small	Cash		Date	Orders
105	Melissa	White	Small	Debit Card		201	345	5
220-A	Juan	Flores	X-Large	Pending		Friday, April 12, 2013	7
220-B	Karla	Nichols	X-Large	Money Order		Friday, April 19, 2013	10
105	Christiana		Chen	Medium	Cash		Friday, April 26, 2013	5
105	Sidney	Kelly	Medium	Check Bounced
220-B	Windy	Shaw	Small	Cash
105	Esther	Yaron	Small	Check
220-B	Tyrese	Hanlon	X-Large	Debit Card
135	Lia	Richards	X-Large	Cash
110	Kris	Ackerman	Large	Money Order
135	Jordan	Weller	Large	Money Order
135	Alex	Yuen	Large	Wrong Amout
105	Nathan	Albee	Medium	Check
110	Gabriel	Del Toro	Medium	Cash
220-B	Avery	Kelly	Medium	Debit Card
135	James	Panarello	Medium	Check
135	Chantal	Weller	Medium	Cash
220-A	Chevonne	Means	Medium	Money Order
220-A	Brigid	Ellison	Small	Cash
105	Derek	MacDonald	Large	Cash
110	Matt	Benson	Medium	Money Order
220-B	Michael	Lazar	Small	Cash
135	Anisa	Naser	Small	Pending
110	Regina	Olivera	Large	Pending
220-B	Samantha	Bell	Medium	Check
220-A	Christopher	Peyton-Gomez	Small	Check Bounced

Part II. Using the table shown in the attached file, sort by:

Last Name in (A-Z) and then add a level to sort by First Name.

Payment method using color cell formatting (red first).

T-shirt size using a custom list (Small, Medium, Large, X-Large) For reference review the GCF tutorial on sorting: http://www.gcflearnfree.org/excel2013/18

What means

Last Name in (A-Z) and then add a level to sort by First Name.

Payment method using color cell formatting (red first).

should I sort Last Name in A-Z or the first name?