Question

Assignment
Type A Theoretical Questions
1 What is a cell and how is it referred in
(c) Cells
(d) All the above
000 Calc?
9. State whether the following statements are
2. What do you mean by a range of cells?
true or false
3. What is the difference between a worksheet (1) When you increase the font size, the row
and a workbook?
height is automatically adjusted.
4. What are the different types of data that can be
(in) By default, the numbers are left aligned
entered in Oo Calc?
and text values are right aligned.
5. The keyboard shortcut for Copy is
and
10. Write cell references for the following:
for Paste is
(i) Cell formed by intersection of row 18, and
6. What will happen to the contents of the
column Z.
destination cell if you copy the contents of
(ii) The right most cell in row 32 in a
the source cell into the destination cell?
worksheet.
7. What is the name of the package which permits
(111) If you select on entire worksheet, which
people to quickly create, manipulate and
range of cells gets selected.
analyse data arranged in rows and columns ? (iv) Reference (Fixed Column and Relative
(a) Spreadsheet package
row) formed by row 134 and column BD.
(b) Wordprocessing package
(v) Mixed Reference (Relative column and Fixed
(c) Outline processors
row) formed by row 120 and column IA
(vi) Absolute Reference formed by 45 and
(d) Application package
column Z
8. What does an electronic spreadsheet consist of?
(vii) Relative Reference formed by row 19 and
(a) Rows (b) Columns
column AB.
11​

Answer 1

Answer:

above

000 Calc?

9. State whether the following statements are

2. What do you mean by a range of cells?

true or false

3. What is the difference between a worksheet (1) When you increase the font size, the row

and a workbook?

height is automatically adjusted.

4. What are the different types of data that can be

(in) By default, the numbers are left aligned

entered in Oo Calc?

and text values are right aligned.

5. The keyboard shortcut for Copy is

and

10. Write cell references for the following:

for Paste is

(i) Cell formed by intersection of row 18, and

6. What will happen to the contents of the

column Z.

destination cell if you copy the contents of

(ii) The right most cell in row 32 in a

the source cell into the destination cell?

worksheet.

7. What is the name of the package which permits

(111) If you select on entire worksheet, which

people to quickly create, manipulate and

range of cells gets selected.

analyse data arranged in rows and columns ? (iv) Reference (Fixed Column and Relative

(a) Spreadsheet package

row) formed by row 134 and column BD.

(b) Wordprocessing package

(v) Mixed Reference (Relative column and Fixed

(c) Outline processors

row) formed by row 120 and column IA

(vi) Absolute Reference formed by 45 and

(d) Application package

column Z

8. What does an electronic spreadsheet consist of?

(vii) Relative Reference formed by row 19 and

(a) Rows (b) Columns

column AB.

11