logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

Which event occurs when a workbook is opened in Excel?

  • Workbook_Open
  • Workbook_Start
  • Workbook_Load
  • Workbook_Begin
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 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 stand for?

  • Visual Basic Analysis
  • Visual Basic Analysis
  • Visual Basic for Applications
  • Visual Basic for Applications
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

What does the Cells(1,1).Value statement refer to?

  • Cell A1
  • Cell B1
  • Cell A2
  • Cell B2
Mark for review

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

  • MsgBox()
  • Alert()
  • ShowMessage()
  • DisplayAlert()
Mark for review

How do you set the font size of a cell to 12 in VBA?

  • Range("A1").Font.Size = 12
  • Range("A1").Font.Size = 12
  • Range("A1").Font.Size = "12"
  • Range("A1").Font.Size = "12"
Mark for review

Which method is used to open a workbook in VBA?

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

Which property is used to access the cells in a worksheet using VBA?

  • Cells
  • Range
  • Rows
  • Columns
Mark for review

How do you make a cell's value read-only using VBA?

  • Range("A1").Locked = True
  • Range("A1").Protect = True
  • Range("A1").Value = "ReadOnly"
  • Range("A1").Formula = "ReadOnly"
Mark for review

Which object represents the Excel application in VBA?

  • App
  • Workbook
  • Worksheet
  • Application
Mark for review

How do you insert a new module in the VBA editor?

  • Insert > Module
  • File > New Module
  • Home > New Module
  • Developer > New Module
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 make a macro run automatically when the workbook is opened?

  • Use Workbook_Open event
  • Use Worksheet_Change event
  • Use Workbook_BeforeClose event
  • Use Workbook_AfterSave event
Mark for review

How do you loop through each worksheet in a workbook using VBA?

  • For Each ws In Worksheets
  • For ws = Worksheets
  • For ws In Sheets
  • For Each ws In Sheets
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

Which method is used to delete a worksheet in VBA?

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

Which function returns the current date in VBA?

  • Date
  • Now
  • Today
  • CurrentDate
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

What does Range("A1:B10").Select do?

  • Selects cells from A1 to B10
  • Selects only cell A1
  • Selects cells from A1 to B10, including B10
  • Selects column A and row 1
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

How do you clear the contents of a cell in VBA?

  • ClearCell()
  • DeleteCell()
  • ClearContents()
  • RemoveCell()
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 execute a VBA macro in Excel?

  • RunMacro()
  • ExecuteMacro()
  • ExecuteMacro()
  • Macro()
Mark for review

How do you start a macro in VBA?

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

What does ActiveCell refer to in VBA?

  • The currently selected cell
  • The first cell in the worksheet
  • The last cell in the worksheet
  • The cell with the highest value
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

How do you check if a file exists in VBA?

  • FileExists()
  • CheckFile()
  • FileExist()
  • DoesFileExist()
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

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