USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Expand the column
|
|
|
Expand the row
|
|
|
Change the formula
|
|
|
None of the above
|
Detailed explanation-1: -In excel, at times we get #### (hashtag) errors. This error occurs when there is nothing missing in the cell, it’s just that there isn’t enough space for the new or updated value. As per Microsoft official site a #### error is Excel’s way of saying that the cell width isn’t enough for the length of the value.
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: -If you are seeing hash marks (#) instead of cell contents in Microsoft Excel, it is likely that the cells are formatted as text. When cells are formatted as text, anything you type into the cells will be treated as text, even if you type numbers or dates.