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
- 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
- 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
- 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])
- 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.
- 6.The lookup value must always be located in the first column of the lookup table
- A.
True
- B.
False
- 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
- 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
- 9.Declaration Make mandatory with the use of Option Implicit
- A.
True
- B.
False
- 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
- 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
- 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
- 13.Private Procedure can be called from anywhere in the project
- A.
True
- B.
False
- 14.TODAY() is Volatile functions?
- A.
True
- B.
False
- 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
Related Topics
Recent Quizzes
Back to top