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 is the maximum number of worksheets in a workbook?
Answer: Limited only by available memory
The number of worksheets is limited only by computer memory.
How do you move a worksheet to another workbook?
Answer: Right-click tab > Move or Copy, select destination workbook
Right-click > Move or Copy lets you choose destination workbook and position.
What does Freeze Panes do?
Answer: Locks rows/columns visible while scrolling the rest
Freeze Panes keeps specified rows and columns visible while scrolling.
How do you protect a worksheet?
Answer: Review > Protect Sheet with optional password and allowed actions
Protect Sheet lets you set password and specify which actions users can still perform.
What is the purpose of Custom Views?
Answer: Saving different display, filter, print settings to switch between
Custom Views save combinations of display, filter, print settings for quick switching.
How do you link data between worksheets?
Answer: Type = then click cell on another sheet, creating =Sheet2!A1
Reference another sheet's cell with =SheetName!CellAddress syntax.
Written and edited by Nathan Beja, 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
- store.certiport.com — Fees, retake fee · verified Nov 2026
- certiport.pearsonvue.com — Renewal, score validity, score release, exam format · verified Nov 2026
- learn.microsoft.com — Test delivery, time limit, eligibility · verified Nov 2026