i 4 6 ??? 1 A. 123 B. 147 C. 156 D. 173 4 FE Review- - PDF document

FE Review- Computational Tools In a typical spreadsheet program, what cell is directly to the right of AB4? A. AB5 B. AC4 C. AC5 D. BC4 How many individual spreadsheet cells are contained in the range C3:J12? A. 8 B. 63 C. 72 D. 80 1

FE Review- Computational Tools A structured program contains the lines of code shown in the box below. What is the value of Y after the segment is executed? 1 Y=4 A. 2 2 B=4 B. 6 3 Y=3*B-6 4 IF Y>B THEN Y=B-2 C. 8 5 IF Y<B THEN Y=Y+2 D. 12 YXUTSPONLIHFEDB 6 IF Y=B THEN Y=B+2 2

FE Review- Computational Tools A structured program contains the lines of code shown in the box below. For which input values of X will the output value of T be equal to X? 1 INPUT X 0 A. 2 IF X<5 T=X*X/(16-X) B. 0,5 3 4 ELSE C. 0,5,8 T=X*5/(10-X) 5 D. YXUTSPONLIHFEDB 6 ENDIF none of the above 7 OUTPUT T 3

FE Review- Computational Tools For the spreadsheet portion A B shown, the formula 3 1 111 =B1+$A$1*A2 is entered into B2 = B1+$A$1*A2 2 4 and copied into B4. What will the 3 5 value in cell B4? r i 4 6 ??? 1 A. 123 B. 147 C. 156 D. 173 4

FE Review- Computational Tools For the spreadsheet portion shown, the formula =B2*A$1 is entered into C2 and copied into 2 C4 and D . What will the values in cells C4 and D3 be, respectively? A. 0,0 B. 60,440 C. 16,25 D. 13,4 5

FE Review- Computational Tools 6