DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Comment
|
|
|
Color Commentary
|
|
|
Spam
|
|
|
Post-It-trademark 3M Corporation
|
Detailed explanation-1: -By default, Excel displays an indicator when a cell contains a comment or a note. You can control how Excel displays comments and indicators in cells by changing the default settings to always show or hide the comments. Click the File tab, then click Options.
Detailed explanation-2: -If you need to discuss data with other people, then use a comment. Notes (formerly called “comments” in earlier versions of Excel) don’t have a Reply box. Notes are just for adding annotations or reminders in cells. If you don’t need to have a discussion about the data, then use a note.
Detailed explanation-3: -In Excel for Microsoft 365, you can use Comments to have conversations with others, or use Notes to make annotations.
Detailed explanation-4: -Just navigate to the Comments section on the REVIEW tab and click on the Show All Comments option. One click and all the comments in the current sheet are displayed on the screen. After reviewing the cell notes, you can hide them by clicking Show All Comments again.