Which of the following is the correct syntax for a sub in VBA?*1 pointSub_Name()SubName()Sub Name()Sub Name

Which of the following is the correct syntax for a function in VBA?*1 pointfunctionNameFunction_Name()Function Name()FunctionName()

Which of the following is the correct syntax for a comment in VBA?*1 point#‘//—

Which of the following is NOT a VBA keyword?*1 pointDimFunctionSubVariable

Give clear explanations for the following errors as they may be encountered in VBa) Syntax Error………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………b) Run-time errors………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………c) Logic Errors

The VBA code ____ refers to the collection of cells in the cell range, A1:B10.Select one:a.Names(A1:B10)b.(A1:B10)c.Range("A1:B10")d.Objects(A1:B10)