Practice Test GeeksExcel Practice Test
← 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.