Practice Test GeeksExcel Practice Test
← All Microsoft Excel Flashcard Decks

Workbook and Worksheet Management 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 Workbook and Worksheet Management flashcards as text

  1. What is a macro-enabled workbook (.xlsm)?

    Answer: A workbook that stores and runs VBA macros

    .xlsm supports VBA macros; needed when workbook contains macro code.

  2. How does Consolidate help across multiple worksheets?

    Answer: Creates summary aggregating matching data from multiple sheets

    Consolidate combines data from multiple ranges using aggregate functions.

  3. How do you encrypt an Excel workbook?

    Answer: File > Info > Protect Workbook > Encrypt with Password (AES-256)

    Encrypt with Password applies AES-256 encryption to the entire file.

  4. How do you manage External Links to other workbooks?

    Answer: Data > Edit Links shows all external references with update, change, break options

    Edit Links displays all external references with options to update, change source, or break links.

  5. What is the Inquire add-in used for?

    Answer: Analyzing workbook structure, comparing workbooks, tracing relationships

    Inquire provides advanced analysis: workbook comparison, cell relationship diagrams, and structure analysis.

  6. How can you recover an unsaved workbook?

    Answer: File > Info > Manage Workbook > Recover Unsaved Workbooks

    AutoRecover saves backup copies that can be recovered through File > Info.