CES CES Workbook & Worksheet Management

Question 1

Which keyboard shortcut inserts a new worksheet in Excel?

Accepted Answer

Shift+F11

Answer

Ctrl+N

Answer

Ctrl+W

Answer

Alt+F1

Question 2

How do you protect a worksheet so that users cannot edit locked cells?

Accepted Answer

Review > Protect Sheet

Answer

File > Info > Protect Workbook

Answer

Home > Format > Protect

Answer

Data > Protect

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

255

Answer

1024

Answer

65,536

Question 4

Which feature allows you to view two different parts of the same worksheet simultaneously?

Accepted Answer

Split

Answer

Freeze Panes

Answer

New Window

Answer

Arrange All

Question 5

What does 'Freeze Panes' do in Excel?

Accepted Answer

Keeps selected rows or columns visible while scrolling

Answer

Locks the workbook from editing

Answer

Prevents new sheets from being inserted

Answer

Saves the current view as a template

Question 6

To rename a worksheet tab, you should:

Accepted Answer

Right-click the tab and select Rename

Answer

Press F2 while the sheet is active

Answer

Go to File > Rename Sheet

Answer

Use the Name Box