logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

How can you add a new worksheet to an Excel workbook using VBA?

  • Worksheets.Add
  • Sheets.New
  • AddSheet
  • Workbook.Sheets.Add
Mark for review

What keyword is used to exit a loop in VBA?

  • Break
  • Exit
  • End
  • Stop
Mark for review

What does the "DoEvents" function do in VBA?

  • Pause execution and wait for user input
  • Allow other events to be processed
  • Stop execution of the current subroutine
  • Display an error message
Mark for review

How do you start a macro in VBA?

  • Sub MacroName()
  • Start MacroName
  • Macro MacroName
  • Begin MacroName
Mark for review

What is the purpose of the "With" statement in VBA?

  • Specify conditional statements
  • Group multiple statements
  • Access properties of an object
  • Define variables
Mark for review

Which object is used to interact with the user in VBA?

  • UserObject
  • FormObject
  • DialogBox
  • UserForm
Mark for review

How do you concatenate strings in VBA?

  • concat()
  • join()
  • &
  • concatString()
Mark for review

Which method is used to open a workbook in VBA?

  • Open()
  • OpenWorkbook()
  • LoadWorkbook()
  • Workbooks.Open()
Mark for review

Which function returns the current date in VBA?

  • Date
  • Now
  • Today
  • CurrentDate
Mark for review

Which statement is used to start a comment in VBA?

  • //
  • /*
  • '
  • #
Mark for review

What is the purpose of the "ByRef" keyword in VBA?

  • Pass arguments by reference
  • Pass arguments by value
  • Declare a variable
  • Declare a constant
Mark for review

Which method is used to insert a row in a worksheet in VBA?

  • InsertRow()
  • AddRow()
  • Insert()
  • Rows.Insert()
Mark for review

What is the use of Dim statement in VBA?

  • To declare variables
  • To define functions
  • To initialize constants
  • To create arrays
Mark for review

How can you create a new workbook using VBA?

  • Workbooks.Add
  • New Workbook
  • CreateWorkbook
  • AddWorkbook
Mark for review

How do you refer to the second sheet in a workbook using VBA?

  • Sheets(2)
  • Worksheets(2)
  • Sheet(2)
  • Workbook.Sheets(2)
Mark for review

Which method is used to display a message box in VBA?

  • ShowMessageBox
  • MsgBox
  • DisplayMsg
  • Alert
Mark for review

What is the purpose of the Cells property in VBA?

  • Access specific cells in a range
  • Define cell formatting
  • Modify cell formulas
  • Count the number of cells in a range
Mark for review

What is the purpose of the Do...Loop structure in VBA?

  • To create an iterative loop
  • To define a function
  • To manage events
  • To handle errors
Mark for review

How do you make a cell value bold using VBA?

  • Range("A1").Font.Bold = True
  • Range("A1").Bold = True
  • Range("A1").Font.Bold = "True"
  • Range("A1").Font.Bold = "1"
Mark for review

Which method is used to select a range of cells in VBA?

  • SelectRange()
  • Range()
  • Select()
  • SetRange()
Mark for review

How do you refer to the active worksheet in VBA?

  • ActiveSheet()
  • CurrentSheet()
  • ThisSheet()
  • Worksheet()
Mark for review

Which property is used to specify the name of a worksheet in VBA?

  • Name
  • SheetName
  • Title
  • WorksheetName
Mark for review

Which method is used to copy a worksheet in VBA?

  • Copy()
  • Duplicate()
  • Clone()
  • Replicate()
Mark for review

Which method is used to delete a worksheet in VBA?

  • DeleteSheet()
  • RemoveSheet()
  • Delete()
  • Remove()
Mark for review

What is the purpose of the "On Error Resume Next" statement in VBA?

  • Ignore errors and continue execution
  • Exit the current loop
  • Stop execution
  • Display an error message
Mark for review

How do you check if a worksheet exists in VBA?

  • WorksheetExists()
  • SheetExists()
  • CheckWorksheet()
  • DoesSheetExist()
Mark for review

How do you enable macros in Excel using VBA?

  • Application.EnableEvents = True
  • Application.MacroOptions.Enable = True
  • Application.AutomationSecurity = msoAutomationSecurityLow
  • Application.MacroSettings.Enable = True
Mark for review

How do you concatenate two strings in VBA?

  • String1 & String2
  • String1 + String2
  • Join(String1, String2)
  • Merge(String1, String2)
Mark for review

How do you access the last row of data in a column using VBA?

  • LastRow()
  • EndRow()
  • Rows.Count
  • Range.End(xlDown).Row
Mark for review

What is the purpose of the "IsNumeric" function in VBA?

  • Check if a variable is numeric
  • Convert a string to a number
  • Round a number to the nearest integer
  • Check if a string is numeric
Mark for review

blinkerOnline

  • 1
  • 2
  • 3
  • 4
  • 5
  • 6
  • 7
  • 8
  • 9
  • 10
  • 11
  • 12
  • 13
  • 14
  • 15
  • 16
  • 17
  • 18
  • 19
  • 20
  • 21
  • 22
  • 23
  • 24
  • 25
  • 26
  • 27
  • 28
  • 29
  • 30
  • Answered
  • Not Answered
  • Marked for Review

Get a 1:1 Mentorship call with our Career Advisor

Book free session