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

Communication & Stakeholder Relations 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 Communication & Stakeholder Relations flashcards as text

  1. A department head wants to review macro changes before they go live. Which VBA IDE feature lets you step through code one line at a time to demonstrate logic to a stakeholder?

    Answer: F8 (Step Into) in the VBA IDE

    Pressing F8 in the VBA IDE steps through code one line at a time, allowing you to demonstrate execution flow interactively.

  2. Your macro must send different email bodies depending on whether a KPI is met. Which VBA structure best models this conditional communication logic?

    Answer: If...Then...Else block assigning different body text

    An If...Then...Else block evaluates the KPI condition and branches to assign the appropriate message body string.

  3. Stakeholders need a macro that inserts a formatted table of results into an email body as HTML. Which MailItem property accepts HTML content?

    Answer: .HTMLBody

    The .HTMLBody property of an Outlook MailItem accepts an HTML string, enabling formatted tables, colors, and links in the email.

  4. A compliance officer wants every macro run logged with the username and timestamp. Which VBA function returns the current Windows username?

    Answer: Environ("USERNAME")

    Environ("USERNAME") reads the Windows environment variable USERNAME, which always reflects the logged-in OS user.

  5. Your macro needs to notify stakeholders only if data in a specific range has changed. Which Excel VBA event fires whenever a cell value changes on a worksheet?

    Answer: Worksheet_Change(ByVal Target As Range)

    The Worksheet_Change event fires whenever a cell value is modified, and the Target parameter identifies which cell(s) changed.

  6. A stakeholder asks you to protect a sheet so users can only edit specific input cells, not the macro-generated output areas. Which VBA method applies sheet protection?

    Answer: ActiveSheet.Protect Password:="pass", UserInterfaceOnly:=True

    ActiveSheet.Protect with UserInterfaceOnly:=True locks the sheet from manual edits while still allowing VBA code to write to protected cells.

  7. After sending a report, a stakeholder replies asking why certain numbers differ from last week. To support auditability, your macro should save a version of the workbook with today's date in the filename. Which line constructs a dated filename?

    Answer: fileName = "Report_" & Format(Date, "YYYY-MM-DD") & ".xlsx"

    Format(Date, "YYYY-MM-DD") produces a sortable ISO date string that is safe for filenames, unlike raw Now() which includes colons.