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

255

Answer

1,000

Answer

65,536

Question 2

How do you move a worksheet to another workbook?

Accepted Answer

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

Answer

Drag tab to other window

Answer

File > Export > Move Sheet

Answer

Cannot move between workbooks

Question 3

What does Freeze Panes do?

Accepted Answer

Locks rows/columns visible while scrolling the rest

Answer

Prevents deletion

Answer

Prevents editing

Answer

Saves current view

Question 4

How do you protect a worksheet?

Accepted Answer

Review > Protect Sheet with optional password and allowed actions

Answer

Set file to read-only

Answer

Lock individual cells only

Answer

Automatic on save

Question 5

What is the purpose of Custom Views?

Accepted Answer

Saving different display, filter, print settings to switch between

Answer

Custom chart views

Answer

Customizing the ribbon

Answer

Different validation rules

Question 6

How do you link data between worksheets?

Accepted Answer

Type = then click cell on another sheet, creating =Sheet2!A1

Answer

Use LINK function

Answer

Copy and paste values

Answer

Requires VBA