1. Name the different tabs available in the Format Cells dialoy
2. How can you format a range of cells with decimal values?
3. How do you enter date and time in an Excel sheet?
4. Write the steps for converting numeric data into labels.
5. What is the use of fill handle?
Answers
Answer:
Answer 1: There are six tabs in the Format Cells dialog box: Number, Alignment, Font, Border, Patterns, and Protection.
Answer 2: 1. Select a cell or a cell range.
2. On the Home tab, select Number from the drop-down. Or, you can choose one of these options: Press CTRL + 1 and select Number. Right-click the cell or cell range, select Format Cells… , and select Number. ...
3. Select the format you want
Answer 3: 1. Ctrl + ; shortcut inserts the today date in a cell.
2. Ctrl + Shift + ; shortcut inserts the current time.
3. To enter the current date and time, press Ctrl + ; then press the Space key, and then Ctrl + Shift + ;.
Answer 4. 3.7/5. 4.
Answer 5. In Microsoft Excel, a fill handle is a feature to extend (and fill) a series of numbers, dates, or even text to a desired number of cells. In the active cell of the spreadsheet, the fill handle is a small black box at the bottom right corner, as shown in the image.