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.

How this page was made: written with AI tools and published by Nathan Beja, founder of Practice Test Geeks, who is responsible for its content. We have not yet matched this exam's facts to an official source, so confirm fees, dates and rules with the exam body. Not reviewed by a subject-matter expert. Editorial policy