DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT 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: -A series of number signs indicates that the data in the cell is unformatted. Autofit determines the best width for a column or the best height for a row based on its contents.
Detailed explanation-2: -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-3: -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-4: -’ An Excel formula that starts with =+ is nothing. It’s an old habit that Lotus Notes users have for starting a formula. Erika, there’s nothing to worry about. Whether a formula starts with = or =+ the answer is going to be the same.