Page 238 - IT 402 v2.0 class 10
P. 238
2. Why do we need to merge worksheets? [2023]
Ans. Sometimes, multiple reviewers return edited versions of a worksheet at the same time. In this case, it may be
quicker to review all of these changes at once, rather than one review at a time. For this purpose, Calc provides
the feature of merging worksheets.
3. ............................. feature of Calc helps to track what data was changed, when the change was made, who made the
change and in which cell the change has occurred. [2023]
(a) Record Changes (b) Edit Record
(c) Change Record (d) Macro
Ans. (a)
4. Arguments passed to a macro from Calc are always ............................. . [2022]
(a) Strings (b) References
(c) Numbers (d) Values
Ans. (d)
5. List any two conditions/formats/items that can be used for conditional formatting in a Spreadsheet. [2020]
Ans. Fill Color, Fill Pattern.
6. What could you do to add an absolute reference? [2016]
(a) Add dollar signs around the cell (b) Click F4
(c) Both (a) and (b) (d) None of these
Ans. (c)
. hat is conditional formatting xplain “sort” and “filter” features available in spreadsheet.
Ans. Calc gives the user an advance formatting feature known as Conditional Formatting. This feature enables the user
to apply formatting to only those cells in the worksheet which satisfy a particular condition. The formatting is not
applied to the cells which do not satisfy the condition.
Sorting means grouping some data by class or type or size. Calc has a built-in feature to sort lists. Calc can sort
a list both in ascending or increasing order and descending or decreasing order. In case of both ascending or
descending order alc first sorts numbers then alphabets followed by blanks cells.
Filter is an object that removes something from whatever passes through it. The Filter feature of Calc gives the
user the required information without making any change in the order of the list.
236 Touchpad Information Technology-X

