Bird
Raised Fist0
Google Sheetsspreadsheet~15 mins

Comments and suggestions in Google Sheets - Real Business Scenario

Choose your learning style10 modes available
LearnWhyDeepSheetTryChallengeScenarioRecallDash

Start learning this pattern below

Jump into concepts and practice - no test required

or
Recommended
Test this pattern10 questions across easy, medium, and hard to know if this pattern is strong
Scenario Mode
👤 Your Role: You are a project coordinator at a small marketing agency.
📋 Request: Your manager wants you to collect feedback from the team on the monthly campaign report. They want you to add comments and suggestions directly in the Google Sheet so everyone can see and respond.
📊 Data: You have a Google Sheet with the monthly campaign data including columns for Campaign Name, Start Date, End Date, Budget, and Results.
🎯 Deliverable: Add comments and suggestions to specific cells in the sheet to highlight areas needing feedback or improvement.
Progress0 / 6 steps
Sample Data
Campaign NameStart DateEnd DateBudget ($)Results ($)
Spring Sale2024-03-012024-03-3150007500
Summer Launch2024-06-012024-06-3070006800
Back to School2024-08-152024-09-1560009000
Holiday Promo2024-12-012024-12-31800012000
Winter Clearance2024-01-102024-01-3140003500
1
Step 1: Open the Google Sheet with the campaign data.
Expected Result
You see the table with campaign names, dates, budgets, and results.
2
Step 2: Select the cell with the 'Summer Launch' campaign's Results ($6800).
Expected Result
Cell with 6800 is selected.
3
Step 3: Add a comment to this cell by right-clicking and choosing 'Comment'. Type: 'Results are below budget. Any ideas to improve?' and click 'Comment'.
Expected Result
A small orange triangle appears in the top-right corner of the cell indicating a comment.
4
Step 4: Select the 'Winter Clearance' campaign's Results cell ($3500). Add a suggestion by right-clicking and choosing 'Suggest edit'. Type: 'Consider increasing budget for better reach.' and save the suggestion.
Expected Result
The cell shows a suggestion indicator and the suggestion is visible to collaborators.
5
Step 5: Review all comments and suggestions by clicking the comment icon in the top-right corner of the sheet to open the comment thread panel.
Expected Result
All comments and suggestions are listed for easy review and reply.
6
Step 6: Reply to the comment on 'Summer Launch' by clicking it and typing: 'We will analyze ad channels for better targeting.'
Expected Result
Your reply is added to the comment thread.
Final Result
Campaign Name | Start Date | End Date   | Budget ($) | Results ($) 
--------------|------------|------------|------------|------------
Spring Sale   | 2024-03-01 | 2024-03-31 | 5000       | 7500       
Summer Launch | 2024-06-01 | 2024-06-30 | 7000       | 6800*      
Back to School| 2024-08-15 | 2024-09-15 | 6000       | 9000       
Holiday Promo | 2024-12-01 | 2024-12-31 | 8000       | 12000      
Winter Clearance | 2024-01-10 | 2024-01-31 | 4000       | 3500#      

* Comment: "Results are below budget. Any ideas to improve?"
# Suggestion: "Consider increasing budget for better reach."
✓The 'Summer Launch' campaign results are below the budget, prompting a comment for improvement ideas.
✓A suggestion was made to increase the budget for the 'Winter Clearance' campaign to improve results.
✓Comments and suggestions help the team communicate directly in the sheet for better collaboration.
Bonus Challenge

Create a summary sheet that lists all cells with comments or suggestions and their content for quick review.

Show Hint
Use the Google Sheets 'Comments' menu or explore Google Apps Script to extract comments and suggestions automatically.

Practice

(1/5)
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