Tracking changes and comments Excel MCQs

  1. 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
  2. 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
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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

Related Posts: