Page 204 - IT_V1.0_Class10
P. 204
21 st
Century #Technology Literacy
Lab Assignment ‘n Activity Skills
Complete the following activities and tick the circle.
During the beginning of every Academic Year, ABC Model School shuffles the section of
their students. Academic Incharge has prepared the data in a sheet as shown below.
Academic Incharge must type comment for changing section of any student. Admin will
review the comment and based on the analysis, change of section will be accepted or
rejected. Admin will save the file by a new name.
Now, both the sheets will be compared by the Principal and after merging the data,
Principal will publish a final sheet. Complete this lab assignment on behalf of Academic
Incharge, Admin and Principal of ABC Model School.
Recap Zone
In LibreOffice Calc, multiple users can simultaneously open and edit the same spreadsheet, allowing
for collaborative editing without managing multiple versions.
The Record Changes feature in spreadsheet packages tracks and highlights changes made in cells,
displaying details about who made the change, when, and which cells were altered, allowing reviewers
to accept or reject these changes before finalising the document.
In LibreOffice Calc, comments allow authors and reviewers to exchange ideas or suggestions, and can
be added by selecting a cell, right-clicking, and choosing Insert Comment to type the desired text.
Reviewing changes in a document allows the author to accept or reject suggested changes made by
other users, which can be done individually or all at once by accessing the Track Changes option in
the Edit menu and selecting Manage.
Exercise
Section A (Objective Type Questions)
A. Multiple choice questions.
1. Reviewers and authors can add their ............................. to explain their changes in the cell of a Spreadsheet.
i. Comments ii. Hyperlink iii. Sheet iv. Macros
2. Krish and Kritika have done a survey of age-wise literacy rates of their locality as a school project, which they
have created in a Spreadsheet. They both want to work simultaneously to complete it on time. Which option
should they use to access the same Spreadsheet to speed up their work? [CBSE Sample Paper, 2023]
i. Consolidate Sheet ii. Shared Sheet iii. Link Sheet iv. Lock Sheet
3. Which button is pressed to accept every change that has been made in the sheet?
i. Accept ii. Accept All iii. Accept Changes iv. Accepted
202 Information Technology Play (Ver 1.0)-X

