355 10:26 Back ICA 10-18 Refer to the worksheet shown, set up to calculate the displacement of a spring. Hooke's law states that the force (F, in newtons) applied to a

spring is equal to the stiffness of the spring (k, in newtons per meter) times the displacement (x, in meters): F = kx. A 1 2 Spring Code 3 3-Blue 4 5 19 2 8 2 A 11 12 13 14 15 16 17 18 100 10 125 150 175 200 225 250 275 300 Problem IAC 10-18.png Mass [g] Displacement [cm] 25 50 75 Stiffness [N/m] Maximum Displacement [mm] 50 20 0.49 0.98 1.47 1.96 2.45 2.94 Dashboard 3.43 3.92 4.41 4.90 5.39 5.88 Warning Too Much Mass Too Much Mass Too Much Mass Too Much Mass 000 000 Calendar Too Much Mass Too Much Mass Too Much Mass Too Much Mass D E 2-Black 2-Red Spring Code Stiffness [N/m] Maximum Displacement [mm] 1-Blue 40 1-Black 60 2-Blue 25 60 30 20 30 10 3-Blue 3-Red 3-Green 10 To Do G Cell A3 contains a data validation list of springs. The stiffness (cell B3) and maximum displacement (cell C3) values are found using a VLOOKUP function linked to the table shown at the right side of the worksheet. These data are then used to determine the displacement of the spring at various mass values. A warning is issued if the displacement determined is greater than the maximum displacement for the spring. Use this information to determine the answers to the following questions. = IF( (1), — (2) a. Write the expression, in Excel notation, that you would type into cell B6 to determine the displacement of the spring. Assume you will copy this expression to cells B7 to B17. b. Fill in the following information in the VLOOKUP function used to determine the maximum displacement in cell C3 based on the choice of spring in cell A3. =VLOOKUP(_ (1)—, — (2). (4) -_-) 10 25 30 40 20 50 c. Fill in the following information in the IF function used to determine the warning given in cell C6, using the maximum displacement in cell C3. Assume you will copy this expression to cells C7 to C17. 191 40 60 H (3) (3)__) Notifications Inbox (