CES CES Workbook & Worksheet Management 1 — Questions and Answers
Question 1: Which keyboard shortcut inserts a new worksheet in Excel?
- Ctrl+N
- Shift+F11 (Correct answer)
- Ctrl+W
- Alt+F1
Correct answer: Shift+F11
Shift+F11 inserts a new blank worksheet to the left of the currently active sheet.
Question 2: How do you protect a worksheet so that users cannot edit locked cells?
- File > Info > Protect Workbook
- Review > Protect Sheet (Correct answer)
- Home > Format > Protect
- Data > Protect
Correct answer: Review > Protect Sheet
Review > Protect Sheet applies a password-protected lock to all cells marked as Locked in Format Cells.
Question 3: What is the maximum number of worksheets you can have in a single Excel workbook?
- 255
- 1024
- Limited only by available memory (Correct answer)
- 65,536
Correct 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.
Question 4: Which feature allows you to view two different parts of the same worksheet simultaneously?
- Freeze Panes
- Split (Correct answer)
- New Window
- Arrange All
Correct answer: Split
View > Split divides the worksheet window into up to four resizable panes, each scrolling independently.
Question 5: What does 'Freeze Panes' do in Excel?
- Locks the workbook from editing
- Keeps selected rows or columns visible while scrolling (Correct answer)
- Prevents new sheets from being inserted
- Saves the current view as a template
Correct 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.
Question 6: To rename a worksheet tab, you should:
- Right-click the tab and select Rename (Correct answer)
- Press F2 while the sheet is active
- Go to File > Rename Sheet
- Use the Name Box
Correct 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.
CES CES Workbook & Worksheet Management 1
Which keyboard shortcut inserts a new worksheet in Excel?