Question

how can we format a range of cells with decimal values? class 9 IT​

Answer 1

Answer:

Select a cell or a cell range.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. ...Select the format you want.

Answer 2

Answer: To format the range in scientific format for the given steps:

1) select the specific range of the cells to be formatted as scientific

2) right click on it and select the format cells option

3) the format cells dialogue box opens

4) click on the number tab

5) select scientific under the category section

6) click on Ok