Managing Worksheets and Workbooks 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 Managing Worksheets and Workbooks flashcards as text
What replaced Shared Workbooks in modern Excel?
Answer: Legacy multi-user editing; replaced by Co-authoring with OneDrive/SharePoint
Co-authoring through OneDrive/SharePoint replaced the legacy Shared Workbook feature.
How do you create a workbook template?
Answer: Save as Excel Template (.xltx) preserving formatting, formulas, structure
Saving as .xltx creates a reusable template; new workbooks start as copies.
How does Watch Window help across multiple worksheets?
Answer: Monitors cells from any worksheet in a floating window without switching
Watch Window displays cell values and formulas from any sheet in a persistent panel.
How do you navigate between worksheets with keyboard?
Answer: Ctrl+Page Down (next), Ctrl+Page Up (previous)
Ctrl+Page Down moves to next sheet, Ctrl+Page Up to previous.
What are Workbook Properties used for?
Answer: Storing metadata like title, author, keywords via File > Info
Properties store metadata that helps organize and find files.
How does Protect Workbook Structure differ from Protect Sheet?
Answer: Structure prevents sheet operations (add/delete/move); Sheet prevents cell editing
Protect Structure prevents structural changes; Protect Sheet prevents content changes.