DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
#####
|
|
|
&&&&&
|
|
|
$$$$$
|
|
|
+++++
|
Detailed explanation-1: -Definition. 1 / 27. refers to cells not wide enough to display entire entry. Tap the card to flip
Detailed explanation-2: -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.
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: -Active Cell: The active cell is the cell in the spreadsheet that is currently selected for data entry.
Detailed explanation-5: -Formatting Cell as Wrap Text We can put multiple lines in a cell by formatting it as Wrap Text. This feature adjusts the width of the cell to make all content visible within a cell by displaying it on multiple lines.