logo

Online Exam Quiz

questionQuestion  1 to 30

Exit Quiz

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

Which object is used to manipulate the Excel workbook?

  • Workbook
  • Workbooks
  • Sheet
  • Worksheet
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 convert a string to a date in VBA?

  • ConvertToDate()
  • DateFromString()
  • DateValue()
  • StringToDate()
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

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

Which object represents the Excel application in VBA?

  • App
  • Workbook
  • Worksheet
  • Application
Mark for review

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

  • UserObject
  • FormObject
  • DialogBox
  • UserForm
Mark for review

What keyword is used to declare a variable in VBA?

  • Dim
  • Var
  • Let
  • Const
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

How do you set the value of a named range in VBA?

  • Range("NamedRange").Value = Value
  • Worksheets("Sheet1").Range("NamedRange").Value = Value
  • Application.Names("NamedRange").Value = Value
  • NamedRange.Value = Value
Mark for review

Which method is used to save a workbook in VBA?

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

How can you create a new workbook using VBA?

  • Workbooks.Add
  • New Workbook
  • CreateWorkbook
  • AddWorkbook
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 method is used to insert a column in a worksheet in VBA?

  • InsertColumn()
  • AddColumn()
  • Insert()
  • Columns.Insert()
Mark for review

What is the purpose of the End statement in VBA?

  • To end a loop or procedure
  • To end a function
  • To end a workbook
  • To end a variable
Mark for review

How do you declare a global variable in VBA?

  • Global
  • DeclareGlobal
  • Public
  • GlobalVar
Mark for review

How do you add a border to a cell in VBA?

  • Range("A1").Borders.LineStyle = xlContinuous
  • Range("A1").Border = xlContinuous
  • Range("A1").Borders.Style = xlContinuous
  • Range("A1").Borders.Add
Mark for review

How do you access the value of a cell using VBA?

  • cell.value
  • cell.text
  • cell.data
  • cell.contents
Mark for review

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

  • Functions
  • Macros
  • Formulas
  • Queries
Mark for review

Which method is used to copy a worksheet in VBA?

  • Copy()
  • Duplicate()
  • Clone()
  • Replicate()
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 property is used to specify the name of a worksheet in VBA?

  • Name
  • SheetName
  • Title
  • WorksheetName
Mark for review

Which method is used to delete a worksheet in VBA?

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

How do you check if a file exists in VBA?

  • FileExists()
  • CheckFile()
  • FileExist()
  • DoesFileExist()
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 method is used to save a workbook in VBA?

  • Workbook.Save
  • SaveWorkbook
  • SaveAs
  • Workbook.SaveAs
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 does the keyword "Option Explicit" do in VBA?

  • Enables case sensitivity
  • Forces declaration of all variables
  • Disables debugging
  • Hides errors
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