Comments and suggestions in Google Sheets - Practice Problems & Coding Challenges

Challenge - 5 Problems

🎯 Scenario

intermediate

Adding a comment to a cell

You want to add a comment to cell B2 in Google Sheets to remind yourself about a deadline. Which method will correctly add a comment visible when hovering over the cell?

A Right-click cell B2, select 'Insert comment', then type your note and click 'Comment'.

B Double-click cell B2 and type your note directly into the cell.

C Select cell B2, then go to Insert > Chart to add a comment.

D Select cell B2, then press Ctrl+C to copy and Ctrl+V to paste a comment.

💡 Hint

Think about how comments are usually added to cells for notes or reminders.

To add a comment in Google Sheets, you right-click the cell and choose 'Insert comment'. This lets you add a note that appears when you hover over the cell.

📊 Formula Result

intermediate

Effect of a comment on formula calculation

If cell A1 contains the number 10 and you add a comment to A1, what will be the result of the formula =A1*2 in cell B1?

Google Sheets

=A1*2

A 20

B Error: Comments are not allowed in formulas

C 0

D The formula will ignore the cell because it has a comment and return blank

💡 Hint

Think about whether comments affect the actual cell value used in formulas.

Comments do not change the cell's value. The formula uses the cell's value (10), so the result is 20.

❓ Function Choice

advanced

Suggesting a change with a note

You want to suggest a change in cell C3 without changing its value. Which feature should you use in Google Sheets to add your suggestion?

A Change the cell value and use Undo later

B Insert a note on cell C3

C Insert a comment on cell C3

D Use Data Validation to restrict input

💡 Hint

Consider which feature is designed for adding visible text notes without implying a conversation.

Notes are simple text attached to a cell for suggestions or explanations. Comments are for conversations and collaboration.

❓ data_analysis

advanced

Identifying cells with comments

You have a large sheet and want to find all cells that have comments. Which method will help you locate these cells quickly?

A Use the menu Edit > Find and type a keyword from the comment

B Use the menu Data > Filter views to filter commented cells

C Use conditional formatting to highlight cells with comments

D Click the Comments button (speech bubble icon) in the toolbar to open the sidebar listing all comments

💡 Hint

Think about built-in features that show comments visually.

Clicking the Comments button opens the sidebar listing all comments, making it easy to locate the cells by navigating to them.

🧠 Conceptual

expert

Difference between comments and notes

Which statement correctly describes the difference between comments and notes in Google Sheets?

A Notes allow replies and conversations; comments are static text only.

B Both comments and notes behave the same and can be used interchangeably.

C Comments are for collaboration and can be replied to; notes are simple text attached to cells without replies.

D Comments change the cell value; notes do not.

💡 Hint

Think about how collaboration features differ from simple annotations.

Comments support conversations and replies, useful for teamwork. Notes are static text for personal reminders or explanations.

Practice

1. What is the main purpose of adding comments in Google Sheets?

easy

A. To change the value of a cell automatically

B. To explain or ask questions about specific cells without changing data

C. To format cells with colors and fonts

D. To create formulas that calculate data

Solution

1. Step 1: Understand the role of comments

   Comments are used to communicate information or questions about a cell without altering its content.

2. Step 2: Differentiate comments from other features

   Formatting and formulas change appearance or data, but comments only add notes visible on hover or in a sidebar.

3. Final Answer:

   To explain or ask questions about specific cells without changing data -> Option B

4. Quick Check:

   Comments = Explain or ask questions [OK]

Hint: Comments explain cells without changing data [OK]

Common Mistakes:

• Thinking comments change cell values
• Confusing comments with formatting
• Using comments to write formulas

2. Which of the following is the correct way to add a comment to a cell in Google Sheets?

easy

A. Use the formula =COMMENT() in the cell

B. Right-click the cell and select 'Insert note'

C. Double-click the cell and type the comment

D. Right-click the cell and select 'Comment'

Solution

1. Step 1: Identify how to add comments

   In Google Sheets, comments are added by right-clicking a cell and choosing 'Comment'.

2. Step 2: Differentiate comments from notes and formulas

   'Insert note' adds a note, not a comment. Double-click edits cell content. =COMMENT() is not a valid formula.

3. Final Answer:

   Right-click the cell and select 'Comment' -> Option D

4. Quick Check:

   Add comment = Right-click + Comment [OK]

Hint: Right-click cell, choose 'Comment' to add comments [OK]

Common Mistakes:

• Choosing 'Insert note' instead of 'Comment'
• Trying to type comment directly in cell
• Using a formula to add comments

3. You see a small orange triangle in the top-right corner of a cell in Google Sheets. What does this indicate?

medium

A. The cell has a formula error

B. The cell contains a comment

C. The cell contains a note

D. The cell is locked for editing

Solution

1. Step 1: Recognize cell indicators

   A small orange triangle in the corner of a cell means there is a note attached to that cell.

2. Step 2: Differentiate notes from comments and errors

   Comments show a speech bubble icon, formula errors show error messages, and locked cells have a lock icon.

3. Final Answer:

   The cell contains a note -> Option C

4. Quick Check:

   Orange triangle = Note [OK]

Hint: Orange triangle means note, not comment [OK]

Common Mistakes:

• Confusing notes with comments
• Thinking orange triangle means error
• Assuming cell is locked

4. A user tries to add a comment but accidentally selects 'Insert note'. What is the main difference they will notice?

medium

A. Notes appear as small orange triangles and show on hover; comments open a sidebar and allow replies

B. Notes change the cell value; comments do not

C. Notes are visible to everyone immediately; comments are private

D. Notes can only be added to text cells; comments only to number cells

Solution

1. Step 1: Understand notes vs comments behavior

   Notes show as small orange triangles and appear when hovering over the cell. Comments open a sidebar and support conversations.

2. Step 2: Identify incorrect options

   Notes do not change cell values, both are visible to collaborators, and both can be added to any cell type.

3. Final Answer:

   Notes appear as small orange triangles and show on hover; comments open a sidebar and allow replies -> Option A

4. Quick Check:

   Notes = orange triangle + hover; Comments = sidebar + replies [OK]

Hint: Notes show on hover; comments open sidebar for discussion [OK]

Common Mistakes:

• Thinking notes change cell values
• Believing comments are private
• Assuming notes only work on text cells

5. You want to suggest a change in a shared Google Sheet without altering the data. Which feature should you use and why?

hard

A. Add a comment to explain your suggestion, so others can reply and discuss

B. Insert a note with your suggestion, so it appears on hover

C. Directly edit the cell to show the new value

D. Use conditional formatting to highlight the suggested change

Solution

1. Step 1: Identify the best way to suggest changes without editing data

   Comments allow you to add suggestions and start discussions without changing the cell content.

2. Step 2: Compare with other options

   Notes are for quick reminders and less interactive. Editing changes data. Conditional formatting only changes appearance, not suggestions.

3. Final Answer:

   Add a comment to explain your suggestion, so others can reply and discuss -> Option A

4. Quick Check:

   Suggest changes = Use comments for discussion [OK]

Hint: Use comments to suggest without changing data [OK]

Common Mistakes:

• Editing cells directly instead of commenting
• Using notes which lack discussion features
• Relying on formatting to suggest changes