Page 287 - open office
P. 287
Solved Exercise
Section A
(Objective Type Questions)
A. Multiple choice questions:
1. If the data is of text type, it will be aligned towards .................................. If the data is of numeric type, it will be
aligned towards ..................................
i. left, right ii. right, left
iii. Both are aligned left iv. None of these
2. Which of the following options helps to rotate the direction of the contents in a Cell.
i. Wrap Text ii. Shrink to fit Cell size
iii. Text Orientation iv. None of these
3. ................................. is an additional feature in spreadsheet in which a certain kind of predefined series of data are
automatically generated once the user feeds the initial data.
i. Automatic Fill ii. Auto Fill
iii. Wrap Text iv. Custom List
4. Which of the following menu has ‘Cells’ option to apply formatting on cells?
i. Home ii. Format
iii. Edit iv. None of these
5. Which of the following helps to forecast the trends on the basis of comparisons?
i. Chart ii. Legends
iii. Plots iv. None of these
6. What helps to identify the plotted data series? Unique colour or pattern is helpful to identify such series.
i. Data abel ii. ridlines
iii. Legend iv. Data series
‘
7. Calc’ provides a feature to create a ................................. where some series of names or text can be pre-defined
and then displayed when the initial data is entered and AutoFill is applied.
i. Style ii. Wrap Text
iii. Custom List iv. None of these
8. The chart preview can be seen in .................................. [CBSE Handbook]
i. Page preview ii. Chart preview
iii. Export chart iv. All of these
9. Which of the following option reduces the font size of the data to accommodate it within the column width?
i. Shrink to fit cell size ii. Columns
iii. Text Orientation iv. None of these
Formatting Cells in Spreadsheet 287

