Are You An Excel Vba Expert?

15 Questions | Total Attempts: 2491

SettingsSettingsSettings
Please wait...
Are You An Excel Vba Expert?

Knowledge check on Excel VBA


Questions and Answers
  • 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

Back to Top Back to top