VBA I

VBA code can work only with Excel

• True

• False

If you record a macro, where will it be stored?

• In Workbook

• In Module

• In Classmodule

Activecell.Offset(3,-1).Select will select cell:

• A2

• B6

• C5

• F2

Which type of controls you should use?

• Form Controls

• ActiveX Controls

What is the correct object order?

• Application.Worksheet.Workbook.Range

• Application.Workbook.Worksheet.Range

• Workbook.Application.Worksheet.Range

• Workbook.Worksheet.Range.Application

Which word is used to declare a variable?

• Sub

• Dec

• Dim

• Set

Which variable is used to store text?

• Single

• Double

• Integer

• String

Which Variable can contain text and numbers?

• Single

• Double

• Boolean

• Variant

What will this macro do?

Sub copy()

Range("A1").Copy Range("B2")

End Sub

• Copy data from A1 and paste to B2

• Copy data from A1 and B2

• Copy data from B2

• Display error

What will this macro do?

• Select Cell A2

• Select Cell B1

• Nothing

• Display an error