Are You An Excel Vba Expert?
Knowledge check on Excel VBA
- 1.
Which of the following is not a valid data type in Excel?
- A.
Number
- B.
Character
- C.
Label
- D.
Date/Time
Correct Answer
B. CharacterExplanation
The given question asks for a data type that is not valid in Excel. The options provided are Number, Character, Label, and Date/Time. In Excel, Number, Label, and Date/Time are valid data types that can be used to represent numerical values, text, and dates respectively. However, Character is not a valid data type in Excel. Excel does not have a specific data type called Character. Instead, text or labels are typically represented using the Label data type in Excel.Rate this question:
-
- 2.
Which menu option can be used to split windows into two In Excel 2007?
- A.
Format -> Window
- B.
View -> Window-> Split
- C.
Window -> Split
- D.
View –> Split
Correct Answer
D. View –> SplitExplanation
The correct answer is "View -> Split". This menu option allows users to split the Excel window into two separate panes, which is useful for viewing different parts of the worksheet simultaneously.Rate this question:
-
- 3.
Difference between iserror and iserr
- A.
Iserr excludes #n/A and returns the value
- B.
Both are same
- C.
Iserror excludes #n/A and returns the value
- D.
Iserr returns when the value is #value
Correct Answer
A. Iserr excludes #n/A and returns the valueExplanation
The correct answer is that Iserr excludes #n/A and returns the value. This means that the Iserr function will return TRUE if the value is any error value except for #N/A, and it will return FALSE if the value is not an error value. It differs from Iserror, which also excludes #N/A but returns the error value itself instead of TRUE or FALSE.Rate this question:
-
- 4.
What is the Syntax of VLOOKUP Function in Excel?
- A.
= VLOOKUP(lookup_value, table_array, col_index_num, [not_exact_match],[range_lookup])
- B.
= VLOOKUP(lookup_value, table_array, col_index_num, [exact_match],[range_lookup])
- C.
= VLOOKUP(lookup_value, table_array, range_lookup, [col_index_num])
- D.
= VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])
Correct Answer
D. = VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])Explanation
The correct answer is = VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]). This is the correct syntax for the VLOOKUP function in Excel. The function is used to search for a value in the first column of a table and return a corresponding value from another column in the same row. The lookup_value is the value to search for, table_array is the range of cells that contains the table, col_index_num is the column number in the table from which to return a value, and range_lookup is an optional argument that specifies whether the lookup_value should be an exact match or not.Rate this question:
-
- 5.
What happens when dollar signs ($) are entered in a cell address? (eg. $A$2:$A$10)
- A.
The sheet tab is changed.
- B.
An absolute cell address is created.
- C.
Cell address will change when it is copied to another cell.
- D.
The status bar does not display the cell address.
Correct Answer
B. An absolute cell address is created.Explanation
When dollar signs ($) are entered in a cell address, it creates an absolute cell address. This means that the cell reference will not change when it is copied to another cell. The dollar signs lock the row and column references, making it fixed and not relative to the location of the copied cell. This is useful when you want to keep a specific cell reference constant in formulas or when working with large datasets.Rate this question:
-
- 6.
The lookup value must always be located in the first column of the lookup table
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The statement is true because in a lookup table, the first column is typically used as the reference column. This means that the value you are trying to look up must be located in the first column of the table. If it is not in the first column, the lookup function may not work correctly and may return inaccurate results. Therefore, it is important to ensure that the lookup value is always in the first column of the lookup table.Rate this question:
-
- 7.
VBA Object hierarchy?
- A.
Objects, Methods, Properties and Variables
- B.
Objects,Properties,Methods and variables
- C.
Methods,Objects,Properties and variables
- D.
Variables,Objects,Methods and Properties
Correct Answer
A. Objects, Methods, Properties and VariablesExplanation
The correct answer is "Objects, Methods, Properties and Variables." In VBA, the object hierarchy refers to the order in which objects are organized and accessed. Objects are the highest level in the hierarchy, representing the various elements in your code such as worksheets, ranges, or user forms. Methods are actions or operations that can be performed on objects, such as copying or formatting. Properties are characteristics or attributes of objects, like their size or color. Variables are used to store and manipulate data within the code. Therefore, the correct order in the VBA object hierarchy is Objects, Methods, Properties, and Variables.Rate this question:
-
- 8.
What is Default in VBA among the Following?
- A.
Pass By Address
- B.
Pass By Reference
- C.
Pass By Value
- D.
None Of the Above
Correct Answer
B. Pass By ReferenceExplanation
Pass By Reference is the default method in VBA. When a procedure is called with a reference to a variable, any changes made to the variable within the procedure will affect the original variable outside of the procedure. This means that the memory address of the variable is passed to the procedure, allowing direct access and modification. This is different from Pass By Value, where a copy of the variable's value is passed to the procedure, and any changes made within the procedure do not affect the original variable.Rate this question:
-
- 9.
Declaration Make mandatory with the use of Option Implicit
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
The statement is false because the use of "Option Implicit" does not make declarations mandatory. "Option Implicit" is a compiler directive in some programming languages that allows variables to be declared implicitly without explicitly specifying their data types. However, it does not enforce mandatory declaration. Variables can still be declared explicitly if desired, but it is not required.Rate this question:
-
- 10.
What does the statement does? Application.Worksheets("Data").Range("1:10").EntireRow.Delete
- A.
Deletes Entire Rows from 1 to10 in the worksheet "Data"
- B.
Deletes contents from Rows 1 to 10 in the worksheet "Data"
- C.
Deletes Entire Columns from 1 to10 in the worksheet "Data"
- D.
Incorrect Statement
Correct Answer
A. Deletes Entire Rows from 1 to10 in the worksheet "Data"Explanation
The given statement deletes entire rows from 1 to 10 in the worksheet "Data". It does not delete the contents of the rows, but rather removes the entire rows from the worksheet.Rate this question:
-
- 11.
How to Hide a Sheet using VBA code?
- A.
Sheets("Sheet1").Visible = True
- B.
Sheets(1).Visible = xlSheetVeryHidden
- C.
Sheets("Sheet1").Visible = False
- D.
None of the Above
Correct Answer
C. Sheets("Sheet1").Visible = FalseExplanation
The correct answer is "Sheets("Sheet1").Visible = False". This line of VBA code sets the visibility property of "Sheet1" to False, which means that the sheet will be hidden. The other options either set the visibility property to True (which would make the sheet visible) or use the xlSheetVeryHidden constant (which is not a valid option for setting the visibility property).Rate this question:
-
- 12.
What is the Use of OPTION EXPLICIT
- A.
It Make the Declaration of Variable Optional
- B.
It Make the Declaration of Variable Unnecessary
- C.
It Make the Declaration of Variable Mandatory
- D.
It Declares the Default Lower Bound for Arrays
Correct Answer
C. It Make the Declaration of Variable MandatoryExplanation
The correct answer is "It Make the Declaration of Variable Mandatory." The OPTION EXPLICIT statement in programming languages, such as Visual Basic, forces the programmer to explicitly declare all variables before using them. Without this statement, variables can be used without prior declaration, which can lead to errors and confusion. By making the declaration of variables mandatory, OPTION EXPLICIT promotes better code organization, readability, and reduces the risk of accidental errors.Rate this question:
-
- 13.
Private Procedure can be called from anywhere in the project
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Private procedures can only be called within the same class or module where they are defined. They cannot be accessed or invoked from other classes or modules within the project. Therefore, the statement "Private Procedure can be called from anywhere in the project" is false.Rate this question:
-
- 14.
TODAY() is Volatile functions?
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
The answer is true because the TODAY() function is a volatile function. Volatile functions are those that are recalculated whenever there is any change in the worksheet. The TODAY() function returns the current date and is recalculated every time the worksheet is opened or changed. Therefore, it is considered a volatile function.Rate this question:
-
- 15.
Select methods that can be used to rename a sheet
- A.
Double-click the sheet tab, type a name, and press Enter.
- B.
Click the sheet tab, type a name, and Press Enter.
- C.
Right-click the sheet tab, choose Rename, type a name, and press Enter.
- D.
Home --> Cells Group --> Format --> Rename
Correct Answer(s)
A. Double-click the sheet tab, type a name, and press Enter.
C. Right-click the sheet tab, choose Rename, type a name, and press Enter.
D. Home --> Cells Group --> Format --> RenameExplanation
The correct answer is a combination of the second and third options. To rename a sheet in Excel, you can either right-click on the sheet tab, choose Rename, type a name, and press Enter, or you can double-click on the sheet tab, type a name, and press Enter. The fourth option mentioned (Home --> Cells Group --> Format --> Rename) does not exist in Excel and is therefore incorrect.Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Nov 07, 2014Quiz Created by
Anmol1990
Back to top