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. June

C. Thursday

D. 18

Answer: Option C

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

In MS PowerPoint, which feature allows you to apply a visual effect to text or objects, such as shadow or glow?

A. Shape Effects

B. WordArt

C. Both A and B

D. Text Effects

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Both Text Effects and Shape Effects provide options for shadows, glows, reflections, etc. for text and shapes respectively.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

What is the shortcut key used to display the traditional 'Save As' file dialog window directly in MS Word and Excel?

A. Ctrl + S

B. Shift + F12

C. Alt + F2

D. F12

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The F12 function key opens the 'Save As' dialog box directly, allowing users to save files under alternative names, extensions, or file directories.

This question belongs to: Computer Microsoft Office