Which of the following functions in Excel returns the current date and time? MCQ with Answer and Explanation

Question

Share Report Error

Which of the following functions in Excel returns the current date and time?

A. =DATE()

B. =TIME()

C. =NOW()

D. =TODAY()

Answer: Option C

Solution (By JKSSB Mock Tests)

=NOW() returns the current date and time. =TODAY() returns only current date. =DATE() creates a date from year, month, day. =TIME() creates time.

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 Word, which specific type of indent moves all lines of a paragraph inward from the left margin except for the first line?

A. First Line Indent

B. Right Indent

C. Hanging Indent

D. Negative Indent

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
A Hanging Indent leaves the first line of a paragraph flush with the margin, while all subsequent lines are indented or set inward.

This question belongs to: Computer Microsoft Office

Question #2

Share Report

In Excel, which function is used to calculate the average of a set of numbers but ignores zero values?

A. MEDIAN

B. AVERAGEA

C. AVERAGEIF

D. AVERAGE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
AVERAGEIF can exclude zero by using criteria 0. AVERAGE includes zeros, AVERAGEA includes logicals, MEDIAN is middle value.

This question belongs to: Computer Microsoft Office

Question #3

Share Report

In MS PowerPoint, which option is used to insert a video from a file?

A. Insert > Object

B. Insert > Media > Video

C. Both A and B

D. Insert > Video > This Device

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
You can insert video from file via Insert > Video > This Device (or Similar).

This question belongs to: Computer Microsoft Office

Explore All Microsoft Office MCQs