A) Fill in the blanks:-
a) A 'Calc' worksheet contains 1024 columns and 65536 rows.
b) Text Orientation helps to rotate direction of contents in a cell.
c) Series of numbers can be filled using Autofill feature.
d) F2 button is used to enter or edit formula in calc.
e) The extension of Calc file is .ods which automatically gets attached with the file name.
B) Select the correct answers:-
1) Address of the current cell/active cell is contained in:
Answer:- Name Box
2) The option that reduces the font size of the data to accomodate it within the column width:
Answer:- Shrink to fit cell size
3) Calc provide a feature where predefined series of name or text are defined. This feature is know as:
Answer:- Autofill
4) Button that is used to calculate the sum of specified range of cells is known as :
Answer:- AutoSum
5) This option accommodates the text automatically within the column width by increasing the row height.
Answer:- Wrap Text
C) Difference between the following:-
1) Autofill and Custom List
Answer:- Autofill feature in spreadsheet package is predefined series of data such as months name of year, days name of week, series number etc.
Custom list feature create a custom list where some series of names or text that can be pre defined and then it can be displayed when the initial data is entered and auto fill is applied.
2) Undo and Redo
Answer:- Undo helps the user to reverse the series of actions and Redo helps to reverse the actions that have been executed by Undo action.
Ctrl+ Z is short cut for Undo and Ctrl + Y is short cut for Redo.
3) Wrap Text and Shrink to Fit
Answer:- Wrap Text option wraps the text in multiple line to accomodate the text automatically within the column by increasing the row height.
Shrink to fit option reduces the font size of the contents to accomodate it within column width.
