Spreadsheet - Developer Mode

What programming language is primarily used for creating macros in Excel?

• Python

• JavaScript

• Visual Basic for Applications (VBA)

• C++

In VBA, which of the following statements is used to declare variables?

• Let

• Dim

• Const

• Var

What does the following code do? Sheets("StudentInfo").Range("C4").Select

• It deletes cell C4 on the StudentInfo sheet.

• It selects cell C4 on the StudentInfo sheet.

• It changes the value of cell C4.

• It clears the contents of cell C4.

What is the purpose of the 'Do Until' loop in VBA?

• It repeats a block of code until a condition becomes false.

• It repeats a block of code while a condition is true.

• It only runs once.

• It repeats a block of code forever.

What does the following code do? MsgBox ("In Progress...")

• It creates a new worksheet.

• It displays a message box with the text "In Progress...".

• It closes the workbook.

• It starts a loop.

What does the code snippet With Selection.Font in VBA control?

• Cell alignment

• Font formatting

• Row height

• Cell borders

Which of the following allows you to enable Developer Mode in Excel?

• File > Options > Customize Ribbon

• Home > View > Enable Developer

• Insert > Developer Tools

• Data > Manage Add-ins

What is the purpose of the macro Call UpdateImage ?

• To create a new worksheet.

• To update a chart.

• To update an image on a worksheet.

• To delete data in a cell.

Which VBA event triggers when a worksheet’s cell value changes?

• Workbook_Open

• Worksheet_Change

• Workbook_BeforeSave

• Workbook_Activate

What is the role of the 'On Error Resume Next' statement in VBA?

• It exits the procedure when an error occurs.

• It prevents the program from stopping due to errors.

• It deletes the current worksheet.

• It raises an error.