Macro VBA

What's the output?

• 11

• 65

• 6

• 5

What's the output

• 3

• 6

• 9

• 7

What's the output

• 1

• 2

• 3

• 4

How do you declare a variable in VBA?

• Dim x as String

• String a;

• x as String

• String x as Dim

Which one is the error?

1. ThisWorkbook.Activate

2. Worksheets("Sheet1").Activate

3. WorkBook("OH Stock.xlsx").Activate

4. Sheets("PivotTable").Select

• 1

• 2

• 3

• 4

What's the output

• 
• 
• 
• 

What's the output

• A

• B

• C

• Not Pass

What's the output

• 20000

• Error

• 10000

• 30000

What's the output

• 20000

• Error

• 15000

• 35000

How to make D4 be like this

• Range("D4").FormulaR1C1 = "=SUM(R[-3]C[-3]:R[-1]C[-1])"

• Range("D4").Value = "=SUM(R[-3]C[-3]:R[-1]C[-1])"

• Range("D4").Value = "=SUM(A1:C3)"

• Range("D4").Formula2R1C1 = "=SUM(R1C1:R3C3)"