In MS Excel, what is the exact output of the formula =TEXT(DATE(2026,6,18), dddd)? MCQ with Answer and Explanation

In MS Excel, what is the exact output of the formula =TEXT(DATE(2026,6,18), dddd)?
A. June
B. 18
C. Thu
D. Thursday
Answer: Option D
Solution (By JKExamLibrary)
The TEXT function formats a numeric date value into a text representation based on a specified format code. The code dddd returns the full name of the day of the week (June 18, 2026 is a Thursday).

This question belongs to: Computer Microsoft Office

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Microsoft Office Questions

Question #1 Report Error
In MS Access, which of the following is not a valid field property?
A. Sort Order
B. Format
C. Caption
D. Field Size

Correct Answer: Option A


Explanation:
Field properties include Field Size, Format, Caption, Default Value, etc. Sort Order is not a field property; sorting is applied in queries or tables via the Sort row.

This question belongs to: Computer Microsoft Office
Question #2 Report Error
In MS PowerPoint, which pane is used to alter the sequence order, adjust triggers, or apply delays to individual slide entry animations?
A. Slide Master Layout
B. Animation Pane
C. Selection Pane
D. Transition Properties

Correct Answer: Option B


Explanation:
The Animation Pane opens on the right side of the screen, allowing users to fine-tune animation timings, ordering, and playback mechanics.

This question belongs to: Computer Microsoft Office
Question #3 Report Error
Which Access database object contains programming code that automates complex tasks?
A. Module
B. Macro
C. Query
D. Report

Correct Answer: Option A


Explanation:
Modules contain VBA code for advanced automation. Macros are simpler.

This question belongs to: Computer Microsoft Office