Run Tools nulas Data Window use the vlookup function in cel x + logicandreference-U0-Dadyn_marshall Review View Assignment Assignment Tasks Conditional E IN Use the AVERAGEIF function in cell K10 to determine the average number of free throws made by students with black hair. Be sure to build a formula can be reused by O copying down. 3 points test before tonight's game to give away free t-shirts. They have recorded the t shoots ten free throws. The hair and eye color groups with the highest Complete the summary tables below to determine which groups made the me which students get a shirt. How many students will get a t-shirt? et Shirt? Hair Color Summary Count Sum Average Black Brown Red Blond Eye Color Summary Count Sum Average Brown Blue Hazel Green How many students will get a shirt? Lookup Functions Conditional Functions Average: 5.30 Count: 601 Sum: 1590.00 match so the values in 09.018 need to be sorted in ascend Probably better just to add an entry for a quantity of 1 2 answers