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.