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

▶

Sep 06, 2023 659 likes •933 views

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-

SLIDE 1

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

FE Review- Computational Tools 1

SLIDE 2

A structured program contains the lines of code shown in the box below. What

is the value of Y after the segment is executed?

A. 2
B. 6
C. 8
D. 12 YXUTSPONLIHFEDB

1 Y=4 2 B=4 3 Y=3*B-6

4 IF Y>B THEN Y=B-2 5 IF Y<B THEN Y=Y+2

6 IF Y=B THEN Y=B+2

FE Review- Computational Tools 2

SLIDE 3

0,5 0,5,8 none of the above

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? A. B. C.

D. YXUTSPONLIHFEDB

1 INPUT X

2 IF X<5 3

T=X*X/(16-X) 4 ELSE

5

T=X*5/(10-X)

6 ENDIF

7 OUTPUT T

FE Review- Computational Tools 3

SLIDE 4

For the spreadsheet portion shown, the formula =B1+$A$1*A2 is entered into B2 and copied into B4. What will the value in cell B4?

A. 123
B. 147
C. 156
D. 173

A B

1

3

111

2 4 = B1+$A$1*A2 3 5

4

r

i

6 1 ???

FE Review- Computational Tools 4

SLIDE 5

2

For the spreadsheet portion shown, the formula =B2*A$1 is entered into C2 and copied into 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

FE Review- Computational Tools 5

SLIDE 6

FE Review- Computational Tools 6

SLIDE 7

FE Review- Computational Tools 7

SLIDE 8

FE Review- Computational Tools 8

SLIDE 9

FE Review- Computational Tools 9

SLIDE 10

FE Review- Computational Tools 10

SLIDE 11

FE Review- Computational Tools 11

SLIDE 12

FE Review- Computational Tools 12

SLIDE 13

FE Review- Computational Tools 13

SLIDE 14

FE Review- Computational Tools 14

SLIDE 15

FE Review- Computational Tools 15

SLIDE 16

FE Review- Computational Tools 16

SLIDE 17

FE Review- Computational Tools 17

SLIDE 18

FE Review- Computational Tools 18

SLIDE 19

FE Review- Computational Tools 19

SLIDE 20

FE Review- Computational Tools 20

SLIDE 21

FE Review- Computational Tools 21

SLIDE 22

FE Review- Computational Tools 22

SLIDE 23

FE Review- Computational Tools 23

SLIDE 24

FE Review- Computational Tools 24

SLIDE 25