Microsoft Excel 2021365 - Beginner to Advanced - Inserting Comments

The video tutorial explains how to add, manage, and customize comments in Excel. It begins with an introduction to the usefulness of comments, especially when sharing workbooks. The tutorial provides a practical example using a leavers list and demonstrates how to add comments using the review tab. It covers customizing comment display settings, editing, and deleting comments, and navigating through comments using Excel's built-in options. The video concludes with tips on showing or hiding comments and using keyboard shortcuts for efficiency.

Why are comments particularly useful in Excel workbooks?

• They enhance the visual appeal of the workbook.

• They provide a way to add instructional text discreetly.

• They help in performing calculations.

• They automatically update data.

What is the keyboard shortcut to add a new comment in Excel?

• Ctrl + V

• Ctrl + C

• Alt + F4

• Shift + F2

What indicates the presence of a comment in an Excel cell?

• A green circle

• A yellow star

• A red triangle

• A blue square

How can you customize the display of comments in Excel?

• By changing the font size

• By adjusting the display settings in the Advanced options

• By changing the cell color

• By using the Home tab

What happens when you select 'comments and indicators' in the display settings?

• Both the comment and the indicator are permanently displayed.

• Neither the comment nor the indicator is shown.

• Only the indicator is shown.

• Only the comment is shown.

How can you delete a comment in Excel?

• By using the Insert tab

• By double-clicking the cell

• By selecting the cell and clicking the delete button

• By pressing the Delete key

Which option allows you to quickly navigate through multiple comments in a worksheet?

• The Previous and Next buttons

• The Home tab

• The Insert tab

• The Page Up and Page Down keys