Excel VBA Research & Evidence-Based Practice 5

Question 1

A VBA procedure must document its analysis steps in a log sheet. Which approach writes text to the next available row automatically?

Accepted Answer

Cells(Rows.Count,1).End(xlUp).Offset(1,0).Value = log

Answer

Cells(Rows.Count,1).End(xlUp).Offset(1,0) navigates to the last filled cell and offsets one row down to append a new log entry.

Question 2

When scraping web-based research data into Excel via VBA, which object is used to make HTTP requests?

Accepted Answer

MSXML2.XMLHTTP

Answer

MSXML2.XMLHTTP (or MSXML2.ServerXMLHTTP) sends HTTP GET/POST requests to retrieve web data programmatically within VBA.

Question 3

A researcher wants a VBA function to return multiple computed statistics. What is the correct approach in VBA?

Accepted Answer

Both A and B are valid

Answer

VBA functions can return arrays directly, and ByRef parameters allow values to be modified in the calling scope — both are valid multi-value return patterns.

Question 4

To prevent a research analysis macro from running on the wrong dataset, which VBA technique validates the active workbook name before execution?

Accepted Answer

If ActiveWorkbook.Name = "Research.xlsx" Then

Answer

Checking ActiveWorkbook.Name against an expected string ensures the macro only runs on the intended file.

Question 5

Which VBA chart property should be set when automating the creation of a research bar chart to label the horizontal axis?

Accepted Answer

Chart.Axes(xlCategory).HasTitle = True

Answer

Setting Chart.Axes(xlCategory).HasTitle = True enables the category (X) axis title, which you then set via .AxisTitle.Text.

Excel VBA Practice Test

Excel VBA Practice Test

Excel VBA Research & Evidence-Based Practice 5