Are You An Excel Vba Expert?

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Anmol1990
A
Anmol1990
Community Contributor
Quizzes Created: 1 | Total Attempts: 3,083
Questions: 15 | Attempts: 3,083

SettingsSettingsSettings
Are You An Excel Vba Expert? - Quiz

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

    Correct Answer
    B. Character
    Explanation
    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 –> Split
    Explanation
    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 value
    Explanation
    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. True
    Explanation
    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 Variables
    Explanation
    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 Reference
    Explanation
    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. False
    Explanation
    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 = False
    Explanation
    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 Mandatory
    Explanation
    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. False
    Explanation
    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. True
    Explanation
    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 --> Rename
    Explanation
    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, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Nov 07, 2014
    Quiz Created by
    Anmol1990
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.