13) In the Excel extract below, we have a table of grading equivalencies. Which of the following formulae would return the appropriate grade in cell B10? B Grade F A 1 Score 2 at or Above 3 0% 4 60% 5 70% 6 80% 7 90% 8 D Explanation 0%-59% = F 60%-69% =D 70%-79% = C 80%-89% =B 90%+ = A B A 9 Score Grade 10 84% =VLOOKUP(A10,A3:37,1,TRUE) =HLOOKUP(A10,A3:37,1,TRUE) =VLOOKUP (A10,A3:37,2,TRUE) =HLOOKUP(A10,A3:37,2,TRUE) 14) In the Excel extract below, we have a table containing traders' profits. Which of the following formulae would provide a total profit for Joe (also known as Joseph, Joe Smith, and Joseph Smith)? A 1 Trader 2 Joe $ 3 Joseph $ 4 Tim $ 5 Anthony $ 6 Joseph Smith $ 7 Jim Thomas $ 8 Joe Smith $ B. Profit 34,200 27,000 74,260 51,920 18,700 22,000 14,650 =SUMIF(A2:A8,"*jo*",A2:48) =SUMIF(B2:18,"*jo*",B2:38) =SUMIF(A2:A8,"*jo*",B2:38) =SUMIF(A2:A8,"jo",B2:38) 15) Which of the following statements are true of Conditional Formatting? I Restricts what the user can input into cells II Formats cells according to rules you create III Can be used to color cells differently according to their values IV Cannot be removed once applied II and III only I and II only I, II, III and IV O I, II, and Ill only