Question

which data format type will increase the cell width in excel instead of overlapping into empty cells ? number , general, text, date​

Answer 1

The correct answer is "numbers"

Explanation:

Explanation for correct option

• If we paste numbers in the excel file which are longer than the width of the cell, excel accommodated them into the cell by converting into exponents.

Explanation for incorrect options

• If we paste alphabets or text, they are transferred to the adjacent cell.

• Date is usually not wider than the width of the cell because it has certain format. So, it doesn't get transferred to the adjacent column.

• General is actually no data type