Cell locking in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to lock cell A1 in Excel.

Excel

Select cell A1, then go to Format Cells and check the [1] option under Protection tab.

Drag options to blanks, or click blank then click option'

ALocked

BRead-only

CUnlocked

DHidden

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Hidden' instead of 'Locked'.

Selecting 'Unlocked' which actually allows editing.

Confusing 'Read-only' with the Excel cell protection option.

To lock a cell in Excel, you must check the Locked option in the Protection tab of Format Cells.

2fill in blank

medium

Complete the step to protect the worksheet after locking cells.

Excel

After locking cells, go to the Review tab and click [1] to enable protection.

Drag options to blanks, or click blank then click option'

AUnprotect Sheet

BProtect Workbook

CAllow Edit Ranges

DProtect Sheet

Attempts:

3 left

💡 Hint

Common Mistakes

Clicking 'Unprotect Sheet' which removes protection.

Choosing 'Protect Workbook' which protects the whole file structure.

Selecting 'Allow Edit Ranges' which manages exceptions.

To enforce cell locking, you must protect the worksheet by clicking Protect Sheet in the Review tab.

3fill in blank

hard

Fix the error in the formula to check if cell B2 is locked.

Excel

=CELL("protect", [1])

Drag options to blanks, or click blank then click option'

AB2

B"B2"

CB$2

D2B

Attempts:

3 left

💡 Hint

Common Mistakes

Using B2 without quotes causes an error.

Using invalid cell references like 2B.

Using absolute references like B$2 which is not accepted here.

The CELL function requires the cell reference as a text string, so use "B2".

4fill in blank

hard

Fill both blanks to create a formula that returns TRUE if cell C3 is locked and FALSE otherwise.

Excel

=IF(CELL([1], [2])=1, TRUE, FALSE)

Drag options to blanks, or click blank then click option'

A"protect"

B"C3"

CC3

D"locked"

Attempts:

3 left

💡 Hint

Common Mistakes

Using C3 without quotes causes an error.

Using "locked" instead of "protect" as the info_type.

Not quoting the info_type argument.

The CELL function with "protect" and the cell reference as a string returns 1 if locked, 0 if unlocked.

5fill in blank

hard

Fill all three blanks to create a formula that counts how many cells in range A1:A5 are locked.

Excel

=SUMPRODUCT(--(CELL([1], [2])=[3]))

Drag options to blanks, or click blank then click option'

A"protect"

BA1:A5

C1

D"A1:A5"

Attempts:

3 left

💡 Hint

Common Mistakes

Using the range as a text string "A1:A5" instead of a range reference.

Using 0 instead of 1 to count locked cells.

Not quoting "protect".

The formula uses CELL with "protect" on each cell in A1:A5, compares to 1 (locked), and sums the TRUE values.