USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
+++++
|
|
|
#####
|
|
|
!!!!!
|
|
|
*
|
Detailed explanation-1: -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.
Detailed explanation-2: -Excel #SPILL! Error. We use the # to instruct a formula’s cell reference to obtain all the entries produced by the Spill Range starting at a defined cell address.
Detailed explanation-3: -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-4: -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.
Detailed explanation-5: -It has no meaning. The “+” after “=” is superfluous. It is a carryover from Lotus 1-2-3, where formulas can be entered as +123+456 instead of =123+456. Excel permits that form as well.