Excel VBA Excel VBA Fundamentals & Syntax 3

Question 1

Which VBA function returns the number of characters in a string?

Accepted Answer

Len()

Answer

Count()

Answer

Length()

Answer

Size()

Question 2

What does the With...End With statement do in VBA?

Accepted Answer

Allows multiple operations on a single object without repeating its name

Answer

Defines error handling

Answer

Creates a loop over a collection

Answer

Opens a file for reading

Question 3

Which keyword exits a Sub procedure immediately in VBA?

Accepted Answer

Exit Sub

Answer

Break

Answer

Stop

Answer

End

Question 4

What is the purpose of the MsgBox function in VBA?

Accepted Answer

Displays a dialog box with a message to the user

Answer

Reads a value from a cell

Answer

Writes text to the immediate window

Answer

Sends an email notification

Question 5

In VBA, what does the IsNumeric() function return?

Accepted Answer

True if the argument can be evaluated as a number

Answer

The numeric value of a string

Answer

The data type of a variable

Answer

The count of digits in a number

Question 6

What is the correct syntax to assign a value to a cell using VBA?

Accepted Answer

Both A and B are correct

Answer

Cells(1,1) = 10

Answer

Range("A1").Value = 10

Answer

Sheet1.A1 = 10