Excel VBA Research & Evidence-Based Practice 3

Question 1

A researcher wants to log each macro run with a timestamp for audit trails. Which VBA function returns the current date and time?

Accepted Answer

Now()

Answer

Now() returns a Date value combining both the current date and time, suitable for timestamping audit log entries.

Question 2

To protect research data integrity, a VBA macro should write results to a new sheet rather than overwrite source data. Which code adds a new worksheet?

Accepted Answer

Sheets.Add

Answer

Sheets.Add inserts a new worksheet into the active workbook, preserving source data on the original sheet.

Question 3

Which VBA error handling structure should wrap data analysis code to catch runtime errors without crashing the macro?

Accepted Answer

On Error GoTo ErrorHandler

Answer

On Error GoTo ErrorHandler redirects execution to a labeled error-handling block when a runtime error occurs.

Question 4

When exporting research results to a new workbook for distribution, which VBA method saves it without displaying a dialog?

Accepted Answer

Workbook.SaveAs filename, FileFormat:=xlOpenXMLWorkbook

Answer

Workbook.SaveAs with a filename and FileFormat argument saves programmatically without prompting the user.

Question 5

A researcher's VBA macro must skip blank rows in a dataset. Which condition correctly identifies a blank cell in column A at row i?

Accepted Answer

Cells(i,1).Value = ""

Answer

Comparing a cell's Value to an empty string "" correctly identifies cells that contain no data.

Excel VBA Practice Test

Excel VBA Practice Test

Excel VBA Research & Evidence-Based Practice 3