Page 288 - open office
P. 288
10. Which of the following option accommodates the text automatically within the column width by increasing the
row height?
i. Merge Cells ii. Text Orientation
iii. Wrap text iv. None of these
Ans. 1. i. 2. iii. 3. ii. 4. ii. 5. i
6. iii. 7. iii. 8. i. 9. i. 10. iii
B. Fill in the blanks.
1. When the corresponding cell address changes with reference to a new cell address, it is known as
................................. reference.
2. ................................. is the heading text that helps to identify the chart.
3. ................................. chart represents the data over a period of time in columns.
4. Regular, Bold, Italic and Bold Italic are the types of ..................................
Ans. 1. relative 2. Chart Title 3. Column 4. Font Styles
Section B
(Subjective Type Questions)
A. Answer the following questions:
1. Write short notes on:
i. Alignment ii. Formatting Cells
iii. Charts iv. Axis Titles
Ans. i. Alignment: The data in a cell gets aligned by default based on the type of the data entered. (If the data is of
text type, it will be aligned towards left. If the data is of numeric type, it will be aligned towards right).
ii. Formatting Cells: Formatting a cell includes changing the contents of a cell with respect to the appearance,
i.e., Changing text, Styles, Alignment, Font, Font style, Font size, Border, Patterns, etc.
iii. Charts: In a spreadsheet package, there are additional features that help to represent information in the
form of charts and graphs. It is a visual graphical representation of data from a worksheet that is very useful
for instant analysis of data and decision-making. There are various options of charts that can be used to
display in ‘Calc’ in graphical format.
iv. Axis Titles: It refers to the titles given to the three axis, i.e. X, Y and Z axis.
2. Differentiate between:
i. Wrap text and shrink to fit cells
ii. Area chart and Line chart
Ans. i. Wrap Text: This option wraps the text in multiple lines to accommodate the text automatically within the
column width by increasing the row height.
hrin to fit Cell si e: This option reduces the font size of the contents to accommodate it within the
column width.
ii. Area Chart: An area chart is a version of a line or column graph. It is useful to emphasize the volume of
changes of data. Area charts have better visual impact than line charts.
Line Chart: Line chart is used to view information that is shown by lines at equal intervals. It depicts the
change in data over a period of time.
288 Touchpad Information Technology-IX

