Page 202 - Computer - 10(A&B)

Compet
Competency Based Questionsency Based Questions
1. Raman is working as a Branch Manager in a Private Bank. He got multiple worksheets of customer
accounts and wants to summarise all the details of the worksheets in a single worksheet. Which option
would he prefer to do so?
a. Consolidate b. Subtotals c. What-if Scenarios d. Goal Seek
2. Subin wants to optimise some equations consisting of multiple unknown variables in Calc. Which option
would he use?
a. Consolidate b. Subtotals c. What-if Scenarios d. Goal Seek
3. Raghav has created multiple worksheets in Calc and wants to retrieve required information from all the
worksheets without re-typing or re-calculating once again. Which option would be useful to him?
a. Consolidate b. Linking c. Goal Seek d. Solver
4. Tina wants to link two worksheets using referencing the cells. But, she does not know what sign she has
to put before the sheet name to link the worksheets. Help her by choosing the appropriate sign for the
same.
a. $ b. # c. % d. =
5. Garima wants to create a hyperlink in Calc using the keyboard shortcut command.Which of the following
key combinations would she use?
a. Ctrl+C b. Ctrl+K c. Ctrl+P d. Ctrl+O
6. Lalit wants to know the name of the tab used to activate the collaboration feature of the worksheet in
Calc. Help him by choosing the correct answer.
a. View b. Data c. Tools d. Format
7. Sheenu wants to protect the worksheet so that no one can make modifications in it at the time of sharing.
Which would option she use to do so?
a. Edit>Protect Document b. Tools>Protect Document
c. Insert>Protect Document d. Format>Protect Document
8. Zubin is working on a shared spreadsheet in Calc. He wants to leave small notes about the changes made
by him. Which of the following options is helpful for him?
a. Notes b. Comments c. Linking d. Consolidate

Asserti
Assertion Reason Based Questionon Reason Based Question
In the following questions, a statement of Assertion (A) is followed by a statement of Reason (R). Choose
the correction option:
(a) if both A and R are true, and R is the correct explanation for A.
(b) if both A and R are true, but R is not the correct explanation for A.
(c) if A is true and R is false.
(d) if A is false and R is true.
1. Assertion: An absolute hyperlink stores the complete location where the file is stored.
Reason: An absolute hyperlink will not work if the file is removed from the location.

2. Assertion: In Calc, one spreadsheet can be used by more than one user at a time by sharing it.
Reason: A shared spreadsheet allows collaborative work so that everyone can contribute, make changes
and view it.
3. Assertion: Sharing a spreadsheet is just like teamwork to work in collaboration with other users.
Reason: The changes made in a shared spreadsheet can never be saved or recorded.

84