What formatting options does the Formatting setting specify for Date, Date Time, and Whole Number?

What formatting options does the Formatting setting specify for Date, Date Time, and Whole Number?

• A. Date - Date displays only the date. Date Time displays the date and time. Whole Number - None displays the value as a string of numbers. Integer displays the value with commas.
• B. Date only, Time only, Numeric without separators
• C. Only text formatting is allowed
• D. Boolean and numeric formatting only

Answer: (A)

Formatting here controls how each data type is displayed, showing the right level of detail for dates and numbers. For dates, you can choose to display just the date portion or both the date and the time. That’s why the option says Date displays only the date, and Date Time displays the date and the time. For numbers, Whole Number refers to integers with no decimals, and the setting can specify no extra formatting or add separators. Saying that Whole Number is None means the value is shown as a continuous string of digits, while using Integer would format the number with thousands separators (commas). This combination best matches the described behavior: dates can be date-only or date-time, and numbers can be shown with or without comma separators. The other descriptions don’t align with these specific formatting nuances.

Formatting here controls how each data type is displayed, showing the right level of detail for dates and numbers. For dates, you can choose to display just the date portion or both the date and the time. That’s why the option says Date displays only the date, and Date Time displays the date and the time. For numbers, Whole Number refers to integers with no decimals, and the setting can specify no extra formatting or add separators. Saying that Whole Number is None means the value is shown as a continuous string of digits, while using Integer would format the number with thousands separators (commas). This combination best matches the described behavior: dates can be date-only or date-time, and numbers can be shown with or without comma separators. The other descriptions don’t align with these specific formatting nuances.