C_BOWI_40 · Question #20
You insert the function CurrentDate() into a cell. To clarify the date you add a string so that the formula is now: ="Sales Report from "+CurrentDate() Which formatting capability is disabled for…
The correct answer is D. Format number. Concatenating a string with CurrentDate() using the '+' operator converts the cell result to a string type, which disables the Format Number option because number/date formatting only applies to numeric or date values.
Question
You insert the function CurrentDate() into a cell. To clarify the date you add a string so that the formula is now: ="Sales Report from "+CurrentDate() Which formatting capability is disabled for the cell?
Options
- AFormat cell
- BHide cell
- CAlign text
- DFormat number
How the community answered
(58 responses)- A5% (3)
- B3% (2)
- C9% (5)
- D83% (48)
Why each option
Concatenating a string with CurrentDate() using the '+' operator converts the cell result to a string type, which disables the Format Number option because number/date formatting only applies to numeric or date values.
Format Cell options such as borders, background color, and font styling remain available regardless of the cell's data type, so this capability is not disabled.
The Hide Cell property is independent of data type and controls visibility, so it remains accessible even when the cell contains a string formula.
Text alignment (Align Text) is a layout property that applies to all cell types including strings, so it is not disabled by this formula change.
When CurrentDate() is combined with a string literal using '+', the entire expression evaluates to a string data type rather than a date or numeric type. Format Number formatting (including date pattern formatting) requires the underlying cell value to be a number or date, so this option becomes unavailable. The cell now holds plain text and can only be formatted with text-oriented properties.
Concept tested: Effect of string concatenation on cell number formatting
Source: https://help.sap.com/docs/SAP_BUSINESSOBJECTS_BUSINESS_INTELLIGENCE_PLATFORM/26d35e64-4dde-4c03-9f5c-67b2a1b1e2e8/formatting-numbers-and-dates.html
Topics
Community Discussion
No community discussion yet for this question.