I need to know what function to type into excel that'll satisfy these questions. I think it's something like "=OR( " but that's all I know.

(4.13) Use the OR function in cell (F3) to determine if Student 1 gets a Tshirt. Students with "Red" as a hair color had the highest average number of free throws made on the "Hair Color Summary" table and students with Eye Color as "Hazel" had the highest average number of free throws made on the "Eye Color Summary" table. a. Students get a T-shirt if their Hair Color is "Red" or their Eye Color is "Hazel". 4.15 Use an appropriate function in cell to calculate the number of T-shirts that will be given away. Luf4s e za8 I/