DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
????????
|
|
#######
|
|
/
|
|
None of the above
|
Detailed explanation-1: -Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as #####.
Detailed explanation-2: -If your spreadsheet displays asterisks or pound signs in a cell instead of data, this is usually because the column is not wide enough to display the value you’ve entered. Lotus 1-2-3 displays asterisks ( *** ) when a column is too narrow; Excel displays pound signs ( ### ).
Detailed explanation-3: -0:00. The purpose of the HASH (#) symbol is to refer to a Spill Range. If you are not familiar with Spill Ranges, check out my video in the #SPILL! error message. Excel #SPILL!
Detailed explanation-4: -If the result of a formula is too large to be displayed in a cell, it may appear as pound signs (#######) instead of a value. This means the column is not wide enough to display the cell content.
Detailed explanation-5: -When using Microsoft Excel, I usually solve ##### errors by double-clicking the offending column headers. This can become a bit tedious, however, when there are multiple columns displaying the errors at the same time.