Page 291 - Computer - 9(A&B)

Compet
Competency Based Questionency Based Question

1. Rohit has created an electronic spreadsheet using Calc. Now, he wants to display multiple lines of text in
a single cell. Which of the following options will he use?
a. Shrink to fi t cell size b. Wrap text automatically
c. Any of these d. None of these
2. Raman wants to position the contents of cells in Calc. In how many ways can he do the same?
a. Two b. Three c. Eight d. Seven
3. Aman wants to know what happens on clicking Insert> Chart. Answer his query by selecting the right
answer.
a. Insert a Chart b. Insert an image c. Delete a chart d. Remove a Chart
4. Raghu wants to insert a formula in Calc. But he doesn’t know the sign used to insert a formula or function
in a spreadsheet application. Help him fi nd the correct option.
a. = (Equal to) b. ? (Question Mark) c. < (Less than) d. > (Greater than)
5. Kavita wants to know the name of the feature of a spreadsheet application that can quickly fi ll a predefi ned
series of data in a worksheet. Help her fi nd the correct option.
a. Autofi ll Handle b. Resize Handle c. Formula and Function d. Rotate Handle
6. Ahana wants to know the name given to a combination of two types of cell references. Help her by
selecting the right answer.
a. Relative Reference b. Absolute Reference c. Mixed Reference d. None of these
7. Anita wants to create a new workbook using the keyboard shortcut. But she doesn’t know how to do it.
Help her by selecting the right key combination.
a. Ctrl+O b. Ctrl+N c. Ctrl+P d. Ctrl+A
8. Aman wants to merge the contents of more than one cell into a single cell. Help him by selecting the right
option.
a. Split Cells b. Merge Cells c. Wrap Cells d. None of these

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: The Function icon helps to insert an equals (=) sign into the selected cell and the Input line
allows the formula to be entered.
Reason: The Function icon shows the icons for most common operations, such as editing, arranging,

fi ltering, etc., used while working on the spreadsheet.
2. Assertion: The selected or activated cell is called an active cell.
Reason: The active cell is the one that contains formulas.

3. Assertion: Any expression that begins with an equals ‘=’ is treated as a formula.
Reason: In an expression, the ‘=’ followed by values, cell address and functions are called as function.

153
153