Track changes and comments in Excel - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to enable tracking changes in Excel.

Excel

Go to the Review tab and click on [1] to start tracking changes.

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

AInsert Comment

BProtect Sheet

CSort & Filter

DTrack Changes

Attempts:

3 left

💡 Hint

Common Mistakes

Choosing 'Insert Comment' instead of 'Track Changes'.

Selecting 'Protect Sheet' which is for locking cells.

To track changes, you must click Track Changes in the Review tab.

2fill in blank

medium

Complete the code to add a comment to a cell.

Excel

Right-click the cell and select [1] to add a comment.

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

ADelete Comment

BFormat Cells

CNew Comment

DClear Contents

Attempts:

3 left

💡 Hint

Common Mistakes

Selecting 'Delete Comment' which removes comments.

Choosing 'Format Cells' which changes cell appearance.

To add a comment, choose New Comment from the right-click menu.

3fill in blank

hard

Fix the error in the formula to show the comment indicator in a cell.

Excel

=IF(ISBLANK(A1), "", [1])

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

ACELL("comment", A1)

BGETCOMMENT(A1)

CCOMMENT(A1)

DSHOWCOMMENT(A1)

Attempts:

3 left

💡 Hint

Common Mistakes

Using non-existent functions like COMMENT or SHOWCOMMENT.

Using GETCOMMENT which is not a valid Excel function.

The CELL("comment", A1) function returns information about comments in cell A1.

4fill in blank

hard

Fill in the blank to create a formula that counts cells with comments in range A1:A10.

Excel

=SUMPRODUCT(--(NOT(ISBLANK([1]("comment",A1:A10)))))

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

ACOMMENT

BCELL

CGETCOMMENT

DISCOMMENT

Attempts:

3 left

💡 Hint

Common Mistakes

Using non-existent functions like COMMENT or ISCOMMENT.

Not using CELL function which is the correct one.

The CELL("comment", cell) function returns comment info, so wrapping it with ISBLANK helps count commented cells.

5fill in blank

hard

Fill all three blanks to create a formula that shows the author of a comment in cell B2 if it exists.

Excel

=IF(NOT(ISBLANK([1]("comment", B2))), [2]([3]("comment", B2), FIND(":", [3]("comment", B2)) - 1), "No Comment")

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

ACELL

BLEFT

CMID

DRIGHT

Attempts:

3 left

💡 Hint

Common Mistakes

Using MID or RIGHT instead of LEFT to get the author name.

Using non-existent functions for comment retrieval.

This formula uses CELL("comment", B2) to get the comment text, then LEFT and FIND to extract the author's name before the colon.