nerdexam
SAP

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.

Using Formulas and Variables

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)
  • A
    5% (3)
  • B
    3% (2)
  • C
    9% (5)
  • D
    83% (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.

AFormat cell

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.

BHide cell

The Hide Cell property is independent of data type and controls visibility, so it remains accessible even when the cell contains a string formula.

CAlign text

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.

DFormat numberCorrect

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

#CurrentDate function#string concatenation#number formatting#formula cell behavior

Community Discussion

No community discussion yet for this question.

Full C_BOWI_40 Practice