USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Validation Text
|
|
|
Default Value
|
|
|
Required
|
|
|
Input Mask
|
Detailed explanation-1: -An input mask forces a user to enter data using a specific format.
Detailed explanation-2: -In an input mask, 0 (zero) denotes a required digit, so that’s what we’ll use for this position.
Detailed explanation-3: -When entering data in a field that has an input mask, Access will insert the appropriate special characters in the proper positions. When you enter data in a memo field, Access automatically expands the row and column to display all the data in the field. Rows in a datasheet may be different sizes.
Detailed explanation-4: -An input mask only displays when a user clicks into that field. When creating a query, you are limited to how many fields you can put into the Design grid. A text box that gets its value from an expression is a calculated control.