A function is being entered into an Excel worksheet to evaluate the contents in cells B5, C5, and D5. The function needs to determine if the value in cell B5 is less than 2%, C5 is greater than 50, and if the word BUY is entered into cell D5. Which of the following functions can accomplish this goal? Question 46 options: =OR(B5<2%,C5>50,D5="BUY") =AND(B5<.02,C5>50,D5="BUY") =AND(B5<.02%,C5>50,D5=BUY) =IF(B5<.02 and C5>50 and D5="BUY") =OR(B5<.02,C5>50,D5=BUY)