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.
–> read-only 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.
–> Changes 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
d) Everyone 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.
–> Comments 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)