Question 5 A portion of an Excel Worksheet is given below: 8 C D NAME REGION Number of Orders Cost of each order 1 3 4 5 6 7 18 69 56 12 25 $16.90 $95.27 595.51 502.20 56241 570.90 9 10 11 12 Jerry Charity lane Nam Harding Jerry Wade Hardin Charity Brya! Jen JETY Daniel Wade jane West West Tast South West North North West South North West Cau North North We 91 7 44 37 19 Los West 14 15 16 17 18 29 20 23 22 23 24 25 56 75 24 30 37 34 53 79 59792 566.32 557.00 519.52 $3125 $12.50 581,07 570.25 55.25 526 27 $22.52 55.25 $8.34 S30 $2730 $15.65 Kennan Lois Wade Quy South South Last Soch Nasim Kannan Jane Sous Wet E 21 76 lela Suppose Cell E4 had the following formula: =IF(AND(C4>50,04>30)!'BONUS REGULAR"). What would be the calculated value in E42