Microsoft Excel Managing Worksheets and Workbooks 2 — Questions and Answers
Question 1: What is the maximum number of worksheets in a workbook?
- 255
- 1,000
- Limited only by available memory (Correct answer)
- 65,536
Correct answer: Limited only by available memory
The number of worksheets is limited only by computer memory.
Each sheet supports 1,048,576 rows x 16,384 columns. Default starts with 1 sheet, configurable in Options.
Question 2: How do you move a worksheet to another workbook?
- Drag tab to other window
- Right-click tab > Move or Copy, select destination workbook (Correct answer)
- File > Export > Move Sheet
- Cannot move between workbooks
Correct answer: Right-click tab > Move or Copy, select destination workbook
Right-click > Move or Copy lets you choose destination workbook and position.
Check 'Create a copy' to copy instead of move. Brings data, formatting, charts. Can also drag between windows (Ctrl+drag to copy).
Question 3: What does Freeze Panes do?
- Prevents deletion
- Locks rows/columns visible while scrolling the rest (Correct answer)
- Prevents editing
- Saves current view
Correct answer: Locks rows/columns visible while scrolling the rest
Freeze Panes keeps specified rows and columns visible while scrolling.
Three options: Freeze Panes (above+left of active cell), Freeze Top Row, Freeze First Column. Doesn't affect printing — use Print Titles.
Question 4: How do you protect a worksheet?
- Set file to read-only
- Review > Protect Sheet with optional password and allowed actions (Correct answer)
- Lock individual cells only
- Automatic on save
Correct answer: Review > Protect Sheet with optional password and allowed actions
Protect Sheet lets you set password and specify which actions users can still perform.
Unlock specific cells first (Format Cells > Protection > uncheck Locked), then protect. Note: sheet passwords are easily crackable — not true security.
Question 5: What is the purpose of Custom Views?
- Custom chart views
- Saving different display, filter, print settings to switch between (Correct answer)
- Customizing the ribbon
- Different validation rules
Correct answer: Saving different display, filter, print settings to switch between
Custom Views save combinations of display, filter, print settings for quick switching.
Saves: widths, zoom, filters, print settings, hidden rows. Does NOT save values or formulas. Disabled when workbook contains Tables.
Question 6: How do you link data between worksheets?
- Use LINK function
- Type = then click cell on another sheet, creating =Sheet2!A1 (Correct answer)
- Copy and paste values
- Requires VBA
Correct answer: Type = then click cell on another sheet, creating =Sheet2!A1
Reference another sheet's cell with =SheetName!CellAddress syntax.
Use quotes for spaces: ='Sheet Name'!A1. 3D references: =SUM(Sheet1:Sheet12!A1). External: ='[Book2.xlsx]Sheet1'!A1.
Microsoft Excel Managing Worksheets and Workbooks 2
What is the maximum number of worksheets in a workbook?