FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
What will appear in the top right corner once comments have been added to a cell?
A
Yellow triangle
B
Green Triangle
C
Red Triangle
D
The fill handle
Explanation: 

Detailed explanation-1: -A red triangle in the upper-right corner of a cell indicates that a note is in the cell.

Detailed explanation-2: -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-3: -The mark is used to resize the table comprising the data, though resizing automatically occurs when data are added to a cell immediately below or to the right of the table. Before making changes to eliminate the mark, you might want to consider any advantages a table offers.

Detailed explanation-4: -Any comments that were created in spreadsheets before today are still available and saved as “Notes”. These are shown in your spreadsheet using a black triangle in the corner of the cell to differentiate them from the new discussion-style comments.

Detailed explanation-5: -Excel displays a red circle around any cells that contain invalid data.

There is 1 question to complete.