G08 - ICT

How do you write an If-Then-Else If-Else statement in VBA?

• A)      If condition ElseIf condition Else End If

•    If Then condition ElseIf Then Else End If

•   If condition Then ... ElseIf condition Then ... Else ... End If

• If condition Then ElseIf condition Then Else End If

1. Which operator is used for checking multiple conditions in an If statement?

• AND

•      ||

•    XOR

• &&

1. Which keyword is used to specify an alternative action if the condition is false?

• Select

• Else

• End

•    Next

1. What will happen if you omit End If in a multi-line If-Then-Else block?

• The code will execute but skip some lines

• The code will display an error

•   The code will run without issues

•   The Else statement will be ignored

What is the correct syntax for a simple If-Then statement in VBA?

• If Then condition statement

•   If condition statement Then

•   If condition Then statement Else

• If condition Then statement End If

1.  In a Select... Case statement, is the "Case" sensitive to the letter casing?

• Yes, it's case-sensitive

•   It depends on the computer's settings

•   It depends on the version of Excel

•     No, it's case-insensitive

1. What is the purpose of the "Case Else" part in a Select... Case statement?

•   It's used to create additional conditions

• It's executed if none of the other cases match

• It's used to indicate the end of the statement

•    It's not used in Select... Case statements

1. In a Select... Case statement, what happens when the expression matches a "Case" value?

• An error occurs True

• The code under that "Case" is skipped

• The code under that "Case" is executed, and all other cases are checked

• The code under that "Case" is executed, and no other cases are checked

1. What are Select... Case statements used for in MS Excel VBA?

• Creating charts

• Printing documents

• Making decisions based on different values

• Sorting data

1. In a Select... Case statement, which keyword is used for specifying the value to be compared to the expression?

• Value

• Case

• Choose

• Check