Vba Tricks And Tips - Quiz
10 Questions
| Total Attempts: 1220
Questions and Answers
- 1.What does VBA mean?
- A.
Visual Basic for Applications
- B.
Visual By Arithmetic
- C.
Visual Basic Answers
- D.
Visual By Algorithms
- 2.What is the shortcut keystroke to debug VBA code one line at a time?
- A.
Alt+F5
- B.
F5
- C.
F8
- D.
Ctrl+F8
- 3.Which of these is not a Visual Basic object?
- A.
Range
- B.
Selection
- C.
FontSize
- D.
Sheets
- 4.Choose the VBA code that will allow you to obtain information about an error.
- A.
Err.Title
- B.
Err.Name
- C.
Err.Type
- D.
Err.Description
- 5.To save a VBA project with an Excel workbook, the workbook must be saved as what type of file?
- A.
Xlsx
- B.
Xlsv
- C.
Xlsm
- D.
Xlv
- 6.To continue to run code even if a line of code causes an error, choose the VBA code to continue to the next line of code.
- A.
Goto
- B.
On Error Resume
- C.
On Error Resume Next
- D.
Next
- 7.To force all variables is a VBA project to be declared, which must be stated in a module?
- A.
Option Declare
- B.
Option Implicit
- C.
Option Explicit
- D.
Option Variables
- 8.What do you need to select to set the developer mode?
- A.
Show macro code settings
- B.
Show mini toolbar on selection
- C.
Show visual basic options menu
- D.
Show developer tab in the Ribbon
- 9.Which of the following would you begin a comment line with?
- A.
Equal sign
- B.
Double quote
- C.
Underscore
- D.
Single quote
- 10.Which of the following snippets of VBA code is not a loop?
- A.
Do While... Loop
- B.
Select Case... Case... Case Else... End Select
- C.
Do Until... Loop
- D.
For Each.. Next
This quiz is inspired by American Enterprise Institute scholar Charles Murray's new book, "Coming Apart: The State of White America, 1960-2010," which explores the unprecedented, class-based cultural gap in America....
Questions: 9 | Attempts: 185009 | Last updated: Mar 21, 2022
-
Sample QuestionWho wrote the Coming Apart: The State of White America, 1960-2010?
Many programmers and web developers alike will agree that when deciding to enter the field of computing, learning one of the essential coding languages out there, HTML will give you a good starting point. In this quiz,...
Questions: 15 | Attempts: 38128 | Last updated: Mar 22, 2022
-
Sample QuestionWhat does HTML stand for?
Here is an interesting quiz with informative questions and answers about Arduino and its related concepts. Arduino is an open-source hardware and software company, that deals in designing and...
Questions: 11 | Attempts: 13667 | Last updated: May 12, 2022
-
Sample QuestionWhat is the range of numbers you can store in a variable of type byte?
- Binary Code Quizzes
- Computer Concept Quizzes
- Computer Essential Quizzes
- Computer Forensics Quizzes
- Computer Hardware Quizzes
- Computer Networking Quizzes
- Computer Parts Quizzes
- Computer Programming Quizzes
- Computer Science Quizzes
- Computer Security Quizzes
- Computer Shortcut Key Quizzes
- Computer Skills Quizzes
- Computer Virus Quizzes
- Cyber Security Quizzes
- Data Quizzes
- Data Security Quizzes
- Hacking Quizzes
- Hci Quizzes
- Internet Quizzes
- It Security Quizzes
- Malware Quizzes
- Microprocessor Quizzes
- Network Quizzes
- Operating System Quizzes
- Phishing Quizzes
- Server Quizzes
- Software Quizzes
Back to top