|Kips Information Technology Class 9
|Unit-4 Electronic Spreadsheet
|12 Formatting Data in a Spreadsheet
|Other Chapters Solutions
|Kips IT Class 9 Solutions
Kips IT Class 9 Chapter 12 Solutions FORMATTING DATA IN A SPREADSHEET Part-B
Answer the Following Questions:
Name the different tabs available in the Format Cells dialog box.
The different tabs available in the Format Cells dialog box are Number, Alignment, Font, Border, Fill, and Protection.
Write the steps for converting numeric data into labels.
• Select the range of cells to be converted from numeric data into labels.
• Right-click on it and select the Format Cells option.
• The Format Cells dialog box opens.
• Click on the Number tab.
• Select Text under the Category section.
• Click on OK.
What is the use of fill handle?
Fill handle allows the user to extend and fill a series of numbers, dates, or even text in the desired number of cells. In the active cell of the spreadsheet, the Fill Handle is a small black box at the bottom-right corner of the cell.