Practice Test GeeksExcel VBA Practice Test
← All Excel VBA Flashcard Decks

Research & Evidence-Based Practice Flashcards

7 cards from real Excel VBA practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Research & Evidence-Based Practice flashcards as text

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

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

    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.

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

    Answer: MSXML2.XMLHTTP

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

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

    Answer: Both A and B are valid

    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.

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

    Answer: If ActiveWorkbook.Name = "Research.xlsx" Then

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

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

    Answer: Chart.Axes(xlCategory).HasTitle = True

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

  6. A VBA script must compare two versions of a research dataset and highlight changed cells. Which approach identifies differences efficiently?

    Answer: Loop cell by cell and compare .Value between two ranges

    Iterating cells and comparing .Value between two corresponding ranges is the most reliable VBA method for cell-level change detection.

  7. To share a VBA analysis tool with colleagues who should not modify the code, which protection method should be applied?

    Answer: VBA Project password via Tools > VBAProject Properties

    Applying a VBA Project password locks the code editor so colleagues can run macros without viewing or editing the source.