1) The correct structure for the COUNTIF function is ...  a) =COUNTIF(E2,E10, “Excellent”) b) =COUNTIF(B2:D10, “Excellent”) c) =COUNTIF(D2:D10, =8) d) =COUNT("Fail", “Pass”) 2) The correct structure for IF with OR function is a) =IF((AND(B1>60,C1>70)), "Pass","Fail") b) =IF((OR(B1>60,C1>70)), Pass,Fail) c) =IF((OR(B1>60,C1>70)), "Pass","Fail") d) =IF((OR(B1>60,C1>70)), "Pass","Fail")))) 3) The function that is used to replace some text with another one. a) CONCATE b) TODAY c) SUBSTITUTE d) RIGHT, LEFT, MID 4) The area of the circle is Pi by the radius squared, in excel it will be a) = 3.14*2B*23 b) = 3.14*B2^2 c) = 3.14*2B^2 d) = 3.14*2B*2 5) COUNT NUMBER function will count the cell with the value "770A%". a) True b) False 6) The CONCATE function does not combine more than 2 cell values together. a) True b) False

Gr8 Midterm Revision1

by
Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?