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 stakeholder requests that your VBA macro send them an automated email summary after each run. Which Outlook object would you use to create and send the email?

    Answer: Outlook.MailItem

    Outlook.MailItem represents an email message and exposes properties like To, Subject, Body, and the Send method.

  2. Your manager wants a pop-up notification when a macro finishes processing. Which VBA statement displays a simple message box with just an OK button?

    Answer: MsgBox "Done!", vbOKOnly

    MsgBox with vbOKOnly displays a dialog with a single OK button, suitable for a simple completion notification.

  3. A stakeholder needs your macro to log activity to a shared status cell so others can monitor progress. Which approach writes text to cell A1 on a sheet named 'Log'?

    Answer: Sheets("Log").Range("A1").Value = "Processing..."

    Setting the .Value property of a Range object writes text directly to the specified cell.

  4. You need to present a dynamic dashboard to executives and want your VBA macro to automatically refresh all pivot tables before they open the file. Which method refreshes all pivot tables in a workbook?

    Answer: ThisWorkbook.RefreshAll

    ThisWorkbook.RefreshAll refreshes all data connections and pivot tables in the workbook at once.

  5. A client asks your macro to display a custom dialog box asking for their project name before running. Which VBA function returns user-typed text from a dialog?

    Answer: InputBox()

    InputBox() displays a prompt dialog and returns the string the user types as its return value.

  6. When distributing a macro-enabled workbook to stakeholders, which file format preserves VBA code while also being recognized as macro-enabled by Excel?

    Answer: .xlsm

    .xlsm is the Excel Macro-Enabled Workbook format that stores VBA code and clearly signals to users that macros are present.

  7. Your stakeholder wants the macro to write a summary report to a separate sheet named 'Report' and then navigate the user to that sheet automatically. Which line of code activates the 'Report' sheet?

    Answer: Sheets("Report").Activate

    Sheets("Report").Activate makes the specified sheet the active sheet, bringing it into view for the user.