Page 311 - TP_IT_V1.0_C9_flipbpookl
P. 311
We can format the data by using any of the given ways:
• Click on the Format → Cells option from the Menu bar. It will open the Format To open the Format
Cells dialog box. Cells dialog box:
OR Short key
• Use the Formatting toolbar present just below the Standard toolbar. +
OR Ctrl 1
• Right-click on the and select the Format Cells option from the context menu. It
will open the Format Cells dialog box.
The formatting of the data can be done by using some of the given tools:
• Font: It is used to change the font type such as Algerian, Calibri, Century Gothic, etc.
• Font Size: The default font size is 10, which can be increased or decreased.
• Bold: It makes the selected text appear thick.
• Italic: It makes the selected text appear slightly tilted.
• Underline: It underlines the selected text.
• Align Left: It aligns the selected text to the left within a cell.
• Align Center: It aligns the selected text to the center of the cell.
• Align Right: It aligns the selected text to the right within a cell.
• Justified: It aligns the selected text to both left and right cell borders.
• Decimal Place: It increases or decrease the decimal place of a number.
• Wrap text: It wraps the text within a cell, so all content is displayed within the cell boundaries.
• Number Formatting: This formats the numbers in a cell to display as currency, percentage, date, time, etc.
Formatting a Range of Cells with Decimal Places
To format the number with a decimal place, we can either use the two options (Add Decimal Place and Delete Decimal
Place) present on the Formatting toolbar or use the Decimal Places option through the Format Cells dialog box.
Perform the following steps to do so:
Step 1: Select the range of cells containing the numbers.
Step 2: Click on the Format → Cells option from the Menu bar.
The Format Cells dialog box opens.
Step 3: Select the Numbers tab.
Step 4: Click on the Number category from the Category list box.
Electronic Spreadsheet 309

