JAMIA 2026 — Computer PYQ

Correct Answer: (b) = TEXT(TODAY(),"ddd")

Detailed Explanation

• The TODAY() Function: This built-in function returns the current serial system date value when it evaluates.

• The TEXT() Function: The $\text{TEXT}$ function allows you to change the way a number or date appears by applying specific formatting codes to it. Its basic syntax is:

  $$\text{=TEXT(value, format\_text)}$$

• Custom Day Formatting Codes: When applied to a valid date value, Excel handles the day formatting argument based on the number of letters provided in the format string:

  • "d" $\to$ Displays the day as a number without a leading zero ($1$ to $31$).

  • "dd" $\to$ Displays the day as a number with a leading zero ($01$ to $31$).

  • "ddd" $\to$ Displays the name of the day in an abbreviated short form (e.g., $\text{Mon, Tue, Wed}$).

  • "dddd" $\to$ Displays the complete, full name of the day (e.g., $\text{Monday, Tuesday, Wednesday}$).

Therefore, combining the current system date with the three-digit day format code yields exactly the requested short-form string representation:

$$\text{=TEXT(TODAY(), "ddd")}$$