Page 249 - IT_Play_V1.0 Class9
P. 249
Step 7: To insert the user-defined entries in the Lists box.
Step 8: Click on the Ok button.
5
6
7
8
Recap Zone
Formatting a cell includes changing the contents of a cell with respect to appearance, i.e., Changing
text, Styles, Alignment, Font, Font style, Font size, Border, Patterns, etc.
The data present in the cell can be customized or formatted using the ‘Format Cells’ option.
Auto Fill is an additional feature in spreadsheet package like ‘LibreOffice Calc’ in which a certain kind
of pre-defined series of data such as name of months of a year, serial numbers, etc. are automatically
generated once the user feeds the initial data.
Exercise
Section A (Objective Type Questions)
A. Multiple choice questions.
1. To format a cell for a scientific number, which tab in the Format Cells dialog box is used?
i. Alignment ii. Font iii. Numbers iv. Protection
2. Which menu in LibreOffice Calc is used to access the Format Cells dialog box?
i. Tools ii. Format iii. Insert iv. View
3. What is the primary purpose of formatting data in a spreadsheet?
i. Make it editable ii. Enhance readability and presentation
iii. Protect data iv. Perform calculations
4. How do you apply Bold formatting in Excel?
i. Press Ctrl + U ii. Press Ctrl + B iii. Press Ctrl + I iv. Press Ctrl + F
5. Which alignment in LibreOffice Calc adjusts the column width to fit text?
i. Center ii. Filled iii. Justified iv. Distributed
6. What happens when the “Shrink to Fit Cell Size” option is selected?
i. Font size is reduced to fit within the column width ii. Text is wrapped
iii. Content is rotated iv. Data is removed
Format Data in the Spreadsheet 247

