Microsoft Excel Managing Worksheets and Workbooks 2

Question 1

What is the maximum number of worksheets in a workbook?

Accepted Answer

Limited only by available memory

Answer

The number of worksheets is limited only by computer memory.

Question 2

How do you move a worksheet to another workbook?

Accepted Answer

Right-click tab > Move or Copy, select destination workbook

Answer

Right-click > Move or Copy lets you choose destination workbook and position.

Question 3

What does Freeze Panes do?

Accepted Answer

Locks rows/columns visible while scrolling the rest

Answer

Freeze Panes keeps specified rows and columns visible while scrolling.

Question 4

How do you protect a worksheet?

Accepted Answer

Review > Protect Sheet with optional password and allowed actions

Answer

Protect Sheet lets you set password and specify which actions users can still perform.

Question 5

What is the purpose of Custom Views?

Accepted Answer

Saving different display, filter, print settings to switch between

Answer

Custom Views save combinations of display, filter, print settings for quick switching.

Excel Practice Test