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

Question

Share Report Error

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

A. Thu

B. Thursday

C. June

D. 18

Answer: Option B

Solution (By JKSSB Mock Tests)

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

Request complete Subject PDF

Discuss this Question (0)

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

Practice More Microsoft Office Questions

Question #1

Share Report

What is the function of the keyboard shortcut 'Ctrl + D' when a shape, text box, or slide is selected in MS PowerPoint?

A. Duplicates the item

B. Deletes the item

C. Centers the alignment

D. Downloads the item

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
Ctrl + D acts as a shortcut to quickly duplicate any selected object, shape, text box, or active slide layout within PowerPoint.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In MS Word, 'Footnote' and 'Endnote' are inserted from which tab?

A. Insert

B. Review

C. Layout

D. References

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Footnotes and endnotes are under References tab.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

To insert a row above the selected row in Excel, press:

A. Ctrl + +

B. Ctrl + Shift + + (plus)

C. Alt + I, R

D. All of these

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
All these shortcuts can insert a row when a row is selected.

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs