USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Short Text
|
|
|
Number
|
|
|
Currency
|
|
|
All of the above
|
Detailed explanation-1: -You can set a default value for table fields set to the Text, Memo, Number, Date/Time, Currency, Yes/No, and Hyperlink data types.
Detailed explanation-2: -The DefaultValue property specifies text or an expression that’s automatically entered in a control or field when a new record is created. For example, if you set the DefaultValue property for a text box control to =Now(), the control displays the current date and time.
Detailed explanation-3: -Note: The default value is the value specified in the HTML value attribute. The difference between the defaultValue and value property, is that defaultValue contains the default value, while value contains the current value after some changes have been made.
Detailed explanation-4: -When text is used as the Default Value for a field property, it is recommended that the text be enclosed within quotation marks to avoid an “invalid syntax” error message.
Detailed explanation-5: -The DefaultValue property doesn’t apply to AutoNumber and Long Binary fields.