CES Workbook & Worksheet Management Flashcards
6 cards from real CES practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.
Read the first 6 CES Workbook & Worksheet Management flashcards as text
Which keyboard shortcut inserts a new worksheet in Excel?
Answer: Shift+F11
Shift+F11 inserts a new blank worksheet to the left of the currently active sheet.
How do you protect a worksheet so that users cannot edit locked cells?
Answer: Review > Protect Sheet
Review > Protect Sheet applies a password-protected lock to all cells marked as Locked in Format Cells.
What is the maximum number of worksheets you can have in a single Excel workbook?
Answer: Limited only by available memory
Excel imposes no fixed limit on the number of sheets per workbook; the actual limit depends on your computer's available memory.
Which feature allows you to view two different parts of the same worksheet simultaneously?
Answer: Split
View > Split divides the worksheet window into up to four resizable panes, each scrolling independently.
What does 'Freeze Panes' do in Excel?
Answer: Keeps selected rows or columns visible while scrolling
Freeze Panes locks specific rows and/or columns in place so they remain visible as you scroll through the rest of the worksheet.
To rename a worksheet tab, you should:
Answer: Right-click the tab and select Rename
Right-clicking a sheet tab and choosing Rename (or double-clicking the tab) allows you to type a new name directly.