logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

How do you reference a cell in VBA?

  • Cells(Row, Column)
  • R1C1
  • Range(Address)
  • SheetName!CellAddress
Mark for review

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

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

How do you define a procedure that does not return a value in VBA?

  • Sub ProcedureName()
  • Function ProcedureName()
  • Public ProcedureName()
  • Private ProcedureName()
Mark for review

Which data type is used to store textual data in VBA?

  • Integer
  • Double
  • String
  • Boolean
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 do you declare a dynamic array in VBA?

  • dim arr()
  • array arr()
  • arr = array()
  • dynamic arr()
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 VBA keyword is used to create a new class module?

  • Class
  • Module
  • Object
  • Structure
Mark for review

Which function is used to find the position of a substring within a string in VBA?

  • Find()
  • Search()
  • Locate()
  • Position()
Mark for review

Which method is used to save a workbook in VBA?

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

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

  • Length
  • Len
  • Size
  • LengthOf
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 can you delete a row in VBA?

  • Rows(RowNumber).Delete
  • Range("RowNumber").Delete
  • Worksheet.Rows(RowNumber).Clear
  • Sheets("Sheet1").Rows(RowNumber).Delete
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

What does the VBA statement Range("A1").Value = 10 do?

  • Sets the value of cell A1 to 10
  • Sets the value of cell A1 to 100
  • Sets the value of cell A1 to "10"
  • Sets the value of cell A1 to "100"
Mark for review

What keyword is used to exit a loop in VBA?

  • Break
  • Exit
  • End
  • Stop
Mark for review

What does the For Each loop iterate through?

  • Elements of a collection
  • Numbers in a range
  • Characters in a string
  • Worksheets in a workbook
Mark for review

What does VBA provide that allows developers to automate repetitive tasks in Excel?

  • Functions
  • Macros
  • Formulas
  • Queries
Mark for review

What does the term "Object-Oriented Programming" mean in the context of VBA?

  • Programming with objects and classes
  • Programming with loops and conditions
  • Programming with arrays and variables
  • Programming with macros and functions
Mark for review

How do you declare an array in VBA?

  • Dim ArrayName(1 To 10) As DataType
  • Dim ArrayName As DataType
  • Dim ArrayName()
  • Dim ArrayName(10) As DataType
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

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

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 property is used to access the cells in a worksheet using VBA?

  • Cells
  • Range
  • Rows
  • Columns
Mark for review

Which statement is used to exit a loop in VBA?

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

How do you execute a VBA macro from a button click in Excel?

  • RunMacro()
  • ExecuteMacro()
  • CallMacro()
  • Assign macro to button
Mark for review

Which function is used to convert a string to uppercase in VBA?

  • Uppercase()
  • ToUpper()
  • Upper()
  • StrConv()
Mark for review

How do you concatenate strings in VBA?

  • concat()
  • join()
  • &
  • concatString()
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

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