FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Data type where the field can contain any character is “ ____ “.
A
text
B
autonumber
C
currency
D
decimal
Explanation: 

Detailed explanation-1: -The CHAR data type stores any string of letters, numbers, and symbols. It can store single-byte and multibyte characters, based on the database locale. The CHARACTER data type is a synonym for CHAR.

Detailed explanation-2: -The TEXT data type stores any kind of text data. It can contain both single-byte and multibyte characters that the locale supports. The term simple large object refers to an instance of a TEXT or BYTE data type.

Detailed explanation-3: -To store text we use a STRING data type. Think of a word or sentence as just a list (string) of characters.

Detailed explanation-4: -The CHAR data type stores character data in a fixed-length field. Data can be a string of single-byte or multibyte letters, numbers, and other characters that are supported by the code set of your database locale.

There is 1 question to complete.