FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Is it true that if we enter data of a certain type, that type cannot be changed afterwards?
A
Not
B
Yes
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -Absolute References, Print Optimisation, Extend formula across/down and Flash Fill are some features of MS Excel. But currency is not a data type.

Detailed explanation-2: -It is possible to convert a string to an integer in Python using the int() function, while the str() function converts an integer to a string. Integers can be converted to floats using float(), and floats can be changed to integers, although this can cause data loss.

Detailed explanation-3: -Answer: When a number is entered in “text type field” it is accepted if it is an alphanumeric field otherwise it will be saved as a text. However, the number may be denoted as text and not the actual number in this case.

Detailed explanation-4: -Change data types in Datasheet view Select the field (the column) that you want to change. On the Fields tab, in the Properties group, click the arrow in the drop-down list next to Data Type, and then select a data type. Save your changes.

There is 1 question to complete.