103k views
3 votes
When data is wider than the column, Excel will display a series of ________.

A. And sign (&)
B. Number signs (#)
C. Dollar Signs ($)
D. Asterisk (*)

User Xmak
by
4.8k points

1 Answer

5 votes

When data is wider than the column, Excel will display a series of Number signs (#)

B. Number signs (#)

Step-by-step explanation:

If cell or column in MS-EXCEL is too smaller to fit data it represents s ‘#’ sign. It is applicable for numeric data only. For text data even it is smaller to fit text data it overlaps text content to next cells.

In MS-Excel cell width can be adjusted by move the use and just move the right corner towards right side. End user can do for one cell or multiple cells by selecting the whole column. Sometime system also display with e to power of some values for numeric data.

User Jason Medeiros
by
5.2k points