← All Microsoft Excel Flashcard Decks

Advanced Formula and Macro Creation Flashcards

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

Read the first 6 Advanced Formula and Macro Creation flashcards as text
  1. What does the VBA keyword 'Dim' stand for?

    Answer: Dimension

    Dim stands for 'Dimension' and is used to declare variables in VBA.

  2. Which Excel function returns a reference to a range specified by a text string?

    Answer: INDIRECT

    INDIRECT converts a text string into an actual cell reference for dynamic reference building.

  3. In VBA, what is the purpose of 'With...End With'?

    Answer: Executing statements on a single object without re-qualifying it

    With...End With performs multiple operations on the same object without repeating the object reference.

  4. What does the FORMULATEXT function do?

    Answer: Returns the formula in a cell as a text string

    FORMULATEXT returns the formula in a referenced cell as text, useful for documentation and auditing.

  5. How do you create a spilling array formula in Excel 365?

    Answer: Simply press Enter — dynamic arrays spill automatically

    In Excel 365, dynamic array formulas automatically spill results into adjacent cells when you press Enter.

  6. What is the purpose of the LAMBDA function in Excel?

    Answer: Defining custom reusable functions without VBA

    LAMBDA lets you create custom reusable functions using Excel formulas alone, without VBA.

Written and edited by , founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

  1. store.certiport.com — Fees, retake fee · verified Nov 2026
  2. certiport.pearsonvue.com — Renewal, score validity, score release, exam format · verified Nov 2026
  3. learn.microsoft.com — Test delivery, time limit, eligibility · verified Nov 2026