In this article, you will get assignment share and review spreadsheet for CBSE IT 402 for class 10.
Assignment share and review spreadsheet – Objective type questions
Fill in the blanks, MCQs and True/False – (1 Mark)
 When the files are shared with multiple users, it is available in ________ mode.
 Which of the following task must be done before sharing?
a) You must apply proper formatting
b) You must save the document
c) You must complete the data entry
d) All of these
 The share workbook option is available under ________ group of review tab.
 The “Allow changes by more than one user at the same time. This also allows workbook merging” option is available under “advanced” tab of share workbook dialog box. (True/False)
Most of the spreadsheet software automatically turn off some features in shared workbook book. (True/False)
 Which of the following options are turned off when the spreadsheet is shared?
b) Merge Cells
d) Wrap Text
 Shared workbooks don’t allow __________, _______, & inserting ______ or ________
–> merging cells, conditional formatting, pictures, graphs
 Which of the following option allows to record and highlight the changes done by other users in shared workbook?
a) Track Changes
c) Protect Workbook
d) Share workbook
 To highlight changes click on ______ –> _______ –> _______ from changes group.
–> Review, Track Changes, Highlight Changes
 Which of the following is not available in the highlight changes dialog box?
a) When – The location where changes highlighted
b) Who – The user by whom the changes done
c) Where – Cells or range of cells to be highlight
d) Entire Worksheet
 Which of the following option is displayed in when the combo box in highlight changes the dialog box by default?
a) Since I last save
c) Not yet review
d) Since Date
 Which of the following option is selected by default under who option in highlight changes dialog box?
c) User name who logged in
 You can only list the changes in the current workbook itself. (True/False)
 The _______ are the additional information provided by the user on specific changes or to highlight work done the another user in spreadsheet.
 User can insert a new comment through ________ –> ________ option from comments section.
–> Review, New Comment
 Which of the following is short cut key new insert new comment?
a) Shift + F1
b) Shift + F2
c) Shift + F3
d) Shift + F4
 The New Comment option is replaced by Edit Comment when user want to edit the comment after insertion. (True/False)
 You cannot hide the comments once inserted. (True/False)
 The user can accept or reject changes anytime in shared workbook. (True/False)
 To accept the changes done in spreadsheet, click on _______ –> _________ –> ________ option from changes group.
–> Review, Track Changes, Accept/Reject Changes
 User can accept or reject changes done the specific user as well as all users. (True/False)
 By default, the merge and compare sheet option is not available in the worksheet. (True/False)
 You must copy the worksheet before merge and compare with original. (True/False)
 The merge and compare option automatically update the changes found in the copied worksheet. (True/False)
 When you reject the changes, the comments also gets deleted. (True/False)
Short answer questions (2/3 marks)
 What are the advantages of sharing worksheet data?
 Write steps to share the the spreadsheet.
 Explain various options available in share workbook dialog box.
 How to highlight changes down by other users in shared workbook?
 List and Explain the options provided Highlight Changes dialog box.
 What are the role of comments in spreadsheet?
 How to insert a new comment?
 Write steps to edit comment.
 How to delete comment(s)?
 Explain the options available to format the comment.
 Elaborate the steps to accept all the changed done the user in spreadsheet.
 Enlist steps to reject the changes one by one.
 How to add merge and compare option in Review tab?
 How to add merge and compare option in quick access toolbar?
 Write steps to compare and merge spreadsheet.