DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
If you enter a number that is too long to fit in a cell, Excel changes the display of the number to ____
|
|
ambersands
|
|
|
question marks
|
|
|
number symbols
|
|
|
exclamation points
|
Explanation:
Detailed explanation-1: -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-2: -By default, when you create a new workbook in Excel, the row height and column width for all cells are set to the same value. 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.
There is 1 question to complete.