Fall 2021 8. What is the appropriate formula to simulate quantity of jackets sold in "B4" cell above? A. =Max(B1-B3,0) B. =Min (B1, B3) C. =Max(B1, B3) D. = Min(B1-B3,0) E. None of the above 9. What is the appropriate formula to simulate whether there is a good snow in this winter in "B2" cell above? A. =randbetween("Yes", "No") B. =if(rand()>0.2, "No", "Yes") C. =if(rand()>0.8, "Yes", "No") D. =if(rand()