Grade 8 ICT Quizzes

The If-Else statement in VBA is used to __________.

• execute code when a condition is True

• perform mathematical calculations

• create loops

• execute code when a condition is False

What does the integer division operator (\) return?

• Sum of the numbers

• Remainder of the division

• Quotient without the remainder

• Product of the numbers

The modulus operator (Mod) returns the __________ of a division.

• result

• product

• remainder

• quotient

The condition number Mod 2 = 0 is used to check if a number is __________.

• negative

• even

• prime

• odd

What does a nested If statement allow you to do?

• Compare multiple variables

• Have multiple levels of conditions

• Create a complex loop

• Use logical operators

Which operator is used for multiplication in MS Excel VBA?

• -

• /

• *

• +

The Select Case statement in VBA is used to __________.

• perform arithmetic operations

• declare variables

• compare a variable against different values

• concatenate strings

How can If... Then... Else statements be compared to real-life situations?

• Writing stories

• Making decisions

• Solving math problems

• Creating loops

Which VBA statement is used to execute code only if a certain condition is True?

• Select Case statement

• If-Then statement

• For loop

• Do-While loop

What is the result of the expression 10 + 5 * 2?

• 30

• 15

• 25

• 20