Track changes and comments in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

What happens when you enable Track Changes in Excel?

When you turn on Track Changes in Excel, what is the main effect on the workbook?

A Excel records all edits made by users, showing who changed what and when.

B Excel automatically saves a backup copy of the workbook every 5 minutes.

C Excel locks the workbook so no one else can edit it until Track Changes is turned off.

D Excel highlights cells with formulas that have errors.

💡 Hint

Think about what 'tracking changes' means in a shared document.

Track Changes lets Excel record edits made by different users, showing details like who made the change and when. It helps in reviewing and accepting or rejecting changes.

📊 Formula Result

intermediate

What is the output of the comment count formula?

You have a worksheet with 5 cells containing comments. You use the formula =COUNTA(COMMENTS()) (assuming COMMENTS() returns all comments). What will this formula return?

A 0

B #NAME? error

C 5

D The text of the first comment

💡 Hint

Is COMMENTS() a valid Excel function?

COMMENTS() is not a built-in Excel function, so using it causes a #NAME? error.

❓ Function Choice

advanced

Which method lets you view all comments in a worksheet at once?

You want to see all comments in your Excel worksheet without clicking each cell. Which option lets you do this?

A Go to Review tab and click 'Show All Comments'.

B Use the formula =SHOWCOMMENTS() in a cell.

C Enable Track Changes to display comments automatically.

D Right-click a cell and select 'View Comment History'.

💡 Hint

Look for a Review feature that manages comments.

The Review tab has a 'Show All Comments' button that displays all comments on the sheet at once.

🎯 Scenario

advanced

You want to accept all tracked changes in a shared workbook. What should you do?

In a shared Excel workbook with Track Changes enabled, you want to accept all changes made by others. Which step correctly accomplishes this?

A Delete all comments manually to accept changes.

B Save the workbook with a new name to accept changes.

C Turn off Track Changes to accept all changes automatically.

D Go to Review tab, click 'Accept/Reject Changes', then choose to accept all changes.

💡 Hint

Look for a Review option that manages changes.

The 'Accept/Reject Changes' feature in the Review tab lets you review and accept or reject tracked changes.

❓ data_analysis

expert

How many changes will be shown after filtering by user 'Alice'?

You have tracked changes from three users: Alice (3 changes), Bob (5 changes), and Carol (2 changes). You filter the change history to show only changes made by Alice. How many changes will be visible?

A 0

B 5

C 3

D 10

💡 Hint

Filtering by user shows only that user's changes.

Filtering by Alice shows only her 3 changes, hiding others.