hans After saving an answer to a question, you can return to the question later and change Don't click Submit unless you want to submit the quilt for grading Multiple Attempts Not allowed. This test can only be taken once. Force Completion This test can be saved and resumed later, Question Completion Status: Moving to another question will save this response. Question 1 Question 1 1 points 12 Subtract 2 2 First Operand Operation Second Operand Answer 50 Subtract 25 25 Add Suured MU Davide Operations Add Subtract Multiply Divide Cell 2 has been set up with data validation that allows the entry of one of the four words Add Subtract, Multiply, or Divide as shown in their Which of the following is a correctly written formula in cell D2 that performs the mathematical operation that corresponds to the word displayed on all ? OA 82-F2A2C2,62-F3.A2-C2,32-4A2C2.02-F512/0) OBB2-A2. Add 82-A2-C2. Subtract, 02-A2C, "Multiply 82A2/C2,Divide OC-582 AddA2C2,62 Subtract.A2C2,12-Multiply A2*22,2-Divide / OD. F2eAdd'A2C273 Subtract", A2C2F4-Multiply A2*2.5-Divide 1/2) Moving to another question will save the response Question of 10 Question 2 Which of the following formulas contains a nested function? OA HIPSUM(A1:A2)-50. The answer is 50"TRUE,"The answer is not 50 OB-NOTLAND(A1:31) OC CONCATE'The value of pils "Pol D. All of the above t. Only answers A and Moving to another question will save this response Question 3 If cell Al contains 1 and cell A2 contains 1 what will the following formulareturn? NOTANDKATA211) CAO B. It will return a N/A error. C. FALSE O. TRUE Mook - HE response Question 4 The only time an OR function will return TRUE is when the outcome of all of its logical tests are TRUE. True False Moving to another question will save this response. Will the following two formulas always produce the same result? -IFS[A1-1, "The colour is red A1-2. The colour is yellow A1=3. The colour is blue TRUE,"The colour is not a primary colour) -SWITCH(A1,1, 'The colour is red",2. The colour is yellow 3. The colour is blue. The colour is not a primary colour True False Question 6 What happens if none of the logical tests in an function et TRUE? A The function returns a N/A error OB. The function will get stuck and never return arett The function returns FALSE D. The function returns the testinvald Value Moving to another question wilave this response Moving to another question will save this response. Question 7 0 Sales 1 Salesperson Shift 2 Alice Alternoon 3 Bobby Morning a carol Evening Scindy Evening 6. Greg Alternoon Lan Morning Marcia Morning Mike Altercon 10 Peter Evening Absent Yes No NO Yes NO NO 592 395 571 1,056 NO No 205 200 53 For the above worksheet, which of the following will result from the formule COUNTIFIC CIO, "NO",02:01017509 CA 3 OCI 002 Moving to another question will save this response Question 61 X A 1 pc E D Sales Average sales of Evening shift 597 395 Salesperson Shift 2 Alice Afternoon 1 Bobby Morning 4 Carol Evening 5 Cindy Evening 6 Greg Afternoon 7 Jan Morning & Mardia Morning 9 Mike Afternoon 10 Oliver Evening 11 Peter Evening 12 Sam Moming 13 Tier Afternoon Absent Yes No No Yes No No No No NO No No No 571 1,056 205 206 388 560 890 826 Which of the following formulas in cell Gl will correctly determine the average sales of all of the salespeople present for the Evening work shit! OA SUMIESTD2:013.82 813Evening C2C13-No OBAVERAGE(82-813."Evening 2013) OC AVERAGEIFSD2013.82-813."Evening.C2.013."No") D. AVERAGEIS/02.012,02:013.-Evening.C2.13,-No) Moving to another question will save this response. Ques co Questions Ansample of nesting function is when you multiple functions to True LA Click Submit to compite this assessment. Question 10 ASWITCH function will return a N/A error sit doesn't find a match and hodelaut is defined. True False Click Submit to complete this assement