ticker	direction	quantity	price
YHOO US	B	100	18.73
YHOO US	B	20	18.8
C US	S	200	34.56
YHOO US	B	100	18.61
FB US	S	200	27.39
BAC US	B	100	9.81
AAPL US	S	50	589.01
ORCL US	S	100	32.39
ORCL US	S	200	32.349
BAC US	B	444	9.825
C US	S	200	34.28
GRPN US	B	400	4.12
BAC US	B	100	9.79
FB US	B	100	27.75
FB US	B	100	27.12
BAC US	S	15	9.81
AAPL US	S	25	589.08
EBAY US	B	100	52.62
YHOO US	S	400	18.62
AAPL US	B	100	589.05
AAPL US	S	10	589.08
BAC US	S	17	9.8
DELL US	S	1452	10.17
AAPL US	S	88	589
GRPN US	B	1000	4.23
FB US	B	100	27.74
C US	B	100	34.28
BAC US	B	100	9.88
C US	S	100	34.37
FB US	B	600	27.74
AAPL US	S	100	588.9
MSFT US	B	500	26.75
AAPL US	S	20	589.08
GRPN US	S	100	4.19
BAC US	S	1800	9.829
MSFT US	S	100	26.62
YHOO US	S	200	18.73
GRPN US	S	100	4.14
BAC US	B	100	9.855
AAPL US	S	25	589.08
BAC US	B	1000	9.81

Directions: Answer the questions below using Excel formulas (e.g. VLOOKUP, SUMIFS, etc). 1) Count the number of trades that are buying YHOO US? 2) Count the number of trades that are selling YHOO US? 3) How many shares of GRPN US were traded on the day? 4) What is the total market value of all the trades that are buying BAC US? 5) What is the volume-weighted average price of all buys in FB US?