USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which symbol will appear in a cell indicating that the data in the cell is wider than the column?
|
|
?????
|
|
|
#####
|
|
|
@@@@@
|
|
|
*
|
Explanation:
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 #####.
There is 1 question to complete.