CES CES Workbook & Worksheet Management

Question 1

Which keyboard shortcut inserts a new worksheet in Excel?

Accepted Answer

Shift+F11

Answer

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?

Accepted Answer

Review > Protect Sheet

Answer

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?

Accepted Answer

Limited only by available memory

Answer

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?

Accepted Answer

Split

Answer

View > Split divides the worksheet window into up to four resizable panes, each scrolling independently.

Question 5

What does 'Freeze Panes' do in Excel?

Accepted Answer

Keeps selected rows or columns visible while scrolling

Answer

Freeze Panes locks specific rows and/or columns in place so they remain visible as you scroll through the rest of the worksheet.

CES - Certified Excel Specialists Practice Test