What is the purpose of a variable in VBA?*1 pointTo create a loopTo define a functionTo store dataTo format cells

What is a macro in VBA?*1 pointA data structureA loopA set of instructions to automate a taskA type of variable

What is a function in VBA?*1 pointA loopA set of instructions to automate a taskA data structureA predefined set of code that performs a specific task

Which of the following is used to define a variable in VBA?*1 pointPrivateSetDimPublic

What is a user-defined function in VBA?

Which of the following is the correct syntax to declare a variable as a string in VBA?*1 pointDim variable As StringDim variable As IntegerDim variable As BooleanDim variable As Double