Page 233 - IT 402 v2.0 class 10
P. 233
Solved Exercise
Section A
(Objective Type Questions)
A. Multiple choice questions:
1. Which feature of Calc helps to see the changes made in the shared worksheet?
i. Record Changes ii. Solver
iii. Subtotal iv. None of these
2. We can add a comment regarding any changes made in shared worksheet by:
i. Edit > Changes > Comments ii. File > Changes > Comments
iii. View > Changes > Comments iv. None of these
3. Worksheets can be merged from ............................. menu.
i. Edit ii. File
iii. View iv. Tools
4. Which types of tasks can be easily performed using Macros?
i. Rare ii. Repetitive
iii. Decision making iv. All of these
5. Raj has created a worksheet where he has added all the information of his employees. He wants every employee
to go through the worksheet and update their address and phone number, if required. He also would like to
know the changes done by his employees. Which feature of spreadsheet he should enable to see the changes
made by his employees? [CBSE Sample Paper, 2022]
i. Macro ii. Link Workbook
iii. Change Worksheet iv. Track Changes
Ans. 1. i 2. i 3. i 4. ii 5. iv
B. Fill in the blanks.
1. ............................. feature is used to track every edited call by highlighting with coloured border.
2. ............................. option helps to display the comment permanently.
. he comments of different author appear in different ............................. .
4. Calc automatically adds a ............................. to any record changes.
Ans. 1. Record changes 2. Show comment 3. colors 4. comment.
Section B
(Subjective Type Questions)
A. Answer the following questions:
1. What do you mean by ‘Record Changes’? List the steps to start recording changes.
Ans. The Record Changes feature is used to track the editing process of any cell by highlighting it with a coloured
border. On selecting the edited cell the details of the changes made by different authors will appear. he steps to
start Record Changes are:
Open the document to be edited.
Click the Edit menu and Select Changes.
Select Record option.
Now start making the changes in the document. Changes get highlighted by a border around the cells.
More About Spreadsheet 231

