USING MICROSOFT EXCEL
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Wrap text
|
|
|
Kind of a jerk.
|
|
|
Truncated
|
|
|
useless.
|
Detailed explanation-1: -In databases and computer networking data truncation occurs when data or a data stream (such as a file) is stored in a location too short to hold its entire length.
Detailed explanation-2: -truncate() takes a filename as its first argument. It sets the file’s size to length, discarding any trailing bytes past the new end. If length is larger than the current file size, then the file is expanded accordingly.
Detailed explanation-3: -The TRUNCATE TABLE command deletes the data inside a table, but not the table itself.
Detailed explanation-4: -First, check if the data type of the column is right for the input data. Maybe its defined length is smaller than it should be, or maybe there’s a misalignment that resulted in a value trying to be stored in a field with different datatype.