USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -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-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: -If a number of hash symbols (######) appear in a cell after you have applied one of Excel number formats, it’s usually because of one of the following reasons: The cell is not wide enough to display the data in the selected format.
Detailed explanation-4: -Double-click a cell where you want to insert the pound sign (e.g., C2), and make sure the cursor is positioned before the number. On the keyboard, press ALT + 0163.
Detailed explanation-5: -Returns the k-th largest value in a data set. You can use this function to select a value based on its relative standing. For example, you can use LARGE to return the highest, runner-up, or third-place score.