In the spreadsheet layout shown, what value would:

ActiveCell.Offset(ActiveCell.Offset(0, -1), Cells(1, 3))

refer to?

1

2

3

4

5

A

3

8

-2

9

B

4

-4

11

7

C

1

3

5

2/nHow will the worksheet appear after the MakeArray subroutine is executed?

A.

C.

12

1

12

2

A

A

Option Explicit

Sub MakeArray ()

Dim A (2, 2) As Double

Dim i As Integer, j As Integer

A(1, 1) -3.4

<=-9.7

5.8

4.5

Range ("A1: B2") - A

End Sub

A(1, 2)

A(2, 1)

A(2, 2)

3.4

5.8

0

OC

0

B

3

-9.7

4.5

04

3.4

B.

12

D. 1

2

A

A

3.4

-9.7

4.5

-9.7

B

B

5.8

4.5

5.8

3.4