Task: Concerning the formula for E2 to determine tuition & fee that can be copied down the whole E-column. Please note that CSU uses stepped tuitions, i.e., below 6 units, there is a flat tuition; 6-11.9 units, another flat tuition, and so on - NOT "per unit" tuition. International students should also pay the one-time per semester (NOT per-unit) International Fee (i.e., Out-of-state tuition + one-time Int'l fees). Tuition & Fees Units 11 9 Country/ Status Name State (*) 2 Bush, Walker TX 2 3 Edwards, John SC 2 4 Feinstein, Diane CA 1 5 Gonzalez, Juan CA 1 Kim, Tae 3 Zhang, Jeff ICA 1 H . Min Meaning: Out-of Units (Explanation) Instate -state 1 1-5.9 units $ 600 $ 1.100 6 6-11.9 units $1,100 $ 2,000 12 12+ units $2,000 $ 3,800 Korea 10 13 12 International fees S 80 International students pay out-of-state tuition, plus International fees: one-time, NOT per unit * Meaning of Status Code; cells below not to be used in formula: 10 California 11 Out of state 12 International 31 Hint: Based on different residence status in column C), return corresponding values from different columns (l or J) in the tuition & fees schedule. Hint: Like VPAC/Soraya Center concert ticket question in your HW where different date of performance needs to look up in a different range. Choose the TRUE statement in the following, regarding the formula in cell E2. The formula is =VLOOKUP(D2,$G$1:$1$4,3) None of the formulas is right. The formula is =VLOOKUP(D2,$G$1:$J$4,4,FALSE) The formula is =IF(C2=1, VLOOKUP(D2,$G$2:$J$4,3), VLOOKUP(D2,$G$2:$J$4,4))