Comments and suggestions in Google Sheets - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is the purpose of adding a comment in Google Sheets?

A comment lets you add notes or explanations to a cell without changing its content. It helps others understand your data or why you made certain changes.

beginner

How do you add a comment to a cell in Google Sheets?

Right-click the cell and choose 'Comment', or select the cell and press Ctrl+Alt+M (Cmd+Option+M on Mac). Then type your note and click 'Comment'.

intermediate

What is the difference between a comment and a suggestion in Google Sheets?

A comment is a note attached to a cell for discussion. A suggestion is a proposed change to the sheet that others can accept or reject.

beginner

How can you reply to a comment in Google Sheets?

Click the comment icon on the cell, then type your reply in the comment thread box and press Enter. This keeps the conversation organized.

intermediate

What happens when you resolve a comment in Google Sheets?

Resolving a comment hides it from the sheet, showing that the issue or question has been addressed. You can still view resolved comments later if needed.

How do you add a comment to a cell in Google Sheets?

A Double-click the cell and type

B Press Ctrl+C to copy

C Right-click the cell and select 'Comment'

D Use the formula bar

Right-clicking the cell and selecting 'Comment' opens the comment box to add notes.

What is a suggestion in Google Sheets?

A A proposed change that others can accept or reject

B A formula to calculate totals

C A note attached to a cell

D A way to format cells

Suggestions are proposed edits that collaborators can review and accept or reject.

What does resolving a comment do?

A Hides the comment as addressed but keeps it accessible

B Sends an email notification

C Marks the cell as locked

D Deletes the comment permanently

Resolving hides the comment from view but keeps it saved for reference.

Which shortcut adds a comment on Windows?

A Ctrl+Z

B Ctrl+C

C Ctrl+V

D Ctrl+Alt+M

Ctrl+Alt+M opens the comment box for the selected cell.

Can you reply to comments in Google Sheets?

A No, comments are read-only

B Yes, you can add replies in the comment thread

C Only the owner can reply

D Replies delete the original comment

Replies keep the conversation organized in the comment thread.

Explain how comments and suggestions help when working with others in Google Sheets.

Think about how you communicate and review work with friends or coworkers.

Describe the steps to add, reply to, and resolve a comment in Google Sheets.

Imagine you are explaining to a friend how to leave notes and finish discussions.