USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
true
|
|
|
false
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data. A thin red border indicates the active cell. You should press the SPACEBAR to clear a cell.
Detailed explanation-2: -Excel AutoFit-the basics AutoFit Column Width-changes the column width to hold the largest value in the column. AutoFit Row Height-adjusts the column width to match the largest value in the row. This option expands the row vertically to hold multi-line or extra-tall text.
Detailed explanation-3: -If the text you enter in a spreadsheet cell is too long and the next column has data, it either spills over into the next blank cell or is truncated by the data in the adjacent cells.
Detailed explanation-4: -Excel number format not working The cell is not wide enough to display the data in the selected format. To fix it, all you need to do is increase the column width by dragging the right boundary. Or, double-click the right boundary to automatically resize the column to fit the largest value within the column.
Detailed explanation-5: -This probably means your cell isn’t wide enough to show the whole number. Try double-clicking the right border of the column that contains the cells with #####. This will change the column width and row height to fit the number. You can also drag the right border of the column to make it any size you want.