1. Enter column headings in the first row and wrap them.
2. Enter players' names in column A and all other information in columns B and C.
3. Compute total of matches in cell B12.
4. Copy a formula from B12 to C12. (Use Fill Right)
6. Find the average dollars per match in cell D2.
    Note:  the average dollars per match is total dollars divided by number of matches.
                It is not =AVERAGE(B2..C2). Why NOT?
7. Copy a formula from D2 to rest of cells in the column D.  (Use Fill Down)
8. Check the result. If you do not know how large the numbers are, format them into fixed numbers.
9.. Add your name.  Show me.
10. Sort the file according to the ascending order of average dollars per match.
11. SHOW ME
 

	A	B	C	D
1	Players	Matches	Total Dollars Earned	Average Dollars Per Match
2	CARVER	20	$91,147
3	COLES	27	$40,602
4	DANIELS	25	$20,026
5	HANES	10	$27,000
6	KING	22	$70,170
7	LOPEZ	24	$89,736
8	OKAMOTO	13	$55,941
9	SMITH	21	$91,477
10	THOMPSON	27	$67,403
11	WILLS	23	$75,100
12	TOTAL

Return to COSI 118 - Home