logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

What is the use of Dim statement in VBA?

  • To declare variables
  • To define functions
  • To initialize constants
  • To create arrays
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

Which object is used to manipulate the Excel workbook?

  • Workbook
  • Workbooks
  • Sheet
  • Worksheet
Mark for review

Which event is triggered when a workbook is opened in VBA?

  • Workbook_Open
  • Workbook_Load
  • Workbook_AfterOpen
  • Workbook_BeforeOpen
Mark for review

How do you declare a constant in VBA?

  • constant
  • declare constant
  • const
  • define constant
Mark for review

Which statement is used to exit a loop in VBA?

  • end loop
  • exit loop
  • break
  • exit for
Mark for review

Which statement is used to start a comment in VBA?

  • //
  • /*
  • '
  • #
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

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

  • ShowMessageBox
  • MsgBox
  • DisplayMsg
  • Alert
Mark for review

What does ActiveWorkbook refer to in VBA?

  • The workbook that is currently active
  • The first workbook in the list
  • The workbook with the most recent changes
  • The workbook with the highest value
Mark for review

How do you concatenate strings in VBA?

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

What is the purpose of the With statement in VBA?

  • To simplify code by grouping statements
  • To define new variables
  • To create a new worksheet
  • To execute a function
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

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

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

How do you concatenate two strings in VBA?

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

Which statement is used to loop through a range of cells in VBA?

  • for loop
  • while loop
  • do-while loop
  • for each loop
Mark for review

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

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

How do you declare a dynamic array in VBA?

  • dim arr()
  • array arr()
  • arr = array()
  • dynamic arr()
Mark for review

What keyword is used to declare a variable in VBA?

  • Dim
  • Var
  • Let
  • Const
Mark for review

What is the purpose of the "Application.ScreenUpdating" property in VBA?

  • Control screen updates while executing macros
  • Hide the Excel application window
  • Enable automatic screen updates
  • Disable screen updates
Mark for review

What does the Offset method do in VBA?

  • Moves the reference to a different cell
  • Adds a new cell
  • Changes the size of a cell
  • Deletes a cell
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

What is the purpose of DoEvents in VBA?

  • Allows other operations to run
  • Ends a loop
  • Pauses execution
  • Ends the macro
Mark for review

How do you convert a number to a string in VBA?

  • ToString()
  • ConvertToString()
  • Str()
  • String()
Mark for review

How do you check if a worksheet exists in VBA?

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

Which function is used to round a number to a specified number of decimal places in VBA?

  • Round()
  • RoundUp()
  • RoundDown()
  • RoundTo()
Mark for review

Which method is used to save a workbook in VBA?

  • Save()
  • SaveAs()
  • SaveWorkbook()
  • Export()
Mark for review

What is the purpose of the Range object in VBA?

  • Access Excel formulas
  • Manipulate cell formatting
  • Work with ranges of cells
  • Create new worksheets
Mark for review

Which event occurs when a workbook is opened in Excel?

  • Workbook_Open
  • Workbook_Start
  • Workbook_Load
  • Workbook_Begin
Mark for review

Which function is used to find the length of a string in VBA?

  • Length
  • Len
  • Size
  • LengthOf
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