Which feature in Excel allows you to see changes made to a workbook by different users?
a) Track Changes
b) Comments
c) Change History
d) Revision Log
Answer: a) Track Changes
How do you enable the ‘Track Changes’ feature in Excel?
a) Go to Review > Track Changes > Highlight Changes
b) Go to File > Options > Track Changes
c) Go to Data > Track Changes
d) Go to View > Track Changes
Answer: a) Go to Review > Track Changes > Highlight Changes
What does the ‘Highlight Changes’ option in Track Changes do?
a) Saves changes automatically
b) Shows a dialog with change details
c) Displays changes made to the workbook with color coding
d) Reverts changes made to the workbook
Answer: c) Displays changes made to the workbook with color coding
Which option allows you to review and accept or reject changes made in a shared workbook?
a) Accept or Reject Changes
b) Review Changes
c) Change History
d) Manage Changes
Answer: a) Accept or Reject Changes
How can you add a comment to a cell in Excel?
a) Right-click the cell and select New Comment
b) Go to Home > Comments > New Comment
c) Go to Review > New Comment
d) Press Ctrl + Shift + C
Answer: c) Go to Review > New Comment
Which VBA function allows you to insert a comment into a cell programmatically?
a) Cell.Comment
b) Range.AddComment
c) Range.Comments.Add
d) Cells.AddComment
Answer: b) Range.AddComment
What does the ‘Show Comments’ option do in Excel?
a) Displays all comments in a separate window
b) Hides all comments in the workbook
c) Displays comments as pop-ups when hovering over cells
d) Shows comments within the cells where they were added
Answer: d) Shows comments within the cells where they were added
How can you delete a comment from a cell?
a) Right-click the cell and select Delete Comment
b) Go to Review > Delete Comment
c) Press Delete while the comment is selected
d) Go to Home > Comments > Remove Comment
Answer: a) Right-click the cell and select Delete Comment
Which Excel feature allows you to insert a comment with the authorâs name and the date it was added?
a) Comment Properties
b) Comment Metadata
c) Comment Options
d) Comment Info
Answer: b) Comment Metadata
How do you make a comment visible without hovering over the cell?
a) Use the “Show/Hide Comments” option in the Review tab
b) Format the comment to always show
c) Use the “Unhide Comments” option
d) Change the cell color to indicate a comment is present
Answer: a) Use the “Show/Hide Comments” option in the Review tab
