Lerato and Thandi are collaborating on a spreadsheet in a cloud-based spreadsheet. Lerato wants to propose changes to the formulas in specific cells without affecting the original data. What should Lerato do?
Turn on suggestion mode and modify the formulas in the cells
Use a different text colour and edit the formulas in the cells.
Create a separate spreadsheet with modified formulas and share it with Thandi.
Create a separate sheet in the spreadsheet with modified formula
and share it with Thandi.
To propose changes to the formulas in specific cells without affecting the original data in a cloud-based spreadsheet, Lerato could follow these steps:
1. Turn on suggestion mode: Many cloud-based spreadsheet applications offer a suggestion mode or a similar feature that allows collaborators to make changes and propose edits without altering the original content. Lerato can enable this mode in the spreadsheet.
2. Modify the formulas in the cells: Once suggestion mode is activated, Lerato can proceed to modify the formulas in the specific cells that require changes. The application will track and display these modifications as suggestions to Thandi.
3. Use a different text colour: Additionally, Lerato can highlight the modified formulas in a different text color. This can provide a visual indication that changes have been proposed to Thandi.
4. Share the spreadsheet or sheet: Lerato can continue collaborating with Thandi on the same spreadsheet or create a separate sheet within the spreadsheet to contain the modified formula. Either way, Lerato needs to make sure the changes are shared with Thandi for her review and acceptance.
Therefore, the most appropriate option for Lerato would be to turn on suggestion mode and modify the formulas in specific cells, ensuring her proposed changes are tracked and visible to Thandi. Using a different text color is an optional step that can provide further clarity.
There are a few options that Lerato can consider to propose changes to the formulas in specific cells without affecting the original data:
1. Turn on suggestion mode and modify the formulas in the cells. This way, Lerato can make changes to the formulas and leave them as suggestions, which Thandi can review and either accept or decline.
2. Use a different text colour and edit the formulas in the cells. By changing the colour of the text for the modified formulas, Lerato can indicate which cells' formulas have been changed and make it easier for Thandi to identify them.
3. Create a separate spreadsheet with modified formulas and share it with Thandi. Lerato can create a duplicate of the original spreadsheet and make the necessary changes to the formulas in the new spreadsheet. Then, this modified version can be shared with Thandi for her review and feedback.
4. Create a separate sheet in the spreadsheet with modified formulas. Lerato can add a new sheet within the spreadsheet and use this new sheet to make changes to the formulas. This way, the modifications are separated from the original data, making it easier for Thandi to compare and evaluate the differences.
Depending on the specific circumstances and preference of Lerato and Thandi, any of these options can be implemented to propose changes to the formulas without affecting the original data in the cloud-based spreadsheet.