USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -What should you do if you see a column of pound signs (###) instead of values or results of formulas? Increase the column width.
Detailed explanation-2: -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-3: -To modify column width: If you see pound signs (#######) in a cell, it means the column is not wide enough to display the cell content. Simply increase the column width to show the cell content.
Detailed explanation-4: -Fix Text Cells With Number Signs In this case, the problem is the cell’s Number format-it is set as Text. To fix text cells that are showing number signs: Set the cell format to General, instead of Text.