This quiz will test your understanding about Variables, Procedures, and Sheets. Please answer the following 10 questions.
Quiz Summary
0 of 10 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 10 Questions answered correctly
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 10
1. Question
What is the scope of a variable in VBA?
CorrectIncorrect -
Question 2 of 10
2. Question
What is the purpose of using a function in VBA?
CorrectIncorrect -
Question 3 of 10
3. Question
How can you create a new worksheet in Excel using VBA?
CorrectIncorrect -
Question 4 of 10
4. Question
What is the purpose of a comment in VBA?
CorrectIncorrect -
Question 5 of 10
5. Question
In VBA, what is the purpose of a worksheet function?
CorrectIncorrect -
Question 6 of 10
6. Question
What is the purpose of a variable in VBA?
CorrectIncorrect -
Question 7 of 10
7. Question
Which data type would you use for a whole number (integer) variable in VBA?
CorrectIncorrect -
Question 8 of 10
8. Question
What is a procedure in VBA?
CorrectIncorrect -
Question 9 of 10
9. Question
In VBA, how can you pass information to a procedure when you call it?
CorrectIncorrect -
Question 10 of 10
10. Question
Which object represents a worksheet in Excel when working with VBA?
CorrectIncorrect