The Complete Excel Guide: Beginners to Advanced - Comments

The video tutorial covers how to use the comment feature in Excel. It explains how to add, edit, resize, and delete comments on cells. The tutorial also demonstrates how to navigate between comments using the review tab and manage their visibility. Additionally, it provides instructions on printing comments, either at the end of the sheet or as displayed on the sheet. The video concludes with a brief summary and a transition to the next section on page setup options.

What is the primary purpose of adding comments to cells in Excel?

• To permanently alter the data in the cell

• To change the cell's formatting

• To provide additional information without affecting the cell's data

• To automatically calculate values

How can you edit an existing comment in Excel?

• Select the cell and press 'Delete'

• Right-click the cell and select 'Edit Comment'

• Click the 'Insert' tab and choose 'Edit Comment'

• Double-click the cell

What are sizing handles used for in Excel comments?

• To change the font of the comment text

• To delete the comment

• To change the size of the comment box

• To move the comment to another cell

Which tab in Excel allows you to navigate between multiple comments?

• Home

• Insert

• Review

• Data

What happens when you choose to 'Show All Comments' in Excel?

• Only the first comment is shown

• All comments are displayed on the sheet

• All comments are hidden

• All comments are deleted

How can you print comments at the end of the sheet in Excel?

• Choose 'End of Sheet' in the Page Setup options

• Select 'Print Comments' from the File menu

• Manually copy comments to a new sheet

• Use the 'Insert' tab to add a print command

What is the effect of selecting 'As displayed on sheet' for printing comments?

• Comments are not printed at all

• Comments are printed on a separate page

• Comments are printed exactly where they appear on the sheet

• Comments are printed in a summary format