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.