Co-authoring in real time in Excel - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is co-authoring in Excel?

Co-authoring in Excel means multiple people can work on the same spreadsheet at the same time from different devices or locations.

beginner

How do you start co-authoring in Excel?

Save your Excel file to OneDrive or SharePoint and then share the link with others to allow them to edit the file simultaneously.

beginner

What visual cue shows that someone else is editing the same Excel file?

Colored flags or cell highlights appear where others are working, showing their presence and changes in real time.

beginner

Can you co-author Excel files offline?

No, co-authoring requires an internet connection because changes must sync in real time through OneDrive or SharePoint.

intermediate

What happens if two people edit the same cell at the same time in Excel co-authoring?

Excel tries to merge changes automatically, but if there is a conflict, it will ask users to choose which version to keep.

Where must you save an Excel file to enable co-authoring?

A On your local desktop only

B On OneDrive or SharePoint

C On a USB drive

D In a PDF format

Co-authoring works only when the file is saved on OneDrive or SharePoint so changes can sync online.

What shows you that someone else is editing the same Excel file?

A A pop-up message every minute

B A sound notification

C No indication at all

D Colored flags or highlights on cells

Excel uses colored flags or highlights on cells to show where others are working in real time.

Can you co-author Excel files without internet?

A No, internet is required

B Yes, always

C Only if saved locally

D Only on mobile devices

Co-authoring requires internet to sync changes through OneDrive or SharePoint.

What happens if two people edit the same cell simultaneously?

A Excel locks the file

B Excel deletes both changes

C Excel merges changes automatically or asks to resolve conflicts

D Excel crashes

Excel tries to merge changes or asks users to choose which version to keep if there is a conflict.

Which of these is NOT needed for co-authoring in Excel?

A Having a PDF reader

B Sharing the file link

C Using Excel desktop or online

D Saving file on OneDrive

A PDF reader is not related to co-authoring Excel files.

Explain how co-authoring works in Excel and what you need to set it up.

Think about where the file is stored and how people access it.

Describe what happens when two people try to edit the same cell at the same time in Excel co-authoring.

Consider how Excel handles conflicts to keep data safe.