Co-authoring in real time in Excel - Practice Problems & Coding Challenges

Challenge - 5 Problems

🎯 Scenario

intermediate

Identify the best practice for real-time co-authoring

You and your team are editing the same Excel workbook simultaneously. Which practice helps avoid conflicts and data loss during co-authoring?

A Work offline and merge changes later manually

B Save the workbook only after everyone finishes editing

C Use comments and chat to communicate changes while editing

D Disable auto-save to control when changes are saved

💡 Hint

Think about how to keep everyone informed while working together.

Using comments and chat helps team members communicate changes instantly, reducing conflicts and confusion during real-time co-authoring.

📊 Formula Result

intermediate

Result of concurrent edits in a shared cell

Two users edit the same cell in a shared Excel workbook at the same time. User 1 enters =SUM(A1:A3). User 2 enters =AVERAGE(A1:A3). After saving, what will the cell show?

A The cell shows the formula <code>=AVERAGE(A1:A3)</code>

B The cell shows the formula <code>=SUM(A1:A3)</code>

C The cell shows an error <code>#CONFLICT!</code>

D The cell shows the last saved value before editing

💡 Hint

Consider which user's change Excel saves last in real-time co-authoring.

In real-time co-authoring, the last saved change overwrites previous ones if editing the same cell simultaneously.

❓ Function Choice

advanced

Choose the function to track changes in a shared workbook

You want to track who made changes to cells in a workbook shared for co-authoring. Which Excel feature or function helps you do this?

A Use the <code>TRACKCHANGES()</code> function in cells

B Enable the 'Track Changes' feature under Review tab

C Use the <code>HISTORY()</code> function in formulas

D Insert a <code>CHANGELOG()</code> worksheet manually

💡 Hint

Look for a built-in Excel feature that records edits by users.

The 'Track Changes' feature in Excel records who changed what and when in a shared workbook, useful for co-authoring scenarios.

❓ data_analysis

advanced

Analyze the impact of simultaneous edits on data integrity

In a shared Excel workbook, two users simultaneously update different rows in a large sales table. What is the expected impact on data integrity and workbook performance?

A Data integrity and performance remain unaffected regardless of edits

B Data integrity is lost, but performance improves due to parallel edits

C Data integrity is compromised, and the workbook crashes often

D Data integrity is maintained, but performance may slow slightly

💡 Hint

Think about how Excel handles multiple edits in different parts of the workbook.

Excel maintains data integrity during simultaneous edits on different rows, but performance can slow slightly due to syncing changes in real time.

🧠 Conceptual

expert

Identify the cause of a #REF! error after co-authoring

After multiple users co-author a workbook, a formula that referenced a deleted row now shows #REF!. What is the most likely cause?

A One user deleted the referenced row during co-authoring

B The workbook was saved without auto-save enabled

C Excel does not support formulas in co-authored workbooks

D The formula syntax is incorrect and needs fixing

💡 Hint

Consider what happens when referenced data is removed by another user.

If a referenced row or cell is deleted by any user during co-authoring, formulas referring to it will show #REF! errors.